Question

In: Accounting

BALANCE SHEET & IS ITEMS 2017      2018          (thousands of US dollars) Sales                &nbs

BALANCE SHEET & IS ITEMS 2017      2018         

(thousands of US dollars)

Sales                         4,166       4,490 (NOTE: the firm

Cash                          2,150       2,198   plans on a 34%

Interest (expense)              274         316   marginal corp.

Other Expenses                  340         280   tax rate for

Inventory                     5,060       5,200   all revenues)

Net Fixed Assets             18,030      18,460                  

Depreciation                    590         590               

Cost of Goods Sold            1,410       1,602

SE(includes paid-in surplus) ?????       ?????

Retained Earnings            11,256      11,128 (ALSO:30,000 CBC

Accounts Payable              2,258       2,190   common equity   

Short-Term Notes Payable        416         390   shares (10% of

Dividends                       500         550   outstanding in

Accounts Receivable           2,846       3,206   ’09 targeted to

Long-Term Debt                7,200       8,400   be repurchased)

1. Operating Cash Flow(in thousands) for ‘18 is expected to be:

2. ‘17-‘18 changes in net working capital(NWC) are forecast at:

3. The summary CF measure Cash Flow From Assets for CBC equals:

4. What’s company P/E ratio if EOY 2018 share price equals $77?

(hint: you’ll need net income and EPS to calculate this one)

Solutions

Expert Solution

1.

Operating Cash Flows (in $ 000)
Inflow
Change in Cash (2198-2140) 48
Accounts receivable 2846
Long term Debt (8400-7200) 1200
Total 4094
Outflow Interest 316
Other expense 280
Changes in Inventory (5200-5060) 140
Changes in Fixed Assets (18460-18030) 430
Changes in Cost of Goods Sold (1602-1410) 192
Accounts payable 2258
Notes payable 416
Dividends 500
Tax expense 766.36
Total 5298.36
Net Cash Flow -1204.36
Income statement
dr cr
Interest 316 Sales 4490
Other Exp 280 Change in stock 140
COGS 1602
Transfer to retained earnings 128
Dividend 50
Total 2376 4630
Profit before Tax 2254
Profit After tax 1487.64
Tax 766.36

2.

Changes in working capital Amount
Assets
Accounts receivable 360
Inventory -140
Cash 48
268
Liabilities
Accounts payable 68
Notes payable 26
Dividends -50
44
Net Changes in working capital 312

Related Solutions

Balance Sheet April 30 (in thousands of dollars) 2019 2018 2017 Assets:    Current assets $ 1,700...
Balance Sheet April 30 (in thousands of dollars) 2019 2018 2017 Assets:    Current assets $ 1,700 $1,120 $1,544    Plant and equipment (net) 8,110 7,830 5,404    Other assets   1,004    695    772    Total assets $10,814 $9,645 $7,720 Liabilities and Stockholders' Equity:    Current liabilities $   950 $  880 $  772    Long-term liabilities 2,023 1,591 1,544    Capital stock ($10 par) 4,600 4,600 3,000    Paid-in capital in excess of par 770 770 386    Retained earnings   2,471 1,804 2,018       Total liabilities and stockholders' equity $10,814 $9,645 $7,720 Income Statement...
Balance Sheet as of December 31, 2018 (Thousands of Dollars) Cash $ 1,080 Accounts payable $...
Balance Sheet as of December 31, 2018 (Thousands of Dollars) Cash $ 1,080 Accounts payable $ 4,320 Receivables 6,480 Accruals 2,880 Inventories 9,000 Line of credit 0    Total current assets $16,560 Notes payable 2,100 Net fixed assets 12,600    Total current liabilities $ 9,300 Mortgage bonds 3,500 Common stock 3,500 Retained earnings 12,860    Total assets $29,160    Total liabilities and equity $29,160 Income Statement for January 1 - December 31, 2018 (Thousands of Dollars) Sales $36,000 Operating costs 32,440    Earnings before interest...
Stealcase’s Balance Sheet, as of December 31(thousands of dollars)                                 
Stealcase’s Balance Sheet, as of December 31(thousands of dollars)                                              2017      2018                                                                            2017      2018 Cash                                 30            25                  Account Payable                                  35          50 Accts Receivable          5              20                  Bank Loan                                            25           25 Inventory                        100         100                Accrued Taxes                                   15          25 Current Assets              135          245                Long Term, Dept current portion    12         12                                                                                  Current Liabilities                                87         112 Net Plant & Equip           200          250                 Long-Term Dept                                100        95                                                                                  Common Stock (10,000 shares)    100      100                                                                                 Additional paid-in...
Use the following balance sheet information to answer this question. Balance Sheet (dollars in thousands) and...
Use the following balance sheet information to answer this question. Balance Sheet (dollars in thousands) and Duration (in years) Duration Amount T-bills 0.5 90 T-notes 0.9 55 T-bonds 4.393 176 Loans 7 2,724 Deposits 1 2,092 Federal funds 0.01    238 Equity 715 A )What is the average duration of all the assets? B )What is the average duration of all the liabilities? C )What is the FI’s leverage-adjusted duration gap? What is the FI’s interest rate risk exposure? D...
      An FI has the following Balance Sheet (in millions of dollars):                         Assets&nbs
      An FI has the following Balance Sheet (in millions of dollars):                         Assets                                      Liabilities and Equity                         Cash                $40                  Deposits          $135                         Loans              $100                Equity             $15                         Securities        $10                      The FI is expecting a $50 million net deposit drain. Show the FI's new balance sheet if: The Stored Liquidity method is used to meet the liquidity shortfall The FI purchases liabilities to offset this expected drain.
