This finance video tutorial explains how to calculate the monthly payment on a mortgage given the principal, the interest rate, and the loan period. This video also explains how to calculate the total interest paid over the lifetime of a loan. How To Calculate The Monthly Payment Using The PMT Function In Excel: Liquidity Ratios: Assets, Liabilities, & Equity: The Short Ratio: Debt to Equity Ratio: Time Value of Money: _____________________________ Future Value of Annuity: More Examples on Annuities: How To Calculate The Monthly Mortgage Payment: The Present Value of an Annuity: Net Present Value & Internal Rate of Return: ____________________________ Annual Percentage Yield: Amortization Loan Formula: Amortization Table: Rule of 72: Bond Yields: