Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SHOW ANSWERS IN EXCEL WITH FORMULAS Projecting cash flows. Complete the cash flow projections for project #2. Assume the following: The project has a 10-year

SHOW ANSWERS IN EXCEL WITH FORMULAS

Projecting cash flows. Complete the cash flow projections for project #2. Assume the following:

  • The project has a 10-year life.
  • Revenues are $70,000 in year 1 and increase $5,000 per year thereafter.
  • Operating expenses are 70% of revenues in each year.
  • Initial equipment purchases are $100,000, depreciated on a 7-year MACRS schedule.
  • Equipment purchased will have a resale value of $30,000 at the end of the project.
  • The tax rate is expected to be 35% over the life of the project.
  • The discount rate for the project is 11.5%
  • Net working capital of $25,000 will need to be maintained over the life of the project.


2. Finding the NPV. Use the NPV function to find the NPV of the project.

Q3: Under the above assumptions, what is the NPV of this project?____________


3. Finding the IRR (in two ways). Use the Goal Seek tool to find the internal rate of return on this project. Recall that the IRR is the discount rate that makes the NPV=0. So in Goal Seek set the NPV to 0 by changing the discount rate. After finding the IRR using Goal Seek, verify the IRR using the IRR function (enter on line 31, below the NPV).

Q4: What is the IRR under the above assumptions?____________

4. Sensitivity analysis. Note on the spreadsheet that all green cells are assumptions that you can modify. Return the discount rate back to 11.5%. Now find the NPV of this project under the following alternative assumptions (change only one at a time, then change back before going to the next one):

Q5: Initial equipment purchases are $115,000 _______________

Q6: Sales in Year 1 are only $60,000, but still rise by $5,000 thereafter ___________

Q7: The equipment has no resale value _______________

Q8: The discount rate is 13% _______________

Step by Step Solution

3.42 Rating (158 Votes )

There are 3 Steps involved in it

Step: 1

Cash flow projections and formulas for Project 2 Revenues Year 1 70000 Year 2 700005000 75000 Year 3 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

12th edition

978-0324597714, 324597711, 324597703, 978-8131518571, 8131518574, 978-0324597707

More Books

Students also viewed these Finance questions

Question

=+b) What are the standard deviations for each action?

Answered: 1 week ago