Question
Assignments will be done by using Microsoft Excel and Word. Please be careful with the NPV function of Excel as it calculates the NPV by
Assignments will be done by using Microsoft Excel and Word. Please be careful with the NPV function of Excel as it calculates the NPV by assuming that the cash flows start in year 1 [(NPV of CF in year 1....CF in year t) + Initial Investment (CF in year 0)]. Please include the spreadsheet printouts you will be building for answering the questions. PROBLEM A project requires a current investment of $348 and yields future expected cash flows of $9, $381, $950 for each year after investment respectively and there is environmental care cost of $1000 for the recycling the residuals of the project in the last year. The appropriate discount rate is 8.5% of these expected cashflows. According to the given information answer the questions below: a. What is the net present value of the project? According to NPV is the project acceptable? b. Calculate the internal rate of return (IRR) for the project. Can you use the calculated IRR for making an investment decision? Explain why or why not. c. Calculate the payback period. If the cut-off is 2 years, would you accept the project? d. Calculate the discounted payback period. If the cut-off is 2 years, would you accept the project? e. What are the differences between parts c and d? Explain.
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