Question
In: Finance
Use the following information for ABC Inc. the answer the following questions (the applicable tax rate...
Use the following information for ABC Inc. the answer the following questions (the applicable tax rate is 34%):
|
2017 |
2018 |
|
|
Sales |
23,146,000 |
25,872,000 |
|
Depreciation |
3,322,000 |
3,472,000 |
|
Cost of Goods Sold |
7,958,000 |
9,414,000 |
|
Other Expenses |
1,892,000 |
1,648,000 |
|
Interest |
1,552,000 |
1,852,000 |
|
Cash |
12,134,000 |
12,932,000 |
|
Accounts Receivable |
16,068,000 |
18,854,000 |
|
Short-term Notes Payable |
3,422,000 |
2,294,000 |
|
Long-term Debt |
40,640,000 |
49,392,000 |
|
Net Fixed Assets |
101,776,000 |
108,546,000 |
|
Accounts Payable |
8,768,000 |
9,288,000 |
|
Inventory |
28,566,000 |
30,576,000 |
|
Dividends |
2,822,000 |
3,236,000 |
- Draw up a statement of comprehensive income and statement of financial position for this company for 2017 and 2018.
- Prepare the cash flow statement.
- For 2018, calculate the cash flow from assets, cash flow to creditors, and cash flow to shareholders.
Solutions
Expert Solution
| a) | STATEMENT OF COMPREHENSIVE INCOME | ||
| 2017 | 2018 | ||
| Sales | $ 2,31,46,000 | $ 2,58,72,000 | |
| Cost of goods sold | $ 79,58,000 | $ 94,14,000 | |
| Gross profit | $ 1,51,88,000 | $ 1,64,58,000 | |
| Operating expenses: | |||
| Depreciation | $ 33,22,000 | $ 34,72,000 | |
| Other expenses | $ 18,92,000 | $ 16,48,000 | |
| Total operating expenses | $ 52,14,000 | $ 51,20,000 | |
| Operating profit | $ 99,74,000 | $ 1,13,38,000 | |
| Interest expense | $ 15,52,000 | $ 18,52,000 | |
| Income before taxes | $ 84,22,000 | $ 94,86,000 | |
| Tax at 34% | $ 28,63,480 | $ 32,25,240 | |
| Net income | $ 55,58,520 | $ 62,60,760 | |
| Dividends | $ 28,22,000 | $ 32,36,000 | |
| Addtion to retained earnings | $ 27,36,520 | $ 30,24,760 | |
| STATEMENT OF FINANCIAL POSITION | |||
| Assets | |||
| Current assets: | |||
| Cash | $ 1,21,34,000 | $ 1,29,32,000 | |
| Accounts receivable | $ 1,60,68,000 | $ 1,88,54,000 | |
| Inventory | $ 2,85,66,000 | $ 3,05,76,000 | |
| Total current assets | $ 5,67,68,000 | $ 6,23,62,000 | |
| Net fixed assets | $ 10,17,76,000 | $ 10,85,46,000 | |
| Total assets | $ 15,85,44,000 | $ 17,09,08,000 | |
| Total liabilities and stockholders' equity | |||
| Current liabilities: | |||
| Accounts payable | $ 87,68,000 | $ 92,88,000 | |
| Short term notes payable | $ 34,22,000 | $ 22,94,000 | |
| Total current liabilities | $ 1,21,90,000 | $ 1,15,82,000 | |
| Long term debt | $ 4,06,40,000 | $ 4,93,92,000 | |
| Total liabilities | $ 5,28,30,000 | $ 6,09,74,000 | |
| Stockholders' equity [Plug in figure] | $ 10,57,14,000 | $ 10,99,34,000 | |
| [158544000-52830000] | [170908000-60974000] | ||
| Total liabilities and stockholders' equity | $ 15,85,44,000 | $ 17,09,08,000 | |
| b) | STATEMENT OF CASH FLOWS-2018 | ||
| Cash flow from operating activities: | |||
| Net income | $ 62,60,760 | ||
| Adjustements to reconcile net income with cash flow from operating activities: | |||
| Depreciation | $ 34,72,000 | ||
| Increase in accounts receivable | $ -27,86,000 | ||
| Increase in inventory | $ -20,10,000 | ||
| Increase in accounts payable | $ 5,20,000 | $ -8,04,000 | |
| Net cash from operating activities | $ 54,56,760 | ||
| Cash flow from investing activities: | |||
| Increase in fixed assets (108546000-101776000+3472000) | $ -1,02,42,000 | ||
| Net cash used by investing activities | $ -1,02,42,000 | ||
| Cash flow from financing activities: | |||
| Payment of dividends | $ -32,36,000 | ||
| Issue of common stock [109934000-105714000-3024760] | $ 11,95,240 | ||
| Payment of ST notes payable | $ -11,28,000 | ||
| Raising of long term debt | $ 87,52,000 | ||
| Net cash from financing activities | $ 55,83,240 | ||
| Increase in cash | $ 7,98,000 | ||
| Beginning balance of cash | $ 1,21,34,000 | ||
| Ending balance of cash | $ 1,29,32,000 | ||
| c) | Cash flow from assets = OCF-Net capital spending-Change in NWC | ||
| OCF = EBIT+Depreciation-taxes = 11338000+3472000-3225240 = | $ 1,15,84,760 | ||
| Net capital spending = 108546000-101776000+3472000 = | $ 1,02,42,000 | ||
| Change in NWC = (62362000-11582000)-(56768000-12190000) = | $ 62,02,000 | ||
| Cash flow from assets | $ -48,59,240 | ||
| Cash flow to creditors = Interest expense+Beginning long term debt-Ending long term debt = 1852000+40640000-49392000 = | $ -69,00,000 | ||
| Cash flow to stock holders = Dividend-New equity = 3236000-1195240 = | $ 20,40,760 | ||
| Cash flow to creditors and stockholders | $ -48,59,240 | ||
jeff jeffy answered 7 months agoRelated Solutions
Use the information below for ABC Co. to answer the following questions. Balance Sheet
Use the information below for ABC Co. to answer the
following questions.
Balance
Sheet December
31
2005 2004
Assets
Cash $ 20,000 $ 10,000
Accounts
receivable 160,000 110,000
Inventories
80,000 50,000
Prepaid
Rent 15,000
10,000
Investments 100,000 75,000
Plant
assets 210,000 250,000
Accumulated depreciation
(65,000) (60,000)
Total
$520,000 $445,000
Liabilities and Stockholders' Equity
Accounts
payable $ 50,000 $ 40,000
Interest payable
20,000 5,000
Income tax
payable 5,000 10,000
Note
payable 130,000 140,000
Common
stock 155,000 100,000
Retained earnings
160,000 150,000
Total
$520,000 $445,000
Income Statement
For the Year Ended December 31, 2005
Sales $800,000
Cost of goods
sold 480,000
Gross
Profit 320,000
Operating expenses (including Depreciation Expense) 120,000
Interest expense 20,000
Income...
Use the information below for ABC Co. to answer the following questions. Balance Sheet
Use the information below for ABC Co. to answer the
following questions.
Balance
Sheet December
31
2005 2004
Assets
Cash $ 20,000 $ 10,000
Accounts
receivable 160,000 110,000
Inventories
80,000 50,000
Prepaid
Rent 15,000
10,000
Investments 100,000 75,000
Plant
assets 210,000 250,000
Accumulated depreciation
(65,000) (60,000)
Total
$520,000 $445,000
Liabilities and Stockholders' Equity
Accounts
payable $ 50,000 $ 40,000
Interest payable
20,000 5,000
Income tax
payable 5,000 10,000
Note
payable 130,000 140,000
Common
stock 155,000 100,000
Retained earnings
160,000 150,000
Total
$520,000 $445,000
Income Statement
For the Year Ended December 31, 2005
Sales $800,000
Cost of goods
sold 480,000
Gross
Profit 320,000
Operating expenses (including Depreciation Expense) 120,000
Interest expense 20,000
Income...
Use the information below for ABC Co. to answer the following questions (#15 – 26). Balance...
Use the information below for ABC Co. to answer the
following questions (#15 – 26).
Balance
Sheet December
31
2005 2004
Assets
Cash $ 20,000 $ 10,000
Accounts
receivable 160,000 110,000
Inventories 80,000 50,000
Prepaid
Rent 15,000 10,000
Investments 100,000 75,000
Plant
assets 210,000 250,000
Accumulated
depreciation (65,000) (60,000)
Total $520,000 $445,000
Liabilities and Stockholders' Equity
Accounts
payable $ 50,000 $ 40,000
Interest
payable 20,000 5,000
Income tax
payable 5,000 10,000
Note
payable 130,000 140,000
Common
stock 155,000 100,000
Retained
earnings 160,000 150,000
Total $520,000 $445,000
Income Statement
For the Year Ended December 31, 2005
Sales $800,000
Cost of goods
sold 480,000
Gross
Profit 320,000
Operating expenses (including Depreciation
Expense) 120,000
Interest
expense 20,000
Income tax
expense 25,000
Total 165,000
Income before Gains...
Answer the following short questions. Use MARR = 12% and tax rate = 40% in all...
Answer the following short questions. Use MARR = 12% and tax
rate = 40% in all problems unless otherwise specified.
3. A young engineer calculated that monthly payments of $A are
required to pay off a $5000 loan for n years at i% interest,
compounded monthly. If the engineer decides to borrow $10,000
instead, her monthly payments are $2A. True or False
Required information Use the following information to answer questions [The following information applies to the questions...
Required information
Use the following information to answer questions
[The following information applies to the questions
displayed below.]
The following information is available for Lock-Tite Company, which
produces special-order security products and uses a job order
costing system.
April 30
May 31
Inventories
Raw materials
$
31,000
$
30,000
Work in process
9,500
18,200
Finished goods
54,000
34,000
Activities and information for
May
Raw materials purchases (paid
with cash)
197,000
Factory payroll (paid with
cash)
200,000
Factory overhead
Indirect materials...
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a...
Use the following information to answer the questions below.
CATERPILLAR INC. Statement of Income for a Recent Year
Total sales and revenues
......................................................................................
$55,184,000
Less: Cost of products sold
...................................................................................
$40,391,000
Gross profit
.......................................................................................,....................
$ 14,793,000
Less: Operating costs :
Selling, general, and administrative expenses
................................................ $ 5,697,000
Research and development expenses
............................................................
$2,135,000
Other operating expenses
...............................................................................
$1,633,000
Total operating costs
.............................................................................................
$ 9,465,000
Operating profit
.....................................................................................................
$ 5,328,000
Less: Other expenses
............................................................................................
245,000
Consolidated profit before taxes
.............................................................................
Use the following information to answer the questions below. CATERPILLAR INC. Statement of Income for a...
Use the following information to answer the questions below.
CATERPILLAR INC. Statement of Income for a Recent Year
Total sales and revenues
......................................................................................
$55,184,000
Less: Cost of products sold
...................................................................................
$40,391,000
Gross profit
.......................................................................................,....................
$ 14,793,000
Less: Operating costs :
Selling, general, and administrative expenses
................................................ $ 5,697,000
Research and development expenses
............................................................
$2,135,000
Other operating expenses
...............................................................................
$1,633,000
Total operating costs
.............................................................................................
$ 9,465,000
Operating profit
.....................................................................................................
$ 5,328,000
Less: Other expenses
............................................................................................
245,000
Consolidated profit before taxes
.............................................................................
Use the following information to answer the questions below:
Use the following information to answer the
questions below:
note: all sales are credit sales
Income Stmt info:
2016
2017
Sales
$ 975,000
$ 1,072,500
less Cost of Goods Sold:
325,000
346,125
Gross Profit
650,000
726,375
Operating Expenses
575,000
609,500
Earnings before Interest & Taxes
75,000
116,875
Interest exp
25,000
31,000
earnings before Taxes
50,000
85,875
Taxes
20,000
34,350
Net Income
$ 30,000
$
51,525
Balance Sheet info:
12/31/2016
12/31/2017
Cash
60,000
$ 63,600
Accounts Receivable
80,000
$ 84,000
Inventory...
Use the following information to answer the next 3 questions. ABC has beginning-of-year balances of: PBO,...
Use the following information to answer
the next 3 questions.
ABC has beginning-of-year balances of:
PBO, $330,000; Plan Assets, $310,000; and Net Loss – AOCI, $55,000.
During the year, ABC recorded a loss on Plan Assets of $8,820 and a
gain on the PBO of $11,000. Net income for the year is $77,000.
Assume no amortization of the net gain/loss in AOCI is needed.
14.
Other comprehensive income is
____.
15.
Comprehensive income is ____.
16.
The end-of-year balance in...
Use the following information for Taco Swell, Inc., (assume the tax rate is 23 percent): ...
Use the following information for Taco Swell, Inc., (assume the
tax rate is 23 percent):
2017
2018
Sales
$
17,073
$
16,236
Depreciation
1,771
1,846
Cost of goods sold
4,529
4,817
Other expenses
1,001
879
Interest
850
981
Cash
6,232
6,796
Accounts receivable
8,150
9,757
Short-term notes payable
1,280
1,257
Long-term debt
20,650
24,911
Net fixed assets
51,130
54,603
Accounts payable
4,560
4,974
Inventory
14,470
15,398
Dividends
1,500
1,728
Prepare a balance sheet for this company for 2017...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- A rigid tank contains hydrogen and has a volume of 4.1 ft3. It is initially at...
- A bat strikes a 0.145-kg baseball. Just before impact, the ball is traveling horizontally to the...
- Question 1. Cystic Fibrosis (CF) is an example of a protein mis-folding disorder since most of...
- a. 500 mol/h methane at 40°C was fed to a furnace and burned with 15% of...
- a) Explain the concept of time value of money b) Distinguish between risk and uncertainty in...
- Assume that John own a company with fx exposure, how John using forward contract to hedge...
- which statements are true about Python functions? a)Different functions cannot use same function name b)a function...
ADVERTISEMENT