Question: First, Create two separate amortization schedules in Excel for car loans having a payoff period of 48 months. The first loan is for $20,000 at

First, Create two separate amortization schedules in Excel for car loans having a payoff period of 48 months. The first loan is for $20,000 at an interest rate of 1.9% (nominal per year). The second loan is for $19,000 with an interest rate of 2.9% (nominal per year)

Second,create two more spreadsheets byaddingan extra column on eachwhere you pay $100 additional on your principal every 3 months. How long does it take to pay off each loan after making the extra payments?

If you could post a link to your spreadsheet please do that also show your formulas in excel

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!

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

Imagine that you have decided you need a new car, but not any car will do; you have decided to purchase the car of your dreams. Conduct some research as to the cost of this car. You have determined...

please help me. I can pay only 70 dollars in this assignment Topic 1 & 2 Introduction to financial management and the Australian Taxation system Financial Markets 2 Learning Objectives Describe what...

For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule. 1 ....

For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule. Create...

For this assignment you are required to create two loan amortization schedules. However, after you create the first one, you can simply just copy and paste to add rows for the second schedule. 1 ....

Please help me with the calculations and parts A through F! included in the second photo is the format. Calculations: Formulas: You will compare 2 different amortization schedules when buying a car....

JETRO CORPORATION Unadjusted Trial Balance As Of December 31, 2019 DEBIT CREDIT P 380,000.00 2,000,000.00 1,260,000.00 239,200.00 150,000.00 140,000.00 2,490,000.00 357,000.00 440,000.00 920,000.00...

In part B, what is the loan payoff amount? Round your answer to two decimal places. What is the new balance on Cindy Lus revolving account? Round your answer to two decimal places. What is your loan...

Figure 3. GPA study data. You can download the GPAs spreadsheet and use it for the exercises. Step 1: Analyzing the Grades Sue thinks that students are more motivated to do well in their major...

Prove that (u + v) (u - v) = ||u||2 - ||v||2 for all vectors u and v in Rn.

What amount of lease obligations does PepsiCo report on the balance sheet at December 29, 2007 and what is it obligated to pay by this date?

What is a firm engaging in when it insures itself against exchange risk? Select one: a . carry trade b . arbitrage c . currency speculation d . hedging e . currency swap

One of the largest automobile dealers in the city advertises a 3-year-old car for sale as follows: Cash price $3575, or a down payment of $375 with 45 monthly payments of $93.41. Susan DeVaux bought...

Calculate the maximum non-expansion work per mole that may be obtained from a fuel cell in which the chemical reaction is the combustion of propane at 298 K.

Suppose that 2.5 mmol Ar (g) occupies 72 dm3 at 298 K and expands to 100 dm3, Calculate G for the process.

Calculate the change in Gibbs energyof25 g of methanol (mass density 0.791 g cm-3) when the pressure is increased isothermally from 100 kPa to 100 MPa.

Calculate the change in the molar Gibbs energy of oxygen when its pressure is increased isothermally from 50.0 kPa to 100.0 kPa at 500 K.

Design a minimum-mass symmetric three-bar truss (the area of member 1 and that of member 3 are the same) to support a load P, as was shown in Fig. 2.9. The following notation may be used: Pu = P cos...

=+for the shareholder of the acquiring company?

=+for the shareholder of the acquired company?

=+for the acquired company?