1. Create an amortization table (in excel or other spreadsheet) for a 60 month car loan. Assume you borrowed $20,000 and have good credit, earning you the ability to borrow at 4.57%. Provide totals to all columns. How much did you pay in interest over the term of the loan?

2. Create an amortization table (in excel or other spreadsheet) for a 60 month car loan. Assume you borrowed $20,000 and do not have good credit. Your cost of borrowing is 9.22%. Provide totals to all columns. How much more did you pay in interest for the car loan compared to #1 above.

3. Using a spreadsheet program to calculate the answer to the following: The day your child is born, you deposit $100 into an account earning 7% interest. You contribute the same amount each month for their first year. On their first birthday, they receive $500 in cash gifts which you add to the account. For their second year, you are able to add $200 each month to the account. On their second birthday, they receive $1,000 in cash gifts which you add to the account For years 3, 4, and 5, you add $250 each month to the account For years 6, 7, 8, 9, and 10, you add $300 each month to the account For years 11, 12, 13, 14, and 15, you add $350 each month to the account For years 16, 17, and 18, you have your child invest their $500 a month part time job check into the account A) What are the effects if you had NOT contributed the $500 on from their first birthday? B) What are the effects if the child didn't contribute during their 18th year? C) What are the effects if you had switched and contributed $1,000 on their first birthday and $500 on their second?