Question: Answer the follwing question: Net Present Value: Initial investment = $ ( 3 0 , 0 0 0 ) Annual income: Year 1 $ 6

Answer the follwing question: Net Present Value:
Initial investment = $(30,000)
Annual income:
Year 1 $6,000 x 0.9524= $5,714.40
Year 2 $9,200x 0.9070=8,344.40
Year 3 $5,900 x 0.8638=5,096.42
Year 4 $7,300 x 0.8227=6,005.71
Year 5 $9,200 x 0.7835=7,208.20
Year 5 $3,000 x 0.7835=2,350.50
Total $34,719.63
Net Present Value: $4,719.63 How would you get this number on excel using =PV FUNCTION and then adding the initial investment to get NPV?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!