Develop a complete amortization table for a loan

Assignment Help Business Economics

Reference no: EM131807531

Using the loan and payment plan developed in Problem 4-120, 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

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: EM131807531

Questions Cloud

Discuss what is the addition to retained earnings : depreciation expense of $43,000, interest expense of $32,000, and a tax rate of 35 percent) $73,000 in cash dividends. What is the addition to retained earnings

Bank because it offered continuous compounding : Barry decided to deposit in the first bank because it offered continuous compounding. Did he make the right decision?

Quarterly deposits made into an account : The first deposit occurs on October 1, 2012, and the last deposit occurs on January 1, 2026. The account earns 13% compounded continuously.

Develop a complete amortization table for a loan : 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%.

What is the earnings per share or eps figure : What is the earnings per share, or EPS, figure. What is the dividends per share figure

What is the present worth of cash flows : What is the present worth of cash flows that begin at $20,000 and increase at 7% per year for 10 years? The interest rate is 9%.

Calculate the pw of the revenue stream : when the assembly plant will be closed (at the end ofYear6). If the firm'sinterest rate is 10%, calculate the PW of the revenue stream.

How do we make an acting impact on students today-tomorrow : How do we make an acting impact on students today - tomorrow, so we position ourselves for the gift in the future?

User Account

All Pages