DISCOVER

# How to calculate total revenue

Updated April 17, 2017

The total revenue of a company is simply everything that comes into the company. This can be from sales or from other income streams like interest on bank deposits. You can create a model in spreadsheet to automatically calculate total revenue each month, and then create a total for the year.

Open your spreadsheet program and start a new spreadsheet. Write “Total Revenue for:” in cell A1. Every time you enter data into this spreadsheet you will write the period name in cell B1. Write “Item” in cell A2, “Price” in B2, “Quantity” in C2 and “Item Total” in D2.

Write down the name of each product you sell in column A, starting with cell A3. If the names are long, stretch out column A so the entire name is visible. At the end of the list put another entry called “Other Revenue” and then another called “TOTAL.”

Enter the unit price for each item in the B column alongside its name. In D3 enter the formula: =B3*C3. Click on the small square in the bottom right hand corner of the frame around D3 and drag it down so the frame includes the D column cell above the “Other Revenue” row. Let go of the mouse button. An adjusted version of the formula will be copied into each cell in the D column.

Click in the D column cell for the TOTAL row. Press the sum button in the menu bar. This is usually written as “Σ” on the button. The spreadsheet should suggest all of the fields in the D column that have the formula in it. This is usually done by showing a frame with a dotted line around those cells. If it doesn’t, click in D3 and drag the mouse down to the D cell of the “Other Revenue” row.

Save the spreadsheet. This will be your template to use for your total revenue calculations. Choose “Save As” to prevent yourself from overwriting the template and save a copy with the name of the period you want to calculate total revenue for.

Enter the name of the period you are calculating total revenue for in the cell B1. Enter sales figures -- the quantities sold -- for each item in your list. Write in any other money that came into the business that did not arise from the sale of these items, like bank deposit interest, in the “Item Total” column for the “Other Revenue” row. The model will automatically calculate your total revenue in the Item Total column of the TOTAL row.