Executive Summary and Consolidated Presentation

sheyitqan
ProjectedFinancialStatementAnalysis.xlsx

Questions

Questions Response Additional considerations PROFESSOR NOTES
What is the vital financial information needed to determine the viability of your plan ? The vital financial information needed to determine the viability of my plan are the balance sheets and cash flow statements Using different souces of finances Some of your explanations were not substantive based on your financials. 
What ratios will you use to determine if the proposed plan is a success? The ratios that I will use to determine if the propsed plan is a success are the gross profit margin and the ROI ROE & the leverage ratio will play an important part in reflecting the liquidity leve
What other, nonfinancial, information did you use to put your plan together? The other nonfinancial information that I've used to put together my plan was proper feasibilty analysis and acquistion of competent intellectual assets Strategic planning will also be important to putting together my plan
Consider the assumptions made when completing Part 3. What assumptions are made? List the assumptions that you used to formulate this plan. The assumptions that were made was that my business has grown, sales are higher than previous years and my expenses have reduced My business will assume that the viability report will be acceptable and attract potential investors
Discuss the financial results from your Pro Forma projections. Include the net income results, breakeven analysis, and required expenses to commercialize your product or service. My net income improved in the 3-year period shooting to $2.52 Billion in Yr 3 from $616.1 million in Yr2. The expense needed is around $1.9 billion while the breakeven analysis stands around $605.1million
Explain how you would determine your pricing model. What seems most appropriate for your business and industry in which you will compete? In Yr 1 & 2, my business will make losses but will start making profits in year three because of sales increased My business intends to enter into the market slowly by offering high quality cosmetics at lower prices
Identify your cost structure. Is your business model cost-driven or value driven? Justify your selection. My business is value driven We want to be able to create satisfaction to our customers and sustain a long term relationship by retaining them and attracting new customers
Review your decision for a revenue model. Based on the financial statements, will this model generate a profit? Provide evidence to prove it.  Based on the financial statements, this model generates a profit. it generates profits in the long run because initially . Many of our customers are unaware of the value of our services; when they start to learn, they start increasing in numbers since higher sales as seen in Yr3 relative to Yr1 & 2
Where are you getting capital to meet your strategic initiative? What terms will be most likely deemed acceptable? I am getting capital from equity, potential investors and those who will be willing to join us as our shareholders My business will also seek grants from the government to help our start up plan
Did you have to reevaluate (go back) why? Yes I had to go back to reevaluate Some losses were too high which would have scared off investors

&"Verdana,Bold"Projected Financial Statment Analysis (3-Year Financial Plan).

12month P&L,Yr 1

