On the sheets named Future Value and Present Value, build formulas for all the cells shaded green. Note you will need to build the algebraic formulas for the cells on Row 24 and the appropriate Excel functions for the cells on Row 27.

SINGLE CASH FLow Present Value Single Cash Flow - Present Value Inputs $T50 Cash fow at t 6 (or FV) Number of periods (or nper) $0 (S1,000) ($2,000) ($3,000) ($4,000) (S5,000) ($6,000) $7,000) 2% Discount Rate Present Value using a Time Line Cash FlowS 7?? $750.00 Enter the Eqn 8.2a in each green cell that uses FV $750, n 6, and the interest rate in Row 22. There will be seven formulas with cdifferent interes rates. 0% 4% 6% 10% 8% 12% Present Value using the Formula Present Value (using Eqn 8-2a) Use the PV function in each green cell where fv $750, nper 6, Present Value using the PV Function Present Value and rate in Row 22. There will be seven functions with different interes rates. Note if you enter fv as a positive value, the results will be negative, so enter it as a negative