Question

In: Accounting

Consider the following financial statements for Industrial Supply Company. (Actual) December 31, Balance sheet Year 1...

Consider the following financial statements for Industrial Supply Company.

(Actual)
December 31,
Balance sheet Year 1 Comments
Assets
Cash $     400,000 20% increase (assumption)
Accounts receivable 2,000,000 20% increase (assumption)
Inventories 4,400,000 20% increase (assumption)
    Total current assets $  6,800,000
Fixed assets, net $  1,200,000 20% increase (assumption)
    Total assets (A) $  8,000,000
Liabilities and Equity
Accounts payable (CL) $  1,200,000 20% increase (assumption)
Notes payable 1,500,000
    Total current liabilities $  2,700,000
Long-term debt 500,000 No change (assumption)
Stockholders’ equity 4,800,000
    Total liabilities and equity $  8,000,000
Income Statement Year 1
Sales (S) $15,100,000 20% increase (forecasted)
Expenses, including interest & taxes 13,800,000
Earnings after taxes (EAT) $ 1,300,000
Dividends paid (D) 250,000 No change (assumption)
Retained earnings $    1,050,000
Selected Financial Ratios
Current ratio 2.52 times
Debt ratio 40.00%
Return on stockholders’ equity 27.08%
Net profit margin on sales 8.61%

Determine the amount of additional financing needed and pro forma financial statements (that is, balance sheet, income statement, and selected financial ratios) for Year 2 under the following conditions:

Increase in Sales Increase in Expenses
$3,020,000 $2,760,000

Assume the following:

  • The company plans to maintain its dividend payments and long-term debt at the same level in Year 2 as in Year 1.
  • All of the additional financing needed is in the form of short-term notes payable.
  • Levels of cash, accounts receivable, inventories, net fixed assets and accounts payable increase proportionately as sales increase.

Round your answers in dollar form to the nearest dollar. Round your answers for financial ratios to two decimal places.

Additional Financing Needed:     $

(Actual) (Pro forma)
December 31, December 31,
Balance sheet Year 1 Year 2
Assets
Cash $     400,000 $
Accounts receivable 2,000,000
Inventories 4,400,000
    Total current assets $  6,800,000 $
Fixed assets, net $  1,200,000 $
    Total assets (A) $  8,000,000 $
Liabilities and Equity
Accounts payable (CL) $  1,200,000 $
Notes payable 1,500,000
    Total current liabilities $  2,700,000 $
Long-term debt 500,000
Stockholders’ equity 4,800,000
    Total liabilities and equity $  8,000,000 $
Income Statement Year 1 Year 2
Sales (S) $15,100,000 $
Expenses, including interest & taxes 13,800,000
Earnings after taxes (EAT) $ 1,300,000 $
Dividends paid (D) 250,000
Retained earnings $   1,050,000 $
Selected Financial Ratios
Current ratio 2.52 times times
Debt ratio 40.00% %
Return on stockholders’ equity 27.08% %
Net profit margin on sales 8.61% %

Solutions

Expert Solution


Related Solutions