2019 2018 Net Sales $        3,749.9 $        3,917.2 Consolidated Balance Sheet 2019 2018 Cash and Cash equivalents $      &nbs
2019 2018 Net Sales $        3,749.9 $        3,917.2 Consolidated Balance Sheet 2019 2018 Cash and Cash equivalents $             281.9 $             253.2 Trade receivables, net of allowance $7.2 and $9.3, $             450.8 $             448.7 at 12/31/19 & 12/31/18 respectively Other receivables, net $                35.8 $                71.5 Total receivables, net $             486.6 $             520.2 Inventories Finished goods $             255.7 $             242.8 Work in progress $                52.6 $                42.6 Raw materials & supplies $             245.1 $             241.8 LIFO reserve $              (33.8) $              (22.6) Total inventories, net $             519.6 $             504.6 Prepaid expenses and other current assets $                36.8 $                33.2 Total current assets $        1,324.9 $        1,311.2...
The following balance sheet information is available (amounts in thousands of dollars and duration in years)...
The following balance sheet information is available (amounts in thousands of dollars and duration in years) for a financial institution: AssetsLiabilities and Equity in millions T-bills $ 95.00,  0.5 year T-notes $ 125.00, 0.9 year T-bonds $ 100.00 Loans $2,724.00 Deposits $2,092.00, 1 year Federal funds $ 282.00 0.01 year Equity $ 670.00 Treasury bonds are five-year maturities paying 6 percent semiannually and quoted at 0.92. a. What is the duration of the T-bond portfolio? b. What is the average duration...
Assume the US Consolidated Bank Balance Sheet has the following major balance sheet items
Assume the US Consolidated Bank Balance Sheet has the following major balance sheet items (billions $) - Assets include Reserves at the Fed $8,000 and earning assets of (1) Treasury bonds and bills $12,000 (2) Loans $80,000 Total Assets equal $100,000. The only liability is demand deposits. The required reserve requirement rr=.08. The Fed Reserve balance sheet has Cash of $8,000 as an asset and Member Bank Deposits of $8,000 as a liability. (a) Set up the initial Consolidated Bank Balance...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017:    2018 2017...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017:    2018 2017 Cash $ 96,245 $ 33,155 Available-for-sale debt securities (not cash equivalents) 24,000 102,000 Accounts receivable 97,000 83,550 Inventory 182,000 160,300 Prepaid insurance 3,030 3,700 Land, buildings, and equipment 1,284,000 1,142,000 Accumulated depreciation (627,000 ) (589,000 ) Total assets $ 1,059,275 $ 935,705 Accounts payable $ 91,640 $ 165,670 Salaries payable 26,800 33,000 Notes payable (current) 40,300 92,000 Bonds payable 217,000 0 Common stock 300,000...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017: ​ 2018 2017...
The Murdock Corporation reported the following balance sheet data for 2018 and 2017: ​ 2018 2017 Cash $77,375 $22,955 Available-for-sale debt securities ​ ​ (not cash equivalents) 15,500 85,000 Accounts receivable 80,000 68,250 Inventory 165,000 145,000 Prepaid insurance 1,500 2,000 Land, buildings, and equipment 1,250,000 1,125,000 Accumulated depreciation (610,000) (572,000) Total assets $979,375 $876,205 Accounts payable $76,340 $148,670 Salaries payable 20,000 24,500 Notes payable (current) 25,000 75,000 Bonds payable 200,000 0 Common stock 300,000 300,000 Retained earnings 358,035 328,035 Total...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT