MGT-660 Part 6
mike9148
MGT-660Week6-StrategicPlanPartVMichaelWallace.xlsxQuestions
| Questions | Response | Additional considerations |
| What is the vital financial information needed to determine the viability of your plan ? | Information on other financial statements. Consider projections of a balance sheet and cash flow statements. | |
| What ratios will you use to determine if the proposed plan is a success? | Liquidity and profitability ratios | |
| What other, nonfinancial, information did you use to put your plan together? | Market data, the demand for our services, and general economic conditions. | |
| 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 are made are the business has grown, its sales are higher than the previous years and expenses are reduced. | |
| 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. | The information is found on the financial statements. Consider projections of a balance sheet and cash flow statements. | |
| Explain how you would determine your pricing model. What seems most appropriate for your business and industry in which you will compete? | In year one and two the business will take losses but also start making profits in year three. This is because its sales would have increased relative to its expenses. | |
| Identify your cost structure. Is your business model cost-driven or value driven? Justify your selection. | It is value driven because we want to create satisfaction to our customers and a long term relationship to retaining them and attracting others. | |
| Review your decision for a revenue model. Based on the financial statements, will this model generate a profit? Provide evidence to prove it. | Yes, it will generate profits in the long run because initially many customers are unaware of the value of our services but when we start taking parts of the market sales will increase as seen in year three and relative to year one and two. | |
| Where are you getting capital to meet your strategic initiative? What terms will be most likely deemed acceptable? | I will borrow the capital. I must have a good business plan to be deemed acceptable. | |
| Did you have to reevaluate (go back) why? | Yes, because some of the losses would push investors away. | |
&"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 | ||||||||||||
| Sale of goods/services | $ 1,000.00 | $ 1,200.00 | $ 1,200.00 | $ 1,000.00 | $ 1,400.00 | $ 1,100.00 | $ 1,600.00 | $ 1,500.00 | $ 1,600.00 | $ 1,800.00 | $ 1,800.00 | $ 2,000.00 |
| Sundry Income (e.g. Commission earned, frachise fees etc.) | $ 300.00 | $ 400.00 | $ 400.00 | $ 250.00 | $ 300.00 | $ 500.00 | $ 400.00 | $ 300.00 | $ 600.00 | $ 500.00 | $ 550.00 | $ 600.00 |
| Etc. | $ 250.00 | $ 150.00 | $ 200.00 | $ 230.00 | $ 180.00 | $ 360.00 | $ 250.00 | $ 160.00 | $ 260.00 | $ 300.00 | $ 350.00 | $ 350.00 |
| Total Sales | $ 1,550.00 | $ 1,750.00 | $ 1,800.00 | $ 1,480.00 | $ 1,880.00 | $ 1,960.00 | $ 2,250.00 | $ 1,960.00 | $ 2,460.00 | $ 2,600.00 | $ 2,700.00 | $ 2,930.00 |
| Less Discounts/Commissions | ||||||||||||
| Sales Discounts given | $ 50.00 | $ 80.00 | $ 50.00 | $ 30.00 | $ 80.00 | $ 60.00 | $ 150.00 | $ 90.00 | $ 40.00 | $ 250.00 | $ 300.00 | $ 230.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 | $ 150.00 | $ 200.00 | $ 170.00 | $ 130.00 | $ 220.00 | $ 170.00 | $ 310.00 | $ 210.00 | $ 200.00 | $ 430.00 | $ 480.00 | $ 430.00 |
| Total Net Income | $ 1,400.00 | $ 1,550.00 | $ 1,630.00 | $ 1,350.00 | $ 1,660.00 | $ 1,790.00 | $ 1,940.00 | $ 1,750.00 | $ 2,260.00 | $ 2,170.00 | $ 2,220.00 | $ 2,500.00 |
| Cost of Sales | ||||||||||||
| Opening Stock | $ 700.00 | $ 750.00 | $ 850.00 | $ 500.00 | $ 800.00 | $ 650.00 | $ 500.00 | $ 750.00 | $ 900.00 | $ 850.00 | $ 900.00 | $ 1,200.00 |
| Stock Purchased | $ 850.00 | $ 900.00 | $ 600.00 | $ 900.00 | $ 900.00 | $ 750.00 | $ 1,050.00 | $ 950.00 | $ 1,200.00 | $ 1,200.00 | $ 1,350.00 | $ 700.00 |
| $ 1,550.00 | $ 1,650.00 | $ 1,450.00 | $ 1,400.00 | $ 1,700.00 | $ 1,400.00 | $ 1,550.00 | $ 1,700.00 | $ 2,100.00 | $ 2,050.00 | $ 2,250.00 | $ 1,900.00 | |
| Less Closing Stock | $ 750.00 | $ 850.00 | $ 500.00 | $ 800.00 | $ 650.00 | $ 500.00 | $ 750.00 | $ 900.00 | $ 850.00 | $ 900.00 | $ 1,200.00 | $ 800.00 |
| Total Cost of Sales | $ 800.00 | $ 800.00 | $ 950.00 | $ 600.00 | $ 1,050.00 | $ 900.00 | $ 800.00 | $ 800.00 | $ 1,250.00 | $ 1,150.00 | $ 1,050.00 | $ 1,100.00 |
| Gross Profit | $ 600.00 | $ 750.00 | $ 680.00 | $ 750.00 | $ 510.00 | $ 890.00 | $ 1,140.00 | $ 950.00 | $ 1,010.00 | $ 1,020.00 | $ 1,170.00 | $ 1,400.00 |
| Expenses | ||||||||||||
| General & Administrative | ||||||||||||
| Bank charges | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 30.00 | $ 20.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 |
| Credit card commission | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 60.00 | $ 50.00 | $ 60.00 | $ 60.00 | $ 60.00 | $ 60.00 |
| Consultant fees | $ 100.00 | $ 90.00 | $ 80.00 | $ 50.00 | $ 50.00 | $ 100.00 | $ 60.00 | $ 90.00 | $ 80.00 | $ 70.00 | $ 90.00 | $ 100.00 |
| Office Supplies | $ 10.00 | $ 8.00 | $ 5.00 | $ 10.00 | $ 8.00 | $ 5.00 | $ 10.00 | $ 7.00 | $ 8.00 | $ 6.00 | $ 9.00 | $ 10.00 |
| License fees | $ 5.00 | $ 5.00 | $ 5.00 | $ 5.00 | $ 5.00 | $ 5.00 | $ 5.00 | $ 5.00 | $ 5.00 | $ 5.00 | $ 5.00 | $ 5.00 |
| Business insurance | $ 10.00 | $ 10.00 | $ 10.00 | $ 10.00 | $ 10.00 | $ 10.00 | $ 10.00 | $ 10.00 | $ 10.00 | $ 10.00 | $ 10.00 | $ 10.00 |
| Etc. | $ 2.00 | $ 5.00 | $ 3.00 | $ 4.00 | $ 5.00 | $ 8.00 | $ 3.00 | $ 4.00 | $ 5.00 | $ 6.00 | $ 3.00 | $ 4.00 |
| Total General & Administrative | $ 197.00 | $ 188.00 | $ 173.00 | $ 149.00 | $ 148.00 | $ 198.00 | $ 178.00 | $ 186.00 | $ 198.00 | $ 187.00 | $ 207.00 | $ 219.00 |
| Marketing & Promotional | ||||||||||||
| Advertising | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 55.00 | $ 60.00 | $ 60.00 | $ 65.00 | $ 65.00 | $ 65.00 | $ 64.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. | $ 20.00 | $ 25.00 | $ 30.00 | $ 24.00 | $ 30.00 | $ 20.00 | $ 15.00 | $ 24.00 | $ 32.00 | $ 22.00 | $ 33.00 | $ 31.00 |
| Total Marketing & Promotional | $ 120.00 | $ 115.00 | $ 120.00 | $ 134.00 | $ 132.00 | $ 115.00 | $ 125.00 | $ 124.00 | $ 157.00 | $ 137.00 | $ 173.00 | $ 165.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 | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 |
| Entertainment/Meals | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 10.00 | $ 100.00 | $ 100.00 | $ 100.00 |
| Travel/Accomodation | $ 50.00 | $ 50.00 | $ 40.00 | $ 60.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 50.00 | $ 55.00 | $ 60.00 | $ 50.00 | $ 90.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 | $ 30.00 | $ 50.00 | $ 40.00 | $ 30.00 | $ 40.00 | $ 50.00 | $ 30.00 | $ 40.00 | $ 50.00 | $ 50.00 | $ 30.00 | $ 80.00 |
| Sundry supplies | $ 20.00 | $ 30.00 | $ 20.00 | $ 60.00 | $ 50.00 | $ 40.00 | $ 40.00 | $ 60.00 | $ 30.00 | $ 20.00 | $ 20.00 | $ - 0 |
| Equipment hire | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 |
| Etc. | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Operating Expenses | $ 410.00 | $ 434.00 | $ 410.00 | $ 458.00 | $ 450.00 | $ 448.00 | $ 430.00 | $ 460.00 | $ 353.00 | $ 440.00 | 410 | $ 460.00 |
| Motor Vehicle Expenses | ||||||||||||
| Fuel | $ 30.00 | $ 20.00 | $ 15.00 | $ 25.00 | $ 35.00 | $ 30.00 | $ 25.00 | $ 18.00 | $ 30.00 | $ 30.00 | $ 28.00 | $ 15.00 |
| Vehicle service costs | $ 10.00 | $ 8.00 | $ 12.00 | $ 8.00 | $ 10.00 | $ 8.00 | $ 9.00 | $ 11.00 | $ 10.00 | $ 12.00 | $ 9.00 | $ 10.00 |
| Tyres & other replacement costs | $ 2.00 | $ 7.00 | $ 3.00 | $ 6.00 | $ 7.00 | $ 8.00 | $ 6.00 | $ 2.00 | $ 5.00 | $ 7.00 | $ 6.00 | $ 4.00 |
| Insurance | $ 45.00 | $ 30.00 | $ 25.00 | $ 15.00 | $ 30.00 | $ 20.00 | $ 15.00 | $ 25.00 | $ 40.00 | $ 30.00 | $ 16.00 | $ 25.00 |
| Registrations | $ 3.00 | $ 2.00 | $ 1.00 | $ 2.00 | $ 3.00 | $ 3.00 | $ 2.00 | $ 1.00 | $ 1.00 | $ 2.00 | $ 2.00 | $ 3.00 |
| Total Motor Vehicle Expenses | $ 90.00 | 67 | $ 56.00 | $ 56.00 | $ 85.00 | $ 69.00 | $ 57.00 | $ 57.00 | $ 86.00 | $ 81.00 | 61 | $ 57.00 |
| Website Expenses | ||||||||||||
| Domain name registration | $ 20.00 | $ 25.00 | $ 30.00 | $ 28.00 | $ 32.00 | $ 30.00 | $ 25.00 | $ 28.00 | $ 30.00 | $ 32.00 | $ 19.00 | $ 32.00 |
| Hosting expenses | $ 10.00 | $ 18.00 | $ 25.00 | $ 13.00 | $ 20.00 | $ 26.00 | $ 16.00 | $ 30.00 | $ 32.00 | $ 28.00 | $ 15.00 | $ 14.00 |
| etc | $ 15.00 | $ 10.00 | $ 25.00 | $ 12.00 | $ 30.00 | $ 23.00 | $ 14.00 | $ 16.00 | $ 18.00 | $ 27.00 | $ 18.00 | $ 12.00 |
| Total Website Expenses | $ 45.00 | $ 53.00 | $ 80.00 | $ 53.00 | $ 82.00 | $ 79.00 | $ 55.00 | $ 74.00 | $ 80.00 | $ 87.00 | $ 52.00 | $ 58.00 |
| Employment Expenses | ||||||||||||
| Permanent | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Salaries/Wages | $ 150.00 | $ 155.00 | $ 154.00 | $ 152.00 | $ 153.00 | $ 150.00 | $ 150.00 | $ 150.00 | $ 152.00 | $ 152.00 | $ 153.00 | $ 154.00 |
| PAYE | $ 45.00 | $ 46.50 | $ 46.20 | $ 45.60 | $ 49.50 | $ 45.00 | $ 45.00 | $ 45.00 | $ 45.60 | $ 45.60 | $ 45.90 | $ 46.20 |
| Superannuation | $ 5.00 | $ 7.00 | $ 6.00 | $ 5.00 | $ 5.00 | $ 6.00 | $ 7.00 | $ 5.00 | $ 6.00 | $ 7.00 | $ 5.00 | $ 6.00 |
| Other - Employee Benefits | $ 10.00 | $ 12.00 | $ 14.00 | $ 16.00 | $ 10.00 | $ 11.00 | $ 12.00 | $ 13.00 | $ 14.00 | $ 15.00 | $ 16.00 | $ 12.00 |
| Recruitment costs | $ 5.00 | $ 6.00 | $ 7.00 | $ 8.00 | $ 9.00 | $ 10.00 | $ 9.00 | $ 8.00 | $ 7.00 | $ 6.00 | $ 5.00 | $ 5.00 |
| Total Perm. Employment Expenses | 215 | 227 | 227 | 227 | 227 | 222 | 223 | 221 | 225 | 226 | 225 | 223 |
| Casual | ||||||||||||
| Salaries/Wages | $ 50.00 | $ 55.00 | $ 40.00 | $ 45.00 | $ 50.00 | $ 55.00 | $ 60.00 | $ 45.00 | $ 50.00 | $ 55.00 | $ 60.00 | $ 55.00 |
| PAYE | $ 15.00 | $ 17.00 | $ 12.00 | $ 13.00 | $ 15.00 | $ 17.00 | $ 20.00 | $ 14.00 | $ 15.00 | $ 17.00 | $ 20.00 | $ 17.00 |
| Superannuation | $ 3.00 | $ 2.00 | $ 1.00 | $ 1.00 | $ 2.00 | $ 3.00 | $ 3.00 | $ 2.00 | $ 1.00 | $ 1.00 | $ 2.00 | $ 3.00 |
| Other - Employee Benefits | $ 7.00 | $ 8.00 | $ 6.00 | $ 3.00 | $ 5.00 | $ 8.00 | $ 5.00 | $ 6.00 | $ 4.00 | $ 3.00 | $ 5.00 | $ 7.00 |
| Recruitment costs | $ 1.00 | $ 2.00 | $ 3.00 | $ 1.00 | $ 2.00 | $ 3.00 | $ 1.00 | $ 2.00 | $ 3.00 | $ 1.00 | $ 2.00 | $ 3.00 |
| Total Casual Employment Expenses | $ 76.00 | $ 84.00 | $ 62.00 | $ 63.00 | $ 74.00 | $ 86.00 | $ 89.00 | $ 69.00 | $ 73.00 | $ 77.00 | $ 89.00 | $ 85.00 |
| Workcover Insurance | $ 45.00 | $ 53.00 | $ 42.00 | $ 55.00 | $ 43.00 | $ 52.00 | $ 55.00 | $ 54.00 | $ 55.00 | $ 50.00 | $ 54.00 | $ 50.00 |
| Total Employment Expenses | $ 121.00 | $ 137.00 | $ 104.00 | $ 118.00 | $ 117.00 | $ 138.00 | $ 144.00 | $ 123.00 | $ 128.00 | $ 127.00 | $ 143.00 | $ 135.00 |
| Occupancy Costs | ||||||||||||
| Electricity/Gas | $ 25.00 | $ 20.00 | $ 19.00 | $ 22.00 | $ 25.00 | $ 27.00 | $ 24.00 | $ 25.00 | $ 26.00 | $ 23.00 | $ 24.00 | $ 27.00 |
| Telephones | $ 4.00 | $ 5.00 | $ 6.00 | $ 4.00 | $ 5.00 | $ 6.00 | $ 6.00 | $ 5.00 | $ 4.00 | $ 4.00 | $ 5.00 | $ 6.00 |
| Property Insurance | $ 30.00 | $ 35.00 | $ 36.00 | $ 34.00 | $ 37.00 | $ 38.00 | $ 39.00 | $ 34.00 | $ 36.00 | $ 38.00 | $ 36.00 | $ 34.00 |
| Rates | $ 17.00 | $ 18.00 | $ 19.00 | $ 17.00 | $ 18.00 | $ 19.00 | $ 17.00 | $ 18.00 | $ 19.00 | $ 17.00 | $ 18.00 | $ 19.00 |
| Rent | $ 28.00 | $ 28.00 | $ 28.00 | $ 28.00 | $ 28.00 | $ 28.00 | $ 28.00 | $ 28.00 | $ 28.00 | $ 28.00 | $ 28.00 | $ 28.00 |
| Repair & maintenance | $ 8.00 | $ 9.00 | $ 7.00 | $ 9.00 | $ 8.00 | $ 7.00 | $ 8.00 | $ 9.00 | $ 7.00 | $ 8.00 | $ 9.00 | $ 8.00 |
| Waste removal | $ 2.00 | $ 3.00 | $ 2.00 | $ 3.00 | $ 2.00 | $ 3.00 | $ 4.00 | $ 2.00 | $ 3.00 | $ 2.00 | $ 3.00 | $ 2.00 |
| Water | $ 5.00 | $ 4.00 | $ 3.00 | $ 3.00 | $ 4.00 | $ 5.00 | $ 5.00 | $ 3.00 | $ 4.00 | $ 5.00 | $ 3.00 | $ 3.00 |
| Etc. | $ 3.00 | $ 1.00 | $ 2.00 | $ 2.00 | $ 1.00 | $ 2.00 | $ 3.00 | $ 1.00 | $ 2.00 | $ 3.00 | $ 2.00 | $ 3.00 |
| Total Occupancy Costs | $ 122.00 | $ 123.00 | $ 122.00 | $ 122.00 | $ 128.00 | $ 135.00 | $ 134.00 | $ 125.00 | $ 129.00 | $ 128.00 | $ 128.00 | $ 130.00 |
| Other Expenses | ||||||||||||
| Legal fees | $ 20.00 | $ 30.00 | $ 25.00 | $ 30.00 | $ 20.00 | $ 35.00 | $ 20.00 | $ 42.00 | $ 30.00 | $ 25.00 | $ 30.00 | $ 20.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 | $ 20.00 | $ 30.00 | $ 25.00 | $ 30.00 | $ 20.00 | $ 35.00 | $ 20.00 | $ 42.00 | $ 30.00 | $ 25.00 | $ 30.00 | $ 20.00 |
| Total Expenses | $ 1,340.00 | $ 1,374.00 | $ 1,317.00 | $ 1,347.00 | $ 1,389.00 | $ 1,439.00 | $ 1,366.00 | $ 1,412.00 | $ 1,386.00 | $ 1,438.00 | $ 1,429.00 | $ 1,467.00 |
| Month Net Profit / (Loss) | -$ 740.00 | -$ 624.00 | -$ 637.00 | -$ 597.00 | -$ 879.00 | -$ 549.00 | -$ 226.00 | -$ 462.00 | -$ 376.00 | -$ 418.00 | -$ 259.00 | -$ 67.00 |
| Total Year to Date Net Profit / (Loss) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | -$ 5,834.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 | |||||
| Sale of goods/services | $ 5,000.00 | $ 6,500.00 | $ 7,200.00 | $ 8,200.00 | $ 21,900.00 |
| Sundry Income (e.g. Commission earned, frachise fees etc.) | $ 1,500.00 | $ 1,550.00 | $ 1,920.00 | $ 2,013.00 | $ 5,483.00 |
| Etc. | $ 500.00 | $ 630.00 | $ 920.00 | $ 1,020.00 | $ 2,570.00 |
| Total Sales | 7,000 | 8,680 | 10,040 | 11,233 | 36,953 |
| Less Discounts/Commissions | |||||
| Sales Discounts given | $ 200.00 | $ 210.00 | $ 180.00 | $ 230.00 | $ 620.00 |
| Sales Commissions paid | $ 500.00 | $ 400.00 | $ 520.00 | $ 710.00 | $ 1,630.00 |
| Total Discounts/ Commissions | $ 700.00 | $ 610.00 | $ 700.00 | $ 940.00 | $ 2,250.00 |
| Total Net Income | $ 6,300.00 | $ 8,060.00 | $ 9,340.00 | $ 10,293.00 | $ 27,693.00 |
| Cost of Sales | |||||
| Opening Stock | $ 2,450.00 | $ 2,550.00 | $ 2,700.00 | $ 2,840.00 | $ 10,540.00 |
| Stock Purchased | $ 1,500.00 | $ 1,650.00 | $ 1,720.00 | $ 1,800.00 | $ 5,170.00 |
| $ 3,950.00 | $ 4,200.00 | $ 4,420.00 | $ 4,640.00 | $ 13,260.00 | |
| Less Closing Stock | $ 2,550.00 | $ 2,700.00 | $ 2,840.00 | $ 2,920.00 | $ 8,460.00 |
| Total Cost of Sales | $ 5,350.00 | $ 5,700.00 | $ 6,000.00 | $ 6,360.00 | $ 18,060.00 |
| Gross Profit | $ 950.00 | $ 2,360.00 | $ 3,340.00 | $ 3,933.00 | $ 10,583.00 |
| Expenses | |||||
| General & Administrative | |||||
| Bank charges | $ 50.00 | $ 50.00 | $ 90.00 | $ 90.00 | $ 230.00 |
| Credit card commission | $ 130.00 | $ 140.00 | $ 150.00 | $ 120.00 | $ 410.00 |
| Consultant fees | $ 210.00 | $ 200.00 | $ 230.00 | $ 216.00 | $ 646.00 |
| Office Supplies | $ 15.00 | $ 15.00 | $ 24.00 | $ 30.00 | $ 69.00 |
| License fees | $ 14.00 | $ 15.00 | $ 16.00 | $ 17.00 | $ 48.00 |
| Business insurance | $ 30.00 | $ 20.00 | $ 30.00 | $ 30.00 | $ 80.00 |
| Etc. | $ 10.00 | $ 24.00 | $ 15.00 | $ 12.00 | $ 51.00 |
| Total General & Administrative | $ 459.00 | $ 464.00 | $ 555.00 | $ 515.00 | |
| Marketing & Promotional | |||||
| Advertising | $ 150.00 | $ 150.00 | $ 180.00 | $ 176.00 | $ 506.00 |
| Promotion - General | $ 130.00 | $ 120.00 | $ 200.00 | $ 200.00 | $ 520.00 |
| Promotion - Other | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Etc. | $ 90.00 | $ 60.00 | $ 96.00 | $ 93.00 | $ 249.00 |
| Total Marketing & Promotional | $ 370.00 | $ 330.00 | $ 476.00 | $ 469.00 | |
| Operating Expenses | |||||
| Newspapers & magazines | $ 170.00 | $ 172.00 | $ 180.00 | $ 180.00 | $ 702.00 |
| Parking/Taxis/Tolls | $ 90.00 | $ 90.00 | $ 90.00 | $ 90.00 | $ 360.00 |
| Entertainment/Meals | $ 300.00 | $ 300.00 | $ 300.00 | $ 300.00 | $ 1,200.00 |
| Travel/Accomodation | $ 120.00 | $ 150.00 | $ 150.00 | $ 250.00 | $ 670.00 |
| Laundry/dry cleaning | $ 300.00 | $ 300.00 | $ 300.00 | $ 240.00 | $ 1,140.00 |
| Cleaning & cleaning products | $ 110.00 | $ 150.00 | $ 150.00 | $ 210.00 | $ 620.00 |
| Sundry supplies | $ 70.00 | $ 120.00 | $ 100.00 | $ 120.00 | $ 410.00 |
| Equipment hire | $ 60.00 | $ 60.00 | $ 60.00 | $ 60.00 | $ 240.00 |
| Etc. | |||||
| Total Operating Expenses | $ 1,220.00 | $ 1,342.00 | $ 1,330.00 | $ 1,450.00 | |
| Motor Vehicle Expenses | |||||
| Fuel | $ 50.00 | $ 90.00 | $ 90.00 | $ 50.00 | $ 230.00 |
| Vehicle service costs | $ 36.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 90.00 |
| Tyres & other replacement costs | $ 10.00 | $ 25.00 | $ 20.00 | $ 20.00 | $ 65.00 |
| Insurance | $ 80.00 | $ 60.00 | $ 100.00 | $ 90.00 | $ 250.00 |
| Registrations | $ 4.00 | $ 9.00 | $ 3.00 | $ 9.00 | $ 21.00 |
| Total Motor Vehicle Expenses | $ 180.00 | $ 214.00 | $ 243.00 | $ 199.00 | |
| Website Expenses | |||||
| Domain name registration | $ 100.00 | $ 100.00 | $ 100.00 | $ 110.00 | $ 310.00 |
| Hosting expenses | $ 75.00 | $ 80.00 | $ 95.00 | $ 75.00 | $ 250.00 |
| etc | $ 75.00 | $ 69.00 | $ 56.00 | $ 40.00 | $ 165.00 |
| Total Website Expenses | $ 250.00 | $ 249.00 | $ 251.00 | $ 225.00 | |
| Employment Expenses | |||||
| Permanent | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Salaries/Wages | $ 750.00 | $ 750.00 | $ 760.00 | $ 850.00 | $ 2,360.00 |
| PAYE | $ 135.00 | $ 130.00 | $ 140.00 | $ 130.00 | $ 400.00 |
| Superannuation | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 | $ 60.00 |
| Other - Employee Benefits | $ 43.00 | $ 33.00 | $ 44.00 | $ 25.00 | $ 102.00 |
| Recruitment costs | $ 21.00 | $ 30.00 | $ 21.00 | $ 15.00 | $ 66.00 |
| Total Perm. Employment Expenses | 969 | 963 | 985 | 1,040 | |
| Casual | |||||
| Salaries/Wages | $ 120.00 | $ 150.00 | $ 150.00 | $ 160.00 | $ 460.00 |
| PAYE | $ 36.00 | $ 54.00 | $ 45.00 | $ 54.00 | $ 153.00 |
| Superannuation | $ 3.00 | $ 9.00 | $ 3.00 | $ 9.00 | $ 21.00 |
| Other - Employee Benefits | $ 20.00 | $ 25.00 | $ 20.00 | $ 21.00 | $ 66.00 |
| Recruitment costs | $ 9.00 | $ 9.00 | $ 9.00 | $ 9.00 | $ 27.00 |
| Total Casual Employment Expenses | $ 188.00 | $ 247.00 | $ 227.00 | $ 253.00 | |
| Workcover Insurance | $ 120.00 | $ 130.00 | $ 123.00 | $ 125.00 | $ 378.00 |
| Total Employment Expenses | $ 120.00 | $ 130.00 | $ 123.00 | $ 125.00 | |
| Occupancy Costs | |||||
| Electricity/Gas | $ 60.00 | $ 90.00 | $ 75.00 | $ 84.00 | $ 249.00 |
| Telephones | $ 18.00 | $ 18.00 | $ 12.00 | $ 18.00 | $ 48.00 |
| Property Insurance | $ 125.00 | $ 116.00 | $ 105.00 | $ 115.00 | $ 336.00 |
| Rates | $ 20.00 | $ 60.00 | $ 53.00 | $ 52.00 | $ 165.00 |
| Rent | $ 84.00 | $ 87.00 | $ 87.00 | $ 87.00 | $ 261.00 |
| Repair & maintenance | $ 21.00 | $ 21.00 | $ 21.00 | $ 24.00 | $ 66.00 |
| Waste removal | $ 6.00 | $ 9.00 | $ 9.00 | $ 6.00 | $ 24.00 |
| Water | $ 9.00 | $ 15.00 | $ 12.00 | $ 9.00 | $ 36.00 |
| Etc. | $ 6.00 | $ 6.00 | $ 6.00 | $ 6.00 | $ 18.00 |
| Total Occupancy Costs | $ 349.00 | $ 422.00 | $ 380.00 | $ 401.00 | |
| Other Expenses | |||||
| legal | $ 75.00 | $ 115.00 | $ 90.00 | $ 60.00 | $ 265.00 |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Other Expenses | $ 75.00 | $ 115.00 | $ 90.00 | $ 60.00 | $ 340.00 |
| Total Expenses | $ 3,992.00 | $ 4,929.00 | $ 4,433.00 | $ 4,484.00 | |
| Month Net Profit / (Loss) | -$ 3,042.00 | -$ 2,569.00 | -$ 1,093.00 | (-551) | |
| Total Year to Date Net Profit / (Loss) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | -$ 7,255.00 |
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 | |||||
| Sale of goods/services | $ 10,000.00 | $ 13,000.00 | $ 15,000.00 | $ 17,000.00 | $ 55,000.00 |
| Sundry Income (e.g. Commission earned, frachise fees etc.) | $ 1,550.00 | $ 1,750.00 | $ 1,523.00 | $ 1,863.00 | $ 6,686.00 |
| Etc. | $ 1,000.00 | $ 1,300.00 | $ 1,800.00 | $ 2,500.00 | $ 6,600.00 |
| Total Sales | 12,550 | 16,050 | 18,323 | 21,363 | |
| Less Discounts/Commissions | |||||
| Sales Discounts given | $ 180.00 | $ 200.00 | $ 150.00 | $ 250.00 | $ 780.00 |
| Sales Commissions paid | $ 350.00 | $ 410.00 | $ 550.00 | $ 700.00 | $ 2,010.00 |
| Total Discounts/ Commissions | $ 530.00 | $ 610.00 | $ 700.00 | $ 950.00 | |
| Total Net Income | $ 12,020.00 | $ 15,440.00 | $ 17,623.00 | $ 20,413.00 | |
| Cost of Sales | |||||
| Opening Stock | $ 2,920.00 | $ 2,400.00 | $ 2,020.00 | $ 1,300.00 | $ 8,640.00 |
| Stock Purchased | $ 1,520.00 | $ 1,650.00 | $ 1,780.00 | $ 2,030.00 | $ 6,980.00 |
| $ 4,440.00 | $ 4,050.00 | $ 3,800.00 | $ 3,330.00 | $ 15,620.00 | |
| Less Closing Stock | $ 2,400.00 | $ 2,020.00 | $ 2,500.00 | $ 1,200.00 | $ 8,120.00 |
| Total Cost of Sales | $ 2,040.00 | $ 2,030.00 | $ 1,300.00 | $ 2,130.00 | |
| Gross Profit | $ 9,980.00 | $ 13,410.00 | $ 16,323.00 | $ 18,283.00 | |
| Expenses | |||||
| General & Administrative | |||||
| Bank charges | $ 57.00 | $ 76.00 | $ 108.00 | $ 120.00 | $ 361.00 |
| Credit card commission | $ 140.00 | $ 150.00 | $ 170.00 | $ 150.00 | $ 610.00 |
| Consultant fees | $ 230.00 | $ 200.00 | $ 220.00 | $ 220.00 | $ 870.00 |
| Office Supplies | $ 20.00 | $ 20.00 | $ 30.00 | $ 40.00 | $ 110.00 |
| License fees | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 120.00 |
| Business insurance | $ 50.00 | $ 30.00 | $ 30.00 | $ 50.00 | $ 160.00 |
| Etc. | $ 13.00 | $ 30.00 | $ 20.00 | $ 22.00 | $ 85.00 |
| Total General & Administrative | $ 540.00 | $ 536.00 | $ 608.00 | $ 632.00 | |
| Marketing & Promotional | |||||
| Advertising | $ 200.00 | $ 180.00 | $ 200.00 | $ 180.00 | $ 760.00 |
| Promotion - General | $ 120.00 | $ 120.00 | $ 230.00 | $ 210.00 | $ 680.00 |
| Promotion - Other | $ 150.00 | $ 140.00 | $ 160.00 | $ 155.00 | $ 605.00 |
| Etc. | $ 95.00 | $ 65.00 | $ 95.00 | $ 97.00 | $ 352.00 |
| Total Marketing & Promotional | $ 565.00 | $ 505.00 | $ 685.00 | $ 642.00 | |
| Operating Expenses | |||||
| Newspapers & magazines | $ 180.00 | $ 182.00 | $ 190.00 | $ 190.00 | $ 742.00 |
| Parking/Taxis/Tolls | $ 100.00 | $ 100.00 | $ 100.00 | $ 100.00 | $ 400.00 |
| Entertainment/Meals | $ 320.00 | $ 320.00 | $ 320.00 | $ 320.00 | $ 1,280.00 |
| Travel/Accomodation | $ 160.00 | $ 160.00 | $ 160.00 | $ 260.00 | $ 740.00 |
| Laundry/dry cleaning | $ 320.00 | $ 320.00 | $ 320.00 | $ 260.00 | $ 1,220.00 |
| Cleaning & cleaning products | $ 120.00 | $ 160.00 | $ 160.00 | $ 220.00 | $ 660.00 |
| Sundry supplies | $ 80.00 | $ 130.00 | $ 100.00 | $ 130.00 | $ 440.00 |
| Equipment hire | $ 70.00 | $ 80.00 | $ 70.00 | $ 70.00 | $ 290.00 |
| Etc. | |||||
| Total Operating Expenses | $ 1,350.00 | $ 1,452.00 | $ 1,420.00 | $ 1,550.00 | |
| Motor Vehicle Expenses | |||||
| Fuel | $ 60.00 | $ 100.00 | $ 100.00 | $ 30.00 | $ 290.00 |
| Vehicle service costs | $ 52.00 | $ 40.00 | $ 40.00 | $ 50.00 | $ 182.00 |
| Tyres & other replacement costs | $ 20.00 | $ 35.00 | $ 30.00 | $ 30.00 | $ 115.00 |
| Insurance | $ 80.00 | $ 70.00 | $ 120.00 | $ 100.00 | $ 370.00 |
| Registrations | $ 10.00 | $ 10.00 | $ 12.00 | $ 13.00 | $ 45.00 |
| Total Motor Vehicle Expenses | $ 222.00 | $ 255.00 | $ 302.00 | $ 223.00 | |
| Website Expenses | |||||
| Domain name registration | $ 120.00 | $ 120.00 | $ 120.00 | $ 120.00 | $ 480.00 |
| Hosting expenses | $ 90.00 | $ 100.00 | $ 100.00 | $ 95.00 | $ 385.00 |
| etc | $ 80.00 | $ 80.00 | $ 70.00 | $ 60.00 | $ 290.00 |
| Total Website Expenses | $ 290.00 | $ 300.00 | $ 290.00 | $ 275.00 | |
| Employment Expenses | |||||
| Permanent | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Salaries/Wages | $ 810.00 | $ 820.00 | $ 860.00 | $ 920.00 | $ 3,410.00 |
| PAYE | $ 140.00 | $ 150.00 | $ 160.00 | $ 140.00 | $ 590.00 |
| Superannuation | $ 30.00 | $ 30.00 | $ 30.00 | $ 30.00 | $ 120.00 |
| Other - Employee Benefits | $ 47.00 | $ 52.00 | $ 46.00 | $ 30.00 | $ 175.00 |
| Recruitment costs | $ 25.00 | $ 35.00 | $ 25.00 | $ 20.00 | $ 105.00 |
| Total Perm. Employment Expenses | 1,052 | 1,087 | 1,121 | 1,140 | |
| Casual | |||||
| Salaries/Wages | $ 125.00 | $ 155.00 | $ 155.00 | $ 165.00 | $ 600.00 |
| PAYE | $ 40.00 | $ 55.00 | $ 46.00 | $ 55.00 | $ 196.00 |
| Superannuation | $ 5.00 | $ 5.00 | $ 5.00 | $ 5.00 | $ 20.00 |
| Other - Employee Benefits | $ 25.00 | $ 26.00 | $ 24.00 | $ 25.00 | $ 100.00 |
| Recruitment costs | $ 10.00 | $ 10.00 | $ 10.00 | $ 10.00 | $ 40.00 |
| Total Casual Employment Expenses | $ 205.00 | $ 251.00 | $ 240.00 | $ 260.00 | |
| Workcover Insurance | $ 130.00 | $ 150.00 | $ 125.00 | $ 130.00 | $ 535.00 |
| Total Employment Expenses | $ 130.00 | $ 150.00 | $ 125.00 | $ 130.00 | |
| Occupancy Costs | |||||
| Electricity/Gas | $ 70.00 | $ 100.00 | $ 85.00 | $ 94.00 | $ 349.00 |
| Telephones | $ 28.00 | $ 28.00 | $ 22.00 | $ 28.00 | $ 106.00 |
| Property Insurance | $ 135.00 | $ 126.00 | $ 115.00 | $ 125.00 | $ 501.00 |
| Rates | $ 30.00 | $ 70.00 | $ 63.00 | $ 62.00 | $ 225.00 |
| Rent | $ 94.00 | $ 97.00 | $ 97.00 | $ 97.00 | $ 385.00 |
| Repair & maintenance | $ 31.00 | $ 31.00 | $ 31.00 | $ 34.00 | $ 127.00 |
| Waste removal | $ 16.00 | $ 19.00 | $ 19.00 | $ 16.00 | $ 70.00 |
| Water | $ 19.00 | $ 25.00 | $ 22.00 | $ 19.00 | $ 85.00 |
| Etc. | $ 16.00 | $ 16.00 | $ 16.00 | $ 16.00 | $ 64.00 |
| Total Occupancy Costs | $ 439.00 | $ 512.00 | $ 470.00 | $ 491.00 | |
| Other Expenses | |||||
| Add an expense description here | $ 85.00 | $ 125.00 | $ 100.00 | $ 70.00 | $ 380.00 |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Add an expense description here | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Total Other Expenses | $ 85.00 | $ 125.00 | $ 100.00 | $ 70.00 | |
| Total Expenses | $ 4,673.00 | $ 4,922.00 | $ 4,436.00 | $ 5,153.00 | |
| Month Net Profit / (Loss) | $ 5,307.00 | $ 8,488.00 | $ 11,887.00 | $ 13,130.00 | |
| Total Year to Date Net Profit / (Loss) | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ 38,812.00 |
