Question

Book1 - Excel Home Insert Page Layout Formulas Data Review View Tell me what you want to do Calibri General Normal Ee Copy 트 ,,El Merge & Center . $ ·96 , +0-0 Conditional Format as Neutral Format Painter Formatting Table Alignment Number ACCOUNT NOTICE Weve run into a problem with your Office 365 subscription, and we need your help to fix it. Reactivate A38 Required: To find the Cash paid to suppliers 1 As the accountant for MM Group your duties include preparing the Statement of Cash 2 Flows from the information provided below MM Group Comparative Statements of Financial Position As at June 30 MM Group Comparative Statements of Financial Position As at June 30 2018 2017 Sales Revenue Less Cost of Goods sold Gross Profit Less Operating expenses (including bad debts and depreciation) 1,000,000.00 600,000.00 400,000.00 300,000.00 100,000.00 10 Accounts Receivable 11 Prepaid Expenses 12 Inventory 13 Equity Investments (non-trading) 14 Equipment 15 Building 5,000.00 82,000.00 8,000.00 60,000.00 80,000.00 40,000.00 300,000.00 300,000.00 40,000.00 655,000.00 55,000.00 100,000.00 10,000.00 65,000.00 70,000.00 50,000.00 Income from Operations Other income and Expenses Gain on sale of investments Loss on sale of equipment 10,000.00 (2,000.00) 8,000.00 108,000.00 48,000.00 60,000.00 80,000.00 730,000.00 18 19 Allowance for Doubtful Accounts 20 Accumulated Depreciation-Equipment 21 Accumulated Depreciation-Building 22 Accounts Payable 23 Income Tax Payable 24 Long term Notes Payable 25 Share Capital Ordinary 26 Retained Earnings 27 28 29 Additional data 30 1 Equipment that cost 10,000 and was 50% depreciated at the time of disposal was sold for $3,000. 31 2. Ordinary shares were issued in exchange for land 32 3. Equity investments which cost 30,000 were sold 33 4. Uncollectible accounts valued at $2,000 were written off during the year 34 5. Cash dividends were declared and paid during the year 35 36 The company prepares its Statement of Cash Flows using the direct method. Less Income before taxes Net Income 12,000.00 10,000.00 30,000.00 75,000.00 10,000.00 70,000.00 440,000.00 350,000.00 98,000.00 730,000.00 655,000.00 14,000.00 15,000.00 33,000.00 70,000.00 12,000.00 60,000.00 86,000.00 38 Required: To find the Cash paid to suppliers

