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.

Calculate interest for each period by multiplying the ending balance by the period rate. Principal reduction is the monthly payment minus the interest.

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 ...

Learn how to calculate principal and interest on loans, including simple interest and amortized loans, and understand the impact on your monthly payments and loan costs.

The loan amount that you borrow is called the principal, and the interest represents the cost of borrowing charged by the lender. To calculate the principal and interest, multiply the principal ...

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

How to Use Excel to Calculate the ROI on a Product. "Return on investment" is a financial calculation used to gauge how well the money you invest earns you even more money. To calculate ROI you ...

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