(1.1) Scenario 1 - First, calculate how much your student loan will cost you. - For the student loans, in C18), write a formula to calculate the total amount you will pay during the first five years of the thirty year loan? - Reference the appropriate values in the tables at the top of the worksheet. - Note: student loans are paid monthly. MyEducator Tasks (1) Financial Formulas You're finishing school and got a great job offer. You've also been saving some money for a while and have that in your savings account. You are wondering what to do about your student debt, mortgage, and car payment. You wonder if it's time to buy a condo and sell your old car or if you should invest some money and postpone more debt. Consider the following three scenarios. (1.1) Scenario 1 - First, calculate (1.2) Scenario 2 - Suppose you want to use your signing bonus as a down payment for the condo and 60% of your savings as a down payment on the car. Please answer the following: - What will be the monthly payment for the car? - Write a formula in C22). - Remember, 60% of savings is used as a down payment on the car. (2