國
立 政 治 大 學
‧
N a tio na
l C h engchi U ni ve rs it y
12. Financial Projections 12.1. Cost of Goods Sold
Costs of goods sold depend on the volume of the customers that the kiosks will receive in a fixed period. These costs are calculated based in the common market prices, taking into consideration the average cost of all the beverages in the menu. These costs might be lower a s volume in orders increase, also increasing the power of Chill Factor to ask for a discounted price.
Drinks average price for a unit drink was calculated based on the survey we did with Indian nationals and willingness to pay for such a drink and other taxes and is more or less going to be around in the range or 40 to 60 INR OR 1 TO 1.2 US$.
Survey statistics: willingness to pay for such a product.
The average cost price of a unit drink comes out to be 20 Rupees or .36 US$.
This gives us a margin of approximately 30 Rupees or .54 US$ per drink.
For details on calculations of Initial investment, fixed and variable cost and calculations of cost per unit and margin per unit- plese refer to tables in appendix 5.
12.2. Operation and Administrative Expenses
Operation and administrative expenses have been determined by staff salaries, cost of basic services, rent, advertising and other costs.
All salaries include the monthly, annual and Diwali bonuses that are regulated by the Indian labor law. The phone account included the telephone located at every kiosk which will be used to order logistics and handle customer calls and will also supply Wi-Fi and internet connection to the POS.
‧
國立 政 治 大 學
‧
N a tio na
l C h engchi U ni ve rs it y
The equipment maintains amount includes regular maintains and unexpected repairs.
After salaries, rent represents the biggest fixed cost. The first year the company expects to open the one store in a major shopping mall and our income statement is based on one store set up only to make things simple.
The advertising and promotion cost will be the high in first year and will gradually decrease with coming years as our brand will be more recognized and become part of mall visitors life.
The other expenses account is for unexpected or uncovered expenses. It was calculated by 3%
of all other costs.
12.3. Initial Investment
The initial investment includes 5 different items including:
License and permit fees: this amount will be paid to a accountancy firm in order to obtain all the necessary licenses and permits to operate. This amount includes the lawyer fee.
Machinery: this amount includes all the machinery necessary to operate the shop in first year such as: commercial blender, Ice maker, fructose dispenser machine, shaking machine, see through refrigerator, POS and automatic sales machine etc.
Utensils: this will include various simple utensils and machines used for beverage making.
For e.g. tea containers, specials scoops, cocktail shakers, measuring spoons among others.
Raw material supplies: this amount takes into the consideration the cups, thick straws, seal printed with the company logo and syrups, powders, jelly, popping boba and tapioca pearls for a demand of 15000 glasses per month.
Please refer to the appendix for the initial setup equipment cost and depreciation calculated.
12.4. Funding
For the first year of operations and 6 months of supply company needs 1,912,822 Rupees or 34,778 US$.
Chill factor would be funded by two sources:
‧
國立 政 治 大 學
‧
N a tio na
l C h engchi U ni ve rs it y
Owners’ capital from personal savings and rental units he owns would cover around 1,000,000 INR or 181,818 US$.
Bank loan of 1,000,000 INR OR 181,818 US$ with the interest rate of 12%
12.5. Break Even Analysis
Break even analysis input in USD:
Expected unit sales 15000/Month
Fixed Cost 2328 US$
Price per unit 1 US$
Variable unit cost 0.49 US$
We will break even at 4,565 units within one month or 54780 per year.
Breakeven Analysis Summary
Variable Cost $0.49 per unit
Fixed Cost $2,328.00
Expected Sales 15,000 units
Price $1.00 per unit
Total Revenue $15,000.00
Total Variable Costs $7,350.00
Profit $5,322.00
This break even analysis puts up in very safe position and even in worst case scenario we are better than break even.
‧
End of December of each year
2014 INR 2014 US$ 2015 INR 2015 US$ 2016 INR 2016 US$
Revenues
Sales 9000000 163636.3636 12870000 234000 17280000 314181.8182
Cost of goods sold
1056000 19200 1200000 21818.18182 1440000 26181.81818
Gross profit ₹ 7,944,000.00 $144,436.36 ₹ 11,670,000.00 $212,181.82 ₹ 16,440,000.00 $298,909.09
Operating expenses
Salaries 600000 10909.09091 720000 13090.90909 840000 15272.72727
Telephone Expenses
12000 218.1818182 12000 218.1818182 12000 218.1818182
Equipment maintenance
120000 2181.818182 120000 2181.818182 120000 2181.818182
Internet 12000 218.1818182 12000 218.1818182 12000 218.1818182
Rent 600000 10909.09091 660000 12000 720000 13090.90909
Business Promotion Expenses
480000 8727.272727 360000 6545.454545 360000 6545.454545
Other Expenses
480000 8727.272727 600000 10909.09091 720000 13090.90909
Net Operating Income
₹ 5,640,000.00 $ 102,545.45 ₹ 9,186,000 $167,018.18 ₹ 13,656,000 $248,290.91
Depreciation 70923 1289.509091 60284.805 1096.087364 51242.08425 931.6742591 Net Income
478974.57 8708.628545 400000 7272.727273 400000 7272.727273
Income before taxes
5090102.43 92547.31691 8725715.195 158649.3672 13204757.92 240086.5076 Income Tax 1527030.729 27764.19507 2617714.559 47594.81015 3961427.375 72025.95227 Net Income ₹ 3,563,071.70 $ 64,783.12 ₹ 6,108,000.64 $111,054.56 ₹ 9,243,330.54 $168,060.56
‧
12.7. Cash Flow Statement: INR
Chill Factor Café
Cash Flow Statement Projection Ended at December 31 of each year
2013 INR 2014 INR 2015 INR 2016 INR
Cash from operating activities
Beverage revenues 0 9000000 12870000 17280000
Total cash recites 0 9000000 12870000 17280000
Cost of goods sold 1056000 1200000 1440000
Equipment Maintenance 120000 120000 120000
Internet 12000 12000 12000
Rent 600000 660000 720000
Advertising and Promotion 480000 360000 360000
Other Expenses 480000 600000 720000
Payment including interest -416348.98 -416348.98 -416348.98 Total cash from financing
activities
2000000 -416348.98 -416348.98 -416348.98
Ending cash position 1527178 5223651.02 8769651.02 12639651.02
Starting cash position 0 1527178 ₹
6,750,829.02
₹
15,520,480.04 Accumulated cash flows 1527178 ₹ 6,750,829 ₹ 15,520,480 ₹ 28,160,131
‧
12.8. Cash Flow Statement: USD
Chill Factor Café
Cash Flow Statement Projection Ended at December 31 of each year
2013 US$ 2014 US$ 2015 US$ 2016 US$
Cash from operating activities
Beverage revenues 163636.364 234000 314181.8182
Total cash recites 163636.364 234000 314181.8182
Cost of goods sold 19200 21818.18182 26181.81818
Cost of sales and
administrative
Salaries 10909.0909 13090.90909 15272.72727
Phone 218.181818 218.1818182 218.1818182
Equipment Maintenance 2181.81818 2181.818182 2181.818182
Internet 218.181818 218.1818182 218.1818182
Rent 10909.0909 12000 13090.90909
Advertising and Promotion 8727.27273 6545.454545 6545.454545
Other Expenses 8727.27273 10909.09091 13090.90909
Total cash from operating
activities 102545.455 167018.1818 237381.8182
Cash from financing activities
Owners investment 18181.82 Short term loan 18181.82 Payment including interest
Total cash from financing activities
36363.64 -7569.98145 -7569.98145 -7569.98145
Cash from investing activities
Machinery and utensils -7687.67 License and permits -909.091 Total cash from investing
activities -8596.76
Ending cash position 27766.88 94975.4731 159448.2004 229811.8367 Starting cash position 0 27766.8727 122742.3458 282190.5462 Accumulated cash flows 27766.87 $122,742.35 $282,190.55 $ 512,002.38
‧
12.9. Net Present Value Analysis
Net Present Value Analysis
INR US$ INR US$ INR US$
Cash flows 5223651.02 94975.4731 8769651.02 159448.2 12639651.02 229811.837 Discount Rate project will be profitable. The project is feasible at a 12% discount rate due to a positive NPV.
‧
國立 政 治 大 學