I need help completing only part B (question B). Which is creating a statement of Cash Flow for 2017. I feel my numbers and format is incorrect.
Particular | 2017 | 2016 | Difference |
Accounts receivable | 4,50,000.00 | 3,50,000.00 | 1,00,000.00 |
Cash & equivalents | 1,08,000.00 | 50,000.00 | 58,000.00 |
Inventory | 12,50,000.00 | 8,50,000.00 | 4,00,000.00 |
Long-term Investments | 4,50,000.00 | 3,60,000.00 | 90,000.00 |
Marketable Securities | 1,50,000.00 | 1,00,000.00 | 50,000.00 |
Net plant & equipment | 53,50,000.00 | 48,00,000.00 | 5,50,000.00 |
Prepaid Expense | 1,20,000.00 | 40,000.00 | 80,000.00 |
TOTAL | 78,78,000.00 | 65,50,000.00 | 13,28,000.00 |
Accounts Payable | 4,20,000.00 | 3,80,000.00 | 40,000.00 |
Accrude Expense | 1,50,000.00 | 1,00,000.00 | 50,000.00 |
Additional Paid in Capital | 6,00,000.00 | 5,00,000.00 | 1,00,000.00 |
Common Stock | 25,00,000.00 | 20,00,000.00 | 5,00,000.00 |
Long term Debt | 29,00,000.00 | 25,00,000.00 | 4,00,000.00 |
Note Payable | 1,50,000.00 | 1,00,000.00 | 50,000.00 |
Other Current Liabilities | 2,00,000.00 | 1,80,000.00 | 20,000.00 |
Retained Earnings | 5,48,000.00 | 5,00,000.00 | 48,000.00 |
Depreciation Reserve | 4,10,000.00 | 2,90,000.00 | 1,20,000.00 |
TOTAL | 78,78,000.00 | 65,50,000.00 | 13,28,000.00 |
Income Statement | |||
Revenue | 75,50,000.00 | ||
Cost of goods sold | 57,50,000.00 | ||
Selling expenses | 8,20,000.00 | ||
Lease Expense | 1,50,000.00 | ||
Administrative expenses | 2,00,000.00 | ||
Depreciation | 1,20,000.00 | ||
Interest expense | 3,50,000.00 | ||
Income tax | 64,000.00 | (74,54,000.00) | |
Net Income | 96,000.00 |
CASH FLOW STATEMENTS | |
USING INDIRECT METHOD | |
CASH FROM OPERATIONS | AMOUNT |
Net Income | 96,000.00 |
Change in Retained Earnings | (48,000.00) |
Depreciation & amortization | 1,20,000.00 |
Change in accounts receivable | (1,00,000.00) |
Change in inventory | (4,00,000.00) |
Change in Prepaid Expense | (80,000.00) |
Change in accounts payable | 40,000.00 |
Change in Accrue Expense | 50,000.00 |
Change in Other Current Liabilities | 20,000.00 |
Cash from operations (A) | (3,02,000.00) |
CASH FOR INVESTMENTS | |
Net Addition in Plant & Machinery | (5,50,000.00) |
Acquisition of Long Term Investment | (50,000.00) |
Acquisition of marketable security | (90,000.00) |
Cash for investments (B) | (6,90,000.00) |
CASH FROM FINANCING | |
Increase in long term Debt | 4,00,000.00 |
Increase in notes payable | 50,000.00 |
Issue of Additional Capital | 1,00,000.00 |
Issue of common Stock | 5,00,000.00 |
Cash from financing (C) | 10,50,000.00 |
Change in cash balance (A+B+C) | 58,000.00 |
I need help completing only part B (question B). Which is creating a statement of Cash...
hi, got this question wrong on my exam as well. Would like the correct answer for the final. Using the data presented below for Blue Sky Inc.: 2017 2016 Sales $7,550,000 $6,150,000 Cost of Goods 5,750,000 4,550,000 Depreciation 120,000 100,000 Selling and G&A Expenses 820,000 730,000 Fixed Expenses 200,000 200,000 Lease Expense 150,000 150,000 Interest Expense 350,000 300,000 Tax Rate 40.00% 40.00% Shares Outstanding 100,000 80,000 Cash 108,000 50,000 Marketable Securities 150,000 100,000 Accounts Receivable 450,000 350,000 Inventory 1,250,000 850,000...
please show all work in Excel CHAPTER 2: THE BASIC FINANCIAL STATEMENTS Homework for Chapter 2: Problem # 1 in the text (Chapter 2) Using the data presented below for Blue Sky Inc.: 2017 2016 S7,550,000 $6,150,000 5,750,000 Sales Cost of Goods Depreciation Selling and G&A Expenses Fixed Expenses Lease Expense Interest Expense 4,550,000 120,000 100,000 820,000 730,000 200,000 200,000 150,000 150,000 350,000 300,000 Tax Rate 40.00% 40.00% Shares Outstanding Cash Marketable Securities Accounts Receivable Inventory Prepaid Expenses Plant &...
prepare cash flow statement PROBLEM 2-7 The financial statements for the JHJ Book Store are as follows: INCOME STATEMENT 2013 3,000,000 2.500.000 500,000 Sales Cost of Books Sold Gross Profit Operating Expenses Depreciation Gain on sale of land Net Income 250,000 50.000 300,000 400.000 600.000 BALANCE SHEET 2013 Cash Accounts Receivable Inventory Equipment Accumulated Depreciation Land Total Assets 2012 100,000 125,000 150,000 100,000 (25,000) 100,000 550.000 2013 300,000 200,000 350,000 450,000 (75,000) 1.225.000 Accounts Payable Long Term Bond Payable Total...
27. Prepare a statement of cash flows for the Crosby Corporation. Follow the general procedures indicated in Table 2–10 on page 38 .Statement of cash flows(L04)Current Assets LiabilitiesCash . . . . . . . . . . . . . . . . . . . . . . . . . $ 15,000 Accounts payable . . . . . . . . $ 20,000Accounts receivable . . . . . . . . . . . ....
See the following financial information (Income Statement and balance Sheet) for Thornton Company for the years ending December 31, 1998 and 1999. What is the Net Plant & Equipment in 1998 and 1999? Calculate the Cash balance in 1998 and 1999? What is firm’s Net Income in 1998 and 1999? What is the Quick ratio in 1998 and 1999? What is the ROE in 1998 and 1999? What is the EPS (Earnings Per Share) in 1998 and 1999? 1998 1999...
PROBLEM 2-9 STATEMENT OF CASH FLOWS te for the Book Store are as follos INCOME STATEMENT 2013 5,000,000 4.500.000 500,000 Sau Chuo Be 300,000 200.000 500.000 (45, 000) 45000 Operating Expenses Deption Le sale of land Net loss BALANCE SHEET 2013 Cast 2012 100,000 25.000 150,000 100,000 (25,000) 100,000 450,000 2013 60,000 325,000 450,000 450,000 (225.000) Accounts Receivable Inventory Equipment Accumulated Depreciation Land Total Assets 1.060.000 100,000 Accounts Payable Long Term Bond Payable Total Liabilities 300,000 200,000 500.000 100.000 Common...
The Castillo Company reported operating profits of $60,000, Depreciation expenses of $40,000, Interest expense of $10,000 and paid $10,000 in taxes in 2017. Following are the Company’s balance sheets for 2016 and 2017. C&B CASTILLO COMPANY 2016 2017 Cash $50,000 $5,000 Accounts Receivables 200,000 300,000 Inventories 400,000 480,000 Total Current Assets 650,000 785,000 Gross Fixed Assets 450,000 570,000 Accumulated Depreciation -100,000 -140,000 Net Fixed Assets ...
Problem #3 The income statement, balance sheets, and additional information for Surround Sound, Inc., are provided below. Surround Sound, Inc. Income Statement For the Year Ended December 31, 2018 Revenues Gain on sale of land $4,500,000 15,000 Expenses: Cost of goods sold Operating expenses Depreciation expense Income tax expense Total expenses Net Income 2.800,000 650,000 75,000 280,000 3.805.000 $710,000 Surround Sound, Inc. Balance Sheets December 31 2018 2017 Increase (or Decrease (D) Assets Current Assets: Cash Accounts receivable Inventory Long-Term...
only need part b worksheet Illustration #3 Pepper Company, which is a calendar-year-reporting company, purchased 100% of the common stock of Salt Inc. for $325,000 on 12/31/17. On the acquisition date, the following net assets of Salt had fair values different than book value: Cost FMV Inventory 80,000 75,000 Turnover 6 times per year Land 70,000 100,000 Building and equipment 220,000 210,000 10 year life Accumulated depreciation (60,000) Covenant-not-to-complete 40,000 4 year life Bonds payable 150,000 175,000 10 years to...
QUESTION 2 Prepare a balance sheet and an income statement for Cucki Company for the year 2017 from the following information: RM 57,000 14,000 150,000 6,200 600,000 Accounts payable Cash Long term debt Marketable securities Sales Taxes (40%) Prepaid rent Accounts receivable Depreciation COGS Interest expenses Inventory Plant and equipment General and administrative expenses 30,000 Accumulated depreciation Accruals Notes payable 1,100 33,000 30,000 460,000 10,000 84,000 300,000 30,000 5,000 mon stockboldes squty135.300