Excel

Depreciation of Existing Fixed Assets
Recall that when we last looked at our income statement, we had only calculated up to EBITDA. To get to operating income (i.e. EBIT), we need to compute...
Read more
Depreciation of Capital Expenditures
As the company makes capital investments, these assets will also depreciate. Now, let's add the depreciation associated with future capital expenditures....
Read more
Operating Income (EBIT)
Now that we have our depreciation and amortization expenses in order, we can revisit the income statement to calculate operating income (i.e. EBIT). We...
Read more
Income Taxes
Now, let's compute taxes on the income statement. We will first revisit the tax schedule we created earlier to link the income before tax we calculated...
Read more