Assignment:
Develop a loan amortization project using Excel spreadsheets. This can be a car loan or a home mortgage. You will develop two alternative loan schedules using realistic rates and repayment schedules and write up a comparison of your two amortization schedules. This involves two tables and two line graphs displaying the decrease in principal.
1. Open the spreadsheet, plan which two loans you want to compare.
2. Fill in the cells for loan amount, rate, and years for the loan.
3. Create two line graphs for the ending balance. Please label the bottom or x axis and the left of the graph or y axis. Write a title across the top.
4. Use the CTRL button to select years and ending balance COLUMNS
5. Insert a line graph, choose the first picture of a line graph. REPEAT for the second loan.
6. Delete the blue points from the graph, label the left side "Ending Balance".
7. In Microsoft Word, write about the trends you see in the amortization table in two paragraphs. My Suggestions: Write another two paragraphs about the second amortization table. Then write your last two paragraphs comparing the two tables.
Provide complete and step by step solution for the question and show calculations and use formulas.