Profit and Loss Statement
Instructions
Give careful thought to the headings.
Expand the sales income and expenses area if your business has distinct categories (e.g. a restaurant may have food sales and beverage sales listed separately and cost of sales for each also separated).
Month One Two Three Four Five Six Seven Eight Nine Ten Eleven Twelve
Income
Sales (Millions)
Sale of goods/services $ 100,854.00 $ 200,200.00 $ 200,200.00 $ 100,854.00 $ 225,400.00 $ 141,954.00 $ 200,400.00 $ 232,300.00 $ 245,500.00 $ 278,800.00 $ 278,800.00 $ 320,000.00
Sundry Income (e.g. Commission earned, frachise fees etc.) $ 3,000.00 $ 3,000.00 $ 3,500.00 $ 2,500.00 $ 3,000.00 $ 5,000.00 $ 4,000.00 $ 3,000.00 $ 6,000.00 $ 5,500.00 $ 5,500.00 $ 6,000.00
Etc. $ 2,500.00 $ 1,500.00 $ 2,000.00 $ 2,300.00 $ 1,800.00 $ 3,600.00 $ 2,500.00 $ 1,600.00 $ 2,600.00 $ 3,000.00 $ 3,500.00 $ 3,500.00
Total Sales $ 106,354.00 $ 204,700.00 $ 205,700.00 $ 105,654.00 $ 230,200.00 $ 150,554.00 $ 206,900.00 $ 236,900.00 $ 254,100.00 $ 287,300.00 $ 287,800.00 $ 329,500.00
Less Discounts/Commissions
Sales Discounts given $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00
Sales Commissions paid $ 100.00 $ 120.00 $ 120.00 $ 100.00 $ 140.00 $ 110.00 $ 160.00 $ 150.00 $ 160.00 $ 180.00 $ 180.00 $ 200.00
Total Discounts/ Commissions $ 125.00 $ 145.00 $ 145.00 $ 125.00 $ 165.00 $ 135.00 $ 185.00 $ 175.00 $ 185.00 $ 205.00 $ 205.00 $ 225.00
Total Net Income $ 106,229.00 $ 204,555.00 $ 205,555.00 $ 105,529.00 $ 230,035.00 $ 150,419.00 $ 206,715.00 $ 236,725.00 $ 253,915.00 $ 287,095.00 $ 287,595.00 $ 329,275.00
Cost of Sales
Opening Stock $ 222.00 $ 222.00 $ 222.00 $ 222.00 $ 223.00 $ 223.00 $ 222.00 $ 220.00 $ 222.00 $ 223.00 $ 223.00 $ 223.00
Stock Purchased $ 223.00 $ 223.00 $ 223.00 $ 223.00 $ 225.00 $ 225.00 $ 220.00 $ 220.00 $ 220.00 $ 220.00 $ 219.00 $ 223.00
$ 445.00 $ 445.00 $ 445.00 $ 445.00 $ 448.00 $ 448.00 $ 442.00 $ 440.00 $ 442.00 $ 443.00 $ 442.00 $ 446.00
Less Closing Stock $ 300.00 $ 300.00 $ 300.00 $ 250.00 $ 250.00 $ 250.00 $ 223.00 $ 250.00 $ 250.00 $ 210.00 $ 210.00 $ 223.00
Total Cost of Sales $ 145.00 $ 145.00 $ 145.00 $ 195.00 $ 198.00 $ 198.00 $ 219.00 $ 190.00 $ 192.00 $ 233.00 $ 232.00 $ 223.00
Gross Profit $ 106,084.00 $ 204,410.00 $ 205,410.00 $ 105,334.00 $ 229,837.00 $ 150,221.00 $ 206,496.00 $ 236,535.00 $ 253,723.00 $ 286,862.00 $ 287,363.00 $ 329,052.00
Expenses
General & Administrative
Bank charges $ 35.00 $ 35.00 $ 35.00 $ 35.00 $ 35.00 $ 35.00 $ 35.00 $ 35.00 $ 35.00 $ 35.00 $ 35.00 $ 35.00
Credit card commission $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00
Consultant fees $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00
Office Supplies $ 300.00 $ 250.00 $ 250.00 $ 300.00 $ 250.00 $ 200.00 $ 200.00 $ 300.00 $ 300.00 $ 250.00 $ 250.00 $ 220.00
License fees $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00
Business insurance $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00 $ 2,500.00
Etc. $ 500.00 $ 500.00 $ 500.00 $ 400.00 $ 400.00 $ 500.00 $ 300.00 $ 400.00 $ 500.00 $ 600.00 $ 300.00 $ 400.00
Total General & Administrative $ 4,035.00 $ 3,985.00 $ 3,985.00 $ 3,935.00 $ 3,885.00 $ 3,935.00 $ 3,735.00 $ 3,935.00 $ 4,035.00 $ 4,085.00 $ 3,785.00 $ 3,855.00
Marketing & Promotional
Advertising $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00
Promotion - General $ 50.00 $ 40.00 $ 40.00 $ 60.00 $ 52.00 $ 40.00 $ 50.00 $ 40.00 $ 60.00 $ 50.00 $ 75.00 $ 70.00
Promotion - Other $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Marketing & Promotional $ 150.00 $ 140.00 $ 140.00 $ 160.00 $ 152.00 $ 140.00 $ 150.00 $ 140.00 $ 160.00 $ 150.00 $ 175.00 $ 170.00
Operating Expenses
Newspapers & magazines $ 60.00 $ 54.00 $ 60.00 $ 58.00 $ 60.00 $ 58.00 $ 60.00 $ 60.00 $ 58.00 $ 60.00 $ 60.00 $ 60.00
Parking/Taxis/Tolls $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00
Entertainment/Meals $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00
Travel/Accomodation $ 1,200.00 $ 1,200.00 $ 1,200.00 $ 1,200.00 $ 1,275.00 $ 1,275.00 $ 1,350.00 $ 1,350.00 $ 1,500.00 $ 1,500.00 $ 1,750.00 $ 1,750.00
Laundry/dry cleaning $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 80.00
Cleaning & cleaning products $ 100.00 $ 100.00 $ 100.00 $ 120.00 $ 120.00 $ 120.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00
Sundry supplies $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ - 0
Equipment hire $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 75.00 $ 75.00 $ 75.00 $ 75.00 $ 75.00 $ 75.00
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Operating Expenses $ 2,085.00 $ 2,079.00 $ 2,085.00 $ 2,103.00 $ 2,180.00 $ 2,183.00 $ 2,265.00 $ 2,265.00 $ 2,413.00 $ 2,415.00 $ 2,665.00 $ 2,615.00
Motor Vehicle Expenses
Fuel $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 350.00 $ 350.00
Vehicle service costs $ 100.00 $ 100.00 $ 120.00 $ 120.00 $ 120.00 $ 120.00 $ 115.00 $ 155.00 $ 115.00 $ 155.00 $ 130.00 $ 130.00
Tyres & other replacement costs $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 54.00 $ 55.00 $ 75.00 $ 75.00 $ 60.00 $ 60.00 $ 60.00
Insurance $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00
Registrations $ 15.00 $ 15.00 $ 12.00 $ 12.00 $ 12.00 $ 12.00 $ 10.00 $ 10.00 $ 10.00 $ 11.00 $ 10.00 $ 10.00
Total Motor Vehicle Expenses $ 715.00 $ 715.00 $ 732.00 $ 732.00 $ 732.00 $ 736.00 $ 730.00 $ 790.00 $ 750.00 $ 776.00 $ 800.00 $ 800.00
Website Expenses
Domain name registration $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00 $ 30.00
Hosting expenses $ 45.00 $ 45.00 $ 45.00 $ 45.00 $ 45.00 $ 45.00 $ 45.00 $ 45.00 $ 45.00 $ 45.00 $ 45.00 $ 45.00
etc $ 20.00 $ 20.00 $ 20.00 $ 20.00 $ 25.00 $ 25.00 $ 25.00 $ 20.00 $ 30.00 $ 30.00 $ 35.00 $ 35.00
Total Website Expenses $ 95.00 $ 95.00 $ 95.00 $ 95.00 $ 100.00 $ 100.00 $ 100.00 $ 95.00 $ 105.00 $ 105.00 $ 110.00 $ 110.00
Employment Expenses
Permanent $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Salaries/Wages $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 100,000.00 $ 1,100,000.00
PAYE $ 50.00 $ 50.00 $ 50.25 $ 50.25 $ 50.25 $ 50.25 $ 50.25 $ 50.25 $ 50.25 $ 50.50 $ 50.50 $ 552.75
Superannuation $ 50.00 $ 50.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 170.00 $ 1,270.00
Other - Employee Benefits $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 1,650.00
Recruitment costs $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 1,100.00
Total Perm. Employment Expenses $ 100,350.00 $ 100,350.00 $ 100,400.25 $ 100,400.25 $ 100,400.25 $ 100,400.25 $ 100,450.25 $ 100,450.25 $ 100,450.25 $ 100,450.50 $ 100,470.50 $ 1,104,572.75
Casual
Salaries/Wages $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 50,000.00 $ 550,000.00
PAYE $ 50.00 $ 50.00 $ 50.25 $ 50.25 $ 50.25 $ 50.25 $ 50.25 $ 50.25 $ 50.25 $ 50.50 $ 50.50 $ 552.75
Superannuation $ 50.00 $ 50.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 170.00 $ 1,270.00
Other - Employee Benefits $ 200.00 $ 200.00 $ 200.00 $ 200.00 $ 200.00 $ 200.00 $ 200.00 $ 200.00 $ 200.00 $ 200.00 $ 200.00 $ 2,200.00
Recruitment costs $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 1,650.00
Total Casual Employment Expenses $ 50,450.00 $ 50,450.00 $ 50,500.25 $ 50,500.25 $ 50,500.25 $ 50,500.25 $ 50,550.25 $ 50,550.25 $ 50,550.25 $ 50,550.50 $ 50,570.50 $ 555,672.75
Workcover Insurance $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 50.00 $ 55.00 $ 55.00 $ 55.00 $ 55.00 $ 570.00
Total Employment Expenses $ 50,500.00 $ 50,500.00 $ 50,550.25 $ 50,550.25 $ 50,550.25 $ 50,550.25 $ 50,600.25 $ 50,605.25 $ 50,605.25 $ 50,605.50 $ 50,625.50 $ 556,242.75
Occupancy Costs
Electricity/Gas $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 600.00 $ 600.00 $ 550.00 $ 550.00 $ 570.00 $ 570.00 $ 550.00 $ 5,990.00
Telephones $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 12,500.00
Property Insurance $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 550.00 $ 550.00 $ 5,600.00
Rates $ 17.00 $ 17.00 $ 17.00 $ 17.00 $ 17.00 $ 17.00 $ 18.00 $ 18.00 $ 18.00 $ 17.00 $ 17.00 $ 190.00
Rent $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00 $ 3,500.00
Repair & maintenance $ 500.00 $ 500.00 $ 500.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 2,300.00
Waste removal $ 500.00 $ 500.00 $ 500.00 $ 350.00 $ 350.00 $ 350.00 $ 350.00 $ 350.00 $ 350.00 $ 350.00 $ 350.00 $ 4,300.00
Water $ 600.00 $ 600.00 $ 660.00 $ 650.00 $ 650.00 $ 650.00 $ 600.00 $ 550.00 $ 550.00 $ 500.00 $ 650.00 $ 6,660.00
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Occupancy Costs $ 7,617.00 $ 7,617.00 $ 7,677.00 $ 6,617.00 $ 6,717.00 $ 6,717.00 $ 6,618.00 $ 6,568.00 $ 6,588.00 $ 6,587.00 $ 6,717.00 $ 41,040.00
Other Expenses
Legal Fees $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Other Expenses $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 2,000.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00 $ 500.00
Total Expenses $ 166,047.00 $ 165,981.00 $ 166,164.50 $ 165,092.50 $ 166,716.50 $ 165,261.50 $ 165,148.50 $ 165,348.50 $ 165,606.50 $ 165,674.00 $ 165,848.00 $ 1,709,905.50
Month Net Profit / (Loss) -$ 59,963.00 $ 38,429.00 $ 39,245.50 -$ 59,758.50 $ 63,120.50 -$ 15,040.50 $ 41,347.50 $ 71,186.50 $ 88,116.50 $ 121,188.00 $ 121,515.00 -$ 1,380,853.50
Total Year to Date Net Profit / (Loss) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 -$ 931,467.00

