INCOME STATEMENT, 2018 |
BALANCE SHEET, as of Dec 31, 2018 |
Sales |
$10,000 |
ASSETS |
Cost of goods sold |
4,000 |
Cash |
$5,000 |
Gross profit |
$6,000 |
Accounts receivable |
3,000 |
S, G & A expenses |
3,000 |
Inventory |
17,000 |
EBIT |
$3,000 |
Current assets |
$25,000 |
Interest |
$200 |
Equipment (gross) |
27,000 |
Before-tax earnings |
$2,800 |
Less Accum Depreciation |
(12,000) |
Taxes |
1,000 |
Equipment (net) |
$15,000 |
Net income |
$1,800 |
Total assets |
$40,000 |
LIABILITIES AND EQUITY |
EPS |
$1.80 |
Accounts payable |
$17,000 |
Current liabilities |
$17,000 |
Dividends |
$600 |
Long-term debt |
$3,000 |
Addition to retained earnings |
$1,200 |
Total liabilities |
$20,000 |
Common stock (1,000 shares) |
$7,000 |
Retained earnings |
$13,000 |
Total equity |
$20,000 |
Total liabilities & Equity |
$40,000 |
Joe's Fly-by-Night Oil |
\ |
|
1. Prepare a graph of sales and net income for the years 2015 – 2018. For the purposes of this exercise, assume the following historical sales and net income figures for Joe’s Fly-By-Night Oil:
Year Sales Net Income
2015 $8,200 $1,500
2016 $8,000 $1,400
2017 $9,000 $1,600
2018 $10,000 $1,800
Comment on the results displayed on the graph.
2. Prepare a pie chart of Joe’s Fly-By-Night Oil’s expense distribution for 2018 and comment on the results displayed.
3.Prepare a pie chart of Joe’s Fly-By-Night Oil’s asset distribution for Dec 31, 2018 and comment on the results displayed.
4. Prepare a pie chart of Joe’s Fly-By-Night Oil’s capital structure for Dec 31, 2018 and comment on the results displayed.
Note: Be sure to comment on each of the four graphs. The numbers mean little
without your explanatory comments.
Answer:
While we see that the sale trend is moving upwards, the Net income is also increasing but at a slower rate. Yet the net income is directly proportional to sales and increases with increase in sales. This shows that the company is able to maintain its cost benefit ratio.
2: The major portion of expenses is cost of goods sold. S,G and A expenses form the other major part of the expenses. This is the portion that the company needs to review since it is alsmost as much as the cost of goods sold.
3: The company has substantial amounts of current assets. This is good in terms of liquidity of the business.
4:
The capital comprises of Equity and lesser portion is debt. This is a good indicator in terms of capital structure of the business.
INCOME STATEMENT, 2018 BALANCE SHEET, as of Dec 31, 2018 Sales $10,000 ASSETS Cost of goods...
INCOME STATEMENT, 2018 BALANCE SHEET, as of Dec 31, 2018 Sales $10,000 ASSETS Cost of goods sold 4,000 Cash $5,000 Gross profit $6,000 Accounts receivable 3,000 S, G & A expenses 3,000 Inventory 17,000 EBIT $3,000 Current assets $25,000 Interest $200 Equipment (gross) 27,000 Before-tax earnings $2,800 Less Accum Depreciation (12,000) Taxes 1,000 Equipment (net) $15,000 Net income $1,800 Total assets $40,000 LIABILITIES AND EQUITY EPS $1.80 Accounts payable $17,000 Current liabilities $17,000 Dividends $600 Long-term debt $3,000 Addition to...
3. Below is the balance sheet for Glucose Control Company as of Dec. 31, 2018. The company reported an annual net income of $85,000 for the following year, 2019, but did not change its assets or liabilities, unless otherwise noted. Assets Cash Marketable securities Accounts receivable Inventory Current assets 13,000 2,000 5,000 33,000 53,000 34,000 80,000 114,000 167,000 Liabilities and Equity Accounts payable 18,000 Notes payable 6,000 Current liabilities 24,000 Long-term debt 95,000 Total liabilities 119,000 Paid-in capital 20,000 Retained...
Dec 31, 2018 A comparative balance sheet for Rocker Company appears below: ROCKER COMPANY Comparative Balance Sheet Dec 31, 2019 Assets Cash $ 34,000 Accounts receivable 18,000 Inventory 25,000 Prepaid expenses 6,000 Long-term investments Equipment 60,000 Accumulated depreciation equipment (20,000) Total assets $123,000 Liabilities and Stockholders' Equity Accounts payable $ 17.000 Bonds payable 36.000 Common stock 40,000 Retained earnings Total liabilities and stockholders' equity $123,000 $11,000 13,000 17.000 9,000 17.000 33,000 (15,000) $85.000 $ 7.000 45,000 23,000 30,000 10.000 $85.000...
Income Statement Year Ended 12/31/18 Balance Sheet Sales Cost of Goods Sold Operating Expenses Depreciation Expense100,000 EBIT Interest Expense EBT Taxes Net Income 12/31/2018 12/31/2017 $60,000$45,000 880,000650,000 200,000Less Acc'd Depreciation 450,000350,000 350,000 $395,000 $1.400,000 Current Assets 750,000 Gross Fixed Assets Fixed Assets 430,000 $490,000 50,000 Total Assets 50,000 00,000 Current Liabilities 120,000Long-term Debt $35,000 330,000 5,000 $50,000 270,000 5,000 70,000 $395,000 180,000 Common Stock Retained Earnings Total Liabilities & Equity $490.000 110 $395.000 a) Prepare the 2018 common-sized income statement...
Consolidated Balance Sheet - USD ($) $ in Millions Dec. 31, 2018 Dec. 31, 2017 Assets Cash and due from banks $ 21,453 $ 19,505 Investment securities Held-to-maturity (fair value $44,964 and $43,723, respectively) 46,050 44,362 Available-for-sale ($2,057 and $689 pledged as collateral, respectively) [1] 66,115 68,137 Loans held for sale (including $2,035 and $3,534 of mortgage loans carried at fair value, respectively) 2,056 3,554 Loans Commercial 102,444 97,561 Commercial real estate 39,539 40,463 Residential mortgages 65,034 59,783 Credit card...
ACME, Inc. Income Statement Month Ended July 31, 2018 Revenues: Sales 99,000 Expenses: Wages Expense 25,000 Rent Expense 12,000 Gasoline Expense 2,400 Utilities Expense 6,000 Supplies Expense 400 Depreciation Expense-Del Van 3,000 Depreciation Expense-Equip 10,000 Total Expenses 58,800 Net Income 40,200 ACME, Inc. Statement of Retained Earnings Month Ended July 31, 2018 Retained Earnings, July 1, 2012 39,100 Plus: Net Income for July 40,200 Less: Dividends 6,000 Increase in Retained Earnings 34,200 Retained Earnings, July 31, 2012 73,300 ACME, Inc. Balance Sheet July 31, 2018 Assets Liabilities Current Assets: Current Liabilities: Cash 42,000 Accounts Payable 4,000 Accounts Receivable 8,000 Sales Tax Payable 4,500 Inventory 800 Total...
Below are the income statement and comparative balance sheet of Doone Corporation for year ending Dec 31, 2019 is given below. All amounts in Canadian dollars. Required: Prepare the cashflow statement, clearly including operating, financing and investing activities up to the net change in cash using the Indirect method as of Dec 31, 2019. Doone Corporation Income Statement For the Year ended Dec 31, 2019 Sales Revenue 880,000 Less: Cost of Goods Sold 520.000 Gross Profit 360,000 Less: Selling, General...
Below are the income statement and comparative balance sheet of Doone Corporation for year ending Dec 31, 2019 is given below. All amounts in Canadian dollars. Required: Prepare the cashflow statement, clearly including operating, financing and investing activities up to the net change in cash using the Indirect method as of Dec 31, 2019. Doone Corporation Income Statement For the Year ended Dec 31, 2019 Sales Revenue 950,000 Less: Cost of Goods Sold 520,000 Gross Profit 430,000 Less: Selling,...
Below are the income statement and comparative balance sheet of Doone Corporation for year ending Dec 31, 2019 is given below. All amounts in Canadian dollars. Required: Prepare the cashflow statement, clearly including operating, financing and investing activities up to the net change in cash using the Indirect method as of Dec 31, 2019. Doone Corporation Income Statement For the Year ended Dec 31, 2019 Sales Revenue 780,000 Less: Cost of Goods Sold 360,000 Gross Profit 420,000 Less: Selling,...
Below are the income statement and comparative balance sheet of Doone Corporation for year ending Dec 31, 2019 is given below. All amounts in Canadian dollars. Required: Prepare the cashflow statement, clearly including operating, financing and investing activities up to the net change in cash using the Indirect method as of Dec 31, 2019. Doone Corporation Income Statement For the Year ended Dec 31, 2019 Sales Revenue 670,000 Less: Cost of Goods Sold 340.000 Gross Profit 330,000 Less: Selling, General...