It's currently January 1, 2023, and you'll be going on Shark Tank in 2 weeks. Using...

 

Transcribed Image Text:

It's currently January 1, 2023, and you'll be going on Shark Tank in 2 weeks. Using the information below, create your 5 year Sales, Cost of Goods Sold (COGS), and Gross Profit forecast for the years 2023-2027. Information: 1 2 3 Required: 1 2 Actual annual sales in the past: 2020 2021 2022 Actual SALES $ 1,200,000.00 $1,500,000.00 $1,875,000.00 Because you feel your most recent sales are the best predictor of future sales, you weight your sales as follows: W1 = 0.2 and W2 = 0.8 You are certain you can get volume discounts on your parts and materials now that your Sales are expected to increase. So, you estimate your COGS will be 52% of Sales, which is less than it has been in the past. Conduct a 2-year weighted moving average to forecast the annual sales for the years 2023-2027. Using the Percent-of-Sales method, compute Cost of Goods Sold. Then compute Gross Profit. 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 2020 1,200,000 (800,000) 400,000 DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2021 2022 1,500,000 (1,040,000) 460,000 1,875,000 (1,105,000) 770,000 2023 2024 2025 2026 2027 It's currently January 1, 2023, and you'll be going on Shark Tank in 2 weeks. Using the information below, create your 5 year Sales, Cost of Goods Sold (COGS), and Gross Profit forecast for the years 2023-2027. Information: 1 2 3 Required: 1 2 Actual annual sales in the past: 2020 2021 2022 Actual SALES $ 1,200,000.00 $1,500,000.00 $1,875,000.00 Because you feel your most recent sales are the best predictor of future sales, you weight your sales as follows: W1 = 0.2 and W2 = 0.8 You are certain you can get volume discounts on your parts and materials now that your Sales are expected to increase. So, you estimate your COGS will be 52% of Sales, which is less than it has been in the past. Conduct a 2-year weighted moving average to forecast the annual sales for the years 2023-2027. Using the Percent-of-Sales method, compute Cost of Goods Sold. Then compute Gross Profit. 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 2020 1,200,000 (800,000) 400,000 DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2021 2022 1,500,000 (1,040,000) 460,000 1,875,000 (1,105,000) 770,000 2023 2024 2025 2026 2027