E H Loan Amortization Assignment Lars May 2022 and you landed a role in your field making $45,000 Per Year (which cquals $3,750 gross per month), However, you realize that you have to pay back your federal and private student loans so you call your loan service to get your Joan details You find out you owe $90,000 in student loans and the representative shares the loan details below. Loan Balance APR (Annual Percentage Rate) Fixed) Term 590,000 4.25% 20 Years Wait, but there is more. Your car recently experienced a major mechanical ime and you determine that is would be best to get another car. Currently, the price of used cars has increased due to supply and demand issues within our current economic environment You find a reliable car that cost $20,000. The car representative shares the loan details below. Loan Balance $20,000 APR (Awal Perontage Rate) (ed) 5.25% Term 6 Y Create an amortization for both scenarios en different tabs and swer the following questions dow How much did you make in the total principal payments? 12. How much did you make in the total interest payments? 2. How much did you pay back in total? 4. If interest rates increased on your indent loans, how will that impact your monthly payments? 5. How much do you have remaining after making your student loan and car payment? ("This will be based upon your pros monthly income and your total monthly 24 payments 15 16 37