Develop an amortization schedule

Reference no: EM1360232

There are seven years remaining on a ten year car loan. The interest rate is 10.25%. The monthly payments are $450.00. The credit union is willing to accept the present value of the loan as a pay off. develop an amortization schedule Using excel that shows how much will need to be paid at the end of each of the ten years. design and create a worksheet that contains both the beginning and ending balance, the amount paid on the principal, and the interest paid for years 4-10 because the first three years have already been paid. Determine only the ending value for year three.

Reference no: EM1360232

Questions Cloud

Compute cost of preferred stock : Hettenhouse Corporation's perpetual preferred stock sells for $102.50 per share, and it pays a $9.50 annual dividend. If the corporation were to sell a new preferred issue,

What is the magnitude of the charge on each sphere : what is the magnitude of the charge on each sphere. A car crashes into a wall at 45 m/s and is brought to rest in 0.1 s. compute the average force exerted on a 80 kg test dummy by the seat belt.

Learning technique for african american families : Do you think learning by modeling after their parents, grandparents, etc. is a common type of learning technique for African American families?

Explain what this all inclusive web site on all labor laws : Explain what this all inclusive web site on all labor laws and procedures contains and then select one subject or area of information that you learned from this great web site

Develop an amortization schedule : There are seven years remaining on a ten year car loan. The interest rate is 10.25%. The monthly payments are $450.00. The credit union is willing to accept the present value of the loan as a pay off.

External events for a business : External events for a business - What do you think are some of the most influential and current external elements that are impacting it?

Determine the amount in the acount : You have $2,000 invested in a bank account that pays a 4% nominal annual interest with daily compounding. How much money will you have in the account in 132 days from today?

What is the magnitude of one of the masses : what is the magnitude of one of the masses.Vertically polarized light passes through two polarizers, the first at 62rm {^circ} to the vertical and the second at 90 rm {^circ} to the vertical.What fraction of light gets through.

Pharmacotherapy versus psychotherapy : Compare pharmacotherapy (drug) therapy with at least one type of psychotherapy (for example, psychoanalysis, Cognitive Therapy, Rational Emotive therapy, etc.) for psychological disorders.

User Account

All Pages