Please show all work. Thank you! A firm is considering undertaking a capital inv
ID: 2801744 • Letter: P
Question
Please show all work. Thank you!
A firm is considering undertaking a capital investment project. The firm is planning on producing a new line of oversize tennis rackets. The additional equipment needed to produce the new rackets would cost $475,622 initially. This amount will be depreciated straight line to a zero salvage value over a 5 year life. The company has already spent $139,000 on an extensive marketing survey that yielded encouraging results for their project. Also, if the firm decides to make the new rackets they will be unable to sell $194,000 (after tax value) of equipment they had planned on selling. The project will require an additional $45,000 in working capital at the start of the project. The additional working capital will not be needed after year 5 The project's marginal operating revenues and expenses before taxes are given in the following table (the project has a five year life) (Marginal) Year 1 Year 2 Year 3 Year 4 Year 5 Sales $409,412 20% of revenue $86,500 $425,635 20% of revenue $86,500 $478,430 20% of revenue $86,500 $387,400 20% of revenue $86,500 $215,655 20% of revenue $86,500 Revenue Variable Costs Fixed Costs Depreciation All revenues and expenses are on a cash basis. The firm has a marginal tax rate of 34% and an average tax rate of 25%. The required return on equity is 15.250%, and the firm's pre-tax cost of debt is 4.236%. The firm employs a 55% debt to capital ratio. The firm considers this project to be about the same level of risk as the typical project for the firm. Watch your rounding, excessive rounding will result in incorrect answers. Round your final answers to two decimal places but do not round any intermediate calculations or variables to less than 4 decimal places. You will not get credit if you do not show your work with the appropriate formulas a. What is the firm's WACC? (Show your work.) (1 point) b. What is the project's NPV? (You can use a spreadsheet to help, but for full credit you must show your work by providing a timeline of the initial cost and the calculation for each year's Cash Flow from Assets, and also show the NPV equation and the solution.) (4 points) What is the project's IRR? (Show the IRR equation and provide the calculator solution.) (1 point) What is the project's payback? (1 point, show your work.) Should the firm take the project? Indicate why. If they do by how much should shareholder wealth change? (1 point) C. d. e.Explanation / Answer
a Calculation of WACC ROE 15.25% Pre tax cost of debt 4.24% Marginal tax rate 34% Post tax cost of debt 2.80% (Pre tax cost of debt*(1- tax rate) Debt to capital 55% WACC 8.40% (Debt to capital*post tax cost of debt + (1- debt to capital)*ROE b Year 0 1 2 3 4 5 Initial investment 475622 Marketing survey cost 139000 Lost sales 194000 Working capital 45000 Sales revenue 409412 425635 478430 387400 215655 Variable costs 81882.4 85127 95686 77480 43131 Fixed cost 86500 86500 86500 86500 86500 Depreciation 95124.4 95124.4 95124.4 95124.4 95124.4 Profit before tax 145905.2 158883.6 201119.6 128295.6 -9100.4 Tax 49607.77 54020.42 68380.66 43620.5 -3094.14 Net income after tax 96297.43 104863.2 132738.9 84675.1 -6006.26 Working capital retrieved 45000 Net operating income -853622 191421.8 199987.6 227863.3 179799.5 134118.1 WACC 8.40% NPV -1,08,127.50 Using NPV formula from excel and all the above calculated cash flows c IRR 3.20% Using IRR function in excel and the net operating cash flows as values in it. d Net operating income -853622 191421.8 199987.6 227863.3 179799.5 134118.1 Cummulative cash flows -853622 -662200 -462213 -234349 -54549.8 79568.38 So payback will be somewhere between year 4 and 5 payback 4.41 Years e Since the NPV of the project is negetive and IRR is also lower than the required rate of returncompany should not invest in it.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.