You would like to purchase a car with a negotiated price of $39,000, and the dealer offers financing over a 4-year period at 6%. If repayments are to be made monthly, at the end of each month, what would be the monthly payments? Calculate using (a) financial calculator or (b) Excel function PV. (Round answer to 2 decimal places, e.g. 52.75. Round interest rate per month to 4 decimal places, e.g. 1.2597%.) Monthly payments $
You would like to purchase a car with a negotiated price of $39,000, and the dealer offers financing over a 4-year period at 6%. If repayments are to be made monthly, at the end of each month, what would be the monthly payments? Calculate using (a) financial calculator or (b) Excel function PV. (Round answer to 2 decimal places, e.g. 52.75. Round interest rate per month to 4 decimal places, e.g. 1.2597%.) Monthly payments $
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
please ansert the following questions thanks

Transcribed Image Text:You would like to purchase a car with a negotiated price of $39,000, and the dealer offers financing over a 4-year period at 6%. If
repayments are to be made monthly, at the end of each month, what would be the monthly payments? Calculate using (a) financial
calculator or (b) Excel function PV. (Round answer to 2 decimal places, e.g. 52.75. Round interest rate per month to 4 decimal places, e.g.
1.2597%.)
Monthly payments
Expert Solution

Step 1
Given: -
Price (PV): - $39,000
Number of payments (Nper): - 4 years*12= 48
Rate (r): - 6%= 6/12=0.50%
Payment: - monthly
Step by step
Solved in 2 steps

Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education