Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use Excel spreadsheets to solve this problem. Use cell references and your own formulas. Your firm's SVP of Finance asked you to evaluate an investment
Use Excel spreadsheets to solve this problem. Use cell references and your own formulas.
Your firm's SVP of Finance asked you to evaluate an investment opportunity that the development team proposed. Here are some pro-forma financial forecasts for the investment opportunity: (in $) 0 Year Sales revenue Costs of goods sold SG&A, including Depreciation EBIT Interest expense Taxable income Income tax expense (23%) Net Income 1 2 3 4 5 12,000.00 12,600.00 13,230.00 13,892.00 14,586.00 5,000.00 5,250.00 5,513.00 5,788.00 6,078.00 2,250.00 2,363.00 2,481.00 2,604.00 2,735.00 4,750.00 4,987.00 5,236.00 5,500.00 5,773.00 305.00 320.00 336.00 353.00 371.00 4,445.00 4,667.00 4,900.00 5,147.00 5,402.00 1,022.35 1,073.41 1,127.00 1,183.81 1,242.46 3,422.65 3,593.59 3,773.00 3,963.19 4,159.54 Depreciation 750.00 788.00 827.00 868.00 912.00 Capital Expenditure 29,500.00 1,000.00 1,050.00 1,103.00 1,158.00 1,216.00 Net Working Capital level 11,500.00 12,075.00 12,679.00 13,313.00 13,979.00 14,678.00 This project is expected to produce cash flows indefinitely, and growth of 5% is expected for all numbers after year 5. (Note: if the level of net working capital is growing at a rate of 5%, then the changes in net working capital will also be growing at a rate of 5%.) Question 1: What are the corresponding UFCF forecasts? The SVP thinks that a discount rate of 10.8244% is appropriate for this project's cash flows (UFCF). Question 2: Make a recommendation about this project: Is it a good idea? Explain carefully, and include all information the SVP will likely want to see. Show your workStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started