You are thinking of investing in one of two corporations, both in the same industry, the Craig Corporation or the Lori Corporation. Selected data follows:
Sales and expense data for the year ended 12/31/17:
Craig: Gross revenue $47,350,000; Returns $2,510,000
Lori: Gross revenue $56,295,000; Returns $3,780,000
Selling expenses:
Craig: Payroll $4,442,000; benefits $2,150,000, travel $650,200; supplies $450,150, commissions $720,400, marketing $1,010,000, postage $310,300, misc $61,500.
Lori: Payroll $4,991,000; benefits $2,350,000, travel $521,200; supplies $590,650, commissions $622,300, marketing $845,000, postage $305,100, misc $221,300.
Administrative expenses:
Craig: Distribution $2,331,000, warehouse $1,175,000, IT $642,200, finance $583,400, human resources $492,250; administrative $383,000, depreciation $187,000
Lori: Distribution $2,922,310, warehouse $1,630,000, IT $692,410, finance $615,270, human resources $362,760; administrative $580,400, depreciation $197,100.
Other Gains and Losses
Craig: Sale of machine with a book value of $37,500 for $8,000 cash.
Loss due to fire damage of $312,000
Lori: Sold a marketable security at a loss of $193,200
Sold a building machine with a book value of $235,000 for $102,200
Irregular Items:
Craig: Profit of discontinued division (not yet sold) of $212,000
Lori: Loss on sale of discontinued division of $875,000 before tax effect.
In addition Craig discovered an inventory error from 2015 which had the effect of overstating income for 2016 by $65,000 before tax.
Tax rates: 35% for both companies:
Outstanding shares of common stock:
Craig: 2,000,000 $1PV shares authorized 1,100,000 shares issued and outstanding.
Lori: 3,100,000 $1PV shares authorized 1,250,000 shares issued and outstanding.
Dividends: both companies paid cash dividends of $1.25 per share.
Selected Balance Sheet Information:
Craig: Cash $1,622,000; marketable securities (at cost $410,300, at fair value $695,400); Account receivable (gross $1,875,400 less allowance for doubtful accounts of $112,100); Finished goods inventory, opening balance $399,400, purchases $12,843,400, ending balance $785,610. Prepaid expenses $40,210, Plant assets at cost $22,700,000, accumulated depreciation $8,612,000, Accounts payable, $493,410, accrued expense payable $311,260, bonds payable $4,814,693, capital stock $1,450,000, beginning retained earnings $2,510,215.
Lori: Cash $1,910,000; marketable securities (at cost $652,430, at fair value $699,400); Account receivable (gross $3,135,400 less allowance for doubtful accounts of $122,300); Finished goods inventory, opening balance $322,640, purchases $14,892,400, ending balance $285,420. Prepaid expenses $61,310, Plant assets at cost $19,953,527, accumulated depreciation $8,395,000, Accounts payable, $733,450, accrued expense payable $342,480, bonds payable $1,644,400, Capital stock $2,210,000, beginning retained earnings $1,850,500.
Required:
1) Prepare a separate schedule comparing the selling and administrative expenses of the two companies. Separate subtotals are required for both selling and administrative expenses. You should have a column which compares the dollar difference by line item of the two companies.
2) Prepare a separate schedule of cost of goods sold for each of the companies.
3) Prepare a comparative income statement in good form for the two companies. Be sure the selling, administrative and cost of goods number comes from your first two schedules by way of formula. Do not simply type in numbers. Percentage of sale data should be presented for cost of goods sold, gross margin, selling expense and administrative expense and net income.
4) Prepare an EPS summary (include disc operations) following your income statement.
5) Prepare a classified balance sheet as shown in chapter 5 of the text. Capital stock must be broken down between common stock and additional paid in capital.
6) Prepare a statement of Retained Earnings. Make sure the net income number is transferred from the income statement by formula and also that total Retained earnings is transferred to the balance sheet by formula.
7) Properly formatted numbers, the appropriate use of $ signs, underlines and double underlines are imperative. Style counts big! Add percentages of difference on B/S. & I/S