PLease make a excel spread sheet for this!

You are trying to decide what makes more economic sense - to purchase a car or to lease one. The car that you like is a 2023 Honda Accord. You plan to keep the car for 9 years, which will either entail three, 3-year leases, or you can purchase the car. You have an account with $40,000 that earns 5%, compounded monthly. You can use the account to make the monthly lease or loan payments if you wish, or you can take $25,000 out of the account and pay for the car in cash. You have two ways that you can purchase the car. You can take $25,000 out of the fund (see above), or you can take out an auto loan. The loan rate will be 6% and you can pay back the loan in 36 months, 48 months, 60 months, or 72 months. You should make an amortization table of the option that you choose. Note that longer loans have smaller monthly payments but you end up paying more interest over the lifetime of the loan. If you take out a loan, your down payment will be $2500. You will need to figure out the amount of your monthly payment, depending on which loan you opt for. The sales tax on your initial purchase of the car is $2000, which you will have to pay upfront (not as part of the loan). In the year 2033 ,the car will be worth $8500. Once you have paid off the auto loan, you can invest the money that you would have spent on loan payments in an account paying 5%, compounded monthly, if you choose that option. You are trying to decide what makes more economic sense - to purchase a car or to lease one. The car that you like is a 2023 Honda Accord. You plan to keep the car for 9 years, which will either entail three, 3-year leases, or you can purchase the car. You have an account with $40,000 that earns 5%, compounded monthly. You can use the account to make the monthly lease or loan payments if you wish, or you can take $25,000 out of the account and pay for the car in cash. You have two ways that you can purchase the car. You can take $25,000 out of the fund (see above), or you can take out an auto loan. The loan rate will be 6% and you can pay back the loan in 36 months, 48 months, 60 months, or 72 months. You should make an amortization table of the option that you choose. Note that longer loans have smaller monthly payments but you end up paying more interest over the lifetime of the loan. If you take out a loan, your down payment will be $2500. You will need to figure out the amount of your monthly payment, depending on which loan you opt for. The sales tax on your initial purchase of the car is $2000, which you will have to pay upfront (not as part of the loan). In the year 2033 ,the car will be worth $8500. Once you have paid off the auto loan, you can invest the money that you would have spent on loan payments in an account paying 5%, compounded monthly, if you choose that option