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

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!

Thunder Corporation, an amusement park, is considering a capital investment in a new exhibit. The exhibit would cost $136,000 and have an estimated useful life of 5 years. It will be sold for $60,000...

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...

Case: Tees R Us - Solutions Tees R Us, set up as a privately held corporation, operating as a t-shirt retailer, of which 100% of the Common Shares are owned by Tamara Green. You were hired to account...

Cese. DITO Shopper - Solutions DITO Shoppee owned by Graham Smith, is a freestyle clothing rear You were hired to account the transactions and report the status of the business. They use the...

You are going to receive at the end of every year, for the next 50 years, a nominal fixed payment of $1,000. The present value of this nominal stream of cash payment is $19,047. Considering that the...

If f is differentiable at a, where a > 0, evaluate the following limit in terms of f (a): fx) - f(a) lim

Vancouver Company has three products, A , B , and C with contribution margins of $ 4 . 4 0 , $ 3 . 6 0 , and $ 1 . 8 0 respectively. The president forecasts sales of 2 4 0 , 0 0 0 units in the coming...

Medwig Corporation has a DSO of 17 days. The company averages $3,500 in credit sales each day what is the companys average accounts receivable?

A 4-kg object is subjected to two forces, F 1 = 2 N i - 3 N j and F 2 = 4 n i - 11 N j . The object is at rest at the origin at time t = 0. (a) What is the objects acceleration? (b) What is its...

Calculating Interest Rates a financial planning service offers a college savings program. The plan calls for you to make six annual payments of $5,000 each, with the first payment occurring today,...

The symmetric concrete gravity dam is held in place by its own weight. If the density of concrete is c and water has a density w, determine the smallest distance d at its base that will prevent the...

Pearson Brothers recently reported an EBITDA of $7.5 million and net income of $1.8 million. It had $2.0 million of interest expense, and its corporate tax rate was 40%. Calculate its charge for...

Why should an entrepreneur do a feasibility study?Group of answer choicesTo determine the practical viability of the business idea.To consider alternatives.To evaluate the financial result.To...

=+Now write the same commercial as a 15-second spot. What copy could you eliminate and still deliver the same message?

=+The TV spot should be for an unusual flavor of Jones soda like the following: a. Turkey & gravy b. Broccoli and cheese c. String bean casserole d. Pumpkin pie

=+Think about the kinds of talent you will be casting, so you have their voices and images in your mind.