Question

In: Finance

Building an Income Statement. During the year, the Senbet Discount Tire Company had gross sales of...

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

Solutions

Expert Solution

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:


Related Solutions

During the year, the Senbet Discount Tire Company had gross sales of $1.22 million. The company’s...
During the year, the Senbet Discount Tire Company had gross sales of $1.22 million. The company’s cost of goods sold and selling expenses were $591,000 and $244,000, respectively. The company also had notes payable of $830,000. These notes carried an interest rate of 7 percent. Depreciation was $121,000. The tax rate was 21 percent. What was the company’s net income? What was the company’s operating cash flow?
The Sterling Tire Company's income statement for 20XX is as follows: STERLING TIRE COMPANY Income Statement Year en...
The Sterling Tire Company's income statement for 20XX is as follows: STERLING TIRE COMPANY Income Statement Year ended December 31, 20XX Sales (50,000 tires at $65 each) $3,250,000Less: Variable costs (50,000 tires at $40)2,000,000 Contribution margin1,250,000  Less: Fixed costs1,050,000 Earnings before interest and taxes (EBIT)200,000Interest expense75,000Earnings before taxes (EBT) 125,000Income tax expense (35%)43,750Earnings after taxes (EAT)$81,250Given this income statement, compute the following a. Degree of operating leverage. b. Degree of financial leverage. c-1. Degree of combined leverage. c-2. Using your answers to a. and b. calculate the percentage increase in...
The Sterling Tire Company's income statement for 20X1 is as follows STERLING TIRE COMPANY Income Statement...
The Sterling Tire Company's income statement for 20X1 is as follows: STERLING TIRE COMPANY Income Statement For the Year Ended December 31, 20X1 Sales (23,000 tires at $66 each) $1,518,000Variable costs (23,000 tires at $33) 759,000Fixed costs 430,000Earnings before interest and taxes (EBIT) $ 329,000Interest expense 51,500Earnings before taxes (EBT)  $277,500Income tax expense (30%) 83,250Earnings after taxes (EAT) $ 194,250a. Compute the degree of operating leverage.b. Compute the degree of financial leverage.c. Compute the degree of combined leverage.d. Compute the break-even point in units.
The Sterling Tire Company’s income statement for 20XX is as follows:    STERLING TIRE COMPANY Income Statement...
The Sterling Tire Company’s income statement for 20XX is as follows:    STERLING TIRE COMPANY Income Statement Year ended December 31, 20XX   Sales (20,000 tires at $60 each) $ 1,200,000       Less: Variable costs (20,000 tires at $30) 600,000   Contribution margin 600,000       Less: Fixed costs 400,000   Earnings before interest and taxes (EBIT) 200,000   Interest expense 50,000   Earnings before taxes (EBT) 150,000   Income tax expense (34%) 51,000      Earnings after taxes (EAT) $ 99,000 Given this income statement, compute the following:...
The Sterling Tire Company’s income statement for 20XX is as follows:    STERLING TIRE COMPANY Income Statement...
The Sterling Tire Company’s income statement for 20XX is as follows:    STERLING TIRE COMPANY Income Statement Year ended December 31, 20XX   Sales (35,000 tires at $50 each) $ 1,750,000       Less: Variable costs (35,000 tires at $20) 700,000   Contribution margin 1,050,000       Less: Fixed costs 750,000   Earnings before interest and taxes (EBIT) 300,000   Interest expense 75,000   Earnings before taxes (EBT) 225,000   Income tax expense (30%) 67,500      Earnings after taxes (EAT) $ 157,500 Given this income statement, compute the following:...
The Sterling Tire Company’s income statement for 20XX is as follows: STERLING TIRE COMPANY Income Statement...
The Sterling Tire Company’s income statement for 20XX is as follows: STERLING TIRE COMPANY Income Statement Year ended December 31, 20XX Sales (30,000 tires at $45 each) $ 1,350,000 Less: Variable costs (30,000 tires at $20) 600,000 Contribution margin 750,000 Less: Fixed costs 600,000 Earnings before interest and taxes (EBIT) 150,000 Interest expense 75,000 Earnings before taxes (EBT) 75,000 Income tax expense (30%) 22,500 Earnings after taxes (EAT) $ 52,500 Given this income statement, compute the following: a. Degree of...
The Brenmar Sales Company had a gross profit margin (gross profits /  sales) of 28% and sales...
The Brenmar Sales Company had a gross profit margin (gross profits /  sales) of 28% and sales of $8.3 million last year. 73% of the firm's sales are on credit, and the remainder are cash sales. Bertram's current assets equal $1.4 million, its current liabilities equal $299,999, and it has $108,000 in cash plus marketable securities. A. If Brenmar's accounts receivable equal $563,100, what is its average collection period? B. If Brenmar reduces its average collection period to 20 days, what...
The Brenmar Sales Company had a gross profit margin (gross profit/sales) of 28% and sales of...
The Brenmar Sales Company had a gross profit margin (gross profit/sales) of 28% and sales of $8.6 million last year. 70% of the firm’s sales are in credit, and the remainder are cash sales. Brenmar’s current assets equal $1.4 million, its current liabilities equal $299,000, and it has $106,000 in cash plus marketable securities. A. If Brenmar’s accounts receivable equal $562,600, what is its average collection period? B. If Brenmar reduces its average collection period is 25 days, what will...
how a cash discount affects the income statement with the gross method and the net method....
how a cash discount affects the income statement with the gross method and the net method. That is, where does the sales discount or the sales discount forfeited appear?
The Brenmar Sales Company had a gross profit margin (gross profits divided by ÷ sales) of...
The Brenmar Sales Company had a gross profit margin (gross profits divided by ÷ sales) of 26 percent and sales of $9.3 million last year. 79 percent of the firm's sales are on credit, and the remainder are cash sales. Brenmar's current assets equal $1.8 million, its current liabilities equal $ 303,500, and it has $104,100 in cash plus marketable securities. a. If Brenmar's accounts receivable equal $563,000 , what is its average collection period? b. If Brenmar reduces its...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT