Two-year auto loan with monthly payments

Assignment Help Business Economics
Reference no: EM132369072

Using the example in lecture notes, what is a similar repayment schedule for a $20,000 two-year auto loan with monthly payments and an effective annual percentage rate (EAR) of 5.00%.

This exercise is most easily done using a spreadsheet program. Some hints:

(1) In order to find each month's interest rate, you need to first convert EAR to APR.

(2) The monthly payment amount is the key item to calculate, which can apply the annuity formula.

(3) The second key item is the interest amount every month, which is calculated using monthly interest on the loan balance at the beginning of the period.

(4) Try to replicate the example first, to make sure you've got things working.

By making fixed monthly payments on your loan, you are repaying the principle amount over the next 24 months. This process of paying off a loan by making regular principal reductions is called amortizing the loan. For your first and last monthly loan payment, what percentages of your payment go to paying your interest, and what is the pattern? How much interest your will pay over the life of the loan?

Reference no: EM132369072

Questions Cloud

Identify issues relating to socio-economic : Topic - Socio-economic. Question - Identify issues relating to your chosen topic with reference to the changing historical context of New Zealand education
Competitiveness of the home market : A strongly competitive home market can sharpen a firm's competitive advantage relative to firms located in less competitive markets.
Emphasize or indications about limits to increase : Do the instructions give suggestions about important areas that the governor wants to emphasize or indications about limits to increase in funding?
What standards of internal control were violated here : 1. What standards of internal control were violated here? 2. How would you revise financial practices in the District to prevent similar fraud in the future?
Two-year auto loan with monthly payments : Using the example in lecture notes, what is a similar repayment schedule for a $20,000 two-year auto loan with monthly payments
How much can he spend each month after retirement : (a) If he wants to use up all his money at the age of 90, how much can he spend each month after retirement?
Amount of the expected synergy : What is the $ amount of the expected synergy? What is the value of Pixar to Disney?
Differences between cash flows used in capital budgeting : What are the differences between cash flows used in capital budgeting calculations and past accounting earnings?
Value consequences of a dividend change : Discuss the effect both on the total return and on the capital gain. Which should be larger?

Reviews

Write a Review

Business Economics Questions & Answers

  Evaluate the results of the regression equation

Evaluate the results of the regression equation tells managers and how it is likely to impact decisions made related to maximizing profitability.

  What creates a monopoly

What distinguishes pure competition in the long run from pure competition in the short run?

  What is the present value of these future profits

A firm will have constant profits of $100,000 per year for the next four years, and the interest rate is 6 percent. Assuming these profits are realized at the end of each year, what is the present value of these future profits?

  Steel manufacturer purchases an iron ore mine and coal mine

A steel manufacturer purchases an iron ore mine and a coal mine.

  Federal reserve injects money into the banking system

he Fed began paying interest on reserves in October 2008. Holding all else constant, what effect would this have on the money supply? When the Federal Reserve injects money into the banking system, it initially causes an excess _____ of money. Equili..

  Calculate lilliputs balance of trade

Suppose the country of Lilliput exported 263 billion dollars worth of goods while they imported 477 billion dollars worth of goods in the last calendar year. Calculate Lilliput\'s balance of trade:_____ billions of dollars.

  Tens of thousands of retail outlets

You work for a large company with tens of thousands of retail outlets throughout the world. The average sales at each retail outlet is $2,400,000 per year

  Write the equation for the consumers budget line

A consumer must divide $600 between the consumption of product X and product Y. The relevant market prices are Px = $10 and Py = $40. a. Write the equation for the consumer's budget line. b. Illustrate the consumer's opportunity set in a carefully la..

  What is the equation of marginal costs

What is the equation of marginal costs? At what level of output are average total costs at their minimum?

  Examine and analyze the case organizations rules

SBM3204 - Sustainability and Ethics - Examine and analyze the case organizations rules, policies to ethics in business decisions making

  Is the true mean greater than the hypothesized mean

Is the true mean greater than the hypothesized mean? Use a = 0.05.

  Introduce and explain what the article is about

Choose any article from the newspaper, magazine or internet pertaining to macroeconomics (U.S. Unemployment). Express your opinion using first person singular case: I agree or disagree with the article either totally,partially or do not agree. Justif..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd