ZuoTi.Pro
Question

I need help calculating the statement of cash flows and common size income statement for the following:

Below are Proteks balance sheet and income statement for two years. The company sold no stock and paid no dividends. Numbers in the statements are in millions. (1) Calculate the difference in balance sheet accounts and (2) use the appropriate differences to construct the indirect method statement of cash flows in proper form for 20X2 in the area to the right. Video- Balance Sheets Income Statements t of Cash Flows 20X2 12/31/20X1 12/31/20X2 12/31/20X1 12/31/20X2 1. Show Difference Sales 1,578 $ 2,106 S631 S906 947 $ 30 (10.00) COGS Accounts Receivable Inventory CURRENT ASSETS 175 $ (176.00) Gross Margin $ (61.00) 295 $ (247.00) Expenses Marketing R&D 316 $ 158 $ 126 600 Fixed Assets 2,373 $ 1,565 $ 955 $ 1,250 $ (808.00) Administration 250.00 Total Expenses (558.00) Gross Accum. Depreciation Net (610] 885 EBIT 347 $ 315 TOTAL ASSETS (805.00) Interest S 63 S 95 EBT 284 $ 97s 187 $ 즈 145 LIABILITIES LIABILITIES Net Income Accounts Payable Accruals CURRENT LIABILITIES 56 (25.00) (5.00) (30.00) 71 630 $ 1,179 $ 101 Long-Term Debt Equity OTAL CAPITAL (630.00) (145.00) (775.00) TOTAL LIABILITIES AND EQUITY 1,250 $ (805.00) 2. Using the information above, develop common size income statements for 20xl and 20X2.

2. Using the information above, develop common size income statements for 20X1 and 20X2. 20x1 20X2 YouTube Video Help Sales COGS Gross Margin -43% 57% 60% Expenses Marketing R&D Administration 24% 10% 10% Total Expenses -42% EBIT Interest EBT Tax Net Income -49% 18% 6% 12% 15% 5% 10% 4% 7% 3. Continuing to use the information above, calculate the requested ratios for 20X1 and 20X2. 20X1 20X2 YouTube Video Help Current Ratio Quick Ratio ACP Inventory Turnover Fixed Asset Turnover Total Asset Turnover Debt Ratio Debt Equity TIE ROS ROA ROE Equity Multiplier https://youtu.be/PO07UrwuSnlk

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

32 Cash flow Statement For the period ending December 31, 20X2 (Indirect method) (In millions) Details $ (In millions) Amount $ 34. 35 36 37 38 39 40 41 42 43 Particulars Cash flows from operating Activities Net Income Add Adjustments to reconcile net income to net cash provided by operating activities Depreciation Changes in Operating Assets & Liabilities Increase in Accounts receivable Increase in Inventory Increase in Accounts Payable Increase in Accruals Net Cash provided by Operating Activities 145 250 (176) (61) 25 43 188 45 47 48 49 50 51 52 53 54 Cash Flows from Investing Activities Purchase of Equipment Net cash used by Investing Activities 808 (808) Cash Flows from Financing Activities Issue of common shares Issue of long term Debt Net cash provided by Financing Activities 630 630Net Increase in Cash & its equivalents Add Opening Balance of Caslh Closing Balance of Cash 10 30 40 57 59 Common Size Income Statement 61 62 63 In this statement each and every figure is divided by the amount of sales 12/31/20x1 12/31/20x2% Sales COGS Gross Margin Expenses Marketing R & D Adminstration Total Expenses EBIT Interest EBT Tax Net Income 1578 631 947 100% 2106 906 1200 100% 43% 57% 316 24% 10% 69 495 211 179 885 315 95 10% 71 72 73 74 75 76 126 600 347 63 38% 42% 15% 5% 10% 4% 4% 696 75 145 97 187 79

