The average student loan debt is approximately $30,000 as of 2023. Interest rates vary based on the type of load, but 5% is about the average interest rate. It is common for students to have to pay the loan back over the time period of 10 years. Create an Excel Worksheet determine (A) The total amount of money paid on the loan and (B) The amount of money paid in interest on the loan Please note the results that you SHOULD get for the first three rows are shown in the template (see Cells Q13 U16). However, your spreadsheet should determine the cells highlighted in yellow by using equations in Excel to perform the calculations. You need to complete the table out to 120 total payments (monthly payments for 10 years). Also, note that some cells have dollar amounts so be sure that the numbers are formatted properly. HINT: Be sure that you know how to use the fill handle (click and drag

The principal after payment is the principal before payment less principal that was paid (Paid on Principal) (A) and (B) are sums and there is only one value (that is why there is no yellow highlighting after the first row)