Question

In: Accounting

The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...

The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, and accounts payable increase spontaneously with sales.

CROSBY, INC.
2017 Income Statement
  Sales $ 750,000
  Costs 585,000
  Other expenses 21,000
  Earnings before interest and taxes $ 144,000
  Interest paid 17,000
  Taxable income $ 127,000
  Taxes (22%) 27,940
  Net income $ 99,060
  Dividends $ 29,718
  Addition to retained earnings 69,342
CROSBY, INC.
Balance Sheet as of December 31, 2017
Assets Liabilities and Owners’ Equity
  Current assets   Current liabilities
    Cash $ 20,940     Accounts payable $ 55,100
    Accounts receivable 43,880     Notes payable 14,300
    Inventory 94,960       Total $ 69,400
      Total $ 159,780   Long-term debt $ 133,000
  Fixed assets   Owners’ equity
    Net plant and equipment $ 426,000     Common stock and paid-in surplus $ 116,000
    Retained earnings 267,380
      Total $ 383,380
  Total assets $ 585,780   Total liabilities and owners’ equity $ 585,780

In 2017, the firm operated at 75 percent of capacity. Construct the pro forma income statement and balance sheet for the company. Assume that fixed assets are sold so that the company has a 100 percent asset utilization. (Do not round intermediate calculations.)

sales

cost

other expenses

EBIT

interest

taxable income

Taxes

Net income



What is the EFN? (Do not round intermediate calculations. A negative answer should be indicated by a minus sign.)

Solutions

Expert Solution

1 Costs and other expenses are increased by 20 percent as the sales are increased by 20%

2 Accounts receivable accounts payable and inventory are incresed to the extent of sales growth

3 Cash is the balancing figure means total liabilities and owners equity minus of accounts receivable and inventory

Subtract the company's projected working capital needs and capital expenditures from net income to determine the amount of external financing needed As such, external sources of finance could help to speed up your growth, acquire new equipment, purchase property, support uneven cash flow, release equity, fund marketing campaigns, replenish supplies, provide emergency relief and much more. External sources of finance are equity capital, preferred stock, debentures, term loans, venture capital, leasing, hire purchase, trade credit, bank overdraft, factoring etc. It is contrasted to internal financing which consists mainly of profits retained by the firm for investment. There are many kinds of external financing. The two main ones are equity issues, (IPOs or SEOs), but trade credit is also considered external financing as are accounts payable, and taxes owed to the government

External financing is money borrowed from the bank or investors. Here's a formula for how much they will need: External Financing Needed (EFN) = Increase in Assets - Increase in Liabilities - Retained Income.

Particulars Sales Costs Other Expenses Earnings before interest and taxes Interest Paid Total Income Taxes (22%) Net Income Dividend Addition to retained earnings CROSBY, INC. 2017 Income Statement 2018 Income Statement $7,50,000 $750000X120% $9,00,000 $5,85,000 $585000X120% $7,02,000 $21,000 $21000X120% $25,200 $1,44,000 $900000-$702000 $1,72,800 $17,000 $17,000 $1,27,000 $172800-$17000 $1,55,800 $27,940 $34,276 $99,060 $155800-$34276 $1,21,524 $29,718 $29,718) $69,342 $121524-$29718 $91,806

Amount in $ Assets Current assets Cash Accounts receivable Inventory Total Fixed assets Net plant and equipment CROSBY, INC. Balance Sheet as of December 31, 2017 Amount in $ Liabilities and Owners' Equity Current liabilities $20,940 Accounts payable $43,880 Notes payable $94,960 Total $1,59,780 Long-term debt Owners' equity $4,26,000 Common stock and paid-in surplus Retained earnings $5,85,780 Total liabilities and owners' equity $55,100 $14,300 $69,400 $1,33,000 $1,16,000 $2,67,380 $5,85,780 Total assets Workings Amount in $ $55100X120% CROSBY, INC. Balance Sheet as of December 31, 2018 Assets Workings Amount in $ Liabilities and Owners' Equity Current assets Current liabilities Cash $666142-$52656-$113952 $4,99,534 Accounts payable Accounts receivable $43880X120% $52,656 Notes payable Inventory $94960X120% $1,13,952 Total Total $6,66,142 Long-term debt Fixed assets Owners' equity Net plant and equipment Common stock and paid-in surplus Retained earnings Total assets $6,66,142 Total liabilities and owners' equity $66,120 $14,300 $80,420 $1,33,000 $267380+$91806 $1,16,000 $3,36,722 $6,66,142


Related Solutions

The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 747,000   Costs 582,000   Other expenses 18,000   Earnings before interest and taxes $ 147,000   Interest paid 14,000   Taxable income $ 133,000   Taxes (24%) 31,920...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 30 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 755,000   Costs 590,000   Other expenses 26,000   Earnings before interest and taxes $ 139,000   Interest paid 22,000   Taxable income $ 117,000   Taxes (22%) 25,740   Net income...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 980,760   Costs 792,960   Other expenses 20,060   Earnings before interest and taxes $ 167,740   Interest paid 14,740   Taxable income $ 153,000   Taxes (21%) 32,130...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 766,000   Costs 622,000   Other expenses 30,500   Earnings before interest and taxes $ 113,500   Interest paid 15,200   Taxable income $ 98,300   Taxes (23%) 22,609...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 754,000   Costs 589,000   Other expenses 25,000   Earnings before interest and taxes $ 140,000   Interest paid 21,000   Taxable income $ 119,000   Taxes (21%) 24,990   Net income...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 760,000   Costs 595,000   Other expenses 31,000   Earnings before interest and taxes $ 134,000   Interest paid 27,000   Taxable income $ 107,000   Taxes (22%) 23,540   Net income...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 769,000   Costs 625,000   Other expenses 32,000   Earnings before interest and taxes $ 112,000   Interest paid 16,400   Taxable income $ 95,600   Taxes (21%) 20,076...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 30 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 752,000   Costs 587,000   Other expenses 23,000   Earnings before interest and taxes $ 142,000   Interest paid 19,000   Taxable income $ 123,000   Taxes (24%) 29,520   Net income...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 755,000   Costs 611,000   Other expenses 25,000   Earnings before interest and taxes $ 119,000   Interest paid 10,800   Taxable income $ 108,200   Taxes (22%) 23,804...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow...
The most recent financial statements for Crosby, Inc., follow. Sales for 2018 are projected to grow by 20 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales. CROSBY, INC. 2017 Income Statement   Sales $ 753,000   Costs 588,000   Other expenses 24,000   Earnings before interest and taxes $ 141,000   Interest paid 20,000   Taxable income $ 121,000   Taxes (25%) 30,250...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT