Compute the payback statistic for Project B if the appropriate cost of capital is 10 percent and the maximum allowable payback period is three years. (Round your answer to 2 decimal places. If the project never pays back, then enter a "0" (zero).)

profilehona10
excel_spread_sheet_problem_1_improved.xlsx
Home>Business & Finance homework help> Compute the payback statistic for Project B if the appropriate cost of capital is 10 percent and the maximum allowable payback period is three years. (Round your answer to 2 decimal places. If the project never pays back, then enter a "0" (zero).)

Sheet1

Compute the NVP for project M
Project M
Year Cash Flow PVIF PV
0 ($1,900) ($1,900)
1 $530 0.9091 $481.82
2 $660 0.8264 $545.45
3 $700 0.7513 $525.92
4 $780 0.683 $532.75
5 $280 0.6209 $173.86
NPV
Discount Rate 0.08%
NPV
IRR