0 0
Add a comment
Know the answer?
Add Answer to:
I need help calculating the statement of cash flows and common size income statement for the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Hello, can you help with "generating a common size income statement for 2018" please! Income Statement...

    Hello, can you help with "generating a common size income statement for 2018" please! Income Statement 2018 (C$ in millions) Balance Sheet (C$ in millions) 2018 Cash 900.6 Short-term investments 96.1 Accounts receivable 5,790.5 Inventory 1,905.1 Total Current Assets 8,692.3 Net Fixed Assets 6,295.5 Total Assets 14,987.8 2017 662.1 289.1 5,785.7 1,773.3 6,043.0 14,553.2 Revenue COGS S&A Expense Depreciation EBIT Interest EBT Taxes Net Income 12,279.6 8,144.3 2,625.4 415.8 1,094.1 92.8 1,001.3 265.4 735.9 Accounts payable Notes payable Total Current...

  • Use the information from the Income Statement and Balance Sheet to construct the ratios and answer...

    Use the information from the Income Statement and Balance Sheet to construct the ratios and answer the questions below. Downloadable Financial statements HW 4 SXP 19.docxPreview the document hw3 ratios.jpg Barry Computers Income statement DEC 31, 2016 Sales 1,607,500 GOGS 1,392,500 Gross Profit 215,000 SG&A 145,000 EBIT 70,000 Interest Expenses 24,500 EBT 45,500 TX (40%) 18,200 NI 27,300 Barry Computers Balance Sheet DEC 31, 2016 Cash 77,500 Accounts Payable 129,000 Accounts receivables 336,000 Accruals 117,000 Inventory 241,500 Notes Payable 84,000...

  • Refer to the following financial statements for Crosby Corporation CROSBY CORPORATION Income Statement For the Year...

    Refer to the following financial statements for Crosby Corporation CROSBY CORPORATION Income Statement For the Year Ended December 31, 20X2 Sales Cost of goods sold Gross profit Selling and administrative expense Depreciation expense Operating income Interest expense $3,900,000 2,470,000 $1,430,000 618,000 290,000 $ 522,000 Earnings before taxes Taxes $ 434,900 127,000 S 307,900 Earnings after taxes Preferred stock dividends Earnings available to common stockholders Shares outstanding Earnings per share 297,900 150,000 Statement of Retained Earnings For the Year Ended December...

  • Kindly, correct me if I am wrong. Income statement (represents profitability in period of time) Sales...

    Kindly, correct me if I am wrong. Income statement (represents profitability in period of time) Sales (Revenue) Total sales Cost of goods sold (COGS) Gross profit SALES - COGS Depreciation (operational cost) (x) Selling & admin expenses (operational cost) Operating profit (net income) Gross profit - (X+Y) Interest expenses (interest) Earnings before Taxes Operating profit - interest Taxes (TAX) Earnings after Taxes EBT-TAX Ration Analysis Liquidity Ratio: ► Ability to meet short term immediate obligations ► Current Ratio (C.R) =...

  • Refer to the following financial statements for Crosby Corporation CROSBY CORPORATION Income Statement For the Year...

    Refer to the following financial statements for Crosby Corporation CROSBY CORPORATION Income Statement For the Year Ended December 31, 20X2 3,900,000 2,470,000 1,430,000 618,000 290,000 522,000 es Cost of goods sold Selling and administrative expense Depreciation expense Operating income Interest expense 434,900 127,000 307,900 10,000 297,900 Eamings before taxes Taxes Eamings after taxes Preferred stock dividends Earnings available to common stockholders Shares outstanding Earnings per share Statement of Retained Earnings For the Year Ended December 31, 20X2 Retained earnings, balance,...

  • The Statement of Cash Flows 215 Problem 14 sed balance sheets of the Spartan Inn are...

    The Statement of Cash Flows 215 Problem 14 sed balance sheets of the Spartan Inn are as follows: The condensed bala Spartan Inn Condensed Balance Sheets December 31, 20X1 and 20X2 20X1 Assets Current Assets: 20X2 Cash $ $ Marketable Securities Accounts Receivable Inventory Total Current Assets Investments Property and Equipment: 30,000 50,000 100,000 20,000 200,000 100,000 40,000 50,000 95,000 25,000 210,000 60,000 500,000 5,000,000 1,000,000 (1,600,000) 4,900,000 $5,200,000 500,000 6,000,000 1,100,000 (2,000,000) 5,600,000 $5,870,000 Land Building Equipment Accumulated Depreciation...

  • Hi, I need help with parts h-m. How do I get the values for h-m?? I...

    Hi, I need help with parts h-m. How do I get the values for h-m?? I have the formulas but Ihave no idea how to get those values. For ex: How do we calculate market price per share? earnings per share? Given what we have... Thank you! I would appreciate if you can break the formulas down even further so I know what numbers to use (h-m) 17-2 Financial Ratios The annual reports of Milano Italian clothing chain, included the...

  • Please show all work. 1. Statement of Cash Flows and Standardized Financial Statements a) Net income...

    Please show all work. 1. Statement of Cash Flows and Standardized Financial Statements a) Net income for your firm was $10,000 last year. The depreciation expense was $2,500; accounts receivable increased $1,250; accounts payable increased $800; and inventories increased by $2,000. Identify the sources and uses of cash • What was the total cash flow from operations for the period? Operating activities = Net Income + Depreciation + Source (inflow) - Use foutflow) b) i) Prepare the 2018 common-size Income...

  • Zandi's Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets Cash and cash equivalents Short-term investments...

    Zandi's Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets Cash and cash equivalents Short-term investments Accounts Receivable Inventories Total current assets Net fixed assets Total assets 2018 $21,000 3.759 52 500 84.000 $161,259 218.400 $379,659 2017 $20,000 3,240 48.000 56.000 $127,240 200.000 $327,240 2016 $21,053 $3,411 $50.526 $58,947 $133,937 200.000 $333,937 Liabilities and equity Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common stock Retained Earnings Total common equity Total liabilities and equity $33,600 12,600...

  • Refer to the following financial statements for Crosby Corporation: CROSBY CORPORATION Income Statement 4.5 For the...

    Refer to the following financial statements for Crosby Corporation: CROSBY CORPORATION Income Statement 4.5 For the Year Ended December 31, 20x2 $ 3,650,000 2,230,000 $1,420,000 654,000 273,000 $ 493,000 85,300 $ 407,700 186,000 $ 221,700 10,000 points Sales Cost of goods sold Gross profit Selling and administrative expense Depreciation expense Operating income Interest expense Earnings before taxes Skipped eBook Тахев Earnings after taxes Preferred stock dividends 211,700 Earnings available to common stockholders Shares outstanding Earningo per share 150,000 1.41 Hint...

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