Question

PROBLEM 1: The 2018 and 2019 comparative balance sheets and 2019 income statement for Edmond &...

PROBLEM 1:


The 2018 and 2019 comparative balance sheets and 2019 income statement for Edmond & Edmond Company appear below:

EDMOND & EDMOND COMPANY

Comparative Balance Sheet

December 31

                                                                                                                   2019                    2018    

Assets

Cash                                                                                                      $ 26,000            $ 23,000

Accounts receivable                                                                                  25,000                34,000

Merchandise inventory                                                                              32,000                15,000

Property, plant, and equipment                                                                 60,000                78,000

Accumulated depreciation                                                                        (21,000)              (24,000)

         Total                                                                                              $122,000            $126,000

Liabilities and Stockholders' Equity

Accounts payable                                                                                  $ 18,000            $ 23,000

Income taxes payable                                                                                 9,000                  8,000

Notes payable (long-term)                                                                           8,000                33,000

Common stock                                                                                          28,000                24,000

Retained earnings                                                                                     59,000                38,000

         Total                                                                                              $122,000            $126,000

EDMOND & EDMOND COMPANY

Income Statement

For the Year Ended December 31, 2019

Sales                                                                                                                                 $400,000

Cost of goods sold                                                                                                            270,000

Gross profit                                                                                                                         130,000

Operating expenses                                                                                                             45,000

Income from operations                                                                                                        85,000

Interest expense                                                                                                                     5,000

Income before income taxes                                                                                                80,000

Income tax expense                                                                                                             24,000

Net income                                                                                                                        $ 56,000

The following additional data were provided:

1.   Dividends declared and paid were $35,000.

2.   During the year, equipment was sold for $17,000 cash. This equipment cost $28,000 originally and had a book value of $17,000 at the time of sale.

3.   Purchased a used delivery truck for $10,000

4.   All depreciation expense is included the operating expenses.

5.   All sales and purchases are on account.

6.   Accounts payable pertain to merchandise suppliers.

REQUIREMENTS: Prepare 1 WORD document (WD1) and 1 EXCEL document (ED1):

1. (WD1)>>Write a brief, yet clear, paragraph about the purpose of a statement of cash flow .

       Be specific.

2. (ED1)>>Prepare a statement of cash flows for Edmond & Edmond Company using the indirect

      method.   Be sure your statement is complete in form, includes all needed line-items, and is
      accurate.  

3.   (WD1)>>Write a brief, yet thorough, email to Cisslee Williams (the Controller for Edmond and
       Edmond) stating the overall conclusion you have drawn from the completed statement of cash
       flows.

PROBLEM 2:

Find the official website for ONE of the following companies:

Coca-cola

Walmart

Tyson Foods

Once you find an official website for the company you select, perform the following tasks:

Find the “Investor Relations” link and click. Once in “investor relations,”

Find the 2017 annual report OR 10-K Report to the SEC

After locating one of the documents, locate the financial statements included in the document.

Copy and paste the (1) comparative balance sheet, (2) income statement, and (3) statement of cash flows and include ALL three (3) in a separate file.      Do not be concerned with the formatting once you have pasted.   Just be sure the name of the company, name of the statement, and the years are clearly shown as proof that you have provided the required statements.

Now that you have access to the financial statements, compute the following ratios FOR TWO YEARS.   Be sure to show ALL computations, equations, formulas,   etc.:

Any two liquidity ratios

One solvency ratio

Any two profitability ratios

              

REQUIRED1:   Write and submit a 1st document that:

>>>Identifies the name of the company on which you performed research

              

>>> Presents the ratios (e.g., a table) you have computed. Keep computations separate from final ratio answers.   Be sure to clearly classify and identify all ratios. Show the computations.   Neatness, order, and clarity are a MUST.   Be sure your presentation is neat, orderly, and can be clearly followed.

>>>States YOUR conclusion about each of the three groups of ratios.   Hint: A cover page is expected.

