Question: Using the Excel sheet you were sent, calculate the NV for all projects for three different discount rates:3%, 7% and 11%. A B Exhibit 1

Using the Excel sheet you were sent, calculate the NV for all projects for three different discount rates:3%, 7% and 11%.


A B Exhibit 1 The Investment Detective Project Free Cash Flows (in

A B Exhibit 1 The Investment Detective Project Free Cash Flows (in $ Thousands) Project Number 1 2 3 I 5 6 19 N 100 Initial Investment ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) ($2,000) Year 1 $330 $1.666 $160 280 $2,200 $1,200 ($350) 2 330 334 200 280 900 -60 3 330 165 350 280 300 60 330 395 280 90 350 330 432 280 70 700 6 330 440 280 1,200 7 330 442 280 2,250 8 1,000 444 280 9 446 280 10 448 280 11 450 280 12 451 280 13 451 280 14 452 280 15 10,000 -2,000 280 Sum of Cash Flow Benefits $3,310 $2,165 $10,000 $3.561 $4,200 $2.200 $2,560 $4,150 Excess of Cash Flow Over Initial Investment $1.310 $165 $8.000 $1.561 $2,200 $200 $560 $2,150

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To calculate the Net Present Value NPV for all projects in the Excel sheet provided for discount r... View full answer

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!