Please do 3.9 and 3.10

3.9 Calculate what you paid before the pause. a. Place your calculation in cell H13). b. Use the initial monthly payment rate. c. Multiply this rate times the number of payments made before the pause. 2 3.10 Calculate what you paid after the pause. a. Place your calculation in cell H14). b. Use the new monthly payment rate. c. Multiply this rate times the number of payments remaining after the pause. 2 H14 B C D E F G H 1 j K L M N O P O R 1 2. 3 4 5 Amount Needed Fee Percent Financial Stress and Forbearance 2 Years into loan hit 6 month pause button Interest accrues - no payment made Fee Loan Amount 6 7 Basic Loan W35,000.00 1.06% W371.00 W35,371.00 6.20% 10 120 W396.25 Balance at 2 years 6 months Interest New Balance W29,930.63 1927.85 #30,858.48 8 9 Annual Interest Rate Term-Years # of monthly Payments Payment Months remaining New Payment 96 1408.54 10 11 12 13 14 Total Cost of the Loan W47,550.30 Period# Interest Balance Reduction Paid before pause Paid after Pause New Cost of the Loan 0 15 16 17 1 182.75 181.65 2 Added Cost 18 3 W180.54 179.42 19 4 20 5 21 6 22 7 W213.50 W214.61 W215.71 216.83 217.95 219.08 220.21 221.34 *222.49 W223.64 W224.79 W225.95 W227.12 23 178.30 #177.18 W176.05 #174.91 #173.76 W172.61 W171.46 8 24 9 25 10 26 11 Loan Balance W35,371.00 135,157.50 W34,942.89 W34,727.181 134,510.35 W34,292.40 W34,073.331 133,853.12 W33,631.77 33,409.28 W33,185.65 32,960.85 W32,734.90 W32,507.78 W32,279.48| 132,050.01 W31,819.34 W31,587.49 W31,354.44 W31,120.191 W30,884.72 W30,648.04 30,410.14 W30, 171.001 27 12 170.30 28 13 W169.13 29 14 W167.96 30 31 32 15 16 17 18 19 33 228.30 W229.48 230.66 W231.85 W233.05 234.25 235.46 236.68 W237.90 W239.13 W166.78 W165.59 W164.40 W163.20 W162.00 W160.79 W159.57 158.35 W157.12 34 20 35 36 37 38 21 22 23