Explore BrainMass
Share

Calculating NPV of given investment proposal

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

A machine costs $380,000 and is expected to produce the following cash flows:
Year 1 2 3 4 5 6 7 8 9 10

Cash Flows (000s) $50 $57 $75 $80 $85 $92 $92 $80 $68 $50

If the cost of capital is 12 percent, what is the machine's NPV?

© BrainMass Inc. brainmass.com March 21, 2019, 9:14 pm ad1c9bdddf
https://brainmass.com/business/net-present-value/calculating-npv-of-given-investment-proposal-367052

Attachments

Solution Preview

Please refer attached file for better clarity of formulas in MS Excel.

Assumptions:
Opportunity cost of capital 12%

Period
0 1 2 3 4 5 6 7 8 9 ...

Solution Summary

Solution describes the steps to calculate net present value of given investment proposal.

$2.19