C D E F G 1 2 A B iPhone App Forecast of Revenue and Costs 3 Assumptions 4 Units Year 1 5 Yearly Increase 6 Price Per unit 7 Apple Commission 8 Contribution Margin per 9 10 Fixed Costs 11 Developer Cost - Initial 12 Incorporation LLC 13 Deveoper Cost - Maintena 14 Apple Developer License 15 Advertising 16 700 100% 2.00 30% $1.40 formula required $3,500 year 1 only $199 year 1 only $1,000 yearly after year 1 QII Answer: $99 yearly $2,400 yearly 17 18 19 Year Units Margin Fixed Costs Profit 1 700 $980.00 $6,198 ($5,218.00) 20 2 1400 $1,960.00 $3,499 ($1,539.00) 21 3 2800 $3,920.00 $3,499 $421.00 22 4 5600 $7,840.00 $3,499 $4,341.00 23 5 11200 $15,680.00 $3,499 $12,181.00 24 Profit Loss $10,186.00 25 26 Sensitivity Analysis 5 year Proft (Loss) as a function of Price Per Unit and changing assumptions 27 above 28 30 32 33 34 35 888588888 29 Price per Uni 25% Yearly Increase 50% 75% 100% 1.00 2.00 3.00 4.00 5.00 36 Sensitivity Analysis 5 year Prof(Loss) as a function of Price Per Unit and using what-if analysis 41 42 43 44 45 6889++7 = 4 37 38 39 40 Price per Uni ning 5 year Yearly Increase 25% 50% 75% 100% 1.00 2.00 3.00 4.00 5.00