All the yellow has to be figured out. Please use Excel if possible as I'd like to see cell references. At least show formulas and plug pieces in for me so I can create an accurate model. Thanks so much!

89 90 Given the following information about 4 mutually exclusive projects that are expected to be repeated infinitely, complete the table information (the shaded blanks). Assume that all projects are equally risky and will have the 91 same cost of capital. Which project should be chosen? 92 93 A C D 94 CFO B ($1,600,000) $565,000 ($2,225,000) ($2,460,000) ($1,500,000) $712,000 95 Inflows (equal for life of project) 96 Project Life 97 NPV $350,000.00 98 IRR 20.00% 99 MIRR 18.50% 100 PAYBACK (Yrs) 2.5 101 Terminal Value 102 WACC 103