1. Proceed to build your first amortization schedule using the amount of money you will need to borrow in order to buy the car for your present value, and the first finance offer that you found
2. and format in excel .
3. On the second worksheet tab at the bottom, right click and rename the tab replacing "Sheet 2" with "Amort 2" or something else appropriate to the assignment.
4. Proceed to build your second amortization schedule using the amount of money you will need to borrow to buy the car for your present value, and. You may choose to apply different formatting .
5. "Sinking Fund" followed by the Sinking Fund formula using the car price as the future value to determine the payment necessary to save up to purchase the car. Choose any interest rate from 1% to 2% and an amount of time that would be reasonable to save up the money.
6. Under the formula, list separately the amount of the deposit you found, how often the deposit is made, the rate you chose, the amount of time it took, what your contributions were, and how much interest you earned. the percent, compounding, and time.

Finance offer 1: Financing Offer 1.99% APR For 60 Months Dealership 2022 Audi RS e-Tron)

Monthly Payment$2,500 (duration can change based on credit )

Term60 months

APR: 1.99%

60 monthly payments of $17.52 per $1000 financed

Finance offer 2: 3.17% APR For 60 Months: Dealership 2022 Audi RS e-Tronl )

Monthly payments: 2,500 (duration can change based on credit )

Term60 months

APR: 3.17%

60 monthly payments of $18.04 per $1000 financed