Calculate each column of the table

Reference no: EM132157918

Question: Using the loan and payment plan developed in Problem, determine the month that the final payment is due, and the amount of the final payment, if $500 is paid for Payment 8 and $280 is paid for Payment 10. This problem requires a separate amortization table giving the balance due, principal payment, and interest payment for each period of the loan

Problem: Develop a complete amortization table for a loan of $4500, to be paid back in 24 uniform monthly installments, based on an interest rate of 6%. The amortization table must include the following column headings:

Payment Number, Principal Owed (beginning of period), Interest Owed in Each Period, Total Owed (end of each period), Principal Paid in Each Payment, Uniform Monthly Payment Amount.

You must also show the equations used to calculate each column of the table. You are encouraged to use spreadsheets. The entire table must be shown.

Reference no: EM132157918

Questions Cloud

Write a paer about the hussein-mcmahon correspondence : Write a two to three page paper about the Hussein/McMahon Correspondence. the Sykes/Picot Agreement and the Balfour Declaration.

Execution of supply agreement valid against purple machine : Paul signs the Supply Agreement on behalf of Purple Machine, Inc. Is the execution of the Supply Agreement valid against Purple Machine, Inc.? Why?

What were the chief motives for european expansion : What were the chief motives for European expansion in the fifteenth and sixteenth centuries?

Benefits of job analysis and job evaluation : Using the Internet explore the various benefits of job analysis and job evaluation.

Calculate each column of the table : Develop a complete amortization table for a loan of $4500, to be paid back in 24 uniform monthly installments, based on an interest rate of 6%.

Mechanisms does strategic planning influence performance : What mechanisms does strategic planning influence performance, to what extent does it impact performance.

What types of people would like to read this kind of book : What does the title do for you? Does it spark your interest? Does it fit well with the text of the book?

How much would need to be set aside : A man is buying a small garden tractor. There will be no maintenance cost during the first 2 years because the tractor is sold with 2 years free maintenance.

Write a pepr about the reies tijerina and the land grants : Write a pepr about the Reies Tijerina and the land grants.

User Account

All Pages