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$ M O B Loan Scenarios $1$ Aggressive Conservative $4\mathrm{.}5$ $$10\mathrm{.}000$ Moderate $50$ $$17\mathrm{.}50004$ MAR May Ban Mont Rate Penete na Loan Amount S $1>$ $$25\mathrm{.}0000\mathrm{.}543$ $$43529$ Task instructions $301112$ In cells, create a formata using the PV tunction to calculate the total loan amount using monthly payment, rate, investment period values in CS:C$7.$