Question: An example is a car purchase where you might pay $3,500 down and borrow $31,000 towards a $34,500 car. If the annual interest rate is

An example is a car purchase where you might pay $3,500 down and borrow $31,000 towards a $34,500 car. If the annual interest rate is 5.45%, you will be making 60 monthly payments and if these payments completely pay off the loan so that no money is due at the end of these payments, what would be the amount of your monthly payment? Assume that the payment is made at the end of each month. Include the equation you used to calculate your answer.

Use the =PMT Excel function to solve this problem.

Step by Step Solution

★★★★★

3.38 Rating (151 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To calculate the amount of the monthly payment for the car l... View full answer

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!

Accounting for Membership Fees and Rewards Program (FSET) BJ's Wholesale Club Holdings, Inc., provides the following description of its revenue recognition policies for membership fees and its reward...

KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...

13. What is a lower bound for the price of 3-month call option on a non- dividend-paying stock when the stock price is $50, the strike price is $45, and the 3-month risk-free interest rate is 8%?...

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

An example is a car purchase where you might pay $3,500 down and borrow $31,000 towards a $34,500 car. If the annual interest rate is 5.45%, you will be making 60 monthly payments and if these...

solve Question two On 31 December 2001, an inexperienced bookkeeper working for Wanji, a sole trader extracted a trial balance. Due to errors committed by the bookkeeper, the trial balance failed to...

Your dream is about to come truel You are about to buy your first sports car. To do so, you have arranged to borrow $80, 000 from your local commercial bank. The interest rate on the loan is 7.00%....

Please help with General Journal, General Ledger, Inventory Valuation, Bank reconciliation and Financial statements Q-A 616 X C D E H F 1 Case: Northern Reflections 5 Northern Reflections sells...

Part I (50 points) Due: _Tues, Sept 10 at beg of class From SUA IFL: Copies of the following general ledger accounts: 10100-Cash 10200 - Accounts Receivable 10300 - Allow. For Doubtful Accts 30100 -...

Chapter 4 Assignment 13. More on the time value of money The time value of money concept can be applied in various situations and is a fundamental concept underlying other financial concepts....

Please help me with heneral journal, general ledger, inventory valuation, bank reconciliation and financial statemnts determined for the inventory The opening balances for the month of September are...

The United States has a progressive tax system, meaning people with higher taxable incomes pay higher feder tax rates. Being "in" a tax bracket doesn't mean you pay that federal income tax rate on...

prince corporation acquired 100 percentage ownership of savr company on jan 1,20X8 for $ 122400. b. prepare a three part consolidation worksheet for 20X9

Property insurance that provides $ 1 0 0 , 0 0 0 coverage for a building and $ 5 0 , 0 0 0 coverage for personal property at a single location is called A . Specific coverage. B . Schedule coverage....

How many compounds among the following may 90. exhibit tautomerism? CH NO; 'N. Ph- CH = CH-OH Ph Ph (1) 1 (2) 2 3) 3 4) 4

Facebooks success can be credited to Web 2.0 technologies, network effects and their Application Programming Interfaces (APIs). However as recent events have proven that these three are also a...

Granny wishes to give her grandchild $10,000 when the child turns 18 in 10 years time. She has two options:- Option 1 : She can make 10 equal deposits (1st in one years time, 2nd in two years time...

The graph of a sinusoidal function intersects its midline at (0,-3) and then has a maximum point at (2,-1.5). Write the formula of the function, where r is entered in radians. f(z) =| %3D

In all other cases A unifom surface charge density 8a exists over the entire xy-plane except for a circular hole of radius 'a' centered at the origin. The electric field at a point P(0,0, 3a). On the...

The City of Golden Mountain began construction this year on a new fire station. It is financed by a $4,000,000 bond issue and supplemented by $1,000,000 to be transferred from the General Fund. The...

Since the early 1970s, the U.S. government has had a program called the Earned Income Tax Credit (previously mentioned in end-of-chapter exercises in Chapter 3.) A simplified version of this program...

Suppose that you have tastes for grits and other goods (where the price of other goods is normalized to 1). Assume throughout (unless otherwise stated) that your tastes are quasilinear in grits. A:...

Tax Revenues and the Laffer curve: In this exercise, we will consider how the tax rate on wages relates to the amount of tax revenue collected. A. As introduced in Section B, the Laffer curve depicts...

Describe how an understanding of social psychology can help people improve their lives.

If X and Y are normally distributed and we let Z = cX + d and W = bY + g, discuss the relationship between the F ratio for ox2 and cry2 and the F ratio for crz2 and aw2- Consider the following two...

Suppose that we take a sample of size 1 from an exponential distribution with parameter X. Can you find a 90 percent confidence interval for X based on this single sample observation?