Statement of Cash Flows (2 points each) Using the financial statements for CAT, which are located in the Appendix, prepare a statement of Cash Flows for CAT. Remember the bottom line "net change in cash & marketable securities is the same change in cosh as we observe on the balance sheet from previous year to current year. If your Net Change in Cash & Marketable Securities don't add up to that figure, then you have made an error somewhere! Check your work to make sure it all sums to the right bottom line number. 17 Operating Activities Net Income 18 + Depreciation 19 +/- Change in Accrued Wages & Taxes +1 - Change in Accounts Payable 21 +/-Change in Accounts Receivable 22 +/-Change in Inventory 23 Cash Flows from Operating Activities 20 24 Investing Activities 25 +/- Change in Grossed Assets Cash Flows from Investing Activities 26 Financing Activities 27 28 29 +/- Change in Notes Payable + Change in Long Term Debt -Dividends Paid Cash flows ws From Financing Activities 30 Net Change in Cash & Marketable Securities Statement of Cash Flows 7 points each) Using the financial statements for CRE, which are located in the Appendix, prepare a statement of Cash Flows for CRE Notice that the time the only onwers you input are the sub- hp 4 0 $ 4 96 5 & 7 3 0 00 9 W E R . TI Y o s D F G H J L K K C V B N M M alt alt Cat-Opla Cat Utter CoCAT Financial Statements Cut-Opla Cat Litter Company income statement Income Statement Less Cost of Goods Sold Gross Prof Less: Other Operating Expenses ENTDA aming bore interest. Ta Depreciation & A Less: Deprecation Amortation (Biries forestal estret tatjans de les tabletreom Les To Netice Les Common Stock on Asto 2011 $100 S1251 325 39 5 60 SIS) 5 45 325 5 30 5 10 5 15) Ames Gel Ople Carter Company Balance sheet 2013 2012 souty 2011 2017 $5.35 AdWap 565 5 5 11 5 10 Accounts Payable $ 5.5 2 Current Assets Accounts 5 30'S $100S 12 3 5 15 545 Loget OS 5 125 12 Nettet 30 des comma To 1 $50 Tout hp con 5 . 6 4 7 3 9 8 O E R. T W P Y C 1 F D H G S J K B V N N M M ctn alt 200 Short Computations (4 points each General Instructions: The financial statements for CAT and CRE are all in millions Any of your answers that are to be in millions", such as FCF Statements, means that $1,250,000 is input 125 and not 1,250,000 Any answers that are "%s, compute to two decimal places, should be input as a whole number 10,15% is input as 10.15, not 0.1015) Any answers that are negative, then make sure to include the negative sign to the answer te si input in Canvasos-5) You are a financial analyst reviewing a pet supply business, the Cat Oplocot Litter Company (NYSE Ticker:CAT) While their financial statements are in the Appendix for questions 11-13 ignore the income Statement and assume CAT earned $12 min 2019 EBT.e. Toxable income). Answer questions 11-13 using this assumption 11 What would be the Tax Liability to what do they owe in taxes in millions to two decimal places) 12 What is the Effective Tax Rate (to two decimals)? 13 What is the Marginal Tax Rate (to two decimals)? ch Ranatiualiasaminaramalan Naurantinanaintamani hp > # 3 $ 4 96 5 & 7 00 9 Statement of Cash Flows 1(2 points each) Using the financial statements for CAT, which are located in the Appendix, prepare e Statement of Cash Flows for CAT Remember: the bottom line "net change in cash & marketable securities is the same change in cash as we observe on the balance sheet from previous year to current year. If your Net Change in Cash & Marketoble Securities don't add up to that figure, then you have made an error somewhere Check your work to make sure it all sumns to the right bottom line number 17 Operating Activities Net Income 18 Depreciation +/-Change in Accrued Wages & Taxes */ Change in Accounts Payable 21 +/-Change in Accounts Receivable 22 +/- Change in inventory 23 Cash Flows from Operating Activities 19 20 24 Investing Activities 25 +/-Change in Gross Feed Assets Cash Flows from Investing Activities 26 Financing Activities 27 28 29 +/-Change in Notes Payable */ Change in Long Term Debt Dividends Paid Cash flown From Financing Activities 30 Net Change in Cash & Marketable Securities Statement of Cash Flow points each) Using the financial statements for CREwhich are located in the Appendix, arrastofement of Collows for CRE Notice that this time the only ones you input on the subfotos Operating Activities Netcome 7 2 M 4 Un N 9 00 W E 20 G T G Y U 1 0 A S D F H N C vl B N M alt at ctn Short Computations (4 points each) General Instructions: The financial statements for CAT and CRE are all in millions. Any of your answers that are to be "in millions", such as FCF Statements, means that $1,250,000 is input 1.25 and not 1,250,000 Any answers that are "%s, compute to two decimal places", should be input as a whole number(ie. 10.15% is input as 10.15, not 0.1015), Any answers that are negative, then make sure to include the negative sign to the answer (ie-5 is input in Canvas as-5). You are a financial analyst reviewing a pet supply business, the Cat-Opia Cat Litter Company (NYSE Ticker: CAT). While their financial statements are in the Appendix, for questions 11-13 ignore the Income Statement and assume CAT earned $12 mil in 2019 EBT (ie. Taxable income). Answer questions 11-13 using this assumption. 11 What would be the Tax Liability (ie. what do they owe in taxes) (in Millions, to two decimal places)? What is the Effective Tax Rate % (to two decimals)? 13 What is the Marginal Tax Rate % (to two decimals)? 12 APPENDIX Corporate Tax Tables Pay This Amount on Base Income Plus This Percentage on Anything Over the Base 15% SO 25% Taxable Income 50-50,000 $50,001-75,000 $75,001-$100,000 $100,001-335,000 $325,001-10,000,000 $10,000,001-15,000,000 $15,000,001-18,333,333 $7.500 $13,750 $22,250 34% 39% $113,900 34% $3,400,000 35% 38% $5,150,000 $6,416,667 Over $18.333,333 35% Cat-Opia Cat Litter Co (CAT) Financial Statements Cat-Opia Cat Litter Company Income Statement Income Statement Sales Less: Cost of Goods Sold Gross Profit Less: Other Operating Expenses EBITDA (Earnings Before Interest, Taxes, Depreciation & Ame) Less: Depreciation & Amortization EBIT (Earnings Before Interest & Taxes Less: Interest EBT(Earnings Before Taxes, le. Taxable Income) Less:Taxes Net Income Less: Common Stock Dividends Addition to Retained Earnings 2011 $ 100 $ 25 $ 75 3 (15) $ 60 5 (15) $ 45 $125) $ 20 $ (6) $ 14 $ (5) $ 9 Assets Current Assets Cash Accounts Receivable Inventory Total Cat-Opia Cat Litter Company Balance Sheet 2018 2017 Liabilities & leuity 2018 2017 S 35 S 25 Current Liabilities Accrued Wages & Taxes $ 6 $ 5 $ 11 $ 10 Accounts Payable $ 55 2 $ 60 S 50 Notes Payable $ 35 5 $ 1065 85 Total $ 145 12 $ 75 $45 Long Term Debt $ 90 $ 65 $(35) $ (20) $ 40 S 25 Stockholder's Equity Common Stock $ 12S 12 Retained Earnings $305 21 Total Equity $ 425 33 $ 146 $ 110 Total Liabilities & Equity $ 1465 110 Fixed Assets Plant & Equipment Less: Depreciation Net Total Fixed Assets Total Assets