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 »