Year 2 P&L

Profit and Loss Statement
Instructions
Give careful thought to the headings.
Expand the sales income and expenses area if your business has distinct categories (e.g. a restaurant may have food sales and beverage sales listed separately and cost of sales for each also separated).
Quarter One Two Three Four Annual total
Income
Sales (Millions)
Sale of goods/services $ 500,854.00 $ 468,208.00 $ 678,200.00 $ 877,600.00 $ 2,024,008.00
Sundry Income (e.g. Commission earned, frachise fees etc.) $ 9,500.00 $ 10,500.00 $ 13,000.00 $ 17,000.00 $ 40,500.00
Etc. $ 6,000.00 $ 7,700.00 $ 6,700.00 $ 10,000.00 $ 24,400.00
Total Sales $ 516,354.00 $ 486,408.00 $ 697,900.00 $ 904,600.00 $ 2,088,908.00
Less Discounts/Commissions
Sales Discounts given $ 75.00 $ 75.00 $ 75.00 $ 75.00 $ 225.00
Sales Commissions paid $ 340.00 $ 350.00 $ 470.00 $ 560.00 $ 1,380.00
Total Discounts/ Commissions $ 415.00 $ 425.00 $ 545.00 $ 635.00 $ 1,605.00
Total Net Income $ 515,939.00 $ 485,983.00 $ 697,355.00 $ 903,965.00 $ 2,087,303.00
Cost of Sales
Opening Stock $ 666.00 $ 668.00 $ 664.00 $ 669.00 $ 2,667.00
Stock Purchased $ 669.00 $ 673.00 $ 660.00 $ 662.00 $ 2,664.00
$ 1,335.00 $ 1,341.00 $ 1,324.00 $ 1,331.00 $ 5,331.00
Less Closing Stock $ 1,100.00 $ 1,100.00 $ 1,100.00 $ 1,100.00 $ 4,400.00
Total Cost of Sales $ 235.00 $ 241.00 $ 224.00 $ 231.00 $ 931.00
Gross Profit $ 515,704.00 $ 485,742.00 $ 697,131.00 $ 903,734.00 $ 2,602,311.00
Expenses
General & Administrative
Bank charges $ 105.00 $ 105.00 $ 105.00 $ 105.00 $ 315.00
Credit card commission $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 900.00
Consultant fees $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 900.00
Office Supplies $ 800.00 $ 750.00 $ 800.00 $ 720.00 $ 2,270.00
License fees $ 1,550.00 $ 1,550.00 $ 1,550.00 $ 1,550.00 $ 4,650.00
Business insurance $ 7,500.00 $ 7,500.00 $ 7,500.00 $ 7,500.00 $ 22,500.00
Etc. $ 1,500.00 $ 1,300.00 $ 1,200.00 $ 1,300.00 $ 3,800.00
Total General & Administrative $ 12,055.00 $ 11,805.00 $ 11,755.00 $ 11,775.00 $ 35,335.00
Marketing & Promotional
Advertising $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 900.00
Promotion - General $ 130.00 $ 152.00 $ 150.00 $ 195.00 $ 497.00
Promotion - Other $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Marketing & Promotional $ 430.00 $ 452.00 $ 450.00 $ 495.00 $ 1,827.00
Operating Expenses
Newspapers & magazines $ 174.00 $ 178.00 $ 178.00 $ 174.00 $ 702.00
Parking/Taxis/Tolls $ 150.00 $ 150.00 $ 150.00 $ 150.00 $ 360.00
Entertainment/Meals $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,200.00
Travel/Accomodation $ 3,600.00 $ 3,750.00 $ 4,200.00 $ 5,000.00 $ 670.00
Laundry/dry cleaning $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 1,140.00
Cleaning & cleaning products $ 300.00 $ 360.00 $ 300.00 $ 300.00 $ 620.00
Sundry supplies $ 75.00 $ 80.00 $ 90.00 $ 60.00 $ 410.00
Equipment hire $ 150.00 $ 150.00 $ 225.00 $ 225.00 $ 240.00
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Operating Expenses $ 6,249.00 $ 6,468.00 $ 6,943.00 $ 7,709.00 $ 27,369.00
Motor Vehicle Expenses
Fuel $ 900.00 $ 900.00 $ 900.00 $ 1,000.00 $ 2,800.00
Vehicle service costs $ 320.00 $ 360.00 $ 385.00 $ 415.00 $ 1,160.00
Tyres & other replacement costs $ 150.00 $ 154.00 $ 205.00 $ 180.00 $ 539.00
Insurance $ 750.00 $ 750.00 $ 750.00 $ 750.00 $ 2,250.00
Registrations $ 42.00 $ 36.00 $ 30.00 $ 31.00 $ 97.00
Total Motor Vehicle Expenses $ 2,162.00 $ 2,200.00 $ 2,270.00 $ 2,376.00 $ 6,846.00
Website Expenses
Domain name registration $ 90.00 $ 90.00 $ 90.00 $ 90.00 $ 270.00
Hosting expenses $ 135.00 $ 135.00 $ 135.00 $ 135.00 $ 405.00
etc $ 60.00 $ 70.00 $ 75.00 $ 100.00 $ 245.00
Total Website Expenses $ 285.00 $ 295.00 $ 300.00 $ 325.00 $ 920.00
Employment Expenses
Permanent $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Salaries/Wages $ 300,000.00 $ 300,000.00 $ 300,000.00 $ 300,000.00 $ 900,000.00
PAYE $ 150.25 $ 150.75 $ 150.75 $ 151.50 $ 453.00
Superannuation $ 200.00 $ 300.00 $ 450.00 $ 490.00 $ 1,240.00
Other - Employee Benefits $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 1,350.00
Recruitment costs $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 900.00
Total Perm. Employment Expenses $ 301,100.25 $ 301,200.75 $ 301,350.75 $ 301,391.50 $ 903,943.00
Casual
Salaries/Wages $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 450,000.00
PAYE $ 150.25 $ 150.75 $ 150.75 $ 151.50 $ 453.00
Superannuation $ 200.00 $ 300.00 $ 450.00 $ 470.00 $ 1,220.00
Other - Employee Benefits $ 600.00 $ 600.00 $ 600.00 $ 600.00 $ 1,800.00
Recruitment costs $ 450.00 $ 450.00 $ 450.00 $ 450.00 $ 1,350.00
Total Casual Employment Expenses $ 151,400.25 $ 151,500.75 $ 151,650.75 $ 151,671.50 $ 454,823.00
Workcover Insurance $ 150.00 $ 150.00 $ 160.00 $ 110.00 $ 420.00
Total Employment Expenses $ 151,550.25 $ 151,650.75 $ 151,810.75 $ 151,781.50 $ 910,066.00
Occupancy Costs
Electricity/Gas $ 1,500.00 $ 1,700.00 $ 1,670.00 $ 1,650.00 $ 5,020.00
Telephones $ 4,500.00 $ 3,000.00 $ 3,000.00 $ 3,000.00 $ 9,000.00
Property Insurance $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 4,500.00
Rates $ 51.00 $ 51.00 $ 54.00 $ 51.00 $ 156.00
Rent $ 10,500.00 $ 10,500.00 $ 10,500.00 $ 10,500.00 $ 31,500.00
Repair & maintenance $ 1,500.00 $ 300.00 $ 300.00 $ 300.00 $ 900.00
Waste removal $ 1,500.00 $ 1,050.00 $ 1,050.00 $ 1,050.00 $ 3,150.00
Water $ 1,860.00 $ 1,365.00 $ 1,700.00 $ 1,400.00 $ 4,465.00
Etc. $ 6.00 $ 6.00 $ 6.00 $ 6.00 $ 18.00
Total Occupancy Costs $ 22,917.00 $ 19,472.00 $ 19,780.00 $ 19,457.00 $ 58,709.00
Other Expenses
Legal Fees $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 6,000.00
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Other Expenses $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 6,000.00
Total Expenses $ 498,248.50 $ 495,043.50 $ 496,159.50 $ 496,810.00 $ 1,986,261.50
Month Net Profit / (Loss) $ 17,455.50 -$ 9,301.50 $ 200,971.50 $ 406,924.00 $ - 0
Total Year to Date Net Profit / (Loss) $ - 0 $ - 0 $ - 0 $ - 0 $ 616,049.50

