Question: Please show this as an Excel document WITH all Formulas. Thank you! 1. Create an amortization table in Excel for a new car loan for

Please show this as an Excel document WITH all Formulas. Thank you!

1. Create an amortization table in Excel for a new car loan for 30,000 for six years at 5%. Determine the total amount of interest you will pay on this loan.

2. Copy the table from Step 1, make an extra principal payment of $2,000 on the first day of year two. How does this change the total interest you will pay on this loan?

3. Create an amortization table in Excel for a new car loan for 30,000 for three years at 5%. Determine the total amount of interest you will pay on this loan.

4. Copy the table from Step 3, change the interest rate to 2%. How does this change the total interest that you will pay on the loan?

5. What is the total amount you will pay for the car (principal and interest) in each of the steps 1,2,3 and 4.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Need the following assignment done in excel. see attached. 1. Create an amortization table in Excel for a new car loan for 30,000 for six years at 5%. Determine the total amount of interest you will...

Objective: The assignment will help you to understand how changes in loan terms and payments will affect the total amount you pay. 1. Create an amortization table in Excel for a new car loan for...

1. Create an amortization table in Excel for a new car loan for30,000 for six years at 5%. Determine the total amount of interestyou will pay on this loan. 2. Copy the table from Step 1, make anextra...

You established a start-up company and are looking to finance a car. This will be the first car for the company. You narrowed down your search and decided to finance a car from Honda, Nissan or...

THE COMPANY: Aylmer Industries Inc. (Aylmer) has been in business since 2017. Since Aylmer is a publicly traded company, it follows IFRS. Aylmer posted accounting transactions throughout the year....

Sparkles Dessert Cafe Please read the instructions carefully and provide what is being requested. A new client of yours, Bailey Waters wants to open a small dessert cafe selling cupcakes, pie slices,...

1. A high performance all-terrain vehicle (ATV) is bought at a price of S20 000. It loses 10% of its value every year. Express this scenario as a sequence recursively and explicitly (provide its...

Scenario Summary Current Values: Original Financing Intermediate Car Changing Cells: Price $ 56,500 $ 21,595 $ 33,999 $ CashBack $ 2,500 $ $ 1,500 $ Months 60 24 36 APR 3.90% 1.90% 2.40% Result...

i need help to get these two amortization tables started and the scenario 2 questions. at least 15 rows to help me see how and some questions... down below are the formulas to the questions Amount...

2. (2 points) In what month will the borrower begin paying more towards principal month than interest? 3. (2 points) What is the total amount of interest the borrower will pay over the life of this...

It is estimated that the average downtime for computer systems at businesses across the country is 175 hours a year (source: networkworld.com). In a sample of 50 companies located outside major...

Multiple-Choice Questions 1. Which one of the following transactions is not governed by Article 2 of the UCC? (a) Purchasing an automobile for $35,000 (b) Leasing an automobile worth $35,000 (c)...

Which of the following statements regarding the guaranteed residual value is true? a . The entire guaranteed residual value is included when measuring and recording the right - of - use asset and...

The following is known about the four savings accounts offered by competing banks. Which of these deals is the best for depositors? A. EAR = 10%, interest is compounded quarterly. B. APR = 10%,...

Identify the types of informal reports.

Write messages that are used for the various stages of collection.

Describe the four elements that are encompassed in the indirect plan for persuasive messages.