REQUIRED2:   Write and submit a 2nd document that includes the financial statements you copied and pasted (as required in “d” above. IF you can easily include your financial statements as pages in the 1st document, that will absolutely acceptable, and preferred.

Homework Answers

Answer #1

Problem- 1

Answer-a:

The main purpose of the cash flow statement is to provide information about the cash receipts and cash payments along with net change in cash and cash equivalents resulting from the operating, investing and financing activities of a firm during the specified period. It helps to answer the following questions:

  1. Where did the cash come from during the specified period
  2. What was the cash used for during the specified period
  3. What was the net change in cash and cash equivalents balance during the specified period.

It helps the investors to assess the firm’s ability to generate cash and cash equivalents and the needs of the entity to utilise those cash flows.

Answer-b:

EDMOND & EDMOND COMPANY

Cash Flow Statement for the year ended December 31, 2019

Cash Flow from Operating Activities

Profit before taxation (Net Income)

80000

Adjustment for:

     Provision for Depreciation ***

8000

     Interest Expense

5000

     Changes in current assets and liabilities

         decrease in accounts receivables

9000

         increase in merchandise inventory

-17000

         decrease in accounts payable

-5000

Cash generated from operations

80000

Less; Income tax paid ***

-23000

Net Cash Flow from Operating Activities

57000

Cash Flow from Investing Activities

   Purchased of used delivery truck

-10000

   Proceed from sale of Equipment

17000

Net cash used in investing activities

7000

Cash Flow from Financing Activities

    Repayment of Notes Payable

-25000

    Proceed from Issue of Share Capital

4000

    Dividend Paid

-35000

    Interest Expense

-5000

Net Cash used in Financing Activities

-61000

Net increase in cash and cash equivalent

3000

Cash and cash equivalent at the beginning of the year

23000

Cash and cash equivalent at the end of the year

26000

Calculation of Depreciation Expense for the year 2019:

            Accumulated depreciation on sold equipment = 11,000

     Add: Accumulated depreciation at the end of year = 21,000

    Less: Accumulated depreciation at the beginning of year = 24,000

           Depreciation for the current year = 8,000.

Calculation of Income Tax Paid during the year:

          Income tax expense for the year = 24,000

Add: liability for income tax at the beginning = 8,000

Less: liability for income tax at the end of year = 9,000

           Income tax paid during the year = 23,000

Answer-c:

Cash flow statement shows that the firm is performing well as it’s earning sufficient resources from the operations to fund its financing and investing activities. It is able to meet the regular liability of interest payment and dividends for its shareholders

PLEASE, post independent question seprately instead of in one go ..

Know the answer?
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
Similar Questions
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 49 $ 28 Accounts receivable 52 63 Less: Allowance for uncollectible accounts (4 ) (3 ) Dividends receivable 6 3 Inventory 71 58 Long-term investment 31 18 Land 110 60 Buildings and...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are...
The comparative balance sheets for 2018 and 2017 and the statement of income for 2018 are given below for Dux Company. Additional information from Dux’s accounting records is provided also. DUX COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 33 $ 20 Accounts receivable 48 50 Less: Allowance for uncollectible accounts (4 ) (3 ) Dividends receivable 3 2 Inventory 55 50 Long-term investment 15 10 Land 70 40 Buildings and...
26) The following are comparative balance sheets and an income statement for Wentworth Company. Wentworth Company...
26) The following are comparative balance sheets and an income statement for Wentworth Company. Wentworth Company Balance Sheets as of December 31 Assets 2018 2017 Cash $21,500 $120,000 Accounts receivable 195,000 105,000 Inventory 180,000 225,000 Long-term investments 0 60,000 Totals $396,500 $510,000 Liabilities and shareholders' equity Accounts payable $75,000 $120,000 Operating expenses payable 24,000 15,000 Bonds payable 70,000 100,000 Common stock 125,000 125,000 Retained earnings 102,500 150,000 Totals $396,500 $510,000 Wentworth Company Income Statement For the Year Ended December 31,...
The comparative balance sheets for 2018 and 2017 and the income statement for 2018 are given...
The comparative balance sheets for 2018 and 2017 and the income statement for 2018 are given below for Arduous Company. Additional information from Arduous’s accounting records is provided also. ARDUOUS COMPANY Comparative Balance Sheets December 31, 2018 and 2017 ($ in millions) 2018 2017 Assets Cash $ 109 $ 81 Accounts receivable 190 194 Investment revenue receivable 6 4 Inventory 205 200 Prepaid insurance 4 8 Long-term investment 156 125 Land 196 150 Buildings and equipment 412 400 Less: Accumulated...
Comparative balance sheets for 2018 and 2017, a statement of income for 2018, and additional information...
Comparative balance sheets for 2018 and 2017, a statement of income for 2018, and additional information from the accounting records of Red, Inc., are provided below. RED, INC. Comparative Balance Sheets December 31, 2018 and 2017 ($ in millions) 2018 2017 Assets Cash $ 24 $ 110 Accounts receivable 178 132 Prepaid insurance 7 3 Inventory 285 175 Buildings and equipment 400 350 Less: Accumulated depreciation (119 ) (240 ) $ 775 $ 530 Liabilities Accounts payable $ 87 $...
Comparative balance sheets for 2018 and 2017 and a statement of income for 2018 are given...
Comparative balance sheets for 2018 and 2017 and a statement of income for 2018 are given below for Metagrobolize Industries. Additional information from the accounting records of Metagrobolize also is provided. METAGROBOLIZE INDUSTRIES Comparative Balance Sheets December 31, 2018 and 2017 ($ in 000s) 2018 2017 Assets Cash $ 390 $ 190 Accounts receivable 450 240 Inventory 600 375 Land 600 560 Building 900 900 Less: Accumulated depreciation (300 ) (285 ) Equipment 2,750 2,450 Less: Accumulated depreciation (430 )...
Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. Balance...
Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. Balance Sheets Assets 2019 2018 Cash and equivalents $100   $85   Accounts receivable 275   300   Inventories 375   250         Total current assets $750   $635   Net plant and equipment 2,300   1,490   Total assets $3,050   $2,125   Liabilities and Equity Accounts payable $150   $85   Accruals 75   50   Notes payable 150   75         Total current liabilities $375   $210   Long-term debt 450   290         Total liabilities 825   500   Common stock 1,225   1,225   Retained earnings...
1. Terry company's 2017 income statement and comparative balance sheets at December 31 of 2016 and...
1. Terry company's 2017 income statement and comparative balance sheets at December 31 of 2016 and 2017are shown. Terry Company                                                                    Income Statement        For the year Ended December 31, 2017    Sales                                                 $ 390,000    Cost of Goods Sold                            235,000                                                                                _______      Gross Profit                                                        $ 155,000    Wages Expenses                              $ 63,000    Depreciation Expense                        14,000    Other Operating Expenses                  26,000    Income Tax Expense                           17,000    120,000                                                                                 ______    ________      Net Income                                                          $ 35,000                                                  ...
Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. The...
Quantitative Problem: Rosnan Industries' 2019 and 2018 balance sheets and income statements are shown below. The balance in the firm's cash and equivalents account is needed for operations and is not considered "excess" cash. Using the financial statements given below, what is Rosnan's 2019 free cash flow (FCF)? Use a minus sign to indicate a negative FCF. Round your answer to the nearest cent. $ ??? Balance Sheets Assets 2019 2018 Cash and equivalents $100   $85   Accounts receivable 275   300  ...
The comparative balance sheet for the ZYX Company at December 31, 2019 and 2018 is as...
The comparative balance sheet for the ZYX Company at December 31, 2019 and 2018 is as follows: 12/31/19 12/31/18 Assets: Cash $146,600 $179,800 Accounts Receivable 224,600 242,000 Merchandise Inventory 321,600 299,200 Prepaid Expenses 13,400 9,600 Equipment 655,000 537,000 Accumulated depreciation-equipment    (170,800) (132,200) Total Assets $1,190,400 $1,135,400 Liabilities and Stockholders’ Equity Accounts payable (merchandise creditors)    $250,200 $237,600 Mortgage note payable 0 336,000 Common Stock, $10 par 74,000 24,000 Paid in Capital-common stock 470,000 320,000 Retained Earnings 396,200 217,800 Total...