Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . Projecting cash flows. Complete the cash flow projections for project # 2 . Assume the following: The project has a 1 0 -
Projecting cash flows. Complete the cash flow projections for project # Assume the following:
The project has a year life.
Revenues are $ in year and increase $ per year thereafter.
Operating expenses are of revenues in each year.
Initial equipment purchases are $ depreciated on a year MACRS schedule.
Equipment purchased will have a resale value of $ at the end of the project.
The tax rate is expected to be over the life of the project.
The discount rate for the project is
Net working capital of $ will need to be maintained over the life of the project.
Finding the NPV Use the NPV function to find the NPV of the project.
Q: Under the above assumptions, what is the NPV of this project?
Finding the IRR. Use the IRR function to find the IRR for the project. enter on line below the NPV
Q: What is the IRR under the above assumptions?
Sensitivity analysis. Note on the spreadsheet that all green cells are assumptions you can modify. The best way to complete sensitivity analysis is by using oneway tables after highlighting the relevant cells go to Data, What If Analyis and then Data Tables Complete sensitivity analysis for various levels of CAPEX, Year sales, Resale value of initial equipment purchase RV and the discount rate WACC The structure of the tables has been set up for you.
Use the data tables to determine the NPV under each of the following individual assumption changes.
Q: Initial equipment purchases CAPEX are $
Q: Year Sales Yr Sales are only $ but still rise by $ thereafter
Q: The equipment has no resale value RV
Q: The discount rate is
Creating a twodimensional data table. Do some additional sensitivity analysis by creating a twodimensional data table. Create a Data Table showing what the NPV would be with discount rates of and and with initial CAPX of $ $ $ $ and $the structure has been set up for you Highlight the table G:L click on data, then what if analysis, then data table. The row input cell is input cell for the Cost of Capital, and the column input cell is the input cell for CAPX. Click on OK and you will have a table showing the NPV under different combinations of assumptions.
Q: According to your table, what would the NPV be if the discount rate were and initial CAPX were $
Step 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