Residents and their tastebuds



Download 369.27 Kb.
Page7/10
Date28.01.2017
Size369.27 Kb.
#9572
1   2   3   4   5   6   7   8   9   10

5.0 Financial Plan


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%

Table 5.2 Base case / Worst case / Best case Scenario results


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.



Download 369.27 Kb.

Share with your friends:
1   2   3   4   5   6   7   8   9   10




The database is protected by copyright ©ininet.org 2024
send message

    Main page