Reviewed by David Kindness The debt service coverage ratio (DSCR) is used in corporate finance to measure the amount of a ...

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.

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 how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

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