How to create a running total in Excel
1
Start with =SUM. Click on the cell where you want your running total to begin. Next, select the SUM function on that cell. ...
2
Create a running total formula. You must use the dollar sign in this formula, even if the numbers you're tallying are not dollar amounts.
The total required equity contribution i.e. the shortfall in capital can be calculated by deducting the total debt from the total uses. Then, the management rollover can be calculated by multiplying the rollover assumption (pro forma ownership) by the required equity contribution.