Cervetti Corporation has two major business segments-East and West. In July, the East business segment had sales revenues of $390,000, variable expenses of $210,000, and traceable fixed expenses of $46,000. During the same month, the West business segment had sales revenues of $1,060,000, variable expenses of $540,000, and traceable fixed expenses of $203,000. The common fixed expenses totaled $314,000 and were allocated as follows: $157,000 to the East business segment and $157,000 to the West business segment. A properly constructed segmented income statement in a contribution format would show that the segment margin of the East business segment is:

Pettijohn inc. the balance sheet and income statement shown below are for pettijohn inc. note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. balance sheet (millions of $) assets 2016 cash and securities $ 1,554.0 accounts receivable 9,660.0 inventories 13,440.0 total current assets $24,654.0 net plant and equipment 17,346.0 total assets $42,000.0 liabilities and equity accounts payable $ 7,980.0 notes payable 5,880.0 accruals 4,620.0 total current liabilities $18,480.0 long-term bonds 10,920.0 total debt $29,400.0 common stock 3,360.0 retained earnings 9,240.0 total common equity $12,600.0 total liabilities and equity $42,000.0 income statement (millions of $) 2016 net sales $58,800.0 operating costs except depr'n $54,978.0 depreciation $ 1,029.0 earnings bef int and taxes (ebit) $ 2,793.0 less interest 1,050.0 earnings before taxes (ebt) $ 1,743.0 taxes $ 610.1 net income $ 1,133.0 other data: shares outstanding (millions) 175.00 common dividends $ 509.83 int rate on notes payable 1. what is the firm's current ratio? (points : 6) 0.97 1.08 1.20 1.33 2. what is the firm's quick ratio? (points : 6) 0.49 0.61 0.73 0.87 3. what is the firm's total assets turnover? (points : 6) 0.90 1.12 1.40 1.68 4. what is the firm's inventory turnover ratio? (points : 6) 4.38 4.59 4.82 5.06 5. what is the firm's debt ratio? (points : 6) 45.93% 51.03% 56.70% 70.00% 6. what is the firm's roa? (points : 6) 2.70% 2.97% 3.26% 3.59% 7. what is the firm's roe? (points : 6) 8.54% 8.99% 9.44% 9.91%

Benton company (bc), a calendar year entity, has one owner, who is in the 37% federal income tax bracket (any net capital gains or dividends would be taxed at a 20% rate). bc's gross income is $395,000, and its ordinary trade or business deductions are $245,000. ignore the standard deduction (or itemized deductions) and the deduction for qualified business income. if required, round computations to the nearest dollar. a. bc is operated as a proprietorship, and the owner withdraws $100,000 for personal use. bc's taxable income for the current year is $ , and the tax liability associated with the income from the sole proprietorship is $ . b. bc is operated as a c corporation, pays out $100,000 as salary, and pays no dividends to its shareholder. bc's taxable income for the current year is $ , and bc's tax liability is $ . the shareholder's tax liability is $ . c. bc is operated as a c corporation and pays out no salary or dividends to its shareholder. bc's taxable income for the current year is $ , and bc's tax liability is $ . d. bc is operated as a c corporation, pays out $100,000 as salary, and pays out the remainder of its earnings as dividends. bc's taxable income for the current year is $ , and bc's tax liability is $ .

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?