Question: based off this information what would I put for the years section Hurdle rate 10.0% Useful (project) life 5 Residual value 5,000 Investment 45,000 Net

based off this information what would I put for the years section

based off this information what would I put for
Hurdle rate 10.0% Useful (project) life 5 Residual value 5,000 Investment 45,000 Net cash inflows Cash Flow Year 1 15,000 Cash Flow Year 2 15,000 Cash Flow Year 3 15,000 Cash Flow Year 4 15,000 Cash Flow Year 5 15,000 SVERYTHING BELOW THIS LINE SHOULD BE FORMULAS 1 >ompute the payback Amount Years Initial investment 45,000 t Cash flow year 1 15,000 use the formula =-MIN(D20,D11), which indicates to use the lesser of the unrecaptured investment or the cash flow Amount left to recapture 30,000 Cash flow year 2 - 15,000 use the formula =-MIN(D22,D12), which indicates to use the lesser of the unrecaptured investment or the cash flow Amount left to recapture 15,000 Cash flow year 3 a 15,000 use the formula =-MIN(D24,D13), which indicates to use the lesser of the unrecaptured investment or the cash flow Amount left to recapture - Cash flow year 4 a 15,000 use the formula =-MIN(D26,D14), which indicates to use the lesser of the unrecaptured investment or the cash flow Amount left to recapture (15,000) Cash flow year 5 a 15,000 use the formula =-MIN(D28,D15), which indicates to use the lesser of the unrecaptured investment or the cash flow Amount left to recapture (30,000) Payback = years

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 Accounting Questions!