Year 3 P&L

Profit and Loss Statement
Instructions
Give careful thought to the headings.
Expand the sales income and expenses area if your business has distinct categories (e.g. a restaurant may have food sales and beverage sales listed separately and cost of sales for each also separated).
Quarter One Two Three Four Annual total
Income
Sales (Millions)
Sale of goods/services $ 1,001,000.00 $ 935,416.00 $ 1,356,400.00 $ 1,755,200.00 $ 5,048,016.00
Sundry Income (e.g. Commission earned, frachise fees etc.) $ 9,500.00 $ 10,700.00 $ 13,800.00 $ 17,500.00 $ 51,500.00
Etc. $ 7,000.00 $ 7,900.00 $ 7,400.00 $ 11,500.00 $ 33,800.00
Total Sales $ 1,017,500.00 $ 954,016.00 $ 1,377,600.00 $ 1,784,200.00 $ 5,133,316.00
Less Discounts/Commissions
Sales Discounts given $ 80.00 $ 80.00 $ 80.00 $ 80.00 $ 320.00
Sales Commissions paid $ 350.00 $ 375.00 $ 500.00 $ 600.00 $ 1,825.00
Total Discounts/ Commissions $ 430.00 $ 455.00 $ 580.00 $ 680.00 $ 2,145.00
Total Net Income $ 1,017,070.00 $ 953,561.00 $ 1,377,020.00 $ 1,783,520.00 $ 5,131,171.00
Cost of Sales
Opening Stock $ 700.00 $ 770.00 $ 705.00 $ 705.00 $ 2,880.00
Stock Purchased $ 705.00 $ 775.00 $ 710.00 $ 710.00 $ 2,900.00
$ 1,405.00 $ 1,545.00 $ 1,415.00 $ 1,415.00 $ 5,780.00
Less Closing Stock $ 1,200.00 $ 1,200.00 $ 1,200.00 $ 1,200.00 $ 4,800.00
Total Cost of Sales $ 205.00 $ 345.00 $ 215.00 $ 215.00 $ 980.00
Gross Profit $ 1,016,865.00 $ 953,216.00 $ 1,376,805.00 $ 1,783,305.00 $ 5,130,191.00
Expenses
General & Administrative
Bank charges $ 100.00 $ 100.00 $ 100.00 $ 90.00 $ 390.00
Credit card commission $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 1,000.00
Consultant fees $ 300.00 $ 300.00 $ 300.00 $ 300.00 $ 1,200.00
Office Supplies $ 400.00 $ 400.00 $ 400.00 $ 400.00 $ 1,600.00
License fees $ 1,600.00 $ 1,600.00 $ 1,600.00 $ 1,600.00 $ 6,400.00
Business insurance $ 7,500.00 $ 7,500.00 $ 7,500.00 $ 7,500.00 $ 30,000.00
Etc. $ 1,200.00 $ 1,200.00 $ 1,300.00 $ 1,300.00 $ 5,000.00
Total General & Administrative $ 11,350.00 $ 11,350.00 $ 11,450.00 $ 11,440.00 $ - 0
Marketing & Promotional
Advertising $ 250.00 $ 250.00 $ 280.00 $ 280.00 $ 1,060.00
Promotion - General $ 200.00 $ 220.00 $ 220.00 $ 300.00 $ 940.00
Promotion - Other $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Marketing & Promotional $ 450.00 $ 470.00 $ 500.00 $ 580.00 $ 2,000.00
Operating Expenses
Newspapers & magazines $ 190.00 $ 190.00 $ 200.00 $ 200.00 $ 780.00
Parking/Taxis/Tolls $ 175.00 $ 175.00 $ 175.00 $ 175.00 $ 700.00
Entertainment/Meals $ 1,600.00 $ 1,600.00 $ 1,600.00 $ 1,600.00 $ 6,400.00
Travel/Accomodation $ 3,700.00 $ 3,800.00 $ 4,300.00 $ 5,500.00 $ 17,300.00
Laundry/dry cleaning $ 325.00 $ 325.00 $ 325.00 $ 325.00 $ 1,300.00
Cleaning & cleaning products $ 275.00 $ 275.00 $ 250.00 $ 250.00 $ 1,050.00
Sundry supplies $ 85.00 $ 100.00 $ 105.00 $ 80.00 $ 370.00
Equipment hire $ 175.00 $ 175.00 $ 230.00 $ 230.00 $ 810.00
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Operating Expenses $ 6,525.00 $ 6,640.00 $ 7,185.00 $ 8,360.00 $ 28,710.00
Motor Vehicle Expenses
Fuel $ 950.00 $ 950.00 $ 950.00 $ 1,250.00 $ 4,100.00
Vehicle service costs $ 350.00 $ 375.00 $ 395.00 $ 430.00 $ 1,550.00
Tyres & other replacement costs $ 200.00 $ 210.00 $ 300.00 $ 200.00 $ 910.00
Insurance $ 700.00 $ 700.00 $ 700.00 $ 700.00 $ 2,800.00
Registrations $ 45.00 $ 40.00 $ 35.00 $ 35.00 $ 155.00
Total Motor Vehicle Expenses $ 2,245.00 $ 2,275.00 $ 2,380.00 $ 2,615.00 $ 9,515.00
Website Expenses
Domain name registration $ 100.00 $ 100.00 $ 100.00 $ 100.00 $ 400.00
Hosting expenses $ 110.00 $ 110.00 $ 100.00 $ 100.00 $ 420.00
etc $ 75.00 $ 70.00 $ 80.00 $ 60.00 $ 285.00
Total Website Expenses $ 285.00 $ 280.00 $ 280.00 $ 260.00 $ 1,105.00
Employment Expenses
Permanent $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Salaries/Wages $ 300,000.00 $ 300,000.00 $ 300,000.00 $ 300,000.00 $ 1,200,000.00
PAYE $ 155.00 $ 155.00 $ 156.00 $ 156.00 $ 622.00
Superannuation $ 250.00 $ 330.00 $ 475.00 $ 500.00 $ 1,555.00
Other - Employee Benefits $ 455.00 $ 455.00 $ 455.00 $ 455.00 $ 1,820.00
Recruitment costs $ 175.00 $ 175.00 $ 175.00 $ 175.00 $ 700.00
Total Perm. Employment Expenses $ 301,035.00 $ 301,115.00 $ 301,261.00 $ 301,286.00 $ 1,204,697.00
Casual
Salaries/Wages $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 150,000.00 $ 600,000.00
PAYE $ 155.00 $ 155.00 $ 156.00 $ 156.00 $ 622.00
Superannuation $ 210.00 $ 310.00 $ 400.00 $ 410.00 $ 1,330.00
Other - Employee Benefits $ 625.00 $ 625.00 $ 625.00 $ 625.00 $ 2,500.00
Recruitment costs $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 1,000.00
Total Casual Employment Expenses $ 151,240.00 $ 151,340.00 $ 151,431.00 $ 151,441.00
Workcover Insurance $ 175.00 $ 175.00 $ 175.00 $ 175.00 $ 700.00
Total Employment Expenses $ 151,415.00 $ 151,515.00 $ 151,606.00 $ 151,616.00 $ 606,152.00
Occupancy Costs
Electricity/Gas $ 1,550.00 $ 1,575.00 $ 1,675.00 $ 1,700.00 $ 6,500.00
Telephones $ 4,300.00 $ 3,750.00 $ 3,750.00 $ 3,750.00 $ 15,550.00
Property Insurance $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 6,000.00
Rates $ 55.00 $ 55.00 $ 60.00 $ 60.00 $ 230.00
Rent $ 10,500.00 $ 10,500.00 $ 10,500.00 $ 10,500.00 $ 42,000.00
Repair & maintenance $ 1,000.00 $ 500.00 $ 400.00 $ 300.00 $ 2,200.00
Waste removal $ 1,050.00 $ 1,000.00 $ 1,000.00 $ 1,000.00 $ 4,050.00
Water $ 1,800.00 $ 1,300.00 $ 1,500.00 $ 1,300.00 $ 5,900.00
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Occupancy Costs $ 21,755.00 $ 20,180.00 $ 20,385.00 $ 20,110.00 $ 82,430.00
Other Expenses
Legal fees $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 6,000.00
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Other Expenses $ 1,500.00 $ 1,500.00 $ 1,500.00 $ 1,500.00 $ - 0
Total Expenses $ 496,560.00 $ 495,325.00 $ 496,547.00 $ 497,767.00 $ 1,986,199.00
Month Net Profit / (Loss) $ 520,305.00 $ 457,891.00 $ 880,258.00 $ 1,285,538.00 $ - 0
Total Year to Date Net Profit / (Loss) $ - 0 $ - 0 $ - 0 $ - 0 $ 3,143,992.00