Question
Its currently January 1, 2023, and youll be going on Shark Tank in 2 weeks. Using the information below, create your 5- year Sales, Cost
Its currently January 1, 2023, and youll 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 Actual annual sales in the past: 2020 2021 2022 Actual SALES $1,200,000 $1,500,000 $1,875,000 2 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
Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2020 2021 2022 2023 2024 2025 2026 2027 Sales (all on credit) 1,200,000 1,500,000 1,875,000 Cost of Goods Sold (800,000) (1,040,000) (1,105,000) Gross Profit 400,000 460,000 770,000 Selling and Administrative Expense Rent Expense Depreciation Expense Operating profit (EBIT) Interest expense Net Income before Taxes Taxes Net Income Shares
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started