Proforma Income Statement Forecasted 2016 Pro Forma 2017 Pro Forma 2018 Pro Forma 2019
Sales 3,751,350.00 4,210,050.00 4,668,609.00 5,127,300.00
COGS 2,518,656.39 2,826,627.57 3,134,498.04 3,442,469.22
Gross Profit 1,232,693.61 1,383,422.43 1,534,110.96 1,684,830.78
Operating Expense
599,814.00
599,814.00
599,814.00
599,814.00
Net Income before taxes 632,879.61 783,608.43 934,296.96 1,085,016.78
Table 6.1
Average Growth Rate 2017: 783,608.43 – 632,879.61/ 632,879.61 = 0.2382
Average Growth Rate 2018: 934,296.96 – 783,608.43/ 783,608.43 = 0.1923
Average Growth Rate 2019: 1,085,016.78 – 934,296.96/ 934,296.96 = 0.1613
Our business has attained these forecasted results by basing it on the average growth of the population …show more content…
The growth rate was taken by dividing the difference of the current and the future income with the current income. With these results, we can assume that the increase in the average growth rate comes the increase in the net cash flow as well which we have assumed as a good sign for a feasible business venture.
Breakeven Analysis
BEQ = 107,170/ (150.00 – 100.71) = 2,174 Our fixed cost is priced at P107,170 which consists of our rent, permits, and equipment. The product is priced at P150 but costs P100.71 which then gives us the breakeven point of 2,174. This then gives us the assumption that we should be able to sell at least 534 in a week and 181 in a day for us to breakeven. And given the sales which we have analyzed in the Pro Forma, this business will be feasible with the right place and the right marketing strategies that it will be …show more content…
Equipment pricing basis, Blender, https://www.amazon.com/dp/B0094B94BM?ref_=ams_ad_dp_asin_1
Equipment pricing basis, Mini Refrigerator, https://www.alibaba.com/product-detail/21L-mini-Display-Refrigerator_331239416.html?spm=a2700.7735675.30.127.2qkur6&s=p
Pennstate extension food entrepreneurs, Price and Pricing http://extension.psu.edu/food/entrepreneurs/starting-a-business/price-and-pricing
Philippine Statistics Authority Population 2015 https://www.psa.gov.ph/content/population-national-capital-region-based-2015-census-population-0
Philippine Statistics Authority Population 2010 http://nap.psa.gov.ph/activestats/psgc/municipality.asp?muncode=137607000®code=13&provcode=76
Booky, Single Origin, http://ph.phonebooky.com/single-origin-fort-bonifacio
Spot, Single Origin, http://www.spot.ph/eatdrink/the-latest-eat-drink/63550/single-origin-bonifacio-high-street-central-bgc
When in Manila, Frank x Dean http://www.wheninmanila.com/frank-and-dean-burgos-circle/
Spot, Frank x Dean,