1. Excel’s IRR function. Excel’s IRR function calculates the internal rate of return for a series of cash flows, assuming equal-size payment periods. Using the example data shown above, the IRR ...

To find out the amount of interest you'll pay, multiply the interest rate (0.5) by the term (3) by the initial amount ($5,000). Your total interest payment over the life of the loan will be $750.

An example Let's say your lender offers you a $200,000 mortgage at 4% interest. The lender charges one discount point ($2,000) and an origination fee of $750, making the total up-front cost $2,750 ...