Nicole T. Le Blanc
Kaplan University
AB299: Unit 6
Impacts to the Profit and Loss Statement As Tim was informed about new business around his coffee shop, he is expecting that sales should increase. Tim needs too to create a pro forma income statement to be able to plan and look at his future projections in his business operations to see if the projections determine a profit or a loss. If need be he can make operational changes such as increasing prices or decreasing costs before these projections become reality that way he can prepare for the potential increase in sales. After completing the pro forma income statement and looking at the projected increased income earned and expenses for year 2012, the forecast is that the expenses, salaries, rent, supplies, lease, interest and insurance and taxes will increase and depending on tangible assets, the depreciation amount could change in 2012. The expenses that will increase due to operational needs, like salaries and supplies. For the increase in salaries, Tim will need to have more labor to cover the projected customers, therefore the salaries will increase. The same goes with supplies; he will be generating more products so he will have to adjust his supplies budget to accommodate the revised supplies that are …show more content…
needed. The taxes will also increase as they are based off the total income earned. The other expenses will not increase, as they are not an expense that is associated directly with daily operational functions. After reviewing the pro forma statement the net profit for year 2012 there will be an increase.
Tim projected that 2012 increases would be about 10%, due to the potential rise in net sales; therefore the increase is due the projected revenue. The increase will affect those expenses that are operational; therefore the bottom line is that there is a substantial net profit from the previous year. If Tim does achieve this projected 10% increase for the year 2012, Tim should continuously update his projections on the pro forma statement monthly or even on a quarterly basis, that way he can be assured that his projections are as accurate as
possible.
Tim 's Coffee Shop
Pro Forma Income Statement
For the Years 2011 - 2012
10% Increase
REVENUE
2011
2012
Gross Sales
$ 400,527 $ 440,579
Net Sales
$ 400,527 $ 440,579
OPERATING EXPENSES
Salaries and Wages
$ 101,600 $ 111,760
Rent Expense
$ 14,400 $ 14,400
Depreciation
$ 12,116 $ 13,328
Supplies
$ 135,827 $ 149,410
Lease expense
$ 11,987 $ 11,987
Tax expense
$ 40,515 $ 44,567
Interest expense
$ 615 $ 677
Insurance expense
$ 8,956 $ 8,956
Total Operating Expenses
$ 326,016.00 $ 355,083.30
Net Income
$ 74,511.00 $ 85,496.40
Net Profit Increase $ 10,985.40
2012
References
Ektajalan. (2014, May 2). Top 10 Largest Coffee Chains in the World - List Dose. Retrieved February 13, 2015, from http://listdose.com/top-10-largest-coffee-chains-in-the-world/
Income Statement Tim 's Coffee Shoppe. (n.d.). Retrieved February 13, 2015, from http://extmedia.kaplan.edu/business/Media/AB299/Tims_Coffee_Shop/business_incomes tatement.html
Way, J. (n.d.). How to Calculate a Five-Year Pro Forma. Retrieved February 13, 2015, from http://smallbusiness.chron.com/calculate-fiveyear-pro-forma-39682.html