$4$ Now, using the Student Loan Amount given below, perform each of the calculations indicated. Refer to the

$17$ Financial formulas section provided on the Instructions Word document as needed. Do not use the Excel built$-$in $=$ PMT$()$ function.

$18$

$19$

Format all financial amounts as Currency with the $ symbol and $2$ decimal places, and all $n$ and $t$ entries as Number with $0$ decimals.

$20$

Subsidized Student Loan $($determine the monthly payment required for a $10-$year loan$)$

$21$

$22$

$23$

$24$

$25$

$26$

$27$

$28$

$29$

$30$

$31$

$32$

$\backslash$table$[[$Initial principal amount to repay $($P$),$$$32,734\mathrm{.}00,],[6\mathrm{.}81\%],[,,4,$Number of years while in school$],[,,,$Additional interest accrued'while in school$],[,,,$New principal amount to repay $($P$)],[$Number of payments per year $($ n $),12,,],[$Number of years $($t$),10,,],[$The monthly loan payment $($PMT$)$ based on the initial principal,,,The monthly loan payment $($PMT$)$ based on the new principal amount$],[$Total amount paid on the loan,,,Total amount paid on the loan$],[$Interest paid on loan,,,Interest paid on the loan $($including the interest accrued while in school$).]]$