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.

Use Excel in your rate card formulas to calculate discounts, dimensions and unit costs of your advertising rate document. Instead of manually calculating each of these components, use Excel ...

The adjusted premium added to the risk-free rate is the difference in the expected market return times the beta of the asset. This formula can be calculated in Microsoft Excel as shown below.

If your business makes investments in equipment and employee benefit contributions, you may need to track the average annual rate of return over a span of time for financial reporting obligations.

Calculating CAGR or Compound Annual Growth Rate in Microsoft Excel is super easy. You will have to use the RRI function to get the job done.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.