DURA-CLEAR WINDOWS, LLC Proforma Income Statement Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes (36%) Net Income Shares Earnings per Share DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet ASSETS Cash Marketable Securities Accounts Receivable Inventory Total Current Assets: Plant and equipment Less: accumulated depreciation Net Plant and equipment Total Assets LIABILITIES & STOCKHOLDER'S EQUITY Accounts Payable Accrued Expenses Total Current Liabilities Long-term Liabilities Total Liabilities Common Stock ($1 par) Capital paid in excess of par Retained Earnings Total Stockholder's Equity Total Liabilities & Stockholder's Equity 2020 1,200,000 (800,000) 400,000, (304,900) 95,100 (35,000) 60,100 (36,900) 23,200 60,000 $0.39 2020 30,000 20,000 170,000 230,000 450,000 650,000 (65,000) 585,000 1.035.000 200,000 20,400 220,400 325,000 545,400 60,000 190,000 239,600 489,600 1.035.000 2021 1,500,000 (1,040,000) 460,000 (350,500) 109,500 (45,000) 64,500 (49,200) 15,300 60,000 $0.26 2021 40,000 25,000 259,000 261,000 585,000 765,000 (141,500) 623,500 1.208.500 310,000 30,000 340,000 363,600 703,600 60,000 190,000 254,900 504,900 1.208.500 2,022 1,875,000 4,000,000 (1,105,000) (1,957,333) 770,000 2,042,667 (443,700) (1,100,120) 326,300 942,547 (85,000) (70,000) 241,300 872,547 (55,600) (314,117) 185,700 558,430 78,000 104,000 $5.37 $2.38 2,023 2022 2023 30,000 60,000 30,000 40,000 360,000 600,000 290,000 693,778 710,000 1,393,778 1,390,000 2,140,000 (280,500) (494,500) 1,109,500 1,645,500 1.819.500 3.039.278 505,000 748,560 75,000 35,000 540,000 823,560 703,900 603,900 1,243,900 1,427,460 104,000 78,000 262,000 1,236,000 235,600 271,818 575,600 1,611,818 1.819.500 3.039.278 2,024 2,025 2024 5,000,000 6,000,000 7,000,000 8,000,000 (2,446,667) (2,936,000) (3,425,333) (3,914,667) 2,553,333 3,064,000 3,574,667 4,085,333 (1,271,650) (1,443,180) (1,614,710) (1,786,240) 1,281,683 1,620,820 1,959,957 2,299,093 (50,000) (40,000) (30,000) 1,570,820 1,919,957 2,269,093 (691,184) (439,806) (565,495) (816,874) 781,877 1,005,325 1,228,772 1,452,220 104,000 104,000 $9.67 (60,000) 1,221,683 104,000 104,000 $7.52 $11.82 $13.96 2,026 2,027 2025 2026 2027 60,000 60,000 60,000 60,000 40,000 40,000 40,000 40,000 800,000 1,000,000 1,100,000 1,200,000 867,222 1,040,667 1,214,111 1,387,556 1,767,222 2,140,667 2,414,111 2,687,556 2,140,000 2,140,000 2,140,000 2,140,000 (708,500) (922,500) (1,136,500) (1,350,500) 1,431,500 789,500 1,217,500 1,003,500 3.198.722 3.358.167 3.417.611 3.477.056 949,222 1,149,884 1,296,458 1,443,031 95,000 115,000 130,000 145,000 1,044,222 1,264,884 1,426,458 1,588,031 503,900 403,900 303,900 203,900 1,548,122 1,668,784 1,730,358 1,791,931 104,000 104,000 104,000 104,000 1,236,000 1,236,000 1,236,000 310,600 349,383 1,236,000 347,254 345,124 1,650,600 1,689,383 1,687,254 1,685,124 3.198.722 3.358.167 3.417.611 3.477.056

