Learn how to use the powerful Excel PMT Function to help you manage your loan payments and easily calculate detailed loan repayment schedules ...

How to Use Excel to Calculate Amortization. Microsoft Excel is a widely used spreadsheet program that can use formulas to compute and display values. When your small business is taking out a loan ...

How to Calculate a Loan's Monthly Payment in Excel With Tax & PMI. Your monthly loan payment consists of more than just equity and interest payments. If you didn't put down at least 20 percent ...

Learn more about the loan-to-value (LTV) ratio, what the ratio measures, and how to calculate the loan-to-value ratio using Microsoft Excel.

We show you how to calculate compound interest in Excel at different rate of interests, like semi-annually, quarterly, monthly, etc.

Unfortunately, you cannot access the Excel spreadsheet everywhere. In such a case, you can use your mathematical mind or an electronic calculator to know how much the EMI comes to.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.