You are interested in buying a brand-new jalopy and expect the purchase price to be $19,000. The car dealership can offer financing at a 6% interest rate over 6 years. If you put 1,000 down towards the purchase and accept the financing terms, what will your monthly payment for the loan be? In Excel, I need to know all the steps in Excel for the answer. Everything thing needs to be filled in, so I have all parts answered for this question. Thank You! Please do not use another example in Excel because that is not the way i am supposed to solve it all arguments in EXCEL need to be entered when using  PMT in Excel I have the answer I need to show how I came up with that answer using all the arguments in one box not broken down to 2 different steps. Thanks, and here is the answer.298.31 The following are the values given to calculate the monthly payment. The purchase price of the jalopy is $19,000 and down payment is $1,000. Hence, the present value of jalopy is $18,000 ($19,000 - $1,000). The annual interest rate is 6%. But the monthly interest rate should be considered as the monthly payment need to be calculated. Hence, the monthly interest rate is 0.005 (6%/12). The period of the loan is 6 years and compounded monthly. Hence, the number of monthly payments is 72 (6 × 12). Calculate the monthly payment as follows: MS-Excel --> Formulas --> Financials --> PMT In the earlier questio you did not enter a FV or type and I do need to know that. I have to enter ever function into Exel this is my second time sending this back to you please do it correctly in EXCEL. Thank You so much! I have to enter a 0 or 1 in FV of the problem I just cannot leave it blank so should I put a 0

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

You are interested in buying a brand-new jalopy and expect the purchase price to be $19,000. The car dealership can offer financing at a 6% interest rate over 6 years. If you put 1,000 down towards the purchase and accept the financing terms, what will your monthly payment for the loan be? In Excel, I need to know all the steps in Excel for the answer. Everything thing needs to be filled in, so I have all parts answered for this question. Thank You! Please do not use another example in Excel because that is not the way i am supposed to solve it all arguments in EXCEL need to be entered when using  PMT in Excel I have the answer I need to show how I came up with that answer using all the arguments in one box not broken down to 2 different steps. Thanks, and here is the answer.298.31

The following are the values given to calculate the monthly payment.

The purchase price of the jalopy is $19,000 and down payment is $1,000. Hence, the present value of jalopy is $18,000 ($19,000 - $1,000).

The annual interest rate is 6%. But the monthly interest rate should be considered as the monthly payment need to be calculated. Hence, the monthly interest rate is 0.005 (6%/12).

The period of the loan is 6 years and compounded monthly. Hence, the number of monthly payments is 72 (6 × 12).

Calculate the monthly payment as follows:

MS-Excel --> Formulas --> Financials --> PMT In the earlier questio you did not enter a FV or type and I do need to know that. I have to enter ever function into Exel this is my second time sending this back to you please do it correctly in EXCEL. Thank You so much! I have to enter a 0 or 1 in FV of the problem I just cannot leave it blank so should I put a 0

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Cost of Credit
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education