Be sure to copy this formula down the column so additional shifts on other rows will calculate, as well. Click the bottom line of a cell and drag it down the column to copy it.

The formula for the down payment is created in cell F2. Because I want this one formula to calculate the down payment for all my loans, I will multiply the selling price of all loans by the down ...

Find out more about return on equity, the formula to calculate ROE, and how to calculate this measure of corporate profitability in Microsoft Excel.