1. Assume you want to buy a Car on an auto loan. Your total Car loan (or Car price) is $35,000. The bank charges you 4.5% rate with 72 months of installments. Develop and upload a complete loan schedule in Excel with the help of "Loan Amortization" Excel under Chapter 2.

2.

Assume you want to buy a Car on an auto loan. Your total Car loan (or Car price) is $35,000. The bank charges you 4.5% rate with 72 months of installments. What will be the principal balance on your loan account at the end of the 12th month? Refer to your Loan Schedule from the previous question.

Assume you want to buy a Car on an auto loan. Your total Car loan (or Car price) is $35,000. The bank charges you 4.5% rate with 72 months of installments. What will be the principal balance on your loan account at the end of the 12th month? Refer to your Loan Schedule from the previous question.

$30,244

$32,456

$33,648

$29,784

3.

Assume you want to buy a Car on an auto loan. Your total Car loan (or Car price) is $35,000. The bank charges you 4.5% rate with 72 months of installments. What is the total interest paid that you will be paying over the 72 months for this loan? Refer to your Loan Schedule from the previous question.

Assume you want to buy a Car on an auto loan. Your total Car loan (or Car price) is $35,000. The bank charges you 4.5% rate with 72 months of installments. What is the total interest paid that you will be paying over the 72 months for this loan? Refer to your Loan Schedule from the previous question.

$5,456

$4,505

$5,003

$4,700