10 11 DURA-CLEAR WINDOWS, LLC Proforma Income Statement 12 2020 2021 2022 2023 2024 2025 2026 2027 13 14 Sales (all on credit) 1,200,000 1,500,000 1,875,000 15 Cost of Goods Sold (800,000) (1,040,000) (1,105,000) 16 Gross Profit 400,000 460,000 770,000 17 Selling and Administrative Expense (304,900) (350,500) (443,700) 8 Operating profit (EBIT) 95,100 109,500 326,300 19 Interest expense (35,000) (45,000) (85,000) 20 Net Income before Taxes 60,100 64,500 241,300 21 Taxes (36,900) (49,200) (55,600) 22 Net Income 23 Shares 24 Earnings per Share 25 23,200 15,300 185,700 60,000 60,000 $0.39 $0.26 78,000 $2.38 26 27 28 Forecasted Balance Sheet (30 points) 29 30 31 32 DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet 2020 2021 2022 33 ASSETS 34 Cash 85 Marketable Securities 30,000 40,000 30,000 20,000 25,000 30,000 36 Accounts Receivable 170,000 259,000 360,000 37 Inventory 230,000 261,000 290,000 38 Total Current Assets: 450,000 585,000 710,000 39 Plant and equipment 650,000 765,000 1,390,000 40 Less: accumulated depreciation (65,000) (141,500) (280,500) 41 Net Plant and equipment 585,000 623,500 1,109,500 2 Total Assets 1,035,000 1,208,500 1,819,500 3 14 LIABILITIES & STOCKHOLDER'S EQUITY 15 Accounts Payable 46 Accrued Expenses 17 Total Current Liabilities 19 18 Long-term Liabilities 50 Common Stock ($1 par) 51 Capital paid in excess of par 52 Retained Earnings Total Liabilities 200,000 310,000 505,000 20,400 30,000 35,000 220,400 340,000 540,000 325,000 363,600 703,900 545,400 703,600 1,243,900 60,000 60,000 78,000 190,000 190,000 262,000 239,600 254,900 235,600 53 Total Stockholder's Equity 489,600 504,900 575,600 54 Total Liabilities & Stockholder's Equity 1,035.000 1,208,500 1.819.500 2023 2024 2025 2026 2027