Question

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

• 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.

• Prepare a pie chart of Joe’s Fly-By-Night Oil’s expense distribution for 2018 and comment on the results displayed.

• Prepare a pie chart of Joe’s Fly-By-Night Oil’s asset distribution for Dec 31, 2018 and comment on the results displayed.

• Prepare a pie chart of Joe’s Fly-By-Night Oil’s capital structure for Dec 31, 2018 and comment on the results displayed.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

AutoSave Book1 - Excel 《Product Activation Failed) Sign in File Insert Page Layout Formulas Data Review View Help Tell me what you want to do 수 Share Home Calibri Wrap Text General 田FF Paste . 녀 . 의 _ . 로三들經垣臣 Merge & Center-5 . % , Conditional Fornat as Cell Insert Delete Fornat FormattingTable Styles- 、. Sort & Find & : Filter-Select- Clipboard Alignment Number Styles Cells Editing C8 Year 2015 2016 2017 2018 Sales 8200 8000 9000 100001800 Net Income 1500 1400 1600 Net Income/Sales 10000 8000 10 2000 12 13 14 15 16 17 2015 2016 2017 2018 -sales-, Net Income Sheet1 Shet2 Ready + 100 cENG 8:55 AM

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: AutoSave (·of , C. 『 Book1-Excel (Product Activation Failed) Chart Tools Sign in File Home Insert Page Layout Formulas Data Review View Help Design Format Tell me what you want to do 수 Share Add Chart Quick Change Element- Layout- Colors ▼ Switch Row Select Change Move Column Data Chart Type Chart Type Location Chart Layouts Chart Styles Chart 1 Format Chart Area Cost of goods sold 4000 S, G & A epenses 3000 Interest Taxes Total expenses 8200 Chart Options▼ Text Options Expenses 4 200 1000 Fill Border 10 12 13 14 15 16 17 ● Cost of goods sold . S, G & A expenses . Interest . Taxes Sheet1 Sheet2 Sheet3 Ready Average: 2050 Count: 8 Sum: 8200- E |L + 100 cENG 9:01 AMThe 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: AutoSave (·of , C. 『 Book1-Excel (Product Activation Failed) Chart Tools Sign in File Home Insert Page Layout Formulas Data Review View Help Design Format Tell me what you want to do Share Add Chart Quick Change Element- Layout- Colors ▼ Switch Row Select Change Move Column Data Chart Type Chart Type Location Chart Layouts Chart Styles Chart 1 Current assets Net Equipment 25000 15000 Total assets Total assets 10 12 13 14 15 16 17 Current assets Net Equipment Sheet1 Sheet2 Sheet3 Ready + 100 cENG 9:06 AMThe 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.

Add a comment
Know the answer?
Add Answer to:
INCOME STATEMENT, 2018 BALANCE SHEET, as of Dec 31, 2018 Sales $10,000 ASSETS Cost of goods...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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...

    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 She...

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

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

    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                           &nbsp

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

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

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

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

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

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT