Explore BrainMass

# Project Valuation and Analysis

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

5. Project Valuation and Analysis: Suppose a new machine costs \$59,000 today. It will yield \$11,000 in after-tax savings each year for 7 years and you sell the machine for \$4,000 in the 7th year.
a. Given an opportunity cost of capital of 8%, what is the NPV of this project?

b. What is the IRR of this project?

c. What is the payback period for this project?

d. What is the discounted payback period for this project?

e. What is the profitability index for this project?

In excel format

#### Solution Preview

Cost of new machine \$59,000
After-tax savings \$11,000 per year
Term (years) 7
Salvage value \$4,000

QUESTION A
Opportunity cost 8%
NPV=(After-tax savings*(1-(1/(1+Opportunity cost)^term)))/Opportunity cost)+(Salvage value/(1+opportunity cost)^term)-Cost of new ...

#### Solution Summary

IRR, payback period, discounted payback period and profitability index for a project are worked out in Excel.

\$2.49