Question

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% %

need additional finance needed and chart filled out please.

Homework Answers

Answer #1

solution:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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 $ 16 $ 12 Accounts receivable 293 230 Inventory 157 195 Prepaid expenses 8 6 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 payable $ 302 $...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December 31   Assets   Current assets:      Cash $ 22,000      Accounts receivable, net 190,000      Merchandise inventory 380,000      Prepaid expenses 11,000   Total current assets 603,000   Property and equipment, net 840,000   Total assets $ 1,443,000   Liabilities and Stockholders' Equity   Liabilities:      Current liabilities $ 200,000      Bonds payable, 10% 310,000   Total liabilities 510,000   Stockholders’ equity:      Common stock, $10 par value $ 150,000      Retained earnings 783,000   Total stockholders’ equity 933,000   Total liabilities...
Financial statements for AAR Company appear below: AAR Company Balance Sheet December 31 Current assets:    ...
Financial statements for AAR Company appear below: AAR Company Balance Sheet December 31 Current assets:     Cash and marketable securities $21,000     Accounts receivable, net 160,000     Inventory 300,000     Prepaid expenses          9,000       Total current assets 490,000 Noncurrent assets:     Plant & equipment, net      810,000 Total assets $1,300,000 Current liabilities:     Accounts payable $75,000     Accrued liabilities 25,000     Notes payable, short term      100,000        Total current liabilities 200,000 Noncurrent liabilities:     Bonds payable      300,000...
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...
The financial statements of Elcamino Company appear below: ELCAMINO COMPANY Comparative Balance Sheet December 31, ________________________________________________________...
The financial statements of Elcamino Company appear below: ELCAMINO COMPANY Comparative Balance Sheet December 31, ________________________________________________________ Assets                                                                                                        2017 2016    Cash ..................................................................................................    $ 25,000................................................................................................ $ 40,000 Debt investments ..............................................................................       20,000 60,000 Accounts receivable (net) .................................................................       50,000 30,000 Inventory ...........................................................................................       140,000 170,000 Property, plant and equipment (net) .................................................        170,000.............................................................................................. 200,000       Total assets ................................................................................       $405,000 $500,000 Liabilities and stockholders' equity Accounts payable .............................................................................    $ 25,000................................................................................................ $ 30,000 Short-term notes payable .................................................................       40,000...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December 31 Assets Current assets: Cash $ 22,000 Accounts receivable, net 210,000 Merchandise inventory 370,000 Prepaid expenses 7,000 Total current assets 609,000 Property and equipment, net 810,000 Total assets $ 1,419,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 240,000 Bonds payable, 11% 390,000 Total liabilities 630,000 Stockholders’ equity: Common stock, $10 per value $ 160,000 Retained earnings 629,000 Total stockholders’ equity 789,000 Total liabilities...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 700,000 shares of common stock were outstanding. The interest rate on the bond payable was 10%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company’s common stock at the...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 600,000 shares of common stock were outstanding. The interest rate on the bond payable was 10%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company’s common stock at the...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 700,000 shares of common stock were outstanding. The interest rate on the bond payable was 10%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company’s common stock at the...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear...
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 600,000 shares of common stock were outstanding. The interest rate on the bond payable was 10%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company’s common stock at the...