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

Learn how to calculate the internal rate of return (IRR) in Excel and how it’s used to determine whether a capital investment can be profitable.

Method Two Let’s assume that we didn’t calculate the IRR of 57% as we did above and have no idea what the correct discount rate is. We can use Excel’s What-If calculator in this case.

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.

Using Excel to calculate IRR with unequal timing of cash flows In the chart below, we have management's estimation for the initial cost and cash flow returns for both the expansion and new ...

Percentages aren't always easy to calculate, but one of the best tools in Excel's toolbox is calculating percentages for you. Here's how to do it.

How to Calculate the Average Return for the Share of Stock in Excel Credit: Next, I need to fill in all the other cash flows I've received from my Microsoft investment.

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