Task Instructions

In cell C$8,$ create a formula using the PV function to

calculate the total loan amount using monthly payment,

rate, investment period values in cells C$5$:C$7.$ In cell C$9,$ create a formula using the PMT function to

calculate the monthly loan payment using interest rate,

and loan period values in cells C$4$:C$8.$ Enter the formula

with a $-($negative$)$ sign to return a positive value. Do not

specify values for the optional arguments fi or type.Task Instructions

In cell B$5,$ enter a formula using defined names to subtract

DirectCosts $($cell B$4)$ from Revenues $($cell B$3).$