Forecasted financial statements are given Sales (all on credit) Cost of Goods Sold Gross Profit Selling and

Forecasted  financial statements are given 
  

Transcribed Image Text:

Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Rent Expense Depreciation Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares Earnings per Share ASSETS Cash Marketable Securities Accounts Receivable. Inventory Plant and equipment Less: accumulated depreciation Net Plant and equipment Total Assets LIABILITIES & STOCKHOLDER'S EQUITY Accounts Payable Accrued Expenses Forecasted Balance Sheet (30 points: 5 for showing work, 25 for accuracy) DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet 2020 2021 Long-term Liabilities Common Stock ($1 par) Capital paid in excess of par Retained Earnings Total Current Assets: Total Current Liabilities Total Liabilities Total Stockholder's Equity DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2020 2021 Total Liabilities & Stockholder's Equity $0.39 2022 $0.26 2023 2022 1,200,000 1,500,000 1,875,000 5,625,000 7,031,250 8,789,063 10,986,328 13,732,910 (800,000) (1.040.000) (1.105.000 3.093.750 3.867.188 4.833.984 6.042.480 7.553.101 400,000 460,000 770,000 8,718,750 10,898,438 13,623,047 17,028,809 21,286,011 (224,900) (270,500) (363,700) (1,053,231) (1,316,539) (1,645,674) (2,057,092) (2,571,365) (15,000) (15,000) (15,000) (200,000) (200,000) (200,000) (200,000) (200,000) (65.000) (76.500) 1139.000) (214.000) (214.000) (214.000) 1214.000) (214,000) 95,100 98,000 252,300 7,251,519. 9,167,898 11,563,373 14,557,716 18,300,645 (85.000 (60,390) (50,390) (40,390) (30,390) (20,390) 167,300 7,191,129 9,117,508 11,522,983 14,527,326 18,280,255 155.600 12.588.806) (3.282.303) (4.148.274) (5.229.837) (6.580,8921 111,700 4,602,322 5,835,205 7,374,709 9,297,489 11,699,363 78,000 104,000 104,000 104,000 104,000 104,000 $44.25 $56.11 $70.91 $89.40 $112.49 (35,000) (45.000) 60,100 53,000 (36.900) (49,200) 23,200 3,800 60,000 60,000 $2.38 2024 2023 2024 2025 50,000 30,000 2025 2026 50,000 2026 2027 30,000 40,000 30,000 50,000 30,000 30,000 20,000 25,000 30,000 30,000 170,000 259,000 360,000 934,455 1,168,068 1,460,085 1,825,107 2,281,383 230.000 261.000 290,000 975.625 1.219.531 1.524.414 1.905.518 2.381.897 450,000 585,000 710,000 1,990,080 2,467,599 3,064,499 3,810,624 4,743,280 650,000 765,000 1,390,000 2,140,000 2,140,000 2,140,000 2,140,000 2,140,000 (65.000) (141,500) (280,500 (494,500) (708.500) (922.500) (1.136.500 (1.350.500) 585.000 623.500 1.109.500 1.645.500 1.431.500 1.217.500 1.003.500 789.500 1.035.000 1.208.500 1.819.500 3.635.580 3.899.099 4.281.999 4.814.124 5.532.780 50,000 2027 50,000 30,000 3,006,625 200,000 310,000 505,000 20.400 30,000 35,000 104.375 130,469 163,086 203.857 254.822 220,400 340,000 540,000 1,175,905 1,458,063 1,810,761 2,251,634 2,802,725 325.000 363.600 703.900 603.900 503,900 403.900 303.900 203.900 545,400 703,600 1,243,900 1,779,805 1,961,963 2,214,661 2,555,534 60,000 60,000 78,000 104,000 104,000 104,000 104,000 190,000 190,000 262,000 1,236,000 1,236,000 1,236,000 1,236,000 1,236,000 239.600 254,900 235,600 515.775 $97.136 727,338 918.590 1.186.156 489.600 504,900 575.600 1.855.775 1937.136 2.067.338 2.258.590 2.526 156 1.035.000 1.208.500 1.819.500 3.635.580 3.899.099 4.281.999 4.814.124 5.532.780 104,000 Sales (all on credit) Cost of Goods Sold Gross Profit Selling and Administrative Expense Rent Expense Depreciation Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares Earnings per Share ASSETS Cash Marketable Securities Accounts Receivable. Inventory Plant and equipment Less: accumulated depreciation Net Plant and equipment Total Assets LIABILITIES & STOCKHOLDER'S EQUITY Accounts Payable Accrued Expenses Forecasted Balance Sheet (30 points: 5 for showing work, 25 for accuracy) DURA-CLEAR WINDOWS, LLC Proforma Balance Sheet 2020 2021 Long-term Liabilities Common Stock ($1 par) Capital paid in excess of par Retained Earnings Total Current Assets: Total Current Liabilities Total Liabilities Total Stockholder's Equity DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2020 2021 Total Liabilities & Stockholder's Equity $0.39 2022 $0.26 2023 2022 1,200,000 1,500,000 1,875,000 5,625,000 7,031,250 8,789,063 10,986,328 13,732,910 (800,000) (1.040.000) (1.105.000 3.093.750 3.867.188 4.833.984 6.042.480 7.553.101 400,000 460,000 770,000 8,718,750 10,898,438 13,623,047 17,028,809 21,286,011 (224,900) (270,500) (363,700) (1,053,231) (1,316,539) (1,645,674) (2,057,092) (2,571,365) (15,000) (15,000) (15,000) (200,000) (200,000) (200,000) (200,000) (200,000) (65.000) (76.500) 1139.000) (214.000) (214.000) (214.000) 1214.000) (214,000) 95,100 98,000 252,300 7,251,519. 9,167,898 11,563,373 14,557,716 18,300,645 (85.000 (60,390) (50,390) (40,390) (30,390) (20,390) 167,300 7,191,129 9,117,508 11,522,983 14,527,326 18,280,255 155.600 12.588.806) (3.282.303) (4.148.274) (5.229.837) (6.580,8921 111,700 4,602,322 5,835,205 7,374,709 9,297,489 11,699,363 78,000 104,000 104,000 104,000 104,000 104,000 $44.25 $56.11 $70.91 $89.40 $112.49 (35,000) (45.000) 60,100 53,000 (36.900) (49,200) 23,200 3,800 60,000 60,000 $2.38 2024 2023 2024 2025 50,000 30,000 2025 2026 50,000 2026 2027 30,000 40,000 30,000 50,000 30,000 30,000 20,000 25,000 30,000 30,000 170,000 259,000 360,000 934,455 1,168,068 1,460,085 1,825,107 2,281,383 230.000 261.000 290,000 975.625 1.219.531 1.524.414 1.905.518 2.381.897 450,000 585,000 710,000 1,990,080 2,467,599 3,064,499 3,810,624 4,743,280 650,000 765,000 1,390,000 2,140,000 2,140,000 2,140,000 2,140,000 2,140,000 (65.000) (141,500) (280,500 (494,500) (708.500) (922.500) (1.136.500 (1.350.500) 585.000 623.500 1.109.500 1.645.500 1.431.500 1.217.500 1.003.500 789.500 1.035.000 1.208.500 1.819.500 3.635.580 3.899.099 4.281.999 4.814.124 5.532.780 50,000 2027 50,000 30,000 3,006,625 200,000 310,000 505,000 20.400 30,000 35,000 104.375 130,469 163,086 203.857 254.822 220,400 340,000 540,000 1,175,905 1,458,063 1,810,761 2,251,634 2,802,725 325.000 363.600 703.900 603.900 503,900 403.900 303.900 203.900 545,400 703,600 1,243,900 1,779,805 1,961,963 2,214,661 2,555,534 60,000 60,000 78,000 104,000 104,000 104,000 104,000 190,000 190,000 262,000 1,236,000 1,236,000 1,236,000 1,236,000 1,236,000 239.600 254,900 235,600 515.775 $97.136 727,338 918.590 1.186.156 489.600 504,900 575.600 1.855.775 1937.136 2.067.338 2.258.590 2.526 156 1.035.000 1.208.500 1.819.500 3.635.580 3.899.099 4.281.999 4.814.124 5.532.780 104,000

Answer rating: 100% (QA)

See the Attac... View the full answer