Question

1 Approved Answer

Posted on Sep 16, 2024

E F G F K M N 0 P R s 4 5 Assumptions 2018. 2109 JINOX Revenue increuses by 20% (3 banis) 2020 6

image text in transcribed

E F G F K M N 0 P R s 4 5 Assumptions 2018. 2109 JINOX Revenue increuses by 20% (3 banis) 2020 6 $ 10X 2018 10,000,000 4.500.000 5,500,000 S 20119 12.500.000 5.562.500 6.937,500 7 2019 2018 2019 $ SOX S 555 Grw MARGIN increase by 1.0% 8 9 10 11 12 ADIVXE XYZ Plumbing - Balance Sheet ADIV.O 2018 ADIVA ASSEIS Cash 1,500,000 #DIVO: AR 1,000,000 NDIV.O: Inventory 2,000,000 ADIVI: Prepaid expenses SEXI,XI0 #DIV/0! Total Current Assis 5,000,000 20.0% 20.0% 2,000,000 1,000,000 SEXI 2000 3,500,000 2.375,000 1,000,000 500,000 3,875,000 19.0X SG&A improves by 1.0% /% basis) 8.0% R&D increases by 10% (sbasis) 40% No change Dave & Amort cost JION 1,500,000 1,500,000 2,300,000 600 000 5,900.000 LIABILITIES Accounts Payable Nu Payable Currcal portion of LTD Actual Liabilities Total Current Liabilities 1.800,000 1,500,000 1,000,000 TUO LOUI 5,000,000 2.000.000 1,500,000 1,000,000 1.520,00 13 6,020,000 2,000,000 20.0% 3,062,500 Long-Term Dcht 9.000.000 161.000,00 15 5 16 17 18 19 15.09XI,XIO 3,000,000 20,000,000 15,000,CIJO 5,1011.000 20,000,000 805,000 45,XIC 875,000 60,000 2.0% Interest costs are given 0.5% Therese inevme is ghor 31 ADIVO: Railding and improvements #DIV.O: Equipment 875,000 ADIVO: MUONIO ADIVO Depreciation ADIVI: Net PPAH ADIVAO ADIVI Total Assets 500.000 19.SCXI000 1,000,000 19,000,QUO Stockholder's Equity Comino Stack at Por Paid in Capital Retained Earnings Total Stockholled's Equity 111011011 9.900,00 SUO, 11011 10,500,000 20 $ 120,000 9.900,000 2,275.525 12,275,525 1,241,00 S WOX 10% See D22 2,747,500 471.975 1,775,525 35.0% 434,000 106.000 XX S 21 22 $ 23 24 5 25 24.500.000 24.900.000 Total Liabilities - Equity 24,500,000 28.295,525 0.08 S 0.18 10,000,000 10,000,000 10,000.00 29 30 31 32 93 34 3,000,000 S100 2,500.000 S 1.00 37 S 4.50 GE A 1 x fx Admin D Use the following information about XYZ Plumbing (FY=12/31), a public company with the most recent closing stock price of $4.50, to answer the following three problems: B F H J K L M NO R 8 T 4 G DN Anahe I've arrone banes De wins ar Breve PROBLEM SOLVING Prilikom Problem 2 7 Analysis 8 Student of Cash Flows 2019 umu KEY His I'm Net Income 2 Cumal Rain Quick Ratio Goss Magin Operating Mergin Accounts Receivable lumerer livestory tulover Toulose und Tail Faily Retum equity Total 10 11 12 13 14 18 16 17 18 19 20 21 14 Aljudima Lxpreciative and mortizztion Cash Provided by Operating Assets and Liabilitics Accounts Recei dole Insures Prepaid expens Accounts payable Aundilities Net Cash provided (used by operating stivities 1 1 1 1 1 min Key 2020E Fts Problema Projections Revetne ince of 20 w wy) CES Gooss Prodi Gross Margin INOM 05 on 29/9) 23 24 25 Cash Pravidlal from Investing Activiti Additions to property, plot and superior Net Culoridad (used by adivities SOLA www hy 1.0% from 2018) R&D (Incses by 10% tv roul dollars from 2019 Dique & Amal w w w 2018) Tool Fispara: Cash Provided from Financing Activities Additions to lose to win Akhire in the humming Net Cash provided used by the stivities 27 20 29 wan Oerdin Prolit Net Cu Flow 1 31 32 33 Interest cost elen Interest incert) 875,000 875.000 20,000 34 Total 20 Instructions: TA21%) Va rog S7 1. All answers go in the YELLOW shadedret 20 FIPS Rasis LP'S - Diluted (See Moriouster for Lowly Structure) 41 2. Make sure your name is written in the first YELLOW shaded lex in the "2" row 4 3. Do not resize, reshap or change any of the boxes on this page Total 16 E F G F K M N 0 P R s 4 5 Assumptions 2018. 2109 JINOX Revenue increuses by 20% (3 banis) 2020 6 $ 10X 2018 10,000,000 4.500.000 5,500,000 S 20119 12.500.000 5.562.500 6.937,500 7 2019 2018 2019 $ SOX S 555 Grw MARGIN increase by 1.0% 8 9 10 11 12 ADIVXE XYZ Plumbing - Balance Sheet ADIV.O 2018 ADIVA ASSEIS Cash 1,500,000 #DIVO: AR 1,000,000 NDIV.O: Inventory 2,000,000 ADIVI: Prepaid expenses SEXI,XI0 #DIV/0! Total Current Assis 5,000,000 20.0% 20.0% 2,000,000 1,000,000 SEXI 2000 3,500,000 2.375,000 1,000,000 500,000 3,875,000 19.0X SG&A improves by 1.0% /% basis) 8.0% R&D increases by 10% (sbasis) 40% No change Dave & Amort cost JION 1,500,000 1,500,000 2,300,000 600 000 5,900.000 LIABILITIES Accounts Payable Nu Payable Currcal portion of LTD Actual Liabilities Total Current Liabilities 1.800,000 1,500,000 1,000,000 TUO LOUI 5,000,000 2.000.000 1,500,000 1,000,000 1.520,00 13 6,020,000 2,000,000 20.0% 3,062,500 Long-Term Dcht 9.000.000 161.000,00 15 5 16 17 18 19 15.09XI,XIO 3,000,000 20,000,000 15,000,CIJO 5,1011.000 20,000,000 805,000 45,XIC 875,000 60,000 2.0% Interest costs are given 0.5% Therese inevme is ghor 31 ADIVO: Railding and improvements #DIV.O: Equipment 875,000 ADIVO: MUONIO ADIVO Depreciation ADIVI: Net PPAH ADIVAO ADIVI Total Assets 500.000 19.SCXI000 1,000,000 19,000,QUO Stockholder's Equity Comino Stack at Por Paid in Capital Retained Earnings Total Stockholled's Equity 111011011 9.900,00 SUO, 11011 10,500,000 20 $ 120,000 9.900,000 2,275.525 12,275,525 1,241,00 S WOX 10% See D22 2,747,500 471.975 1,775,525 35.0% 434,000 106.000 XX S 21 22 $ 23 24 5 25 24.500.000 24.900.000 Total Liabilities - Equity 24,500,000 28.295,525 0.08 S 0.18 10,000,000 10,000,000 10,000.00 29 30 31 32 93 34 3,000,000 S100 2,500.000 S 1.00 37 S 4.50 GE A 1 x fx Admin D Use the following information about XYZ Plumbing (FY=12/31), a public company with the most recent closing stock price of $4.50, to answer the following three problems: B F H J K L M NO R 8 T 4 G DN Anahe I've arrone banes De wins ar Breve PROBLEM SOLVING Prilikom Problem 2 7 Analysis 8 Student of Cash Flows 2019 umu KEY His I'm Net Income 2 Cumal Rain Quick Ratio Goss Magin Operating Mergin Accounts Receivable lumerer livestory tulover Toulose und Tail Faily Retum equity Total 10 11 12 13 14 18 16 17 18 19 20 21 14 Aljudima Lxpreciative and mortizztion Cash Provided by Operating Assets and Liabilitics Accounts Recei dole Insures Prepaid expens Accounts payable Aundilities Net Cash provided (used by operating stivities 1 1 1 1 1 min Key 2020E Fts Problema Projections Revetne ince of 20 w wy) CES Gooss Prodi Gross Margin INOM 05 on 29/9) 23 24 25 Cash Pravidlal from Investing Activiti Additions to property, plot and superior Net Culoridad (used by adivities SOLA www hy 1.0% from 2018) R&D (Incses by 10% tv roul dollars from 2019 Dique & Amal w w w 2018) Tool Fispara: Cash Provided from Financing Activities Additions to lose to win Akhire in the humming Net Cash provided used by the stivities 27 20 29 wan Oerdin Prolit Net Cu Flow 1 31 32 33 Interest cost elen Interest incert) 875,000 875.000 20,000 34 Total 20 Instructions: TA21%) Va rog S7 1. All answers go in the YELLOW shadedret 20 FIPS Rasis LP'S - Diluted (See Moriouster for Lowly Structure) 41 2. Make sure your name is written in the first YELLOW shaded lex in the "2" row 4 3. Do not resize, reshap or change any of the boxes on this page Total 16