w Uw Format Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? D E F H K L Loan Amount Number of years Annual Interest Rate Payments per year Loan Payment Update and complete this spreadsheet. Enter the appropriate values, functions or formulas In column B as indicated by the appropriate labels in column A and the information provided below. Do not hard code any values in any formulas ar functions. It should look Inice and be formatted appropriately. Enter the correct numbers, functions or formulas in the cells in column 3 to calculate the weekly payment as indicated in the headings in column A and the following I'm borrowing $38,400 for years. The annual interest rate is 5.25%. I am making weekly payments. Complete this worksheet as per the headings in column A Create a table, as we did in dass, that shows how the payment varies when the number of years of the loan varies from 3 years to 7 years in one year increments. I can afford a payment of $150 a week. Use a utility that will show me how much the loan amount will be to have a payment of $150. (10 points) Form Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? C D E F G H 3 Loan Amount 4 Number of years 5 Annual interest Rate 6 Payments per year 8 Loan Payment 9 10 Update and complete this spreadsheet. Enter the appropriate values, functions or formulas 11 in column B as indicated by the appropriate labels in column A and the information 12 provided below. Do not hard code any values in any formulas or functions. It should look nice" and be formatted appropriately 13 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Enter the correct numbers, functions or formulas in the cells in column B to calculate the weekly payment as indicated in the headings in column A and the following I'm borrowing $38,400 for 6 years. annual interest rate is 25% tam making weekly payments. Complete this worksheet as per the headings in column A Create a table, as we did in class, that shows how the payment varies when the number of years of the loan varies from 3 years to 7 years in one year incernents. I can afford a payment of $150 a week. Use a utility that will show me how much the loan amount will be to have a payment of $150. (10 points) 33 34 35 Prob Prob Info