Question

In: Accounting

Using the below financial statements to complete the ratio analysis and statement of Cash Flow questions...

Using the below financial statements to complete the ratio analysis and statement of Cash Flow questions following the financial statements.

Milky Way corp comparative Balance sheet December 31, 20XX and 20XX (Prior)

Assets Current Prior
Cash 1,580 1,080
Account Receivable 1,300 1,680
Inventory 12,420 12,000
Total Current Assets 15,300 14,760
Land 12,300 10,200
Equipment 11,480 9,600
Accumulated Depreciation (2,040) (1,080)
Total Long-term Assets 37,040 33,480
Liabilities
Account Payable 1,920 960
Salaries Payable 5,060 4,080
Total Current Liabilities 6,980 5,040
Long-term Debt 4,300 4,200
Total Liabilities 11,280 9,240
Stockholders' Equity
Common Stock, 1000 Shares 10,000 10,000
Retained Earnings 15,760 14,240
Total Stockholders' Equity 25,760 24,240
Total Liabilities Stockholders' Equity 37,040 33,480

Milky Way Corp Income statement for the year Ended December 31, 20XX

Current year

Sales 24,720
Cost of goods sold 11,600
Gross Profit 13,120
Operating Expense
Depreciation Expense 960
Salaries Expense 3,240
Other Expenses 2,400
Total Operating Expenses 6,600
Operating Income 6,520
Interest Expense (600)
Net Income 5,920

Prepare the Statement of Cash flows for Milky Corp for 20XX. Use the Indirect method.

Milky Way Corp Statement of cash flow For the year Ended December 31, 20XX

Cash Flows from Operating Activities:

Net Cash inflow from Operating Activities

Cash flows from Investing Activities

Net Cash Outflow from Investing Activities

Cash flows from Financing Activities:

Net Cash from Financing Activities

Net Increase/ Decrease in cash flow

Plus: Beginning Cash Balance

Ending Cash Balance

Solutions

Expert Solution

Working note:


Related Solutions

evaluate financial statements using ratio analysis
evaluate financial statements using ratio analysis
1.    Cash Flow Statements Prepare a cash flow statement for Anna’s Apples Ltd using the information below....
1.    Cash Flow Statements Prepare a cash flow statement for Anna’s Apples Ltd using the information below. Use the indirect method for operating cash flows. Net Profit for year ended 30 June 2017: $200,000                                                       30 June 2017                 1 July 2016 Cash                                                         ?                             $20,000 Inventory                                            $30,000                       $40,000 Accounts Payable                               $15,000                       $30,000 Unearned Revenue                              $12,000                       $15,000 Prepaid Insurance                               $18,000                       $33,000 Goodwill                                             $50,000                       $0 Equipment                                          $300,000                     450,000 Acc Dep’n Equipment $150,000                     $160,000 Loan Payable                                      $50,000                       $100,000 During the year equipment with a cost of $150,000 and accumulated depreciation of $50,000 was sold for $115,000. No other purchases or sales of equipment...
128). What is Financial statement and cash flow analysis?
128). What is Financial statement and cash flow analysis?
Complete the Cash Flow Statement for the company, CM Inc, using the information presented below. CM...
Complete the Cash Flow Statement for the company, CM Inc, using the information presented below. CM Inc. is a wholesale manufacturer of nut butters including: peanut, almond, and cashew. They also purchase sesame seeds to turn into the world's finest tahini. CM has engaged you to prepare a Statement of Cash Flows for their next quarterly meeting. CM's accounting department prepared the Income Statement and the Balance Sheet included in the table below. They were unable to provide you with...
Using the information below, Complete the Cash Flow Statement for Jenna Jam’s on 31 December 2019....
Using the information below, Complete the Cash Flow Statement for Jenna Jam’s on 31 December 2019. Cash 01/01/2019 272,000 Cash 31/12/2019 ???? Depreciation on Motor Vehicle 9,000 Owner investment 90,000 Interest on Loan Payable 4,700 Payment for purchase of Motor Vehicle 21,800 Collections from customers 283,000 Owner withdrawals 91,000 Payment of wages 121,000 Cash received for sale of Land 580,000 Payment to suppliers 345,000
. Using the financial statement and data below answer the following questions: Financial Statement Data and...
. Using the financial statement and data below answer the following questions: Financial Statement Data and Stock Price Data for Flextronics (All data as of fiscal year end; $ in millions) Income Statement 2012 2013 2014 2015 2016 Revenue 404.3 363.8 424.6 510.7 604.1 Cost of Goods Sold -188.3 -173.8 -206.2 -246.8 -293.4 Gross profit 216 190 218.4 263.9 310.7 Sales and Marketing -66.7 -66.4 -82.8 -102.1 -120.8 Administration -60.6 -59.1 -59.4 -66.4 -78.5 Depreciation & Amortization -27.3 -27 -34.3...
Discuss the interrelationship of the cash flow statement to the other financial statements. In your discussion...
Discuss the interrelationship of the cash flow statement to the other financial statements. In your discussion comment and explain operating activities, investing activities, and financing activities. What is the difference between an indirect and a direct cash flow statement? Which is GAAP? (250 words total and no plagiarirm please)
Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet...
Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet as of the end of 20XX based on the data provided below for year 20XX. All sales are collected when the sale is made and all expenses are paid when the expense is incurred. Explain the purpose of each financial statement. a. Income Statement Data for 20XX:  Units produced and sold = 420  Sales ($80 per unit selling price) = $33600 ...
Describe impacts on the 3 financial statements (balance sheet, income statement and cash flow statement) of:...
Describe impacts on the 3 financial statements (balance sheet, income statement and cash flow statement) of: a. An increase of accounts receivables by $100 b. An increase of accrued expenses by $100 c. A decrease of prepaid expenses by $100 d. An increase in inventory by $100 (paid in cash) e. An increase in depreciation by $100 f. A sale of equipment for $200 (value on the balance sheet: $170) g. An asset write-down (impairment) of $100 h. A debt...
Describe impacts on the 3 financial statements (balance sheet, income statement and cash flow statement) of:...
Describe impacts on the 3 financial statements (balance sheet, income statement and cash flow statement) of: g. An asset write-down (impairment) of $100 h. A debt write-down (impairment) of $100 i. An issue of new shares for $500 j. An issue of new shares to employees as stock-based compensation for $500 k. A payment of dividends for $100 l. An expense of $50 of interest on a debt, 50% in cash and 50% in PIK (Paid-In-Kind i.e. accrued) interest Remark:...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT