Scribd
Upload
18 views1 page

Revenue Growth Assumptions for Pizza

The document outlines a financial modeling exercise requiring the completion of specific cells related to case assumptions and revenue projections for a pizza business. It instructs the user to create names for three cases (Base, Upside, Downside) and to use a CHOOSE function for annual growth rates based on the selected case. Additionally, it provides a formula for calculating units sold for future years based on the selected growth rates.

Uploaded by

Nouf A
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
18 views1 page

Revenue Growth Assumptions for Pizza

The document outlines a financial modeling exercise requiring the completion of specific cells related to case assumptions and revenue projections for a pizza business. It instructs the user to create names for three cases (Base, Upside, Downside) and to use a CHOOSE function for annual growth rates based on the selected case. Additionally, it provides a formula for calculating units sold for future years based on the selected growth rates.

Uploaded by

Nouf A
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Assumptions Err:502

Dec-YE Unit 2018A 2019A 2020A 2021E 2022E 2023E 2024E 2025E

* Case Chooser
COMPLETE THE ORANGE SHADED CELLS
Active Case # Err:502
# Rows 8-10 (Column B): Create names for each of the three cases (Base Case, Upside Case, Downside Case)
#
Row 7 (Column D): Insert the number 1 in the cell (assume we are running Base Case for now)
#
Rows 8-10 (Column D): Assign a case number to the Base Case, Upside Case and Downside Case (i.e. 1, 2, 3)
* Revenue Assumptions

Organic Pizza COMPLETE THE ORANGE SHADED CELLS


Units Sold # 200,000 250,000 290,000
Row 16: Given the assumptions have already been provided for the Base Case,
Annual Growth % 25.0% 16.0%
Upside Case and Downside Case, use a =CHOOSE function for cells G16 to K16.
0 % 12.0% 10.0% 8.0% 6.0% 4.0% > HINT: The "index_num" is cell D7 (remember to insert it as $D$7)!
0 % 12.0% 10.0% 8.0% 6.0% 4.0% > Refer to the Lecture from Section 1.4 if you get stuck!
0 % 12.0% 10.0% 8.0% 6.0% 4.0%
Row 15: With the Active Case annual growth numbers now selected in Row 16,
calculate the Units Sold for 2021-25E using the formula: Units Sold (this year) =
Units Sold (previous year) x (1+annual growth)

You might also like