A) Using the information below and the template on the next tab, prepare a statement of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A) Using the information below and the template on the next tab, prepare a statement of cash flows (indirect method). B) Also using the template on the next tab, compute free cash Bow. Grading In order to get full points for this project: Cells in orange on the template should be a VALUE. Cells in green on the template should be a FORMULA Cells in yellow on the template should be TEXT. The points available for each row requiring input are noted in Column G on the template in the next tab. We Really Love Cash, Co. Comparative Balance Sheer December 31 We Really Love Cash, Co. Income Statemet For the Year ended December 31, 2020 2020 2019 Sales reveniue $242,000 175,000 67,000 24,000 Assets Cost of goods sold Gross profit Operating expenses Income from operations Interest expense Income before income taxes Income tax expense Cash $39,000 $20,000 Accounts Receivable 30,000 14,000 20,000 27,000 60,000 Inventory Equipment Accumulated depreciation-equipment Total Assets 43,000 (29.000) $127,000 78,000 (24,000) $108,000 3,000 40,000 8,000 Net income $32,000 Liabilities and Stockholders' Equity Accounts payable Income taxes payable $24,000 7,000 $15,000 8,000 Bonds mas We Really Love Cash, Co. Comparative Balance Sheet We Really Love Cash, Co. Income Statement December 31 For the Year ended December 31, 20 2020 2019 Sales revenue Cost of goods sold Gross profit Operating expenses Income from operations Interest expense Income before income taxes Income tax expense Net income Assets Cash $39,000 $20,000 Accounts Receivable 30,000 27,000 60,000 (29,000) $127,000 14,000 Inventory Equipment Accumulated depreciation-equipment Total Assets 20,000 78,000 (24,000) $108,000 Liabilities and Stockholders' Equity Accounts payable Income taxes payable Bonds payable $24,000 7,000 $15,000 8,000 27,000 18,000 51,000 $127,000 33,000 14,000 38,000 $108,000 Common stock Retained eamings Total Liabilities and Stockholders' Equity Additional data: 1. Dividends declared and paid were $19,000. 2. During the year equipment was sold for $6,500 cash. This equipment cost $18,000 originally and had a book value of $6,500 at the time of sale. 3. All depreciation expense, $16,500, is in the operating expenses. 4. All sales and purchases are on account. A) We Really Love Cash, Co. Statement of Cash Flows For the year ended December 31, 2020 B) Free Cash Flow: B) Free Cash Flow: A) Using the information below and the template on the next tab, prepare a statement of cash flows (indirect method). B) Also using the template on the next tab, compute free cash Bow. Grading In order to get full points for this project: Cells in orange on the template should be a VALUE. Cells in green on the template should be a FORMULA Cells in yellow on the template should be TEXT. The points available for each row requiring input are noted in Column G on the template in the next tab. We Really Love Cash, Co. Comparative Balance Sheer December 31 We Really Love Cash, Co. Income Statemet For the Year ended December 31, 2020 2020 2019 Sales reveniue $242,000 175,000 67,000 24,000 Assets Cost of goods sold Gross profit Operating expenses Income from operations Interest expense Income before income taxes Income tax expense Cash $39,000 $20,000 Accounts Receivable 30,000 14,000 20,000 27,000 60,000 Inventory Equipment Accumulated depreciation-equipment Total Assets 43,000 (29.000) $127,000 78,000 (24,000) $108,000 3,000 40,000 8,000 Net income $32,000 Liabilities and Stockholders' Equity Accounts payable Income taxes payable $24,000 7,000 $15,000 8,000 Bonds mas We Really Love Cash, Co. Comparative Balance Sheet We Really Love Cash, Co. Income Statement December 31 For the Year ended December 31, 20 2020 2019 Sales revenue Cost of goods sold Gross profit Operating expenses Income from operations Interest expense Income before income taxes Income tax expense Net income Assets Cash $39,000 $20,000 Accounts Receivable 30,000 27,000 60,000 (29,000) $127,000 14,000 Inventory Equipment Accumulated depreciation-equipment Total Assets 20,000 78,000 (24,000) $108,000 Liabilities and Stockholders' Equity Accounts payable Income taxes payable Bonds payable $24,000 7,000 $15,000 8,000 27,000 18,000 51,000 $127,000 33,000 14,000 38,000 $108,000 Common stock Retained eamings Total Liabilities and Stockholders' Equity Additional data: 1. Dividends declared and paid were $19,000. 2. During the year equipment was sold for $6,500 cash. This equipment cost $18,000 originally and had a book value of $6,500 at the time of sale. 3. All depreciation expense, $16,500, is in the operating expenses. 4. All sales and purchases are on account. A) We Really Love Cash, Co. Statement of Cash Flows For the year ended December 31, 2020 B) Free Cash Flow: B) Free Cash Flow:
Expert Answer:
Answer rating: 100% (QA)
X Microsoft Excel 25092020 A B F G H M N P Q 1 Solution 2 A Cash flow statement Workings Cashflow fr... View the full answer
Related Book For
Foundations of Finance The Logic and Practice of Financial Management
ISBN: 978-0132994873
8th edition
Authors: Arthur J. Keown, John D. Martin, J. William Petty
Posted Date:
Students also viewed these finance questions
-
Prepare a statement of cash flows for Abrahams Manufacturing Company for the year ended December 31, 2012. Interpret your results. Abrahams Manufacturing Company Income Statement for the Year Ended...
-
Prepare a statement of cash flows in accordance with IAS 7 using the information in Question 32.9. There was no investment income or interest paid during the year ended 31 March 20X3. J. White...
-
Using the direct method, prepare the statement of cash flows for the year ended June 30,2011. GECKO INC. Comparative Balance Sheets June 30,2011 and 2010 2011 2010 GECKO INC. Income Statement For...
-
When developing cost functions, which of the following statements is FALSE? A. Personal observations of costs and activities provide the best evidence of a plausible relationship between a cost and...
-
Suppose that f : R (0, ) satisfies f(x + y) = f(x)/(y). Modifying the outline in Exercise 3.3.8, show that if f is continuous at 0, then there is an a (0, ) such that f(x) = ax for all x R. (You...
-
Brent Corporation owns equipment that cost $80,000 and has a useful life of 8 years with no salvage value. On January 1, 2025, Brent leases the equipment to Havaci Inc. for one year for one rental...
-
Use a process simulator to determine the flow rate of saturated vapor benzene at \(176.2^{\circ} \mathrm{F}\) and \(1 \mathrm{~atm}\) to be mixed with \(100 \mathrm{lbmol} / \mathrm{hr}\) of liquid...
-
2. Cash basis $(3,400)Fantastic Catering completed the following selected transactions during May 2016: May 1 Prepaid rent for three months, $1,800. 5 Received and paid electricity bill, $200. 9...
-
Electric potential is measured at points A = ( - 2 , - 3 ) cm and B = ( 5 , - 4 ) cm . The measurements are VA = 9 V and VB = 3 6 V , respectively. The electric field points exclusively along the x -...
-
Ellipses Corp is a small business that operates in Herndon, VA. The company is located at10 Period Lane, Herndon, VA 20170. Its federal Employer Identification Number is 77-7777777, and its...
-
As a newly promoted portfolio manager, you are given responsibility for a $100 million portfolio consisting of two assets: a zero-coupon bond with maturity of 7 years, and a perpetuity, each...
-
Consider the hypotheses for the general linear model, which are of the form \[H_{0}: \mathbf{T} \beta=\mathbf{c}, \quad H_{1}: \mathbf{T} \beta eq \mathbf{c}\] where $\mathbf{T}$ is a $q \times p$...
-
Three single-phase two-winding transformers, each rated 25 M V A , 38.1 / 3.81 k V 25 M V A , 38.1 / 3.81 k V , are connected to form a three-phase Y Y bank with a balanced Y-connected resistive...
-
It's a sunny winter day. In your haste to get to an exam you accidentally lock Rover in the car. The interior dimensions are \(\left(L=2 \mathrm{~m} ight.\), Area \(=2.5 \mathrm{~m}^{2}\), Volume...
-
A shock wave generated due to an explosion travels at a speed of 1.5 km/s into still air at 100 kPa and 300 K. Determine the velocity of the air, static, and stagnation quantities (with respect to a...
-
Is it possible separate positive and negative charges unequally in two objects by a charge-separating method or by any mechanical equipment?
-
Breeze Manufacturing agrees to purchase goods from Hawkins Inc. In what situation could Breeze reject a shipment of goods from Hawkins under the perfect tender rule?
-
To help you become familiar with the accounting standards, this case is designed to take you to the FASBs Web site and have you access various publications. Access the FASBs Web site at...
-
Clearview Productions is a publicly held company whose common stock has recently been selling for $ 50.00 a share. The firm is expected to pay an annual cash dividend of $ 5.00 a share next year, and...
-
About how many years would it take for your investment to grow fourfold if it were invested at 16 percent compounded semiannually?
-
Describe the five- question approach to using financial ratios.
-
Hannah Gilpin is the controller of Blakemore Auto Glass, a division of Eastern Glass and Window. Her division has been under pressure to improve its divisional operating income. Currently, divisions...
-
Key success factors. Dalworth Construction Company provides construction services for major projects. Managers at the company believe that construction is a people-management business, and they list...
-
How do companies add value, and what are the dimensions of performance that customers are expecting of companies?
Study smarter with the SolutionInn App