MGAB01H3 Chapter Notes - Chapter 1-2: Deferred Income, Bayer, Current Liability
Get access
Related Documents
Related Questions
STATEMENT OF CASHFLOWS
A comparative balance sheet for the Last Corporation ispresented below:
Last Corporation | ||
Balance Sheet | ||
December 31, 2014 | ||
2014 | 2013 | |
Assets | ||
Cash | $53,140 | $33,000 |
Accounts Receivable | 19,000 | 22,000 |
Inventory | 20,000 | 12,000 |
Total Current Assets | $92,140 | $67,000 |
Land | $55,000 | $60,000 |
Equipment | 160,000 | 140,000 |
Less Accumulated Depreciation | (60,500) | (50,000) |
Total Non-current Assets | $154,500 | $150,000 |
Total Assets | $246,640 | $217,000 |
Liabilities | ||
Accounts Payable | $31,000 | $25,000 |
Current Portion of Bank Loan | 18,000 | 22,000 |
Total Current Liabilities | $49,000 | $47,000 |
Non-Current portion of Bank Loan | 70,000 | 65,000 |
Total Liabilities | $119,000 | $112,000 |
Shareholders' Equity | ||
Common Shares | $80,000 | $70,000 |
Retained Earnings | 47,640 | 35,000 |
Total Shareholders' Equity | $127,640 | $105,000 |
Total Liabilities and Shareholders' Equity | $246,640 | $217,000 |
Additional information Net income for the year is $34,730. There was no purchase of land, or a gain/loss on sale ofland. There were no sales of equipment. Cash dividends were paid during the year. |
REQUIRED: | |||||||
Prepare the cash flow statement for December 31, 2014 using theindirect method. |
The following is the financial statement of Executive Fruit Company for the year ended December 2014. |
INCOME STATEMENT, 2014 | |||
(Figures in $ Thousands) | |||
Revenue | $ | 5,500 | |
Cost of goods sold | 4,950 | ||
EBIT | $ | 550 | |
Interest | 110 | ||
Earnings before taxes | $ | 440 | |
State and federal tax | 176 | ||
Net income | $ | 264 | |
Dividends | 176 | ||
Additions to retained earnings | $ | 88 | |
BALANCE SHEET (Year-End, 2014) | |||
(Figures in $ Thousands) | |||
Assets | |||
Net working capital | $ | 550 | |
Fixed assets | 2,200 | ||
Total assets | $ | 2,750 | |
Liabilities and shareholders' equity | |||
Long-term debt | $ | 1,100 | |
Shareholders' equity | 1,650 | ||
Total liabilities and shareholders' equity | $ | 2,750 | |
The following are the first stage and second stage pro forma financial statements of Executive Fruit Company for the year ended December 2015. |
First stage pro forma statements: |
PRO FORMA INCOME STATEMENT, 2015 | |||
(Figures in $ Thousands) | |||
Revenue | $ | 6,050 | |
Cost of goods sold | 5,445 | ||
EBIT | $ | 605 | |
Interest | 110 | ||
Earnings before taxes | $ | 495 | |
State and federal tax | 198 | ||
Net income | $ | 297 | |
Dividends | 198 | ||
Additions to retained earnings | $ | 99 | |
PRO FORMA BALANCE SHEET (Year-End, 2015) | |||
(Figures in $ Thousands) | |||
Assets | |||
Net working capital | $ | 605 | |
Fixed assets | 2,420 | ||
Total assets | $ | 3,025 | |
Liabilities and shareholders' equity | |||
Long-term debt | $ | 1,100 | |
Shareholders' equity | 1,749 | ||
Total liabilities and shareholders' equity | $ | 2,849 | |
Required external financing | $ | 176 | |
Second stage pro forma balance sheet: |
PRO FORMA BALANCE SHEET (Year-End, 2015) | |||
(Figures in $ Thousands) | |||
Assets | |||
Net working capital | $ | 605 | |
Fixed assets | 2,420 | ||
Total assets | $ | 3,025 | |
Liabilities and shareholders' equity | |||
Long-term debt | $ | 1,276 | |
Shareholders' equity | 1,749 | ||
Total liabilities and shareholders' equity | $ | 3,025 | |
How would Executive Fruitâs financial model change if the dividend payout ratio were cut to 1/3? Use the revised model to generate a new financial plan for 2015 assuming that debt is the balancing item. What would be the required external financing? (Do not round intermediate calculations.) |
Dividends fall by $ . Therefore, the requirement for external financing falls from $ to $ . On the other hand, shareholders' equity will be increased by $ . |
The right-hand side of the balance sheet becomes (Do not round intermediate calculations. Enter your answers in thousands.): |
Long-term debt | $ |
Shareholders' equity | |
Total | $ |
The following is the financial statement of Executive Fruit Company for the year ended December 2014. |
INCOME STATEMENT, 2014 | |||
(Figures in $ Thousands) | |||
Revenue | $ | 4,000 | |
Cost of goods sold | 3,600 | ||
EBIT | $ | 400 | |
Interest | 80 | ||
Earnings before taxes | $ | 320 | |
State and federal tax | 128 | ||
Net income | $ | 192 | |
Dividends | 128 | ||
Additions to retained earnings | $ | 64 | |
BALANCE SHEET (Year-End, 2014) | |||
(Figures in $ Thousands) | |||
Assets | |||
Net working capital | $ | 400 | |
Fixed assets | 1,600 | ||
Total assets | $ | 2,000 | |
Liabilities and shareholders' equity | |||
Long-term debt | $ | 800 | |
Shareholders' equity | 1,200 | ||
Total liabilities and shareholders' equity | $ | 2,000 | |
The following are the first stage and second stage pro forma financial statements of Executive Fruit Company for the year ended December 2015. |
First stage pro forma statements: |
PRO FORMA INCOME STATEMENT, 2015 | |||
(Figures in $ Thousands) | |||
Revenue | $ | 4,400 | |
Cost of goods sold | 3,960 | ||
EBIT | $ | 440 | |
Interest | 80 | ||
Earnings before taxes | $ | 360 | |
State and federal tax | 144 | ||
Net income | $ | 216 | |
Dividends | 144 | ||
Additions to retained earnings | $ | 72 | |
PRO FORMA BALANCE SHEET (Year-End, 2015) | |||
(Figures in $ Thousands) | |||
Assets | |||
Net working capital | $ | 440 | |
Fixed assets | 1,760 | ||
Total assets | $ | 2,200 | |
Liabilities and shareholders' equity | |||
Long-term debt | $ | 800 | |
Shareholders' equity | 1,272 | ||
Total liabilities and shareholders' equity | $ | 2,072 | |
Required external financing | $ | 128 | |
Second stage pro forma balance sheet: |
PRO FORMA BALANCE SHEET (Year-End, 2015) | |||
(Figures in $ Thousands) | |||
Assets | |||
Net working capital | $ | 440 | |
Fixed assets | 1,760 | ||
Total assets | $ | 2,200 | |
Liabilities and shareholders' equity | |||
Long-term debt | $ | 928 | |
Shareholders' equity | 1,272 | ||
Total liabilities and shareholders' equity | $ | 2,200 | |
How would Executive Fruitâs financial model change if the dividend payout ratio were cut to 1/3? Use the revised model to generate a new financial plan for 2015 assuming that debt is the balancing item. What would be the required external financing? (Do not round intermediate calculations.) |
Dividends fall by $ . Therefore, the requirement for external financing falls from $ to $ . On the other hand, shareholders' equity will be increased by $ . |
The right-hand side of the balance sheet becomes (Do not round intermediate calculations. Enter your answers in thousands.): |
Long-term debt | $ |
Shareholders' equity | |
Total | $ |