The following is the balance sheet of Korver Supply Company at December 31, 2020 (prior year)....
The following is the balance sheet of Korver Supply Company at December 31, 2020 (prior year). KORVER SUPPLY COMPANY Balance Sheet At December 31, 2020 Assets Cash $ 175,000 Accounts receivable 300,000 Inventory 250,000 Furniture and fixtures (net) 195,000 Total assets $ 920,000 Liabilities and Shareholders’ Equity Accounts payable (for merchandise) $ 300,000 Notes payable 310,000 Interest payable 12,400 Common stock 140,000 Retained earnings 157,600 Total liabilities and shareholders’ equity $ 920,000 Transactions during 2021 (current year) were as follows:...
The following is the balance sheet of Korver Supply Company at December 31, 2017. KORVER SUPPLY...
The following is the balance sheet of Korver Supply Company at December 31, 2017. KORVER SUPPLY COMPANY Balance Sheet At December 31, 2017 Assets Cash $ 120,000 Accounts receivable 300,000 Inventories 200,000 Furniture and fixtures, net 150,000                                                                                          Total assets $ 770,000 Liabilities and Shareholders’ Equity Accounts payable (for merchandise) $ 190,000 Note payable 200,000 Interest payable 6,000 Common stock 100,000 Retained earnings 274,000                                                                             Total liabilities and shareholders' equity$ 770,000 Transactions during 2018 were as follows: 1. Sales to...
1. Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31...
1. Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash and cash equivalents $ 14 $ 13 Accounts receivable 292 230 Inventory 159 195 Prepaid expenses 9 5 Total current assets 474 443 Property, plant, and equipment 513 434 Less accumulated depreciation (83 ) (71 ) Net property, plant, and equipment 430 363 Long-term investments 24 31 Total assets $ 928 $ 837 Liabilities and Stockholders' Equity Accounts...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash $ 9 $ 15 Accounts receivable 340 240 Inventory 125 175 Prepaid expenses 10 6 Total current assets 484 436 Property, plant, and equipment 610 470 Less accumulated depreciation 93 85 Net property, plant, and equipment 517 385 Long-term investments 16 19 Total assets $ 1,017 $ 840 Liabilities and Stockholders' Equity Accounts payable $ 310 $ 230 Accrued...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash and cash equivalents $ 11 $ 11 Accounts receivable 292 230 Inventory 160 196 Prepaid expenses 8 5 Total current assets 471 442 Property, plant, and equipment 513 434 Less accumulated depreciation (81 ) (72 ) Net property, plant, and equipment 432 362 Long-term investments 26 33 Total assets $ 929 $ 837 Liabilities and Stockholders' Equity Accounts payable...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash and cash equivalents $ 18 $ 11 Accounts receivable 294 230 Inventory 157 194 Prepaid expenses 9 5 Total current assets 478 440 Property, plant, and equipment 511 432 Less accumulated depreciation (81 ) (71 ) Net property, plant, and equipment 430 361 Long-term investments 25 31 Total assets $ 933 $ 832 Liabilities and Stockholders' Equity Accounts payable...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash and cash equivalents $ 11 $ 12 Accounts receivable 291 229 Inventory 159 195 Prepaid expenses 9 5 Total current assets 470 441 Property, plant, and equipment 513 435 Less accumulated depreciation (81 ) (71 ) Net property, plant, and equipment 432 364 Long-term investments 25 31 Total assets $ 927 $ 836 Liabilities and Stockholders' Equity Accounts payable...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash and cash equivalents $ 11 $ 12 Accounts receivable 291 229 Inventory 159 195 Prepaid expenses 9 5 Total current assets 470 441 Property, plant, and equipment 513 435 Less accumulated depreciation (81 ) (71 ) Net property, plant, and equipment 432 364 Long-term investments 25 31 Total assets $ 927 $ 836 Liabilities and Stockholders' Equity Accounts payable...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash and cash equivalents $ 21 $ 12 Accounts receivable 295 231 Inventory 157 195 Prepaid expenses 9 5 Total current assets 482 443 Property, plant, and equipment 511 432 Less accumulated depreciation (81 ) (71 ) Net property, plant, and equipment 430 361 Long-term investments 27 34 Total assets $ 939 $ 838 Liabilities and Stockholders' Equity Accounts payable...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This...
Comparative financial statements for Weaver Company follow: Weaver Company Comparative Balance Sheet at December 31 This Year Last Year Assets Cash and cash equivalents $ 31 $ 13 Accounts receivable 293 229 Inventory 156 196 Prepaid expenses 9 6 Total current assets 489 444 Property, plant, and equipment 504 425 Less accumulated depreciation (82 ) (70 ) Net property, plant, and equipment 422 355 Long-term investments 28 35 Total assets $ 939 $ 834 Liabilities and Stockholders' Equity Accounts payable...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT