# Incremental revenue: How do you calculate it in Excel?

Asked 2 years ago

What does the excel formula for incremental revenue look like?

Albert Bowen

Friday, May 27, 2022

Excel is one of the most effective tools, especially for processing complex calculations. People frequently ask how to calculate incremental revenue in Excel. The process is pretty straightforward.

Incremental Revenue = Units sold * Price per unit

To calculate IR in Excel, follow these steps:

- Open a new Excel workbook and name it "Incremental revenue analysis."
- List all your relevant revenue assumptions.
- In cell B2, compute the original revenue by multiplying the total units produced by their selling price.
- Calculate the Adjusted Revenue in cell B3 by making various production and pricing assumptions.
- Now take the differences between your original and adjusted revenue to compute your Incremental Revenue in cell B4.

Note: You can consider using BeProfit to track your expenses in one place and get the most accurate results.

Donnell Cash

Thursday, September 15, 2022

Follow the given steps to calculate your incremental revenue in an Excel spreadsheet:

- Create a simple outline for revenue and add the incremental costs from the B1 cell to the right.
- Now add Revenue Cost starting from A2 to downwards.
- Create equations by starting the first intersection of increment and cost. Type A2*B1 to direct Excel for the mathematic procedure.
- Highlight the B2 cell and drag the black box towards the remaining costs at the bottom. Repeat the process for other rows to complete the worksheet.

Please follow our Community Guidelines