CASAS ST CORTH C. XYZ. Plumbing - Income Statement 2021 5 S Reve CUS Gross Profi XYZ Plumbing - Balance Sheet 2019 10,000,000 4,500,000 5.500,000 Assumptions 2020 2022 2027 13,000,000 1918 kevave increases by 20% (bis) 3,745.000 7,215.000 35.3% Gros MANGIN Icrares by 0.3% 100.0% 45.0% 35.0% % 2019 2020 2019 2020 29.01 SG&A RA Depree & Amort Total Op Expense 2.000.000 100000 500.000 3,500,000 ASSETS Cash AR Tavenie Pre-paid expenses Total Current Aucta 2.470/000 19.9% SGSA w by 1.55 (basis) 1.000.000 77% RAD rase by 15X75 hasil 500.000 18% Ned in De Amore 3,970,000 30.5 1.500.000 1.000.000 2.000000 - 500.000 5,000,000 5,009.300 1.500.000 2,000,000 600,000 9,439.000 LIAULITIS Account Isable Noyable Current portion of LTD Accrued Liabilica Total Current Labs 1,100,000 1,500,000 1,000,000 700,000 5,000,000 2.000.000 1.500.000 1.000 1,52 10 6,000,000 Operating Profit s 2,000,000 20.0% s 3,245,000 25.09 Long Tera Debt 9.000.000 Building and lovements Equipment 10,000,000 15,000.00 5,000.00 20.000.000 15,000,000 3,000.000 20,000.00 Inrestens Teslincem 805 000 45 000 675.00 60/000 6.7% were rear are given 0% free given 9.5 65,000 100,000 9.000.000 Depreciation Net PPAX SO2000 19,500,000 Sockholders Equity Commen Anekater Din Capital Retained Hentas Total Stockholder's Equity 1.000.000 19,000,000 1,240,000 5 74 1000 9,000 2,419.00 12,419.700 s 500,000 Pre-Tex TAXIN Net Income 2,430,000 SLOBO 1,919,700 21.06 See 10,500,000 S 979660 $ Total AN 18.619,700 Tntal rinklius - Tasty 14.510,400 28,430,700 $ 0.10 $ EPS- Rasir EPS-Duted Average Stures Outstanding 10.000.000 10,000,000 10.000,00 Diluted Shares Duued Shares Information Officers and Directors Options Txerce Thiee 3,000,000 S100 Prihlice Warran Fxercise Price $2.50 Anck Trice sed for calling Dilated Shares $6.00 10,000,000 Diluted Shares Callebation Table Be Share OAD WAT Pubuc Total LU.000.000 Proceeds Officers and Directors Truhlic Shareholders Tribal Threeds Burbeek Price Total Westo purchased Dilated Shares PROBLEM SOLVING Problem 1 Do not type in the Blue or Brown boxes problem Do not type in the Blue or Brown boxes below Problem 2 Analysis Statement of Cash Flows Admin Key 2020 2020 Pts Admin Key Pts 1 Net Income 1 1 Current Ratio Quick Ratio Gross Margin Operating Margin Accounts Receivable tumover Inventory turnover Total asset tumover Debt to Equity Retum on Equity 1 2 Adjustments Depreciation and amortization Cash Provided by Operating Assets and Liabilities Accounts Receivable Inventories Pre-paid expenses Accounts payable Accrued liabilities Net Cash provided (used) by operating activities 2 2 2 2 Problem 3 Projections Admin Key 2021E Pts Cash Provided from Investing Activities Additions to property, plant and equipment Net Cash provided (used) by investing activities Revenue (Increase of 20% from 2020) CGS Gross Profit (Gross Margin increases by 0.5% from 2020) 1 1 1 1 Cash Provided from Financing Activities Additions to long term borrowing Addition to short term borrowing Net Cash provided (used) by financing activities SG&A (Improves by 1.5% from 2020) R&D (Increases by 15% in total dollars from 2020) Deprec & Amort (no change from 2020) Total Op. Expense 1 1 1 1 2 2 Operating Profit 1 Net Cash Flow Interest cost (given Interest income (given) $ $ 875,000 65,000 875,000 65,000 Total 20 1 Pre-Tax Tax (21% rate) Net Income 1 1 he YELLOW shaded boxes. EPS - Basic EPS - Diluted (See Information show for Equity Structure) 4 me is written in the first YELLOW shaded box in the "2" row CASAS ST CORTH C. XYZ. Plumbing - Income Statement 2021 5 S Reve CUS Gross Profi XYZ Plumbing - Balance Sheet 2019 10,000,000 4,500,000 5.500,000 Assumptions 2020 2022 2027 13,000,000 1918 kevave increases by 20% (bis) 3,745.000 7,215.000 35.3% Gros MANGIN Icrares by 0.3% 100.0% 45.0% 35.0% % 2019 2020 2019 2020 29.01 SG&A RA Depree & Amort Total Op Expense 2.000.000 100000 500.000 3,500,000 ASSETS Cash AR Tavenie Pre-paid expenses Total Current Aucta 2.470/000 19.9% SGSA w by 1.55 (basis) 1.000.000 77% RAD rase by 15X75 hasil 500.000 18% Ned in De Amore 3,970,000 30.5 1.500.000 1.000.000 2.000000 - 500.000 5,000,000 5,009.300 1.500.000 2,000,000 600,000 9,439.000 LIAULITIS Account Isable Noyable Current portion of LTD Accrued Liabilica Total Current Labs 1,100,000 1,500,000 1,000,000 700,000 5,000,000 2.000.000 1.500.000 1.000 1,52 10 6,000,000 Operating Profit s 2,000,000 20.0% s 3,245,000 25.09 Long Tera Debt 9.000.000 Building and lovements Equipment 10,000,000 15,000.00 5,000.00 20.000.000 15,000,000 3,000.000 20,000.00 Inrestens Teslincem 805 000 45 000 675.00 60/000 6.7% were rear are given 0% free given 9.5 65,000 100,000 9.000.000 Depreciation Net PPAX SO2000 19,500,000 Sockholders Equity Commen Anekater Din Capital Retained Hentas Total Stockholder's Equity 1.000.000 19,000,000 1,240,000 5 74 1000 9,000 2,419.00 12,419.700 s 500,000 Pre-Tex TAXIN Net Income 2,430,000 SLOBO 1,919,700 21.06 See 10,500,000 S 979660 $ Total AN 18.619,700 Tntal rinklius - Tasty 14.510,400 28,430,700 $ 0.10 $ EPS- Rasir EPS-Duted Average Stures Outstanding 10.000.000 10,000,000 10.000,00 Diluted Shares Duued Shares Information Officers and Directors Options Txerce Thiee 3,000,000 S100 Prihlice Warran Fxercise Price $2.50 Anck Trice sed for calling Dilated Shares $6.00 10,000,000 Diluted Shares Callebation Table Be Share OAD WAT Pubuc Total LU.000.000 Proceeds Officers and Directors Truhlic Shareholders Tribal Threeds Burbeek Price Total Westo purchased Dilated Shares PROBLEM SOLVING Problem 1 Do not type in the Blue or Brown boxes problem Do not type in the Blue or Brown boxes below Problem 2 Analysis Statement of Cash Flows Admin Key 2020 2020 Pts Admin Key Pts 1 Net Income 1 1 Current Ratio Quick Ratio Gross Margin Operating Margin Accounts Receivable tumover Inventory turnover Total asset tumover Debt to Equity Retum on Equity 1 2 Adjustments Depreciation and amortization Cash Provided by Operating Assets and Liabilities Accounts Receivable Inventories Pre-paid expenses Accounts payable Accrued liabilities Net Cash provided (used) by operating activities 2 2 2 2 Problem 3 Projections Admin Key 2021E Pts Cash Provided from Investing Activities Additions to property, plant and equipment Net Cash provided (used) by investing activities Revenue (Increase of 20% from 2020) CGS Gross Profit (Gross Margin increases by 0.5% from 2020) 1 1 1 1 Cash Provided from Financing Activities Additions to long term borrowing Addition to short term borrowing Net Cash provided (used) by financing activities SG&A (Improves by 1.5% from 2020) R&D (Increases by 15% in total dollars from 2020) Deprec & Amort (no change from 2020) Total Op. Expense 1 1 1 1 2 2 Operating Profit 1 Net Cash Flow Interest cost (given Interest income (given) $ $ 875,000 65,000 875,000 65,000 Total 20 1 Pre-Tax Tax (21% rate) Net Income 1 1 he YELLOW shaded boxes. EPS - Basic EPS - Diluted (See Information show for Equity Structure) 4 me is written in the first YELLOW shaded box in the "2" row