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.
Homework Answers
| 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 |
Add Answer to:
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...
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:...
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...
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...
Prepare a statement of cash flows for the Crosby Corporation
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...
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...
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...
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 ...
Balance Sheet and Income Statement ASSETS 2015 2014 CASH AND MARKETABLE SECURITIES 29,000 25,000 ACCOUNTS RECEIVABLE...
Balance Sheet and Income Statement ASSETS 2015 2014 CASH AND MARKETABLE SECURITIES 29,000 25,000 ACCOUNTS RECEIVABLE 116,000 100,000 INVENTORIES 145,000 125,000 CURRENT ASSETS 290,000 250,000 GROSS PLANT AND EQUIPMENT 362,000 350,000 LESS: ACCUMULATED DEPRECIATION 130,000 100,000 NET FIXED ASSETS 232,000 250,000 TOTAL ASSETS 522,000 500,000 LIABILITIES AND EQUITY ACCOUNTS PAYABLE 90,480 78,000 ACCRURALS 34,800 30,000 NOTES PAYABLE 25,420 34,000 CURRENT LAIBILITIES 150,700 142,000 LONG TERM DEBT 145,000 140,000 TOTAL LIABILITIES 295,700 282,000 COMMON STOCK ($1.00 par) 150,000 150,000 RETAINED EARNINGS...
Problem #3 The income statement, balance sheets, and additional information for Surround Sound, Inc., are provided...
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%...
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...
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...
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...
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...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago