Hi, I was trying to unsubscribe, but it said you still have 3 assignments to submit. I'm wondering if can I get this assignment done. Please don't do the assignment before letting me know if there is any charge.
Thank you
Key Input Information Growth Investment IGrowth Plans POPLAR Ltd. is for now real - a combination of growth potential businesses with access to financial capital. The founders and yourself have undertaken a thorough review of next steps for growth keeping in mind that as they grow the focus of competitors on the Company will intensify. As well, overall economic conditions are expected to weaken over the next 18 - 24 months. After a series of meetings, discussing strategic strengths, weaknesses, opportunities and threats - externally and internally, the Board and Management agreed to pursue a growth plan for existing business as well as from external acquisitions. A long-term target WACC was determined using a 5 year plan and a five year goal for Debt as a % of total assets to be no more than 40% of total assets. An additional outcome of these meetings was five options for consideration - three to enable growth by increasing existing production capacity and two through the purchase of an operating division of a competitor. You have been tasked with the financial evaluation of each option to determine which productive option and business acquisition option should be chosen. Only one of each can be managed at this time. As noted above, your task is to assess the alternatives and determine which two should be pursued. The required information for analysis is found below and on the tabs marked the color You will input the key information in the relevant tabs marked You are to only enter figures or comments in the areas marked It is highly recommended that you save the original information as a separate file in the event you have to start over. REQUIREMENT: You must complete this analysis - 2 A in order to move on to Phase 2 B - Refinancing as accepted projects are used to determine what the refinancing steps are required. Frequent communication with your senior manager is recommended. Other key assumptions arising from the meetings are listed below. You must calculate the Target WACC to determine the acceptable range for project evaluation and future financing goals. See below for the pro-forma long-term funding objectives. FNCE 390 Project Information - Phase 2 - Growth Investments Other Strategic Decision Matters A)Debt 1)Venture demand loan can be used as a demand loan provided it does not exceed 75% of accounts receivable. Long-term Interest rate = Prime + 3.0% = 8.0% 2)Term loan repayable will now be repayable over 5 years in equal installments. Interest rate adjusted to 8.5% over five year term. Maximum borrowing is 35% of Equipment 3)Amended Mortgage to be repayable over 25 years - 7.75% per annum - locked for 5 years Maximum borrowing is 70% of Land and Buildings 4) Refinance term loan - to be completed when transactions completed - Interest rate proposed10.00% - Maximum borrowing capacity$15,000,000 - Repayment10 years equal principal payments B)Equity Shares issued and outstanding5,200,000Pre-split - consider when refinancing Share price - based on Year 1 EBITDA X Multiplier EBITDA - Board approved financials2,811,932Determine from Board approved financials Multiplier7.00 Current market value$ 19,683,524 Share price$ 3.79Pre-split - consider when refinancing Dividends $ - 0 Cost of Equity Long Range Target21.00% Assumed to remain constant for transactions planned Minimum ownership position - founders52% Venture capital share price "discount"28.00% Private placement market price$ 3.00Pre-split - consider when refinancing C)Other information Tax Rate - Pro-forma Years (future)25%Use for target WACC Risk premiums - Equipment4.00% - Business acquisitions6.00% D)WACC Target WACC15.50%from Target WACC tab Range of Tolerance for Next Year+ / - 1.0%Range for 2B Low 14.50% High 16.50% Target WACC GREENGO Ltd. Growth Plan - Target Financing and WACC Target Weighted Average Cost of Capital As Is Capital Item$ ValueWeightedPre-TaxAfter-TaxWeighted TargetsAverageReturnReturnComponent End of five years forecastPre-tax X (1-tax rate)Weighted Average X After Tax Return Tax Rate Venture demand loan9,000,0009%0%0.00% Term loan payable13,000,00013%0.00%0.00% Refinance term loan6,000,0006%0.00%0.00% Mortgage payable12,000,00012%0.00%0.00% Share capital30,000,00030% Retained earnings30,000,00030% Total Net Assets100,000,000100% Round Up Cell G17 to nearest .5% - eg .11.34 = 11.5 Debt as % of Total Net Assets Equity as % of Total Net Assets Note: The Capital Base outlined above includes the working capital balance of the business - which is the net balance of current assets minus current liabilities. Project - Equipment A FNCE 390 POPLAR Ltd. Project Information AEquipment AcquisitionRevenue (Cost) - $Capital Budgeting Evaluation of Option costs(300,000) Selected Option - Equipment Investment Summary Purchase Cost$ (3,120,000) Delivery Cost(370,000) Install and Commissioning(650,000) Total Cost of Asset$ (4,140,000) Working Capital Investment - Year 1 Accounts Receivable(560,000)Additional Permanent "Investment" Inventory(510,000) (1,070,000) Equipment Life20 Years Salvage / Disposal Value65,000 Amortizationstraight line Annual Amortization203,750 Incremental Benefits of InvestmentPer annum Revenues Years 1 -2- 3 and 8 -9 -10$ 3,400,000 Product costs 1- 2 - 3 and 8 -9- 10(2,312,000) Revenues Years 4- 5- 6- 7$ 4,000,000 Product costs 4 -5 -6 -7(2,720,000) Operating savings - all years300,000reduce General and Admin Tax benefit Tax depreciation methodCapital cost - straight line 15 years Capital Cost - Equipment4,140,000 Tax depreciation term15 Annual tax benefit276,000 Tax Rate Year 1 - 326%Per current Government budgets Year 4 - 1025%Per current Government budgets Hurdle Rate WACC - Target15.50% Risk Premium4.00% 19.50% Cap Bud - Equipment A Capital Budgeting / Business Valuation Solution Template - Discounted Cash Flow YearYearYearYearYearYearYearYearYearYearYear 012345678910 Critical InputsProject time frame Weighted Average Cost of Capital (WACC) + Project Risk Premium = Required Project Return (Hurdle Rate) = Income tax rate by year Input items Cash Outflows - Investment Initial Investment - Year 0 Subsequent Investments- 0- 0- 0- 0- 0- 0- 0- 0- 0 Total- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Project Net Cash Flows - Project Operations Revenues - Inflows Operating Costs - Outflows Other Cost Savings - Inflows Other - Tax Depreciation Total Undiscounted Pre-Tax Net Cash Flows- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Tax Rate26%26%26%25%25%25%25%25%25%25% Less: Taxes- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Add: Tax Depreciation - 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Total Undiscounted After-Tax Net Cash Flows- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Terminal Value - 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Total Undiscounted Cash flow- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Discount Rate = 11.00001.00001.00001.00001.00001.00001.00001.00001.00001.0000 Discounted Net Cash Flows- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Total NPV- 0 Conclusion: Payback = IRR = Business - Acquisition A FNCE 390 POPLAR Ltd. Project Information ABusiness AcquisitionRevenue (Cost) - $Capital Budgeting Evaluation of Option costs(800,000) Selected Option - Investment Accounts Receivable$ 3,600,000 Inventory3,075,000 Equipment9,500,000 Land1,750,000 Building3,000,000 Assets Acquired20,925,000 Liabilities Assumed Accounts Payable(2,035,000) Mortgage(1,540,000) (3,575,000) Venture Short Term Loan$ 17,350,000 Building Remaining Life20 Years Salvage Value600,000 Amortizationstraight line Annual Amortization$ 120,000 Equipment Life20 Years Salvage Value1,050,000 Amortizationstraight line Annual Amortization$ 422,500 Base + Incremental Revenue - Last Year14,500,000 Terminal Value Multiple1.20Terminal value Terminal Value17,400,000 Incremental Benefits of InvestmentPer annum Revenues - 1- 2- 3- 4 - 5$ 13,000,000 Product costs - 1- 2- 3- 4- 5(7,150,000) Revenues - 6- 7- 8- 9 - 10$ 14,000,000 Product costs - 6- 7- 8- 9- 10(7,700,000) Incremental revenues - current business500,000 Incremental product costs - current(350,000) Tax benefit - Buildings and Equipment Tax depreciation methodNet capital cost - straight line 20 years Capital Cost9,500,000 Tax depreciation term20 Annual tax benefit475,000 Tax Rate Year 1 - 526%Per current Government budgets Year 6 - 1025%Per current Government budgets Hurdle Rate WACC - Target15.50% Risk Premium6.00% 21.50% Cap Bud - Acquisition A Capital Budgeting / Business Valuation Solution Template - Discounted Cash Flow YearYearYearYearYearYearYearYearYearYearYear 012345678910 Critical InputsProject time frame Weighted Average Cost of Capital (WACC) + Project Risk Premium = Required Project Return (Hurdle Rate) = Income tax rate by year Input items Cash Outflows - Investment Initial Investment - Year 0 Subsequent Investments- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Total- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Project Net Cash Flows - Project Operations Revenues - Inflows Operating Costs - Outflows Incremental Revenues - Inflows Incremental Expenses - Outflows Other - Tax depreciation Total Undiscounted Pre-Tax Net Cash Flows- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Tax Rate Less: Taxes- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Add: Tax Depreciation - 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Total Undiscounted After-Tax Net Cash Flows- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Terminal Value Total Undiscounted Cash flow- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Discount Rate = 11.00001.00001.00001.00001.00001.00001.00001.00001.00001.0000 Discounted Net Cash Flows- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 Total NPV- 0 Conclusion: Payback = IRR =