Page 1 of 1
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
Posted: Wed Mar 09, 2022 8:41 am
by answerhappygod
- 1 (26.76 KiB) Viewed 33 times
- 2 (26.76 KiB) Viewed 33 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