Calculate the monthly payment on the loan

Assignment Help Finance Basics

Reference no: EM131453538

Question: You have just taken a car loan of $15,000. The loan is for 48 months at an annual interest rate of 15% (which the bank translates to a monthly rate of 15%/12 = 1.25%). The 48 payments (to be made at the end of each of the next 48 months) are all equal.

a. Calculate the monthly payment on the loan.

b. In a loan table calculate, for each month: the principal remaining on the loan at the beginning of the month and the split of that month ' s payment between interest and repayment of principal.

c. Show that the principal at the beginning of each month is the present value of the remaining loan payments at the loan interest rate (use either NPV or the PV functions).

Reference no: EM131453538

Questions Cloud

Analyze the process to be used in project to convert data : The inefficiencies surrounding the project. Analyze process to be used in the project to convert data to a monetary value. How this information will be used?

Targeted versus mass marketing : Think of a product you believe is mass marketed. How did you arrive at this conclusion? You might want to comment on classmates' posts.

Identify a non-nursing theory : NR 501: Select a nursing practice area - nursing education; then identify a non-nursing theory and apply it to the nursing practice area you have.

What are the benefits of public health assessments : What are the benefits of public health assessments? What are the disadvantages, if any. How can public health assessments be used to form public policy

Calculate the monthly payment on the loan : You have just taken a car loan of $15,000. The loan is for 48 months at an annual interest rate of 15%.

Global competitive advantage : Select a company of your choice. What has been their global competitive advantage (either successful or not)?

Element of the triple constraint of project management : Briefly explain in your own words the relationship between each element of the triple constraint of project management

Why good leaders make bad decisions : Why Good Leaders Make Bad Decisions? Why it Pays to be Socially Responsible! Communicating Corporate Social Responsibility to a Cynical Public.

Calculate the monthly effective rate : You are considering buying a car from a local auto dealer. The dealer offers you one of two payment options: • You can pay $30,000 cash.

User Account

All Pages