wd 19-22 - $771,144 Kowabunga 275,000 $296,789 $320,304...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Scenario Summary Current Values: GrowthRate Changing Cells: $G$4 7.92% 1.50% Result Cells: $G$16 $4,000,000 $3,408,341 Notes: Current Values column represents values of changing cells at time Scenario Summary Report was created. Changing cells for each scenario are highlighted in gray.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Klassy Kow Ice Cream, Inc. Sales Projections Next Year Sales Forecast Formula Quarterly Growth Rate Growth Adjustment Factor KowOwow Kowabunga Ice Cream Sandwich Forecast KowOwow $325,000 $403,363 $500,621 $621,330
Background image of page 2
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $771,144 Kowabunga 275,000 $296,789 $320,304 $345,683 $373,073 Ice Cream Sandwich 200,000 $142,459 $101,472 $72,278 $51,483 800,000.00 Target Sales in Millions The formula to estimate each quarter's sales is: (PreviousQuarterSales) * (1+ GrowthRate) * (GrowthAdjustmentFactor). Actual Q4 Last Year Q1 Next Year Q2 Next Year Q3 Next Year Q4 Next Year 7.92% 1.15 1.00 0.66 $2,296,458 $1,335,849 $367,693 $4,000,000 Total Next Year GrowthRate Page 4 0.02...
View Full Document

This note was uploaded on 10/30/2010 for the course FINANCE Excel taught by Professor Vahn during the Spring '10 term at City College of San Francisco.

Page1 / 4

wd 19-22 - $771,144 Kowabunga 275,000 $296,789 $320,304...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online