A B F G Student Number. 4321169 4321169 1.9% D E Savings Goal Nominal Periodic #of Payments Payment 60 Interest Payment Number Payment Amount Change in Fund Balance Amount 0 1 Step 1 2 Input the last 5 digits of your student # 3 into B2. It should copy over to F1. 4 Step 2 5 Calculate the periodic interest based 6 on 3% compounded monthly in F3. 7. Consider monthly payments. 8. Step 3 9 Calculate the payment amount to 2 10 decimals in F5 using the PMT function. Step 4 12 Fill in rows 0 - 60 accordingly. 13 Remember, all payments in a sinking 14 fund are calculated the same. Step 5 16 Using the SUM function in D70, 17 calculate the amount of interest 18 earned for this loan. 1 2 3 4 5 6 7. 8 9 10 COM