Problem 20 - Calculating Payment Calculating Loan Payments You want to buy a new sports coupe for $69,300, and the finance office at the dealership has quoted you a loan with an APR of 5.6 percent for 48 months to buy the car. What will your monthly payments be? What is the effective annual rate on this loan? Input area: Amount borrowed APR # of years # of times compounded per year $ 69,300 5.6% 4 12 (Output area) Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Loan payment Effective interest rate
Added by Christopher V.
Close
Step 1
Annual interest rate = 5.74% / 12 = 0.4783% Show more…
Show all steps
Your feedback will help us improve your experience
Supreeta N and 89 other Principles of Accounting educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Recommended Videos
Find the monthly payments and total interest for loan A
Supreeta N.
How much would your monthly payment be on a 5-year loan if the following assumptions were true? You borrowed $6,500. The fixed APR on the loan is 4.3%. Note: A fixed APR is an annual interest rate that does not change during the 5-year period. You will make equal monthly payments to repay both the loan amount and the monthly interest charges. You want to completely pay off the loan in exactly 5 years. (Round to the nearest cent, do not include a negative sign) Note: while this money is "leaving your wallet" the negative sign should not be included in the numeric answer because it is already implied by the word "payment" What is the total amount that you would pay to the bank over this 5-year period? Hint: Be sure to use your rounded answer from the previous step in the calculation of this answer. (Round to the nearest cent, do not include a negative sign) How much total interest would you have paid to the bank? (Round to the nearest cent, do not include a negative sign)
Patrick R.
Use the appropriate function(s) in Excel to answer the following questions. How much would your monthly payment be on a 5-year loan if the following assumptions were true? You borrowed $6,400. The fixed APR on the loan is 5.5%. Note: A fixed APR is an annual interest rate that does not change during the 5-year period. You will make equal monthly payments to repay both the loan amount and the monthly interest charges. You want to completely pay off the loan in exactly 5 years. Number (Round to the nearest cent, do not include a negative sign) Note: while this money is "leaving your wallet" the negative sign should not be included in the numeric answer because it is already implied by the word "payment" What is the total amount that you would pay to the bank over this 5-year period? Hint: Be sure to use your rounded answer from the previous step in the calculation of this answer. Number (Round to the nearest cent, do not include a negative sign) How much total interest would you have paid to the bank? Number (Round to the nearest cent, do not include a negative sign)
Danielle F.
Recommended Textbooks
Horngren’s Cost Accounting
Cost Accounting A Managerial Emphasis
Principles of Accounting Volume 1: Financial Accounting
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD