Two projects have following projected cash flows:

Years Project A CFs Project B CFs

$0-9,500-16,400$

$16,0003,500$

$25,5004,000$

$3-4,5005,000$

$44,500-5,050$

$508800$

$607800$

Find:

Use $7\%$ WACC

Project's A discounted bayback period?

Project's B discounted bayback period?

Project's A NPV$?$

Project's B NPV$?$

Profitability index for project A$?$

Profitability index for project A$?$

IRR for A$?$

IRR for B$?$

Project's A Equivalent Annual Annuity?

Project's B Equivalent Annual Annuity?

Project's A MIRR. For investemnt rate use IRR rate?

Project's B MIRR. For investemnt rate use IRR rate? ALL SOLUTIONS in EXCEL!