1. பொ Design hele O to what you want to Share A A A AED - Prod Ar BLU ABC ABCD AaBbc Bcc AaB Paste Op Sect Day FINC 3733

[answerhappygod]

1 (26.76 KiB) Viewed 32 times

2 (26.76 KiB) Viewed 32 times

1. பொ Design hele O to what you want to Share A A A AED - Prod Ar BLU ABC ABCD AaBbc Bcc AaB Paste Op Sect Day FINC 3733 Spring 2022 Ch 5 Excel Assignment You plan to buy a new car. The car loan will be so 000. The loan is for 5 years and Interest rate is 3.6% per year. Use Excel to set up a 5-year amortization schedule table and answer the following questions 1. How much is the monthly payment? 2 How much is the remaining balance after 3 years (36 months)? 2. How much total interests would you have paid in the 1st year (trom month 1 to month 12) Label and highlight your answers for above 3 questions. Your results should reflect the formula sed. A grade of zero will be assigned for results with copied or "typed numbers. Excel features covered in this assignment Creating worksheets Ener