Given the below proposed project cost and estimated cashflows, fill in the yellow cells. Project Cost:...

 

Transcribed Image Text:

Given the below proposed project cost and estimated cashflows, fill in the "yellow" cells. Project Cost: Project Term (yrs): Required Return: Project IRR: NPV at Required Return: Traditional Payback (yrs): $2,000,000 6.00 9.00% NPV Cost/Flow Calculation ($2,000,000) $ 400,000 $450,000 $ 500,000 $ 500,000 $ 500,000 $ 450,000 * insert the present value of each year's cashflow in the appropriate cell Year 0 1 2 3 4 * 56 Accumulate Cash Flow ** Given the below proposed project cost and estimated cashflows, fill in the "yellow" cells. Project Cost: Project Term (yrs): Required Return: Project IRR: NPV at Required Return: Traditional Payback (yrs): $2,000,000 6.00 9.00% NPV Cost/Flow Calculation ($2,000,000) $ 400,000 $450,000 $ 500,000 $ 500,000 $ 500,000 $ 450,000 * insert the present value of each year's cashflow in the appropriate cell Year 0 1 2 3 4 * 56 Accumulate Cash Flow **

Answer rating: 100% (QA)

The following calculations are as shown ... View the full answer