1 Conduct a 2-year weighted annual sales forecast for the years 2023-2027. Place your results on the Sales line of the Milestone 1 Sales Forecast tab in the highlighted area.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Topic Video
Question

Questions

 

1. How reliable is your Sales Forecast? Explain your answer.

 

2. What are some ways you could potentially improve the accuracy of your forecast?

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 Forecast for the years 2023-2027.
Information:
1
2
Required:
1
2
Actual annual sales in the past:
Actual SALES
2020
2021
2022
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
Conduct a 2-year weighted annual sales forecast for the years 2023-2027. Place your
results on the Sales line of the Milestone 1 Sales Forecast tab in the highlighted area.
Answer the questions on the Milestone 1 Questions tab.
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 Forecast for the years 2023-2027. Information: 1 2 Required: 1 2 Actual annual sales in the past: Actual SALES 2020 2021 2022 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 Conduct a 2-year weighted annual sales forecast for the years 2023-2027. Place your results on the Sales line of the Milestone 1 Sales Forecast tab in the highlighted area. Answer the questions on the Milestone 1 Questions tab.
3 Fill in the yellow highlighted cells with your forecasted figures.
4 SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly la
5
All your work must be shown on this sheet, not on a separate tab.
6
7
8
9
10
11
12 Sales (all on credit)
13 Cost of Goods Sold
14 Gross Profit
15 Selling and Administrative Expense
16 Operating profit (EBIT)
17 Interest expense
18 Net Income before Taxes
19 Taxes
20 Net Income
21 Shares
22 Earnings per Share
2020
1,200,000
DURA-CLEAR WINDOWS, LLC
Proforma Income Statement
2021
1,500,000
2022
1,875,000
2023
2024
2025
2026
2027
Transcribed Image Text:3 Fill in the yellow highlighted cells with your forecasted figures. 4 SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both -- clearly la 5 All your work must be shown on this sheet, not on a separate tab. 6 7 8 9 10 11 12 Sales (all on credit) 13 Cost of Goods Sold 14 Gross Profit 15 Selling and Administrative Expense 16 Operating profit (EBIT) 17 Interest expense 18 Net Income before Taxes 19 Taxes 20 Net Income 21 Shares 22 Earnings per Share 2020 1,200,000 DURA-CLEAR WINDOWS, LLC Proforma Income Statement 2021 1,500,000 2022 1,875,000 2023 2024 2025 2026 2027
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Ratio Analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education