you are a financial analyst reviewing a pet supply business, thr cat-opia cat littet company (NYSE ticker:Cat) while their financial statements are appendix for questions 11-13 ignore the income statement and assume CAT earned $12 mil in 2019 EBT (i.e taxable income)
17.) CAT operatint activities: Net income
18.) CAT operating activities: + depreciation
19.) CAT operating activities: +\- Change Accured Wages and Taxes
20.) CAT operating activities: +/- change in accounts payable
Pistol full ren Statement of Cash Flows 1/2 points each) Using the financial statements for CAT, which are located in the Appende prepare o Statement of Cash Flows for CAL. Remember the bottom Anenet change in cash & marketable securities in the some change in cash 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 sum to the right bottom line number 17 Operating Activities Net Income 18 Depreciation 19 +/-Change in crued Wages & Taxes 20 +1 - Change in Accounts Payable 21 47 Change in Accounts Receivable 22 + Channel Inventory 23 Cash Flows from Operating Activities 24 Investing Activities +/ Change in Gross Fed Assets 25 Cash Flows from Investing Activities 26 Financing Activities 27 28 20 +/-Change in Notes Payable +/ Change in Long Term Debt Dividends and Cash flows From Financing Activities 30 Net Change in Cash & Marketable Securities Statement of Canh Flows 7 points each thing the ancielements for which one located in the Arend prepare a statement of Cash Flow for ORE Notice that they were you out on the subtle Operating Activities income hp 3 4 3 7 UT 6 7 2 5 8 2 Q W R T Y 1 A s DU G K H J 3 N X V B N M alt . . Short Computations (4 points each General Instruction The financial statements for CAT and CE sre all in millions Any of your answers that are to be in millions such as FOF Statement, means that SL.250.000 is input 1.25 ond not 1.250,000 Any on wes thet are compute to two decimal places should be input as a whole number. 10.1SN Input as 10.15 not 0.1015 Any answers that are negative, then make sure to include the negative into the well-5 ta input in Canvas 5) You are a financial analyst reviewing a pet upoly business the cor Opla Cor Litter Company (NYSE Ticker CAT While their financial statements are in the Appendix, for questions 11-13 ignore the income Statement and enume CAT earned $12 milin 2019 EBT. Towable Incomel Answer questions 11-13 using this assumption 11 What would be the Tax Liability to what do they wt in taxes) in million to two decimal places? 12 What is the Effective Tax Rates to we decimas? 13 What is the Marginal Tax Rate 10 two decimas? You are a financial analyst reviewing manufacturer of electrie engines the Custom Proctone he common INSET CREJ While the financial statements are in the Agenda fororition 4-3 ore the income Statement and assume ORE earned 58 mil in 2019 ETIL. Tarble income Angustiant 14-16 thum hop 2 3 5 4 un 6 7 7 00 09 0 W m R T Y U 1 o P S D 77 G H C K Z C V B N M alr at 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 "X's, compute to two decimal places, should be input as a whole number fie. 10.158 is input as 10.15, not 0.1015) Any answers that are negative, then make sure to include the negative sign to the answer lies is input in Canvasos-5), You are a financial analyst reviewing a pet supply business, the Cat-Oplo Cot Litter Company (NYSE Ticker:CAT). While their financial statements are in the Appendix, for questions 11-13 lgnore the income Statement and assume CAT earned $12 mil in 2019 EBT (le: Taxable income). Answer questions 11-13 using this assumption 11 What would be the Tax Liability tie, 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)? You are a financial analyst reviewing o manufacturer of electric engines the Custom Reactionless Engine Company (NYSE Ticker CRE). While their financial statements are in the Append, for questions 14-16 ignore the income Statement and stume CRE camned $8 mil in 2019 EBTie. Taxable income). Answer questions 14-16 using this assumption R S D F A K C N 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 "ner change in cash & marketable securities the some change in cash 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 + Depreciation +/-Change in Accrued Wages & Taxes 20 + / Change in Accounts Payable +/- Change in Accounts Receivable +/- Change in Inventory Cash Flows from Operating Activities 18 19 21 22 23 24 Investing Activities 25 +/- Change in Gross Fixed 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 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 Cosh Flows for GRE Notice that this time the only answers you input are the sub-total Operating Activities Net Income 3 R U S D G H B. N M 1 . Short Computations ( 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 "', 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-is input in Canvas as-S). 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 (le. Taxable income). Answer questions 11-13 using this assumption. What would be the Tax Liability (i.e. what do they owe in taxes) (in Millions, to two decimal places)? 12 What is the Effective Tax Rate % (to two decimals)? What is the Marginal Tax Rate % (to two decimals)? 11 13 APPENDIX Corporate Tax Tables Pay This Amount on Base Income Plus This Percentage on Anything Over the Base 50 15% $7.500 25 $13,750 345 Taxable income 50-50,000 $50,001-75,000 575,001-S100,000 $100,001-335,000 $335,001-10,000,000 $10,000,001-15,000,000 $15,000,001-18,333,333 Over $18,333,333 39% $22,250 $113.900 35% $3,400,000 $5,150,000 $6,416,667 38% 355 Cat-Opia Cat Litter CO (CAT) Financial Statements Cat-Opia Cat Litter Company Income Statement Income Statement 2018 Sales $ 100 Less: Cost of Goods Sold 325 Gross Profit S75 Less: Other Operating Expenses SLS EBITDA (Earnings Before Interest, Taxes, Depreciation & Ame) $ 60 Less: Depreciation & Amortization $1151 EBIT (Earnings Before Interest & Taxes) $45 Less Interest $ 125 EBT(Earnings Before Taxes, Le Taxable income $ 20 Less: Taxes $ 16) Net Income $ 14 Less: Common Stock Dividends 5 (S) Addition to Retained Earnings Cat-Opla Cat Litter Company Balance Sheet Assets 2018 2017 Liabilities & Equity 2011 2017 Current Assets Cash $ 35 $ 25 Current Liabides Accrued Wages & Taxes S 6 $ 5 Accounts Receivable $ 11 S 10 Accounts Payable 5 5S Inventory $ 60 $ 50 Notes Payable $ 35 Total $ 106 $ 85 Total $ 145 12 Fixed Assets Plant & Equipment $ 75 $45 tong-Term Debt $ 90 $ Less: Depreciation $_(35) $ (20) Net Total Feed Assets $ 40 $ 25 Stockholder's Equity Common Stock 5 12 $ 12 Retained Earnings $ 30$ 21 Total Equity $ 425 33 Total Assets $ 146 5 110 Total Liabilities & Equity $ 146 $ 2 5 65 110 Pistol full ren Statement of Cash Flows 1/2 points each) Using the financial statements for CAT, which are located in the Appende prepare o Statement of Cash Flows for CAL. Remember the bottom Anenet change in cash & marketable securities in the some change in cash 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 sum to the right bottom line number 17 Operating Activities Net Income 18 Depreciation 19 +/-Change in crued Wages & Taxes 20 +1 - Change in Accounts Payable 21 47 Change in Accounts Receivable 22 + Channel Inventory 23 Cash Flows from Operating Activities 24 Investing Activities +/ Change in Gross Fed Assets 25 Cash Flows from Investing Activities 26 Financing Activities 27 28 20 +/-Change in Notes Payable +/ Change in Long Term Debt Dividends and Cash flows From Financing Activities 30 Net Change in Cash & Marketable Securities Statement of Canh Flows 7 points each thing the ancielements for which one located in the Arend prepare a statement of Cash Flow for ORE Notice that they were you out on the subtle Operating Activities income hp 3 4 3 7 UT 6 7 2 5 8 2 Q W R T Y 1 A s DU G K H J 3 N X V B N M alt . . Short Computations (4 points each General Instruction The financial statements for CAT and CE sre all in millions Any of your answers that are to be in millions such as FOF Statement, means that SL.250.000 is input 1.25 ond not 1.250,000 Any on wes thet are compute to two decimal places should be input as a whole number. 10.1SN Input as 10.15 not 0.1015 Any answers that are negative, then make sure to include the negative into the well-5 ta input in Canvas 5) You are a financial analyst reviewing a pet upoly business the cor Opla Cor Litter Company (NYSE Ticker CAT While their financial statements are in the Appendix, for questions 11-13 ignore the income Statement and enume CAT earned $12 milin 2019 EBT. Towable Incomel Answer questions 11-13 using this assumption 11 What would be the Tax Liability to what do they wt in taxes) in million to two decimal places? 12 What is the Effective Tax Rates to we decimas? 13 What is the Marginal Tax Rate 10 two decimas? You are a financial analyst reviewing manufacturer of electrie engines the Custom Proctone he common INSET CREJ While the financial statements are in the Agenda fororition 4-3 ore the income Statement and assume ORE earned 58 mil in 2019 ETIL. Tarble income Angustiant 14-16 thum hop 2 3 5 4 un 6 7 7 00 09 0 W m R T Y U 1 o P S D 77 G H C K Z C V B N M alr at 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 "X's, compute to two decimal places, should be input as a whole number fie. 10.158 is input as 10.15, not 0.1015) Any answers that are negative, then make sure to include the negative sign to the answer lies is input in Canvasos-5), You are a financial analyst reviewing a pet supply business, the Cat-Oplo Cot Litter Company (NYSE Ticker:CAT). While their financial statements are in the Appendix, for questions 11-13 lgnore the income Statement and assume CAT earned $12 mil in 2019 EBT (le: Taxable income). Answer questions 11-13 using this assumption 11 What would be the Tax Liability tie, 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)? You are a financial analyst reviewing o manufacturer of electric engines the Custom Reactionless Engine Company (NYSE Ticker CRE). While their financial statements are in the Append, for questions 14-16 ignore the income Statement and stume CRE camned $8 mil in 2019 EBTie. Taxable income). Answer questions 14-16 using this assumption R S D F A K C N 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 "ner change in cash & marketable securities the some change in cash 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 + Depreciation +/-Change in Accrued Wages & Taxes 20 + / Change in Accounts Payable +/- Change in Accounts Receivable +/- Change in Inventory Cash Flows from Operating Activities 18 19 21 22 23 24 Investing Activities 25 +/- Change in Gross Fixed 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 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 Cosh Flows for GRE Notice that this time the only answers you input are the sub-total Operating Activities Net Income 3 R U S D G H B. N M 1 . Short Computations ( 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 "', 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-is input in Canvas as-S). 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 (le. Taxable income). Answer questions 11-13 using this assumption. What would be the Tax Liability (i.e. what do they owe in taxes) (in Millions, to two decimal places)? 12 What is the Effective Tax Rate % (to two decimals)? What is the Marginal Tax Rate % (to two decimals)? 11 13 APPENDIX Corporate Tax Tables Pay This Amount on Base Income Plus This Percentage on Anything Over the Base 50 15% $7.500 25 $13,750 345 Taxable income 50-50,000 $50,001-75,000 575,001-S100,000 $100,001-335,000 $335,001-10,000,000 $10,000,001-15,000,000 $15,000,001-18,333,333 Over $18,333,333 39% $22,250 $113.900 35% $3,400,000 $5,150,000 $6,416,667 38% 355 Cat-Opia Cat Litter CO (CAT) Financial Statements Cat-Opia Cat Litter Company Income Statement Income Statement 2018 Sales $ 100 Less: Cost of Goods Sold 325 Gross Profit S75 Less: Other Operating Expenses SLS EBITDA (Earnings Before Interest, Taxes, Depreciation & Ame) $ 60 Less: Depreciation & Amortization $1151 EBIT (Earnings Before Interest & Taxes) $45 Less Interest $ 125 EBT(Earnings Before Taxes, Le Taxable income $ 20 Less: Taxes $ 16) Net Income $ 14 Less: Common Stock Dividends 5 (S) Addition to Retained Earnings Cat-Opla Cat Litter Company Balance Sheet Assets 2018 2017 Liabilities & Equity 2011 2017 Current Assets Cash $ 35 $ 25 Current Liabides Accrued Wages & Taxes S 6 $ 5 Accounts Receivable $ 11 S 10 Accounts Payable 5 5S Inventory $ 60 $ 50 Notes Payable $ 35 Total $ 106 $ 85 Total $ 145 12 Fixed Assets Plant & Equipment $ 75 $45 tong-Term Debt $ 90 $ Less: Depreciation $_(35) $ (20) Net Total Feed Assets $ 40 $ 25 Stockholder's Equity Common Stock 5 12 $ 12 Retained Earnings $ 30$ 21 Total Equity $ 425 33 Total Assets $ 146 5 110 Total Liabilities & Equity $ 146 $ 2 5 65 110
