Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

The Routledge Handbook Of Responsible Investment

Authors: Tessa Hebb, James Hawley, Andreas Hoepner, Agnes Neher, David Wood

1st Edition

0415624517, 978-0415624510

More Books

Students also viewed these Finance questions

Question

What risks to organizations does the growing use of networks pose?

Answered: 1 week ago

Question

Identify the types of informal reports.

Answered: 1 week ago

Question

Write messages that are used for the various stages of collection.

Answered: 1 week ago