Posts Tagged ‘annuity by loan secured’

Breaking Loan Payments Into Principal and Interest Components

Microsoft Excel can help you down a loan payment into its principal and interest components. Excel’s IPMT function lets you calculate the interest component of a loan payment. And Excel’s PPMT function lets you calculate the principal component of a payment.

Using the IPMT Function to Calculate Payment Interest

The IPMT function calculates the interest portion of a payment given its interest rate, Read the rest of this entry »

Technorati Tags: , , , , , , , , ,