1 DOL \& DFL. (5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) a. Is your DOL increasing or decreasing? b. What about your OFL? c. Do your fieures for DOL reflect a high amount of operatine leverage or a conservative amount? d. Do your figures for DFL reflect a high amount of financial leverage or a conservative amount? 2 Breakeven (S points: 1 pt for grommar/speiling, 4 pts for thought-out, correct onswers) a. Does vour breakeven point (in terms of sales dolltars) increase, decrease, or both? b. What is causing this? \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & 2020 & 2021 & 2,022 & 2,023 & 2,024 & 2,025 & 2,026 & 2,027 \\ \hline & \multirow{2}{*}{1,200,0001,000,000} & 1,500,000 & \multirow{2}{*}{1,875,0001,105,000} & \multirow{2}{*}{4,000,0001.957,333} & \multirow{2}{*}{5,000,00012.446,667} & \multirow{2}{*}{6,000,00012,935,000} & \multirow{2}{*}{7,000,0003,425,3393} & \multirow{2}{*}{8,000,000(3,914,657} \\ \hline Cont of Goods Sold & & \multirow{2}{*}{460,000[1,040,000} & & & & & & \\ \hline \multirow{2}{*}{GrossProfitSelingandAdminlstrativeExpense} & \multirow{2}{*}{400,000(304,900)} & & 770,000 & 2,042,657 & \multirow{2}{*}{2,553,333(1,271,650)} & 3,064,000 & 3,574,667 & \\ \hline & & (350,500) & (443,700) & 11.100,120 & & 11,445,1802 & {[1,514,710} & (1,286,240) \\ \hline \multirow{2}{*}{Operatingprofit(EBIT)interestexpense} & 95,100 & 109,500 & 326,300 & 942,547 & 1,281,683 & 1,620,820 & 1,959,957 & \multirow{2}{*}{2,299,093[30,000)} \\ \hline & 35,000 & (45,000) & 35,000 & (70,000) & (60,000] & (50,000) & 140,000 & \\ \hline \multirow{2}{*}{NetincomebeforeTaxesTaxes(36S)} & 60,100 & 64,500 & 241,300 & 872,547 & 1,221,683 & 1,570,820 & 1,919,957 & 2,269,0931816.874 \\ \hline & 23,200(36,900) & 15.300(49.200) & (55,600) & (314,117 & (439.805 & 1005325(365,495) & 1228772(691,184 & \multirow{2}{*}{1,452,220} \\ \hline NetIncomeshares & 23,20060,000 & 15,30069,000 & 165,70078,000 & 558,430 & 781,877 & 1,005,325104,000 & 1,228,772104,000 & \\ \hline Earninguper Share & 60,0005039 & 60,00050.26 & 78,0005238 & 104,00055,37 & 104,0005752 & 104,00059.67 & 511.82 & 104,000513,99 \\ \hline \multicolumn{9}{|l|}{ DURA-CLEAR WINDOWS, LLC } \\ \hline Proforma Balance Sheet & & & & & & & & \\ \hline Assets & & & 2027 & 2023 & 2024 & 2025 & 2026 & 2027 \\ \hline Cash & 30,000 & 40,000 & 30,000 & 60,000 & 60,000 & 60,000 & 60,000 & 60,000 \\ \hline Marketabie securities & 20,000 & 25,050 & $0,000 & 40,000 & 40,000 & 40,000 & 40,000 & 40,000 \\ \hline ActountsReceivableinventory & 170,000 & 259,000 & 360,000 & 600,000 & 100,000 & 1,000,000 & 1,100,000 & 1,200,000 \\ \hline invemeryToulCurrent & 450,000210,000 & 261,000 & 290.000 & & 216722857,222 & 1.060,657 & 1,214,111 & 1.307 .556 \\ \hline ToulCurrentAssets.piantandequipment & 450,000650,000 & 585,000 & 710,000 & 1,393,77B & 1,767,222 & 2,140,667 & 2,414,111 & 2,607,556 \\ \hline Lew: accumulated depreciation & 650,00065,000 & 765,000124.500 & 1,390,000250,500 & 2,240,000(494,300) & 2,140,000(7011,500 & 2,140,000922,500 & 2,140,0001,136,500 & 2.140,0601,3.150,500 \\ \hline Net Plant and equipment & 585,000 & 623,500 & 1.109500 & 1,645,500 & 1,431,500 & 1.217 .500 & 1,003.500 & 289.50010.500 \\ \hline Totni Anets & 1.025.900 & 201500 & 1.42002 & 2019.278 & 1493.722 & 13816162 & & 2427056 \\ \hline & & & & & & & & \\ \hline AccountsPryableAccruedExpenses & 200,00020,400 & 310,0000,000 & 505,00035,000 & 748,56075,000 & 949,22295,000 & 1,149,854115,000 & 1,296,454190,000 & 1,445,031145,000 \\ \hline AccruedExpensesTotalCurrentLinbirties & 220,40020,400 & 340,000 & 540,00035,000 & $23,560 & 1,044,222 & 2,264,894 & 2,426.458 & 1,538,091145,000 \\ \hline fonc-term uabilibe: & 325,000 & 363,600 & 703909 & 601900 & 503900 & 403.900 & 308,200 & 1,536091202909 \\ \hline Totar Liboilities & 5,45,400 & 703,600 & 1,243,900 & 1,427,450 & 1,548,122 & 2,568,764 & 1,730,35a & 1,792931 \\ \hline Common Stock(st par) & 50,000 & 50,000 & 78,000 & 104,000 & 104,000 & 104,000 & 204,060 & 104,000 \\ \hline Copital poid in eacest of par & 190,000 & 190,000 & 262,000 & 1,236,000 & 1,235,000 & 1,236,000 & 1,235,000 & 1236000 \\ \hline Fetained Eamings: & 4239,600 & 254,900 & 235,600 & 273271,818 & 310,600 & 149.993 & 37.254 & \\ \hline Total 5tockholder's Equity & 805000489600 & 504,900 & 575,600 & 1611.818 & 1,650,600 & 1659,383 & 1,587,254 & 1.5est124 \\ \hline Lotal Uabilities a Stocanolsers Equity & 20350001 & 1208500 & 1.49800 & 2] 1009274 & 1198722 & 3asange & 342681L & Landest \\ \hline \end{tabular} Financial Analysis (5 points: 1 pt for grammar/spelling, 4ts for thought-out, correct answers) a. Based upon your Payoack, IRR, and NPV results, is this a wise investment for the shark? b. Explain what your results mean. 4 Cash flow (5 points: 1 pr for grummar/spelling, 4s for thought-ouc, correct answers) a. Looking at your FCF retults, do you think you should go to the Sharks for money? b. If so, why? if not, why not? \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & 2020 & 2021 & 2,022 & 2,023 & 2,024 & 2,025 & 2,026 & 2,027 \\ \hline & \multirow{2}{*}{1,200,0001,000,000} & 1,500,000 & \multirow{2}{*}{1,875,0001,105,000} & \multirow{2}{*}{4,000,0001.957,333} & \multirow{2}{*}{5,000,00012.446,667} & \multirow{2}{*}{6,000,00012,935,000} & \multirow{2}{*}{7,000,0003,425,3393} & \multirow{2}{*}{8,000,000(3,914,657} \\ \hline Cont of Goods Sold & & \multirow{2}{*}{460,000[1,040,000} & & & & & & \\ \hline \multirow{2}{*}{GrossProfitSelingandAdminlstrativeExpense} & \multirow{2}{*}{400,000(304,900)} & & 770,000 & 2,042,657 & \multirow{2}{*}{2,553,333(1,271,650)} & 3,064,000 & 3,574,667 & \\ \hline & & (350,500) & (443,700) & 11.100,120 & & 11,445,1802 & {[1,514,710} & (1,286,240) \\ \hline \multirow{2}{*}{Operatingprofit(EBIT)interestexpense} & 95,100 & 109,500 & 326,300 & 942,547 & 1,281,683 & 1,620,820 & 1,959,957 & \multirow{2}{*}{2,299,093[30,000)} \\ \hline & 35,000 & (45,000) & 35,000 & (70,000) & (60,000] & (50,000) & 140,000 & \\ \hline \multirow{2}{*}{NetincomebeforeTaxesTaxes(36S)} & 60,100 & 64,500 & 241,300 & 872,547 & 1,221,683 & 1,570,820 & 1,919,957 & 2,269,0931816.874 \\ \hline & 23,200(36,900) & 15.300(49.200) & (55,600) & (314,117 & (439.805 & 1005325(365,495) & 1228772(691,184 & \multirow{2}{*}{1,452,220} \\ \hline NetIncomeshares & 23,20060,000 & 15,30069,000 & 165,70078,000 & 558,430 & 781,877 & 1,005,325104,000 & 1,228,772104,000 & \\ \hline Earninguper Share & 60,0005039 & 60,00050.26 & 78,0005238 & 104,00055,37 & 104,0005752 & 104,00059.67 & 511.82 & 104,000513,99 \\ \hline \multicolumn{9}{|l|}{ DURA-CLEAR WINDOWS, LLC } \\ \hline Proforma Balance Sheet & & & & & & & & \\ \hline Assets & & & 2027 & 2023 & 2024 & 2025 & 2026 & 2027 \\ \hline Cash & 30,000 & 40,000 & 30,000 & 60,000 & 60,000 & 60,000 & 60,000 & 60,000 \\ \hline Marketabie securities & 20,000 & 25,050 & $0,000 & 40,000 & 40,000 & 40,000 & 40,000 & 40,000 \\ \hline ActountsReceivableinventory & 170,000 & 259,000 & 360,000 & 600,000 & 100,000 & 1,000,000 & 1,100,000 & 1,200,000 \\ \hline invemeryToulCurrent & 450,000210,000 & 261,000 & 290.000 & & 216722857,222 & 1.060,657 & 1,214,111 & 1.307 .556 \\ \hline ToulCurrentAssets.piantandequipment & 450,000650,000 & 585,000 & 710,000 & 1,393,77B & 1,767,222 & 2,140,667 & 2,414,111 & 2,607,556 \\ \hline Lew: accumulated depreciation & 650,00065,000 & 765,000124.500 & 1,390,000250,500 & 2,240,000(494,300) & 2,140,000(7011,500 & 2,140,000922,500 & 2,140,0001,136,500 & 2.140,0601,3.150,500 \\ \hline Net Plant and equipment & 585,000 & 623,500 & 1.109500 & 1,645,500 & 1,431,500 & 1.217 .500 & 1,003.500 & 289.50010.500 \\ \hline Totni Anets & 1.025.900 & 201500 & 1.42002 & 2019.278 & 1493.722 & 13816162 & & 2427056 \\ \hline & & & & & & & & \\ \hline AccountsPryableAccruedExpenses & 200,00020,400 & 310,0000,000 & 505,00035,000 & 748,56075,000 & 949,22295,000 & 1,149,854115,000 & 1,296,454190,000 & 1,445,031145,000 \\ \hline AccruedExpensesTotalCurrentLinbirties & 220,40020,400 & 340,000 & 540,00035,000 & $23,560 & 1,044,222 & 2,264,894 & 2,426.458 & 1,538,091145,000 \\ \hline fonc-term uabilibe: & 325,000 & 363,600 & 703909 & 601900 & 503900 & 403.900 & 308,200 & 1,536091202909 \\ \hline Totar Liboilities & 5,45,400 & 703,600 & 1,243,900 & 1,427,450 & 1,548,122 & 2,568,764 & 1,730,35a & 1,792931 \\ \hline Common Stock(st par) & 50,000 & 50,000 & 78,000 & 104,000 & 104,000 & 104,000 & 204,060 & 104,000 \\ \hline Copital poid in eacest of par & 190,000 & 190,000 & 262,000 & 1,236,000 & 1,235,000 & 1,236,000 & 1,235,000 & 1236000 \\ \hline Fetained Eamings: & 4239,600 & 254,900 & 235,600 & 273271,818 & 310,600 & 149.993 & 37.254 & \\ \hline Total 5tockholder's Equity & 805000489600 & 504,900 & 575,600 & 1611.818 & 1,650,600 & 1659,383 & 1,587,254 & 1.5est124 \\ \hline Lotal Uabilities a Stocanolsers Equity & 20350001 & 1208500 & 1.49800 & 2] 1009274 & 1198722 & 3asange & 342681L & Landest \\ \hline \end{tabular} ONE: Qumery of winsows sold io: Sellint price per window (P) Total Fued Cotsipes Totaivaribtie Cous (Tric) volviton: \begin{tabular}{|c|c|c|c|c|} \hline 2003 & 2024 & 2025 & 2026 & 2027 \\ \hline 3000 & 5000 & 6000 & 7000 & 1000 \\ \hline 51,000 & 31000 & 3500 & 31000 & 38.000 \\ \hline 3400 & & 5851 & sin: & 1825 \\ \hline 5500050 & 5500,000 & 5500,000 & 5500000 & 5500000 \\ \hline 52,000,000 & 58000000 & 53200000 & 40800000 & 65000000 \\ \hline \end{tabular} GMTH NOTE. Coin flowition operabena [fotal for coment] sotveron: Coh thest frem Operstish 2on 2on aws. 2021 (4 pts) Compuse the following for the forecasted years. (Total company) (HINT: See Week 1 Chopter reodings for FCF formulo) GIVEN: NOTE 1: Dividends are zero every vear. NOTE 2$750,000 of the $1M invested by the shark was spent on Capital Expenditures in 2023. No other capital expecitures occurred. 1 DOL \& DFL. (5 points: 1 pt for grammar/spelling, 4 pts for thought-out, correct answers) a. Is your DOL increasing or decreasing? b. What about your OFL? c. Do your fieures for DOL reflect a high amount of operatine leverage or a conservative amount? d. Do your figures for DFL reflect a high amount of financial leverage or a conservative amount? 2 Breakeven (S points: 1 pt for grommar/speiling, 4 pts for thought-out, correct onswers) a. Does vour breakeven point (in terms of sales dolltars) increase, decrease, or both? b. What is causing this? \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & 2020 & 2021 & 2,022 & 2,023 & 2,024 & 2,025 & 2,026 & 2,027 \\ \hline & \multirow{2}{*}{1,200,0001,000,000} & 1,500,000 & \multirow{2}{*}{1,875,0001,105,000} & \multirow{2}{*}{4,000,0001.957,333} & \multirow{2}{*}{5,000,00012.446,667} & \multirow{2}{*}{6,000,00012,935,000} & \multirow{2}{*}{7,000,0003,425,3393} & \multirow{2}{*}{8,000,000(3,914,657} \\ \hline Cont of Goods Sold & & \multirow{2}{*}{460,000[1,040,000} & & & & & & \\ \hline \multirow{2}{*}{GrossProfitSelingandAdminlstrativeExpense} & \multirow{2}{*}{400,000(304,900)} & & 770,000 & 2,042,657 & \multirow{2}{*}{2,553,333(1,271,650)} & 3,064,000 & 3,574,667 & \\ \hline & & (350,500) & (443,700) & 11.100,120 & & 11,445,1802 & {[1,514,710} & (1,286,240) \\ \hline \multirow{2}{*}{Operatingprofit(EBIT)interestexpense} & 95,100 & 109,500 & 326,300 & 942,547 & 1,281,683 & 1,620,820 & 1,959,957 & \multirow{2}{*}{2,299,093[30,000)} \\ \hline & 35,000 & (45,000) & 35,000 & (70,000) & (60,000] & (50,000) & 140,000 & \\ \hline \multirow{2}{*}{NetincomebeforeTaxesTaxes(36S)} & 60,100 & 64,500 & 241,300 & 872,547 & 1,221,683 & 1,570,820 & 1,919,957 & 2,269,0931816.874 \\ \hline & 23,200(36,900) & 15.300(49.200) & (55,600) & (314,117 & (439.805 & 1005325(365,495) & 1228772(691,184 & \multirow{2}{*}{1,452,220} \\ \hline NetIncomeshares & 23,20060,000 & 15,30069,000 & 165,70078,000 & 558,430 & 781,877 & 1,005,325104,000 & 1,228,772104,000 & \\ \hline Earninguper Share & 60,0005039 & 60,00050.26 & 78,0005238 & 104,00055,37 & 104,0005752 & 104,00059.67 & 511.82 & 104,000513,99 \\ \hline \multicolumn{9}{|l|}{ DURA-CLEAR WINDOWS, LLC } \\ \hline Proforma Balance Sheet & & & & & & & & \\ \hline Assets & & & 2027 & 2023 & 2024 & 2025 & 2026 & 2027 \\ \hline Cash & 30,000 & 40,000 & 30,000 & 60,000 & 60,000 & 60,000 & 60,000 & 60,000 \\ \hline Marketabie securities & 20,000 & 25,050 & $0,000 & 40,000 & 40,000 & 40,000 & 40,000 & 40,000 \\ \hline ActountsReceivableinventory & 170,000 & 259,000 & 360,000 & 600,000 & 100,000 & 1,000,000 & 1,100,000 & 1,200,000 \\ \hline invemeryToulCurrent & 450,000210,000 & 261,000 & 290.000 & & 216722857,222 & 1.060,657 & 1,214,111 & 1.307 .556 \\ \hline ToulCurrentAssets.piantandequipment & 450,000650,000 & 585,000 & 710,000 & 1,393,77B & 1,767,222 & 2,140,667 & 2,414,111 & 2,607,556 \\ \hline Lew: accumulated depreciation & 650,00065,000 & 765,000124.500 & 1,390,000250,500 & 2,240,000(494,300) & 2,140,000(7011,500 & 2,140,000922,500 & 2,140,0001,136,500 & 2.140,0601,3.150,500 \\ \hline Net Plant and equipment & 585,000 & 623,500 & 1.109500 & 1,645,500 & 1,431,500 & 1.217 .500 & 1,003.500 & 289.50010.500 \\ \hline Totni Anets & 1.025.900 & 201500 & 1.42002 & 2019.278 & 1493.722 & 13816162 & & 2427056 \\ \hline & & & & & & & & \\ \hline AccountsPryableAccruedExpenses & 200,00020,400 & 310,0000,000 & 505,00035,000 & 748,56075,000 & 949,22295,000 & 1,149,854115,000 & 1,296,454190,000 & 1,445,031145,000 \\ \hline AccruedExpensesTotalCurrentLinbirties & 220,40020,400 & 340,000 & 540,00035,000 & $23,560 & 1,044,222 & 2,264,894 & 2,426.458 & 1,538,091145,000 \\ \hline fonc-term uabilibe: & 325,000 & 363,600 & 703909 & 601900 & 503900 & 403.900 & 308,200 & 1,536091202909 \\ \hline Totar Liboilities & 5,45,400 & 703,600 & 1,243,900 & 1,427,450 & 1,548,122 & 2,568,764 & 1,730,35a & 1,792931 \\ \hline Common Stock(st par) & 50,000 & 50,000 & 78,000 & 104,000 & 104,000 & 104,000 & 204,060 & 104,000 \\ \hline Copital poid in eacest of par & 190,000 & 190,000 & 262,000 & 1,236,000 & 1,235,000 & 1,236,000 & 1,235,000 & 1236000 \\ \hline Fetained Eamings: & 4239,600 & 254,900 & 235,600 & 273271,818 & 310,600 & 149.993 & 37.254 & \\ \hline Total 5tockholder's Equity & 805000489600 & 504,900 & 575,600 & 1611.818 & 1,650,600 & 1659,383 & 1,587,254 & 1.5est124 \\ \hline Lotal Uabilities a Stocanolsers Equity & 20350001 & 1208500 & 1.49800 & 2] 1009274 & 1198722 & 3asange & 342681L & Landest \\ \hline \end{tabular} Financial Analysis (5 points: 1 pt for grammar/spelling, 4ts for thought-out, correct answers) a. Based upon your Payoack, IRR, and NPV results, is this a wise investment for the shark? b. Explain what your results mean. 4 Cash flow (5 points: 1 pr for grummar/spelling, 4s for thought-ouc, correct answers) a. Looking at your FCF retults, do you think you should go to the Sharks for money? b. If so, why? if not, why not? \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & 2020 & 2021 & 2,022 & 2,023 & 2,024 & 2,025 & 2,026 & 2,027 \\ \hline & \multirow{2}{*}{1,200,0001,000,000} & 1,500,000 & \multirow{2}{*}{1,875,0001,105,000} & \multirow{2}{*}{4,000,0001.957,333} & \multirow{2}{*}{5,000,00012.446,667} & \multirow{2}{*}{6,000,00012,935,000} & \multirow{2}{*}{7,000,0003,425,3393} & \multirow{2}{*}{8,000,000(3,914,657} \\ \hline Cont of Goods Sold & & \multirow{2}{*}{460,000[1,040,000} & & & & & & \\ \hline \multirow{2}{*}{GrossProfitSelingandAdminlstrativeExpense} & \multirow{2}{*}{400,000(304,900)} & & 770,000 & 2,042,657 & \multirow{2}{*}{2,553,333(1,271,650)} & 3,064,000 & 3,574,667 & \\ \hline & & (350,500) & (443,700) & 11.100,120 & & 11,445,1802 & {[1,514,710} & (1,286,240) \\ \hline \multirow{2}{*}{Operatingprofit(EBIT)interestexpense} & 95,100 & 109,500 & 326,300 & 942,547 & 1,281,683 & 1,620,820 & 1,959,957 & \multirow{2}{*}{2,299,093[30,000)} \\ \hline & 35,000 & (45,000) & 35,000 & (70,000) & (60,000] & (50,000) & 140,000 & \\ \hline \multirow{2}{*}{NetincomebeforeTaxesTaxes(36S)} & 60,100 & 64,500 & 241,300 & 872,547 & 1,221,683 & 1,570,820 & 1,919,957 & 2,269,0931816.874 \\ \hline & 23,200(36,900) & 15.300(49.200) & (55,600) & (314,117 & (439.805 & 1005325(365,495) & 1228772(691,184 & \multirow{2}{*}{1,452,220} \\ \hline NetIncomeshares & 23,20060,000 & 15,30069,000 & 165,70078,000 & 558,430 & 781,877 & 1,005,325104,000 & 1,228,772104,000 & \\ \hline Earninguper Share & 60,0005039 & 60,00050.26 & 78,0005238 & 104,00055,37 & 104,0005752 & 104,00059.67 & 511.82 & 104,000513,99 \\ \hline \multicolumn{9}{|l|}{ DURA-CLEAR WINDOWS, LLC } \\ \hline Proforma Balance Sheet & & & & & & & & \\ \hline Assets & & & 2027 & 2023 & 2024 & 2025 & 2026 & 2027 \\ \hline Cash & 30,000 & 40,000 & 30,000 & 60,000 & 60,000 & 60,000 & 60,000 & 60,000 \\ \hline Marketabie securities & 20,000 & 25,050 & $0,000 & 40,000 & 40,000 & 40,000 & 40,000 & 40,000 \\ \hline ActountsReceivableinventory & 170,000 & 259,000 & 360,000 & 600,000 & 100,000 & 1,000,000 & 1,100,000 & 1,200,000 \\ \hline invemeryToulCurrent & 450,000210,000 & 261,000 & 290.000 & & 216722857,222 & 1.060,657 & 1,214,111 & 1.307 .556 \\ \hline ToulCurrentAssets.piantandequipment & 450,000650,000 & 585,000 & 710,000 & 1,393,77B & 1,767,222 & 2,140,667 & 2,414,111 & 2,607,556 \\ \hline Lew: accumulated depreciation & 650,00065,000 & 765,000124.500 & 1,390,000250,500 & 2,240,000(494,300) & 2,140,000(7011,500 & 2,140,000922,500 & 2,140,0001,136,500 & 2.140,0601,3.150,500 \\ \hline Net Plant and equipment & 585,000 & 623,500 & 1.109500 & 1,645,500 & 1,431,500 & 1.217 .500 & 1,003.500 & 289.50010.500 \\ \hline Totni Anets & 1.025.900 & 201500 & 1.42002 & 2019.278 & 1493.722 & 13816162 & & 2427056 \\ \hline & & & & & & & & \\ \hline AccountsPryableAccruedExpenses & 200,00020,400 & 310,0000,000 & 505,00035,000 & 748,56075,000 & 949,22295,000 & 1,149,854115,000 & 1,296,454190,000 & 1,445,031145,000 \\ \hline AccruedExpensesTotalCurrentLinbirties & 220,40020,400 & 340,000 & 540,00035,000 & $23,560 & 1,044,222 & 2,264,894 & 2,426.458 & 1,538,091145,000 \\ \hline fonc-term uabilibe: & 325,000 & 363,600 & 703909 & 601900 & 503900 & 403.900 & 308,200 & 1,536091202909 \\ \hline Totar Liboilities & 5,45,400 & 703,600 & 1,243,900 & 1,427,450 & 1,548,122 & 2,568,764 & 1,730,35a & 1,792931 \\ \hline Common Stock(st par) & 50,000 & 50,000 & 78,000 & 104,000 & 104,000 & 104,000 & 204,060 & 104,000 \\ \hline Copital poid in eacest of par & 190,000 & 190,000 & 262,000 & 1,236,000 & 1,235,000 & 1,236,000 & 1,235,000 & 1236000 \\ \hline Fetained Eamings: & 4239,600 & 254,900 & 235,600 & 273271,818 & 310,600 & 149.993 & 37.254 & \\ \hline Total 5tockholder's Equity & 805000489600 & 504,900 & 575,600 & 1611.818 & 1,650,600 & 1659,383 & 1,587,254 & 1.5est124 \\ \hline Lotal Uabilities a Stocanolsers Equity & 20350001 & 1208500 & 1.49800 & 2] 1009274 & 1198722 & 3asange & 342681L & Landest \\ \hline \end{tabular} ONE: Qumery of winsows sold io: Sellint price per window (P) Total Fued Cotsipes Totaivaribtie Cous (Tric) volviton: \begin{tabular}{|c|c|c|c|c|} \hline 2003 & 2024 & 2025 & 2026 & 2027 \\ \hline 3000 & 5000 & 6000 & 7000 & 1000 \\ \hline 51,000 & 31000 & 3500 & 31000 & 38.000 \\ \hline 3400 & & 5851 & sin: & 1825 \\ \hline 5500050 & 5500,000 & 5500,000 & 5500000 & 5500000 \\ \hline 52,000,000 & 58000000 & 53200000 & 40800000 & 65000000 \\ \hline \end{tabular} GMTH NOTE. Coin flowition operabena [fotal for coment] sotveron: Coh thest frem Operstish 2on 2on aws. 2021 (4 pts) Compuse the following for the forecasted years. (Total company) (HINT: See Week 1 Chopter reodings for FCF formulo) GIVEN: NOTE 1: Dividends are zero every vear. NOTE 2$750,000 of the $1M invested by the shark was spent on Capital Expenditures in 2023. No other capital expecitures occurred