Calculate the principal remaining on the loan

Assignment Help Financial Management

Reference no: EM131954779

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) Create a loan table: For each month, calculate 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: EM131954779

Questions Cloud

What else will the ato charge on tax shortfall : Daniel was audited by the ATO. He runs a furniture business. What else will the ATO charge on tax shortfall?

Children funding when it is ready to buy equipment : If the annual interest rate on the investment is 15%, how much will be available to the Children Funding when it is ready to buy the equipment?

Start saving for retirement : You have just turned 35, and you intend to start saving for your retirement. All savings draw compound interest of 10% per year.

Explain relationship between interest rates and bond value : Explain the relationship between interest rates and bond value. What makes interest rates change?

Calculate the principal remaining on the loan : Calculate 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.

Forecasts are objective-realistic and unbiased : Financial statements analysts must ensure that their forecasts are objective, realistic, and unbiased.

What is the minimum annual cash flow required : What is the minimum annual cash flow required to make the purchase of this asset viable?

Do you think you will be able to live comfortably with money : Do you think you will be able to live comfortably with the money from the answer to the question above?

Calculate the expected rate of return on this bond : What is the value of the coupon payment? Calculate the expected rate of return on this bond for the year.

User Account

All Pages