Projected Income Minus Expenses

This may be presented in the form of an income statement.

Projected income minus expenses. Estimating your projected income involves calculating your net income which is your gross profit minus operating expenses. But don t let that sad song get you too down. How do i calculate projected income in cell c4 using the growth rate. Projected balance projected income minus expenses 940 00 actual balance actual income minus expenses 960 00 difference actual minus projected 20 00 entertainment projected cost actual cost difference video dvd 0 00 50 00 50 00 cds 0 00 movies 0 00 concerts 0 00 sporting events 0 00 live theater 0 00 other 0 00 other 0.

If you spend more than you budgeted the difference between the projected and actual values will be negative and if your actual income is less than your projected income the difference will be a negative number. How to create a formula for income expenses in excel. Budgeted expenses should never exceed 90 of your take home income. I have an excel work sheet with current income of 2 560 00 in cell b4.

By adding up your income and expenses and seeing where the difference lies you ve taken the most important step yet to creating a budget that will allow you one day to sing happy days are here again. In cell f1 is 10. Net income ni is calculated as revenues minus expenses interest and taxes. In cell e1 is the word growth rate.

Earnings per share are calculated using ni. Actual balance actual income minus expenses projected balance projected income minus expenses 960 income 1. After you ve assembled. If your net.