0 0
Add a comment Improve this question Transcribed image text
Answer #1
cash paid to suppliers =
cost of goods sold +increase in inventory +decrease in accounts payable-
decrease in invnetory - increase in accounts payable
600,000+5000+5000
610,000 answer
Add a comment
Know the answer?
Add Answer to:
Book1 - Excel Home Insert Page Layout Formulas Data Review View Tell me what you want...
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
  • TEL Company provided the following account balances on December 31, 2019: Accounts receivable 400,000.00 Advances to...

    TEL Company provided the following account balances on December 31, 2019: Accounts receivable 400,000.00 Advances to officers-not-currently collectible 100,000.00 Sinking fund 400,000.00 Building 5,000,000.00 Long-term refundable deposit 50,000.00 Cash and cash equivalents 500,000.00 Cash surrender value 60,000.00 Equipment 1,000,000.00 Lease rights 100,000.00 Accrued interest on notes receivable 10,000.00 Inventories 1,300,000.00 Land 1,500,000.00 Land held for speculation 500,000.00 Notes receivable 250,000.00 Computer software 3,250,000.00 Prepaid expenses 70,000.00 Trading securities 280,000.00 Unearned rent income 40,000.00 Retained earnings (deficit) (1,800,000.00) Share premium -...

  • File Home inset Page Layout Formulas Data Review View Tell me what you want to PROTECTED...

    File Home inset Page Layout Formulas Data Review View Tell me what you want to PROTECTED VIIW Be Careful files from the Internet can contain viruses. Unless you need to edit it's safe to stay in Prote Balance Sheet Income Statement 2 Current Assets Sales en $ 195,000.00 New Inne Income Net Revenue is process ed goods 20.000,00 TIL Current 10 Nom Current Acts Directly related Beyler New Purce Ren Alles Production $ 12,000.00 $ 10 12 Land $ 3.500,000.00...

  • TEL Company provided the following account balances on Dec. 31, 2019 Accounts Receivable    400,000.00 Advances...

    TEL Company provided the following account balances on Dec. 31, 2019 Accounts Receivable    400,000.00 Advances to Officers -not- currently collectible 100,000.00 Sinking Fund 400,000.00 Building    5,000,000.00 Longterm Refundable Deposit    50,000.00 Cash and cash Equivalent    500,000.00 Cash Surrender Value 60,000.00 Equipment 1,000,000.00 Lease Rights    100,000.00 Accrued Interest on Notes Receivable 10,000.00 Inventories 1,300,000.00 Land 1,500,000.00 Land Held for Speculation 500,000.00 Notes Receivable    250,000.00 Computer Software    3,250,000.00 Prepaid Expenses 70,000.00 Trading Securities    280,000.00 Unsaved...

  • the comparative balance sheet of yellow dog enterprises inc. at December 31, 20Y8 and 20Y7, is...

    the comparative balance sheet of yellow dog enterprises inc. at December 31, 20Y8 and 20Y7, is as follows:     dec 31. 20Y8        dec 31. 20Y7.                         Assets.                                                                                        cash.                          $80,000.00.             $100,000.00.                      Accounts receivable 275,000.00.              300,000.00.        merchandise inventory 510,000.00.          400,000.00.      prepaid expenses.        15,000.00.            10,000.00.          equipment.                  1,750,000.00.          750,000.00.         Accumulated depreciation (200,000.00. (160,000.00.     total Assets.                  1,750,000.00.     $1400,000.00.      liabilities and stockholders equity.                                           Accounts payable.         $100,000.00.        $90,000,00.    mortgage note payable   0.00.                   400,000.00.       common stock $10 par. 600,000.00.      200,000.00.     paid in capital.                   300,000.00.      100,000.00.        retained earnings.             750,000.00.       610,000.00.     total...

  • Write a narrative of up to 750 words in which you describe the following trends in...

    Write a narrative of up to 750 words in which you describe the following trends in the below images related to the income statement, balance sheet and financial ratios. Identify what you believe to be the most significant changes. The assignment is completed by simply describing the changes. As an option, you may speculate as to the causes of the changes. wwc Balance Sheet wwc Retained Earnings Horizontal Analysis Increase or (Decrease) 2018 over 2017 Dollars Percent Vertical Analysis Percent...

  • Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to...

    Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do = = ). General Calibri B I 11 . Font - A A . .A. Wrap Text Merge & Center. U $ . % * 3 Alignment Number Clipboard R14 4. A . B C D G H nter the last 4 digits of your student ID number 4 Name/s: 7 Save this file in EXCEL FORMAT as: P2 Lastname 8 Round all...

  • le Data Review View Help Tell me what you want to do 14 Home Insert X...

    le Data Review View Help Tell me what you want to do 14 Home Insert X Cut Le Copy Format Painter Clipboard General Arial 10 - A A BIUD #CA Paste 2. $ . % 19 Conditional Format Formatting as Table Tables Font Alignment Number сар GH Statement of cash flows Cash at the Beginning of Year Change in Net Operating Working Capital Except Cash Not Income Common Dividends Machinery Equipment Purchases Depreciation Expense Long-Term Debt Interest Rate on Long-Term...

  • Need formulas for areas in red Home Insert Draw Page Layout Formulas Date Review View Developer...

    Need formulas for areas in red Home Insert Draw Page Layout Formulas Date Review View Developer Help Power Piv Cut Copy- Parte Clipboard - Font Alignment G28 Cash Flow Identity Exercise Complete the CFI using the given income statements and other information below 2019 2018 11 12 13 Comparative Balance Sheets Assets 2019 2018 Liabilities Current Assets Current Liabilities Cash & Equivalents 2.500 2.550 Accounts payable Short term investments 1,834 2.400 Accruals and Other Accounts receivable 5,672 4.966 Total current...

  • 1 3 Minneapolis, Inc. is a small shop in the neighborhood that sells fruit. The owner...

    1 3 Minneapolis, Inc. is a small shop in the neighborhood that sells fruit. The owner of the shop, Ms. Foster, hired 4 you to help with her accounting. The previous accountant got married and left the company. Ms. Foster 5 was able to finish the financial statement except the statement of cash flow so she asked you to prepare the s statement of cash flow as your first job. 7 8 Ms. Foster prepared the following financial statements. 2018...

  • Week 5 Homework Assignment-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11...

    Week 5 Homework Assignment-Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri - 11 A A Wrap Text Auto Fil- General Paste BIU - A Merge & Center E Conditional Format as Cell Formatting Insert Delete Formar Clear- Table Styles Clipboard Font Alignment Number Styles Cells K11 A D F G H J 1 Comprehensive Budgeting Problem 20 points Silverman Manufacturing is preparing its master budget for the first quarter of the upcoming year. The following data pertain...

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