Based on the data presented in Appendix E, it appears that Gelato Mobile will make a profit in 2009 of about $7,100. The assumptions that contributed to this figure are listed in Appendix F. Conservative estimates were used in almost every situation. After analyzing the variables for revenues and expenses, it would appear that the most crucial variable is in fact sales. As noted in Table 5.1 and 5.2, under the worst case scenario, if sales drop 25%, the NPV changes substantially by $ 66,501, and becomes negative. Alternatively, under the best case scenario, if sales were 25% higher than planned, the NPV changes to $91,668.
Table 5.1 Base case / Worst case / Best case Scenario variables
Variable
|
Base Case
|
Worst Case
|
Best Case
|
Sales (Year 1)
|
63,300
|
47,475
|
79,125
|
Margin
|
60%
|
47%
|
68%
|
Scenario
|
NPV
|
IRR
|
Avg Annual Net Income
|
Base Case
|
30,612
|
N/A
|
8,813
|
Worst Case
|
-35,889
|
N/A
|
-6,990
|
Best Case
|
91,668
|
N/A
|
23,342
|
|
Worst
|
Best
|
Change in Sales
|
-25%
|
25%
|
Change in NPV
|
$66,501.00
|
$61,056
|
Table 5.3 Summary of Financial Data
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Year
|
2009
|
2010
|
2011
|
2012
|
2013
|
Sales Revenue
|
63,300
|
68,127
|
71,371
|
74,615
|
77,859
|
Cost of Goods Sold
|
25,257
|
25,888
|
26,535
|
27,199
|
27,879
|
Gross Margin
|
38,043
|
42,239
|
44,835
|
47,416
|
49,980
|
Total Expenses
|
28,564
|
29,278
|
34,909
|
35,782
|
37,481
|
Net Income Before Taxes
|
9,480
|
12,961
|
9,926
|
11,634
|
12,500
|
Income Taxes
|
1,765
|
2,348
|
1,799
|
2,108
|
2,265
|
Net Income(Loss)
|
7,714
|
10,612
|
8,128
|
9,526
|
10,235
|
Net Present Value (NPV)
|
32,417
|
IRR
|
N/A
|
The NPV calculated for the base case noted above in Table 5.3 is based on projected net income for 5 years, plus a multiple of 3 in the fifth year (2013).
To break even, Gelato Mobile will need $54,536 in revenue (to achieve $0 net income).
Should projected revenues not be realized and Gelato Mobile cannot survive financially, the exit strategy is to simply close up shop. Gelato Mobile would simply sell remaining gelato at a discounted price and return the leased equipment. Worst case scenario, the Owners are out their initial investment of $2000 each, yet can chalk this business venture up to a social experiment in Saskatoon.
Share with your friends: |