Using the Composition of Loan Payments Chart an Interactive Chart

question 35

Essay

Using the Composition of Loan Payments Chart An interactive chart for investigating the composition of loan payments is provided in the textbook's Online Learning Centre (OLC). Go to the Student Edition of the OLC. In the navigation bar, select "Chapter 14" in the drop-down box. In the list of resources for Chapter 13, select "Links in Textbook" and then click on the link named "Composition of Loan Payments."
The chart provides cells for entering the essential information about a loan (PV, j, m, PMT, and payments/year). You can then compare the composition (interest and principal components) of any two payments. Simply enter the serial numbers of the two payments and then click on the "Submit" button. Two bar diagrams provide a visual comparison of the interest and principal components. The actual numerical values are also displayed.
Consider a $120,000 mortgage loan at 6.5% compounded semi-annually. Monthly payments of $800 will pay off the loan in 25 years and 4 months.
a) How much more interest is paid by the 20^th payment than the 220^th payment?
b) How long does it take before the interest component of a payment drops below 50%?
c) Which payment number is closest to being comprised of: (i) 75% interest? (ii) 25% interest?
d) Which payment number comes closest to having a mix of principal and interest that is the opposite of the first payment's mix?
e) Which payment number comes closest to having double the principal component of the 5^th payment?
f) Which payment number comes closest to having half the interest component of the 10^th payment?

---

Definitions:

Inconsistent Service

Variation in the quality or delivery of services provided to customers, leading to unpredictable customer experiences.

Air Transportation

The movement of people and goods by aircraft, an essential component of global logistics and travel.

Damages

Compensation sought by or awarded to a party in a legal case due to loss, injury, or harm caused by another party's actions or negligence.

Supply Chain Management

The oversight and control of the movement of goods and services from supplier to customer, optimizing efficiency and cost-effectiveness.