Pro Forma 2014 Case Study

Decent Essays
Financial Prospects
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,

Related Documents

  • Superior Essays

    Knee Scooters Case Study

    • 1709 Words
    • 7 Pages

    We’ve seen tremendous growth this year, going from taking a $4000 loss in the first year, to a $30,000 profit this year. These risks are most likely not detrimental to our business, but could prevent a profit decrease due to…

    • 1709 Words
    • 7 Pages
    Superior Essays
  • Improved Essays

    Balance Sheet Observation Pinnacle Entertainment INC. (PNK) a) What is the trend, in each company, in total revenues over the three years? Growth has been observed in revenue. It is increased from (2012) 1,002,836 to (2014) 2,210,543 which is 120% growth as compare to base year. Revenue is very sensitive for the survival of company but since growth rate is very high, it is sign that company will grow further in future. PNK need to maintain it through the period, any negative in growth can badly affect the reputation of PNK.…

    • 464 Words
    • 2 Pages
    Improved Essays
  • Great Essays

    Net profit margin 27.32 25.91 24.89 1.813 4.10 Return on equity 30.45 35.72 36.39 29.16 -2.61 Return on assets 17.87 19.34 16.69 9.71 -0.65 Return on Capital 22.33 23.85 22.08 16.06 2.08 Income/Employee 960 1,043 934 655 -55 Revenue Employee 5,342 6,186 15,727 4,782 5,594 Revenue turn over 1.00 1.15 1.02 0.83 0.56 Inventory turnover 61.80…

    • 595 Words
    • 3 Pages
    Great Essays
  • Brilliant Essays

    From charts and financial report above show that revenues increased by each year from $450,000,000 to $29,150,000 in the past five years; total employees grew from 54 people in 2011 to 175 in 2014; and the highest productivity (revenue/employee) was $1,083,333 in 2012. By calculation, Revenue Growth Rate in one year was 206.1% and 90.6% of 3 year average. Employee Growth Rate was 56.3% in one year and 3 year average was 48%. (Privco, 2016) Strengths YETI has existed distribution and sales networks in different countries, including REI.com, Cabela's Alibaba.com, Amazon.com, and Dick's Sporting Goods.…

    • 691 Words
    • 3 Pages
    Brilliant Essays
  • Improved Essays

    AICPA Case Study Summary

    • 118 Words
    • 1 Pages

    Assume that Brenda has no reason to doubt Vincent’s veracity with respect to the statement that it is “a one-time request,” it should not influence what Brenda decides to do. Brenda should retain her morality and ethics when she faces such demand from her manager, whether is a one-time request or not. Although Brenda has an alternative to overlook the tax return, which results in satisfying both Vincent and the client’s needs but violating the tax law; the right action for Brenda to take is to follow the Principles of AICPA Code and the Ethical Standards of the IMA. Brenda should take the courage reporting Vincent’s unlawful act to management, or whistleblowing via fraud hotline if there’s any.…

    • 118 Words
    • 1 Pages
    Improved Essays
  • Great Essays

    Swot Analysis Of Capsim

    • 4542 Words
    • 19 Pages

    Cash Flow Statement PROFORMA CASH FLOW STATEMENT | Cash Flows from Operating Activities | | Net Income (Loss) | (13274) | Adjustment for non-cash items | | | Depreciation & Writeoff | 9693 | Change in Current Assets and Liabilities | | | Accounts Payable | 1116 | | Inventory | 7562 | | Accounts Receivable | (1933) | Net cash from operations | 3165 | | Cash Flows From Investing Activities | | Plant Improvements | (31600) | | Cash Flows from Financing Activities | |…

    • 4542 Words
    • 19 Pages
    Great Essays
  • Decent Essays

    Before seeking Johnson Angel Investment LLC, it is imperative that your business is at the correct growth level stage and that your company is ready for everything that comes with having outside investors. For example, we like to invest in local companies in Southern California, giving us the ability to visit from time to time, however we will consider investing in companies that are in the sounding area. Below you will find criteria that will help you to see if your company has what it takes to be part of the Johnson Angel Investment team. The Johnson Angel Investment is looking to invest in companies with an upside of 10% or higher and will invest up to $250,000 or more if the company has a proven concept wit…

    • 325 Words
    • 2 Pages
    Decent Essays
  • Improved Essays

    Over the past 5 years, Hasbro has maintained healthy profitability factors. As you can see from the snip that follows of the information provided in Appendix A- Financial Ratios, Hasbro’s Return on Sales is at 9.47%, its Return on assets is at 10.47%, and its Return of Common Equity is at 26.13%, which is the perfect ladder we have learned about throughout this course. Growth Hasbro has shown consistent growth over the past five year period reviewed. As the following table shows, Hasbro’s average revenue growth percentage is 5.37% and its average net profit margin is 9.10% over the last 5 years. This equate to a 15.29% average net income growth percentage over the last 5 years.…

    • 567 Words
    • 3 Pages
    Improved Essays
  • Superior Essays

    After enough units are sold to cover fixed costs of $93,000.00, the contribution margin per unit from remaining sales becomes profit. I decided to compare contribution margins per unit and per order for both necklaces and earring being sold at the trade show and online. Difference in selling price resulting in different contribution margin per unit (Exhibit4). After the contribution margin analysis, it helps to determine the sales goals for the overall business…

    • 1639 Words
    • 7 Pages
    Superior Essays
  • Great Essays

    Case Study Of Only Eggless

    • 1470 Words
    • 6 Pages

    Task 3: Which is the most appropriate method to increase revenue for the business you have chosen? What is Profitability? Source-(Edexcel GCSE Business: Introduction to small business) Revenue= Price x Quantity sold Total costs= Fixed costs + Variable costs Profit= Revenue – Total costs…

    • 1470 Words
    • 6 Pages
    Great Essays
  • Superior Essays

    Lizards and apes, sparrows and whales, donkeys and humans, according to evolution these all have a shared common ancestor, that has evolved over millions of years. Creation teaches that each family and or genus has a different ancestor, an intelligent creator thought up each one, only a few thousand years ago. Which do I choose to place my faith in? I choose to believe in an intelligent creator, that created the earth only a few thousand years ago, rather than millions of years, for three irrefutable claims; first of all, if the sedimentary layers were displaced over millions of years there would be erosion and signs of wear, but there is not. Secondly if you calculate the approximate amounts of human reproduction per year, going backwards…

    • 1272 Words
    • 6 Pages
    Superior Essays
  • Brilliant Essays

    Its headquarters and manufacturing facilities are located in Chicago, Illinois. ChemInc specializes in manufacturing medical compounds. Given the nature of these medical compounds, many require special storage until they are used in formulating drugs and/or medications by a pharmaceutical company. The special storage requirements include strict regulation of the temperature, air pressure, and humidity. ChemInc stores the medical compounds it manufactures in the appropriate storage facilities until they are purchased by and shipped to a customer.…

    • 1851 Words
    • 8 Pages
    Brilliant Essays
  • Improved Essays

    Their revenue is 233.27 billion USD. This is one of the highest in the whole world. These goals and objectives help them forecast how far they have already gotten, and motivate internal stakeholders to do their…

    • 999 Words
    • 4 Pages
    Improved Essays
  • Improved Essays

    Issue Analysis From the high concentration on the overall performance of the store, the keen issues identified that cause the disturbance in the sales ratio of the Rufus and Emma Belacastran Australian Hardware Store. Those issues including the competition in the Melbourne hardware stores with respect to prices, the rising vacancy rates and the rising cost of labour and delivery charges of store 2 and 3. The management of the corresponding store should evaluate the complete scenario and will implement the most effective strategies for increasing the demand for its products by considering the external factors in mind. Furthermore, the management has no control over the environmental factors but it can manage the current costs of the store products. Through the…

    • 839 Words
    • 4 Pages
    Improved Essays
  • Great Essays

    Swot Analysis Of Quintiles

    • 1250 Words
    • 5 Pages

    Totaling to a difference of 13.5%. The mathematical model for profitability improve is as follows: NI= 0.08(#of Sales) – 0.09(CGS)-3.84(State Tax). As of 2014 the company’s Net income is 129.094 (in millions), to improve the company the Net profit margin within two years the net income should at least reach 401 million with approximately 2268 million in sales to reach a 17.7% profit margin. To increase sales from the company average sale of 1727.7684 to 2268 million the company needs to raise the…

    • 1250 Words
    • 5 Pages
    Great Essays