1. Fill the yellow blanks with proper Excel formulas to solve for the variables.

Discounted Payback Discount Rate Discounted Cash Flow Leftover # of Years CFO 12% Cash Flow ($165,000) $63,120 $70,800 $91,080 CF1 1 CF2 CF3 Payback CFO CF1 CF2 NPV & IRR ($29,000) $4,300 $9,800 $15,200 $16,800 $21,200 CF3 CF4 CF5 IRR 1 11% NPV CFO CF1 CF2 Profitability Index ($165,000) $63,120 $70,800 $91,080 CF3 | 12% PV of CFs PI