While basic calculations are easy enough to do in this way, Excel is packed with hundreds of formulas — some common, others esoteric — that you can apply to values in your spreadsheet.

To do this calculation, we'll use a spreadsheet to make the calculation as easy as possible. First, we'll set up the data. In a column in the spreadsheet, input the amount financed in the top cell.

With spreadsheets, you store and analyze sets of data, which is key in many businesses. Spreadsheets offer a range of automated functions to perform calculations on data in addition to building ...

You may have already used Microsoft Excel spreadsheets to calculate the expected rate of return. If so, simply use the value in that cell to represent the expected return in the risk premium formula.