Learn how to calculate the discount rate in Microsoft Excel, what the discount factor is, and how the discount rate and discount factor compare.

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

Thankfully your handy spreadsheet program can make quick work of this problem. Using Excel to calculate IRR with unequal timing of cash flows ...

The debt service coverage ratio (DSCR) is used to measure a company’s cash flow available to pay current debt. Learn how to calculate the DSCR in Excel.

Calculating the IRR, or an investment’s expected annual rate of growth, is no easy task for investors. Find the formula and tips for calculating IRR.

Earlier, we had seen how the RATE function can be used to calculate the return on investments, whether lump-sum or periodic. This can come in handy in the calculation of SIP returns, too.

Calculating the IRR for a project with an initial outlay and single cash flow is very easy to do. It's also very practical for measuring the returns on investments in collectibles, commodities ...