In: Finance
Building an Income Statement. During the year, the Senbet Discount Tire Company had gross sales of $925,000. The firm's cost of goods sold and selling expenses were $490,000 and $220,000, respectively. Senbet also had notes payable of $740,000. These notes carried an interest rate of 4 percent. Depreciation was $120,000. Senbet's tax rate was 35 percent.
a. What was Senbet's net income?
b. What was Senbet's operating cash flow?
Please provide the following for each in the tan box:
| Sales |
| Cost of goods sold |
| Selling expenses |
| Notes payable |
| Interest rate |
| Depreciation expense |
| Tax rate |
| a) | Particulars | $ |
| Sales | 925,000 | |
| Less: Cost of goods sold | 490,000 | |
| Gross Profit | 435,000 | |
| Less: Selling expenses | 220,000 | |
| EBITDA | 215,000 | |
| Less: Depreciation | 120,000 | |
| EBIT | 95,000 | |
| Less: Interest expense | 29,600 | |
| EBT | 65,400 | |
| Less: Taxes at 35% | 22,890 | |
| Net Income | 42,510 |
| b) | Particulars | $ |
| Net income | 42,510 | |
| Add back depreciation | 120,000 | |
| Add back Interest expense | 29,600 | |
| Operating cash flow | 192,110 |
Note:
1) We add back depreciation because it is a non-cash expense.
2) We add back interest expense because it is cash flow from
financing activity.
3) EBITDA = Earnings Before, Interest, Taxes, Depreciation and
Amortization.
Excel formulas:
