Strategic plan Gantt chart
ksmth0
ProjectedFinancialStatementAnalysis.xlsxQuestions
| Questions | Response | Additional considerations |
| What is the vital financial information needed to determine the viability of your plan ? | Information on the proforma financial statements. Consider proections of a balance sheet and cash flow statements. | Information on intellectual assets. Also on leverage level , debt ,and return on investment |
| What ratios will you use to determine if the proposed plan is a success? | Return on investment and profitability ratios such as Gross profit margin | Leverage ratio and return on equity are also critical in reflecting liquidity level |
| What other, nonfinancial, information did you use to put your plan together? | I incorporated information from Market about demand for our services and general economic conditions. | This are handy when doing proper feasibity analysis |
| Consider the assumptions made when completing Part 3. What assumptions are made? List the assumptions that you used to formulate this plan. | i).organisational key functions are connected when developing the org charts.ii)Also, funds will be ready available to support the funds project and its operation. | we also assumed that the feasiblity report will attract prospective investors and would be acceptable. |
| 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. | In year one, the business will make profits but very low as compared to year two and three. Primarily , this can be attributed to the fact that the sales have significantly increased while the expenses have relatively decreased . | The breakpoints are varied for throughout the first three years . Normally , it is expected that high expenses at the inception of a business . |
| Explain how you would determine your pricing model. What seems most appropriate for your business and industry in which you will compete? | penetration pricing | I intend to enter the market gradually by offering high quality health services at lower prices or charges. |
| Identify your cost structure. Is your business model cost-driven or value driven? Justify your selection. | value driven. | This is because we want to impart on our customers . We want to ensure high level of customers' satisfaction, customer retention as well as 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. | penetration pricing is used even as a long term solution and as the demand increase, the revenus will increase as well. | In the long run, procedures are used to optain profits because customers are not aware of our pricing.This should increase out profits in year 2 and 3. |
| Where are you getting capital to meet your strategic initiative? What terms will be most likely deemed acceptable? | I will get the capital from investors and shareholders. This means that I must design a good business project plan so as to get sufficient capital. | I can also seek grants to kickstart the operations. |
| Did you have to reevaluate (go back) why? | yes | This is because majors affecting the organization and the industry necessitate for changes of the strategic plan. any venture involving strategic planning,review of the strategies are key to be sure that the idea is viable |
12month P&L,Yr 1
| Profit & Loss Statement | ||||||||||||
| Instructions | ||||||||||||
| Give careful thought to the headings. | Amount in $"000 | |||||||||||
| 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 | 210,900.0 | $ 215,118.0 | $ 208,664.5 | $ 213,009.0 | $ 216,204.1 | $ 217,011.0 | $ 214,840.9 | $ 218,334.2 | $ 212,731.3 | $ 214,858.6 | $ 219,113.3 | $ 220,208.8 |
| Sundry Income (e.g. Commission earned, frachise fees etc.) | 2,185.0 | $ 2,228.7 | $ 2,161.8 | $ 2,206.9 | $ 2,240.0 | $ 2,248.3 | $ 2,225.8 | $ 2,262.0 | $ 2,203.3 | $ 2,225.4 | $ 2,292.1 | $ 2,303.6 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Sales | 213,085.0 | $ 217,346.7 | $ 210,826.3 | $ 215,215.9 | $ 218,444.1 | $ 219,259.4 | $ 217,066.8 | $ 220,596.2 | $ 214,874.2 | $ 217,022.9 | $ 223,533.6 | $ 224,651.3 |
| Less Discounts/Commissions | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Sales Discounts given | 17,654.0 | $ 18,007.1 | $ 17,466.9 | $ 17,830.5 | $ 18,098.0 | $ 18,165.5 | $ 17,983.9 | $ 18,276.3 | $ 17,802.2 | $ 17,980.3 | $ 18,519.7 | $ 18,612.3 |
| Sales Commissions paid | 12,400.0 | $ 12,648.0 | $ 12,268.6 | $ 12,524.0 | $ 12,711.9 | $ 12,759.3 | $ 12,631.7 | $ 12,837.1 | $ 12,504.1 | $ 12,629.2 | $ 12,879.2 | $ 12,943.6 |
| Total Discounts/ Commissions | 30,054.0 | $ 30,655.1 | $ 29,735.4 | $ 30,354.5 | $ 30,809.9 | $ 30,924.8 | $ 30,615.6 | $ 31,113.4 | $ 30,306.3 | $ 30,609.4 | $ 31,527.7 | $ 31,685.3 |
| Total Net Income | 183,031.0 | $ 186,691.6 | $ 181,090.9 | $ 184,861.3 | $ 187,634.2 | $ 188,334.5 | $ 186,451.2 | $ 189,482.8 | $ 184,618.2 | $ 186,464.4 | $ 190,156.8 | $ 191,107.6 |
| Cost of Sales | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Opening Stock | 48,200.0 | $ 49,164.0 | $ 47,689.1 | $ 48,682.0 | $ 49,412.2 | $ 49,596.6 | $ 49,100.7 | $ 49,899.0 | $ 47,596.3 | $ 48,072.3 | $ 49,024.2 | $ 49,269.3 |
| Stock Purchased | 54,654.0 | $ 55,747.1 | $ 54,074.7 | $ 55,200.5 | $ 56,028.5 | $ 56,237.7 | $ 55,675.3 | $ 56,580.6 | $ 55,112.9 | $ 55,664.0 | $ 57,334.0 | $ 57,620.6 |
| 102,854.0 | $ 104,911.1 | $ 101,763.7 | $ 103,882.5 | $ 105,440.8 | $ 105,834.3 | $ 104,776.0 | $ 106,479.6 | $ 101,700.8 | $ 102,717.8 | $ 104,751.8 | $ 105,275.6 | |
| Less Closing Stock | 41,350.0 | $ 42,177.0 | $ 40,911.7 | $ 41,763.5 | $ 42,390.0 | $ 42,548.2 | $ 42,122.7 | $ 42,807.6 | $ 41,697.2 | $ 42,114.2 | $ 43,377.6 | $ 43,594.5 |
| Total Cost of Sales | 61,504.0 | $ 62,734.1 | $ 60,852.1 | $ 62,119.0 | $ 63,050.8 | $ 63,286.1 | $ 62,653.3 | $ 63,672.0 | $ 61,042.3 | $ 61,652.7 | $ 62,873.5 | $ 63,187.9 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Gross Profit | 121,527.0 | $ 123,957.5 | $ 120,238.8 | $ 122,742.3 | $ 124,583.4 | $ 125,048.4 | $ 123,797.9 | $ 125,810.8 | $ 123,576.0 | $ 124,811.7 | $ 127,283.2 | $ 127,919.7 |
| Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| General & Administrative | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Bank charges | 457.0 | $ 466.1 | $ 452.2 | $ 461.6 | $ 468.5 | $ 470.2 | $ 465.5 | $ 473.1 | $ 460.8 | $ 465.4 | $ 479.4 | $ 481.8 |
| Credit card commission | 310.0 | $ 316.2 | $ 306.7 | $ 313.1 | $ 317.8 | $ 319.0 | $ 315.8 | $ 320.9 | $ 323.7 | $ 326.9 | $ 333.4 | $ 335.1 |
| Consultant fees | 180.0 | $ 183.6 | $ 178.1 | $ 181.8 | $ 184.5 | $ 185.2 | $ 183.4 | $ 186.3 | $ 181.5 | $ 183.3 | $ 188.8 | $ 189.8 |
| Office Supplies | 750.0 | $ 765.0 | $ 742.1 | $ 757.5 | $ 768.9 | $ 771.7 | $ 764.0 | $ 776.4 | $ 766.4 | $ 774.0 | $ 789.4 | $ 793.3 |
| License fees | 121.0 | $ 123.4 | $ 119.7 | $ 122.2 | $ 124.0 | $ 124.5 | $ 123.3 | $ 125.3 | $ 122.0 | $ 123.2 | $ 126.9 | $ 127.6 |
| Business insurance | 425.0 | $ 433.5 | $ 420.5 | $ 429.3 | $ 435.7 | $ 437.3 | $ 432.9 | $ 440.0 | $ 331.8 | $ 335.1 | $ 341.7 | $ 343.4 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total General & Administrative | 2,243.0 | $ 2,287.9 | $ 2,219.2 | $ 2,265.4 | $ 2,299.4 | $ 2,308.0 | $ 2,284.9 | $ 2,322.1 | $ 2,218.5 | $ 2,240.7 | $ 2,285.0 | $ 2,296.5 |
| Marketing & Promotional | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Advertising | 421.0 | $ 429.4 | $ 416.5 | $ 425.2 | $ 431.6 | $ 433.2 | $ 428.9 | $ 435.8 | $ 434.6 | $ 439.0 | $ 447.7 | $ 449.9 |
| Promotion - General | 690.0 | $ 703.8 | $ 682.7 | $ 696.9 | $ 707.4 | $ 710.0 | $ 702.9 | $ 714.3 | $ 695.8 | $ 702.8 | $ 723.8 | $ 727.5 |
| Promotion - Other | 398.0 | $ 406.0 | $ 393.8 | $ 402.0 | $ 408.0 | $ 409.5 | $ 405.4 | $ 412.0 | $ 400.3 | $ 404.3 | $ 412.3 | $ 414.4 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Marketing & Promotional | 1,509.0 | $ 1,539.2 | $ 1,493.0 | $ 1,524.1 | $ 1,547.0 | $ 1,552.7 | $ 1,537.2 | $ 1,562.2 | $ 1,535.8 | $ 1,551.1 | $ 1,581.9 | $ 1,589.8 |
| Operating Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Newspapers & magazines | 605.0 | $ 617.1 | $ 635.6 | $ 611.1 | $ 620.2 | $ 661.0 | $ 654.4 | $ 626.3 | $ 640.3 | $ 646.7 | $ 659.5 | $ 662.8 |
| Parking/Taxis/Tolls | 1,377.0 | $ 1,404.5 | $ 1,446.7 | $ 1,390.8 | $ 1,411.6 | $ 1,504.5 | $ 1,489.5 | $ 1,425.5 | $ 1,474.5 | $ 1,489.2 | $ 1,533.9 | $ 1,541.5 |
| Entertainment/Meals | 467.0 | $ 476.3 | $ 490.6 | $ 471.7 | $ 478.7 | $ 510.3 | $ 505.2 | $ 483.5 | $ 521.5 | $ 526.7 | $ 537.1 | $ 539.8 |
| Travel/Accomodation | 2,973.0 | $ 3,032.5 | $ 3,123.4 | $ 3,002.7 | $ 3,047.8 | $ 3,248.4 | $ 3,215.9 | $ 3,077.8 | $ 3,183.4 | $ 3,215.2 | $ 3,311.7 | $ 3,328.3 |
| Laundry/dry cleaning | 635.0 | $ 647.7 | $ 667.1 | $ 641.4 | $ 651.0 | $ 693.8 | $ 686.9 | $ 657.4 | $ 712.1 | $ 719.2 | $ 733.4 | $ 737.1 |
| Cleaning & cleaning products | 542.0 | $ 552.8 | $ 569.4 | $ 547.4 | $ 555.6 | $ 592.2 | $ 586.3 | $ 561.1 | $ 580.4 | $ 586.2 | $ 603.7 | $ 606.8 |
| Sundry supplies | 770.0 | $ 785.4 | $ 809.0 | $ 777.7 | $ 789.4 | $ 841.3 | $ 832.9 | $ 797.1 | $ 835.2 | $ 843.6 | $ 860.3 | $ 864.6 |
| Equipment hire | 438.0 | $ 446.8 | $ 460.2 | $ 442.4 | $ 449.0 | $ 478.6 | $ 473.8 | $ 453.4 | $ 469.0 | $ 473.7 | $ 487.9 | $ 490.3 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Operating Expenses | 7,807.0 | $ 7,963.1 | $ 8,202.0 | $ 7,885.1 | $ 8,003.3 | $ 8,530.1 | $ 8,444.8 | $ 8,082.2 | $ 8,359.5 | $ 8,443.1 | $ 8,696.4 | $ 8,739.9 |
| Motor Vehicle Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Fuel | 1,530.0 | $ 1,560.6 | $ 1,607.4 | $ 1,545.3 | $ 1,568.5 | $ 1,671.7 | $ 1,655.0 | $ 1,583.9 | $ 1,638.3 | $ 1,654.7 | $ 1,704.3 | $ 1,712.8 |
| Vehicle service costs | 380.0 | $ 387.6 | $ 399.2 | $ 383.8 | $ 389.6 | $ 415.2 | $ 411.0 | $ 393.4 | $ 385.5 | $ 389.3 | $ 397.0 | $ 399.0 |
| Tyres & other replacement costs | 720.0 | $ 734.4 | $ 756.4 | $ 727.2 | $ 738.1 | $ 786.7 | $ 778.8 | $ 745.4 | $ 771.0 | $ 778.7 | $ 802.0 | $ 806.0 |
| Insurance | 210.0 | $ 214.2 | $ 220.6 | $ 212.1 | $ 215.3 | $ 229.5 | $ 227.2 | $ 217.4 | $ 235.6 | $ 237.9 | $ 242.6 | $ 243.9 |
| Registrations | 154.0 | $ 157.1 | $ 161.8 | $ 155.5 | $ 157.9 | $ 168.3 | $ 166.6 | $ 159.4 | $ 164.9 | $ 166.5 | $ 171.5 | $ 172.4 |
| Total Motor Vehicle Expenses | 2,994.0 | 3,053.9 | 3,145.5 | $ 3,023.9 | $ 3,069.3 | $ 3,271.3 | $ 3,238.6 | $ 3,099.5 | $ 3,173.8 | $ 3,205.5 | $ 3,269.0 | $ 3,285.3 |
| Website Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Domain name registration | 352.0 | $ 359.0 | $ 369.8 | $ 355.5 | $ 360.9 | $ 384.6 | $ 380.8 | $ 364.4 | $ 484.0 | $ 488.8 | $ 498.5 | $ 501.0 |
| Hosting expenses | 126.0 | $ 128.5 | $ 132.4 | $ 127.3 | $ 129.2 | $ 137.7 | $ 136.3 | $ 130.4 | $ 134.9 | $ 136.3 | $ 140.4 | $ 141.1 |
| etc | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Website Expenses | 478.0 | $ 487.6 | $ 502.2 | $ 482.8 | $ 490.0 | $ 522.3 | $ 517.1 | $ 494.8 | $ 511.8 | $ 516.9 | $ 532.5 | $ 535.1 |
| Employment Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Permanent | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Salaries/Wages | 9,865.0 | $ 10,062.3 | $ 10,364.2 | $ 9,963.7 | $ 10,113.1 | $ 10,778.7 | $ 10,670.9 | $ 10,212.7 | $ 10,563.2 | $ 10,668.8 | $ 10,880.1 | $ 10,934.5 |
| PAYE | 2,960.0 | $ 3,019.2 | $ 3,109.8 | $ 2,989.6 | $ 3,034.4 | $ 3,234.2 | $ 3,201.8 | $ 3,064.3 | $ 3,169.5 | $ 3,201.2 | $ 3,297.2 | $ 3,313.7 |
| Superannuation | 154.0 | $ 157.1 | $ 161.8 | $ 155.5 | $ 157.9 | $ 168.3 | $ 166.6 | $ 159.4 | $ 143.5 | $ 144.9 | $ 147.8 | $ 148.5 |
| Other - Employee Benefits | 12,057.0 | $ 12,298.1 | $ 12,667.1 | $ 12,177.6 | $ 12,360.2 | $ 13,173.8 | $ 13,042.0 | $ 12,482.0 | $ 12,910.3 | $ 13,039.4 | $ 13,430.6 | $ 13,497.7 |
| Recruitment costs | 112.0 | $ 114.2 | $ 117.7 | $ 113.1 | $ 114.8 | $ 122.4 | $ 121.2 | $ 115.9 | $ 119.9 | $ 121.1 | $ 123.5 | $ 124.1 |
| Total Perm. Employment Expenses | 12,323.0 | $ 12,569.5 | $ 12,946.5 | $ 12,446.2 | $ 12,632.9 | $ 13,464.4 | $ 13,329.8 | $ 12,757.4 | $ 13,195.1 | $ 13,327.1 | $ 13,726.9 | $ 13,795.5 |
| Casual | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Salaries/Wages | 87.0 | $ 88.7 | $ 91.4 | $ 87.9 | $ 89.2 | $ 95.1 | $ 94.1 | $ 90.1 | $ 93.2 | $ 94.1 | $ 96.9 | $ 97.4 |
| PAYE | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Superannuation | 21.0 | $ 21.4 | $ 22.1 | $ 21.2 | $ 21.5 | $ 22.9 | $ 22.7 | $ 21.7 | $ 22.5 | $ 22.7 | $ 23.4 | $ 23.5 |
| Other - Employee Benefits | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Recruitment costs | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Casual Employment Expenses | 108.0 | $ 110.2 | $ 113.5 | $ 109.1 | $ 110.7 | $ 118.0 | $ 116.8 | $ 111.8 | $ 104.9 | $ 106.0 | $ 108.1 | $ 108.6 |
| Workcover Insurance | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Employment Expenses | 12,431.0 | $ 12,679.6 | $ 13,060.0 | $ 12,555.3 | $ 12,743.6 | $ 13,582.4 | $ 13,446.6 | $ 12,869.2 | $ 14,101.0 | $ 14,242.0 | $ 14,524.0 | $ 14,596.6 |
| Occupancy Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Electricity/Gas | 977.0 | $ 996.5 | $ 1,026.4 | $ 986.8 | $ 1,001.6 | $ 1,067.5 | $ 1,056.8 | $ 1,011.4 | $ 1,044.0 | $ 1,054.4 | $ 1,075.3 | $ 1,080.7 |
| Telephones | 45.0 | $ 45.9 | $ 47.3 | $ 45.5 | $ 46.1 | $ 49.2 | $ 48.7 | $ 46.6 | $ 48.2 | $ 48.7 | $ 50.1 | $ 50.4 |
| Property Insurance | 1,344.0 | $ 1,370.9 | $ 1,412.0 | $ 1,357.4 | $ 1,377.8 | $ 1,468.5 | $ 1,453.8 | $ 1,391.4 | $ 1,440.2 | $ 1,454.6 | $ 1,483.4 | $ 1,490.8 |
| Rates | 249.0 | $ 254.0 | $ 261.6 | $ 251.5 | $ 255.3 | $ 272.1 | $ 269.3 | $ 257.8 | $ 266.6 | $ 269.3 | $ 277.4 | $ 278.8 |
| Rent | 777.0 | $ 792.5 | $ 816.3 | $ 784.8 | $ 796.5 | $ 849.0 | $ 840.5 | $ 804.4 | $ 827.7 | $ 836.0 | $ 852.5 | $ 856.8 |
| Repair & maintenance | 350.0 | $ 357.0 | $ 367.7 | $ 353.5 | $ 358.8 | $ 382.4 | $ 378.6 | $ 362.3 | $ 374.8 | $ 378.5 | $ 389.9 | $ 391.8 |
| Waste removal | 108.0 | $ 110.2 | $ 113.5 | $ 109.1 | $ 110.7 | $ 118.0 | $ 116.8 | $ 111.8 | $ 115.6 | $ 116.8 | $ 119.1 | $ 119.7 |
| Water | 320.0 | $ 326.4 | $ 336.2 | $ 323.2 | $ 328.0 | $ 349.6 | $ 346.1 | $ 331.3 | $ 342.6 | $ 346.1 | $ 356.5 | $ 358.2 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Occupancy Costs | 4,170.0 | $ 4,253.4 | $ 4,381.0 | $ 4,211.7 | $ 4,274.9 | $ 4,556.2 | $ 4,510.7 | $ 4,317.0 | $ 4,465.1 | $ 4,509.8 | $ 4,645.1 | $ 4,668.3 |
| Other Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Mail Delivery expenses | 899.0 | $ 917.0 | $ 944.5 | $ 908.0 | $ 921.6 | $ 982.3 | $ 972.4 | $ 930.7 | $ 962.6 | $ 972.2 | $ 1,001.4 | $ 1,006.4 |
| Depreciation costs | 1,236.0 | $ 1,260.7 | $ 1,298.5 | $ 1,248.4 | $ 1,267.1 | $ 1,350.5 | $ 1,337.0 | $ 1,279.6 | $ 1,461.6 | $ 1,476.2 | $ 1,505.5 | $ 1,513.0 |
| Office changeover fees | 129.0 | $ 131.6 | $ 135.5 | $ 130.3 | $ 132.2 | $ 140.9 | $ 139.5 | $ 133.5 | $ 138.1 | $ 139.5 | $ 143.7 | $ 144.4 |
| Forex costs | 333.2 | $ 339.9 | $ 350.1 | $ 336.5 | $ 341.6 | $ 364.1 | $ 360.4 | $ 344.9 | $ 366.2 | $ 369.9 | $ 377.2 | $ 379.1 |
| Total Other Expenses | 2,597.2 | $ 2,649.1 | $ 2,728.6 | $ 2,623.2 | $ 2,662.5 | $ 2,837.8 | $ 2,809.4 | $ 2,688.8 | $ 2,781.0 | $ 2,808.8 | $ 2,893.1 | $ 2,907.5 |
| Total Expenses | 33,751.2 | $ 34,426.2 | $ 35,459.0 | $ 34,088.7 | $ 34,600.0 | $ 36,877.4 | $ 36,508.6 | $ 34,940.9 | $ 36,988.7 | $ 37,358.6 | $ 38,098.4 | $ 38,288.9 |
| Month Net Profit / (Loss) | 87,775.8 | $ 89,531.3 | $ 92,217.3 | $ 88,653.6 | $ 89,983.4 | $ 95,905.9 | $ 94,946.9 | $ 90,869.9 | $ 93,987.8 | $ 94,927.7 | $ 97,775.5 | $ 98,264.4 |
| Total Year to Date Net Profit | $ 1,114,839.5 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Year 2 P&L
| Profit and Loss Statement | |||||
| Quarter | One | Two | Three | Four | Annual total |
| Income | |||||
| Sales | |||||
| Sale of goods/services | 550,304.0 | $ 555,807.0 | $ 544,801.0 | $ 552,973.0 | $ 2,203,885.0 |
| Sundry Income (e.g. Commission earned, frachise fees etc.) | 5,125.0 | $ 5,176.3 | $ 5,073.8 | $ 5,149.9 | $ 20,524.9 |
| Etc. | 0.0 | $ - 0 | |||
| Total Sales | 555,429.0 | $ 560,983.3 | $ 549,874.7 | $ 558,122.8 | $ 2,224,409.8 |
| Less Discounts/Commissions | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Sales Discounts given | 51,000.0 | $ 51,000.0 | |||
| Sales Commissions paid | 27,760.0 | $ 28,037.6 | $ 27,482.4 | $ 27,894.6 | $ 111,174.6 |
| Total Discounts/ Commissions | 78,760.0 | $ 79,547.6 | $ 77,972.4 | $ 79,142.0 | $ 315,422.0 |
| Total Net Income | 476,669.0 | $ 476,669.0 | |||
| Cost of Sales | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Opening Stock | 103,270.0 | $ 104,302.7 | $ 102,237.3 | $ 103,770.9 | $ 413,580.9 |
| Stock Purchased | 60,625.0 | $ 60,625.0 | |||
| 163,895.0 | $ 165,534.0 | $ 162,256.1 | $ 164,689.9 | $ 656,374.9 | |
| Less Closing Stock | 35,300.0 | $ 35,653.0 | $ 34,947.0 | $ 35,471.2 | $ 141,371.2 |
| Total Cost of Sales | 128,595.0 | $ 128,595.0 | |||
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Gross Profit | 348,074.0 | $ 351,554.7 | $ 344,593.3 | $ 349,762.2 | $ 1,393,984.2 |
| Expenses | $ - 0 | ||||
| General & Administrative | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Bank charges | 410.0 | $ 414.1 | $ 405.9 | $ 412.0 | $ 1,642.0 |
| Credit card commission | 321.0 | $ 321.0 | |||
| Consultant fees | 1,905.0 | $ 1,924.1 | $ 1,886.0 | $ 1,914.2 | $ 7,629.2 |
| Office Supplies | 1,565.0 | $ 1,580.7 | $ 1,549.4 | $ 1,572.6 | $ 6,267.6 |
| License fees | 1,024.0 | $ 1,024.0 | |||
| Business insurance | 310.0 | $ 313.1 | $ 306.9 | $ 311.5 | $ 1,241.5 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total General & Administrative | 5,535.0 | 4,231.9 | 4,148.1 | 4,210.3 | 18,125.3 |
| Marketing & Promotional | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Advertising | 251.0 | $ 253.5 | $ 248.5 | $ 252.2 | $ 1,005.2 |
| Promotion - General | 1,575.0 | 1,590.8 | 1,606.7 | 1,622.7 | $ 6,395.1 |
| Promotion - Other | 227.0 | $ 229.3 | $ 224.7 | $ 228.1 | $ 909.1 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Marketing & Promotional | 2,053.0 | 2,073.5 | 2,079.9 | 2,103.0 | 8,309.4 |
| Operating Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Newspapers & magazines | 2,598.0 | $ 2,624.0 | $ 2,572.0 | $ 2,610.6 | $ 10,404.6 |
| Parking/Taxis/Tolls | 11,367.0 | $ 11,367.0 | |||
| Entertainment/Meals | 487.0 | $ 491.9 | $ 482.1 | $ 489.4 | $ 1,950.4 |
| Travel/Accomodation | 2,975.0 | $ 3,004.8 | $ 2,945.3 | $ 2,989.4 | $ 11,914.4 |
| Laundry/dry cleaning | 665.0 | $ 665.0 | |||
| Cleaning & cleaning products | 541.0 | $ 546.4 | $ 535.6 | $ 543.6 | $ 2,166.6 |
| Sundry supplies | 2,780.0 | $ 2,807.8 | $ 2,752.2 | $ 2,793.5 | $ 11,133.5 |
| Equipment hire | 448.0 | $ 448.0 | |||
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Operating Expenses | 18,720.0 | $ 18,907.2 | $ 18,532.8 | $ 18,810.8 | $ 74,970.8 |
| Motor Vehicle Expenses | $ - 0 | ||||
| Fuel | 1,545.0 | $ 1,560.5 | $ 1,529.6 | $ 1,552.5 | $ 6,187.5 |
| Vehicle service costs | 370.0 | $ 373.7 | $ 366.3 | $ 371.8 | $ 1,481.8 |
| Tyres & other replacement costs | 705.0 | $ 705.0 | |||
| Insurance | 320.0 | $ 323.2 | $ 316.8 | $ 321.6 | $ 1,281.6 |
| Registrations | 210.0 | $ 212.1 | $ 207.9 | $ 211.0 | $ 841.0 |
| Total Motor Vehicle Expenses | 3,150.0 | 2,469.5 | 2,420.6 | 2,456.9 | $ 10,496.9 |
| Website Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Domain name registration | 332.0 | $ 335.3 | $ 328.7 | $ 333.6 | $ 1,329.6 |
| Hosting expenses | 125.0 | $ 125.0 | |||
| etc | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Website Expenses | 457.0 | $ 461.6 | $ 452.4 | $ 459.2 | $ 1,830.2 |
| Employment Expenses | $ - 0 | ||||
| Permanent | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Salaries/Wages | 23,676.0 | $ 23,912.8 | $ 23,439.2 | $ 23,790.8 | $ 94,818.8 |
| PAYE | 7,960.0 | $ 7,960.0 | |||
| Superannuation | 134.0 | $ 135.3 | $ 132.7 | $ 134.6 | $ 536.6 |
| Other - Employee Benefits | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Recruitment costs | 112.0 | $ 112.0 | |||
| Total Perm. Employment Expenses | 31,370.7 | $ 31,684.4 | $ 31,057.0 | $ 31,522.8 | $ 125,634.9 |
| Casual | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Salaries/Wages | 187.0 | $ 187.0 | |||
| PAYE | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Superannuation | 70.0 | $ 70.7 | $ 69.3 | $ 70.3 | $ 280.3 |
| Other - Employee Benefits | 0.0 | $ - 0 | |||
| Recruitment costs | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Casual Employment Expenses | 257.0 | $ 259.6 | $ 254.4 | $ 258.2 | $ 1,029.2 |
| Workcover Insurance | 0.0 | $ - 0 | |||
| Total Employment Expenses | 31,627.7 | $ 31,944.0 | $ 31,311.4 | $ 31,781.1 | $ 126,664.2 |
| Occupancy Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Electricity/Gas | 1,975.0 | $ 1,975.0 | |||
| Telephones | 340.0 | $ 343.4 | $ 336.6 | $ 341.6 | $ 1,361.6 |
| Property Insurance | 1,345.0 | $ 1,358.5 | $ 1,331.6 | $ 1,351.5 | $ 5,386.5 |
| Rates | 419.0 | $ 419.0 | |||
| Rent | 6,773.0 | $ 6,840.7 | $ 6,705.3 | $ 6,805.8 | $ 27,124.8 |
| Repair & maintenance | 1,340.0 | $ 1,353.4 | $ 1,326.6 | $ 1,346.5 | $ 5,366.5 |
| Waste removal | 1,068.0 | $ 1,068.0 | |||
| Water | 281.0 | $ 283.8 | $ 278.2 | $ 282.4 | $ 1,125.4 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Occupancy Costs | 13,541.0 | 10,179.8 | 9,978.2 | 10,127.9 | $ 43,826.9 |
| Other Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Mail Delivery expenses | 871.0 | $ 879.7 | $ 862.3 | $ 875.2 | $ 3,488.2 |
| Depreciation costs | 1,275.0 | $ 1,275.0 | |||
| Office changeover fees | 2,124.0 | $ 2,145.2 | $ 2,102.8 | $ 2,134.3 | $ 8,506.3 |
| Forex costs | 712.0 | $ 719.1 | $ 704.9 | $ 715.5 | $ 2,851.5 |
| Total Other Expenses | $ 4,982.0 | $ 3,744.1 | $ 3,669.9 | $ 3,725.0 | $ 16,121.0 |
| Total Expenses | $ 80,065.7 | $ 80,866.4 | $ 79,265.0 | $ 80,454.0 | $ 320,651.1 |
| Quarterly Net Profit / (Loss) | $ 268,008.3 | $ 270,688.4 | $ 265,328.2 | $ 269,308.1 | $ 1,073,333.0 |
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 | 527,000.0 | $ 521,730.0 | $ 532,270.0 | $ 529,556.0 | $ 2,110,556.0 |
| Sundry Income (e.g. Commission earned, frachise fees etc.) | 5,425.0 | $ 5,370.8 | $ 5,479.3 | $ 5,451.3 | $ 21,726.3 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Sales | 532,425.0 | $ 527,100.8 | $ 537,749.3 | $ 535,007.3 | $ 2,132,282.3 |
| Less Discounts/Commissions | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Sales Discounts given | 37,244.0 | $ 36,871.6 | $ 37,616.4 | $ 37,424.6 | $ 149,156.6 |
| Sales Commissions paid | 11,200.0 | $ 11,088.0 | $ 11,312.0 | $ 11,254.3 | $ 44,854.3 |
| Total Discounts/ Commissions | 48,444.0 | $ 47,959.6 | $ 48,928.4 | $ 48,679.0 | $ 194,011.0 |
| Total Net Income | 483,981.0 | $ 479,141.2 | $ 488,820.8 | $ 486,328.3 | $ 1,938,271.3 |
| Cost of Sales | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Opening Stock | 141,600.0 | $ 140,184.0 | $ 143,016.0 | $ 142,286.8 | $ 567,086.8 |
| Stock Purchased | 53,654.0 | $ 53,117.5 | $ 54,190.5 | $ 53,914.2 | $ 214,876.2 |
| 195,254.0 | $ 193,301.5 | $ 197,206.5 | $ 196,201.0 | $ 781,963.0 | |
| Less Closing Stock | 100,800.0 | $ 99,792.0 | $ 101,808.0 | $ 101,288.9 | $ 403,688.9 |
| Total Cost of Sales | 94,454.0 | $ 93,509.5 | $ 95,398.5 | $ 94,912.1 | $ 378,274.1 |
| $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| Gross Profit | 389,527.0 | $ 385,631.7 | $ 393,422.3 | $ 391,416.2 | $ 1,559,997.2 |
| Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| General & Administrative | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Bank charges | 467.0 | $ 462.3 | $ 471.7 | $ 469.3 | $ 1,870.3 |
| Credit card commission | 1,321.0 | $ 1,307.8 | $ 1,334.2 | $ 1,327.4 | $ 5,290.4 |
| Consultant fees | 200.0 | $ 198.0 | $ 202.0 | $ 201.0 | $ 801.0 |
| Office Supplies | 760.0 | $ 752.4 | $ 767.6 | $ 763.7 | $ 3,043.7 |
| License fees | 1,213.0 | $ 1,200.9 | $ 1,225.1 | $ 1,218.9 | $ 4,857.9 |
| Business insurance | 329.0 | $ 325.7 | $ 332.3 | $ 330.6 | $ 1,317.6 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total General & Administrative | 6,000.0 | $ 5,940.0 | $ 6,060.0 | $ 6,029.1 | $ 24,029.1 |
| Marketing & Promotional | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Advertising | 1,431.0 | $ 1,416.7 | $ 1,445.3 | $ 1,437.9 | $ 5,730.9 |
| Promotion - General | 695.0 | $ 688.1 | $ 702.0 | $ 698.4 | $ 2,783.4 |
| Promotion - Other | 1,397.0 | $ 1,383.0 | $ 1,411.0 | $ 1,403.8 | $ 5,594.8 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Marketing & Promotional | 3,800.0 | $ 3,762.0 | $ 3,838.0 | $ 3,818.4 | $ 15,218.4 |
| Operating Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Newspapers & magazines | 598.0 | $ 592.0 | $ 604.0 | $ 600.9 | $ 2,394.9 |
| Parking/Taxis/Tolls | 1,367.0 | $ 1,353.3 | $ 1,380.7 | $ 1,373.6 | $ 5,474.6 |
| Entertainment/Meals | 487.0 | $ 482.1 | $ 491.9 | $ 489.4 | $ 1,950.4 |
| Travel/Accomodation | 2,975.0 | $ 2,945.3 | $ 3,004.8 | $ 2,989.4 | $ 11,914.4 |
| Laundry/dry cleaning | 665.0 | $ 658.4 | $ 671.7 | $ 668.2 | $ 2,663.2 |
| Cleaning & cleaning products | 541.0 | $ 535.6 | $ 546.4 | $ 543.6 | $ 2,166.6 |
| Sundry supplies | 780.0 | $ 772.2 | $ 787.8 | $ 783.8 | $ 3,123.8 |
| Equipment hire | 448.0 | $ 443.5 | $ 452.5 | $ 450.2 | $ 1,794.2 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Operating Expenses | 23,400.0 | $ 23,166.0 | $ 23,634.0 | $ 23,513.5 | $ 93,713.5 |
| Motor Vehicle Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Fuel | 1,540.0 | $ 1,524.6 | $ 1,555.4 | $ 1,547.5 | $ 6,167.5 |
| Vehicle service costs | 360.0 | $ 356.4 | $ 363.6 | $ 361.7 | $ 1,441.7 |
| Tyres & other replacement costs | 700.0 | $ 693.0 | $ 707.0 | $ 703.4 | $ 2,803.4 |
| Insurance | 220.0 | $ 217.8 | $ 222.2 | $ 221.1 | $ 881.1 |
| Registrations | 144.0 | $ 142.6 | $ 145.4 | $ 144.7 | $ 576.7 |
| Total Motor Vehicle Expenses | 8,892.0 | $ 8,803.1 | $ 8,980.9 | $ 8,935.1 | $ 35,611.1 |
| Website Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Domain name registration | 452.0 | $ 447.5 | $ 456.5 | $ 454.2 | $ 1,810.2 |
| Hosting expenses | 226.0 | $ 223.7 | $ 228.3 | $ 227.1 | $ 905.1 |
| etc | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Website Expenses | 678.0 | $ 671.2 | $ 684.8 | $ 681.3 | $ 2,715.3 |
| Employment Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Permanent | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Salaries/Wages | 29,595.0 | $ 29,299.1 | $ 29,891.0 | $ 29,738.5 | $ 118,523.5 |
| PAYE | 9,880.0 | $ 9,781.2 | $ 9,978.8 | $ 9,927.9 | $ 39,567.9 |
| Superannuation | 134.0 | $ 132.7 | $ 135.3 | $ 134.6 | $ 536.6 |
| Other - Employee Benefits | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Recruitment costs | 112.0 | $ 110.9 | $ 113.1 | $ 112.5 | $ 448.5 |
| Total Perm. Employment Expenses | 39,213.0 | $ 38,820.9 | $ 39,605.1 | $ 39,403.2 | $ 157,042.2 |
| Casual | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Salaries/Wages | 233.0 | $ 230.7 | $ 235.3 | $ 234.1 | $ 933.1 |
| PAYE | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Superannuation | 55.0 | $ 54.5 | $ 55.6 | $ 55.3 | $ 220.3 |
| Other - Employee Benefits | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Recruitment costs | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Casual Employment Expenses | 295.0 | $ 292.1 | $ 298.0 | $ 296.4 | $ 1,181.4 |
| Workcover Insurance | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Employment Expenses | 583.0 | $ 577.2 | $ 588.8 | $ 585.8 | $ 2,334.8 |
| Occupancy Costs | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Electricity/Gas | 890.0 | $ 881.1 | $ 898.9 | $ 894.3 | $ 3,564.3 |
| Telephones | 45.0 | $ 44.6 | $ 45.5 | $ 45.2 | $ 180.2 |
| Property Insurance | 1,350.0 | $ 1,336.5 | $ 1,363.5 | $ 1,356.5 | $ 5,406.5 |
| Rates | 420.0 | $ 415.8 | $ 424.2 | $ 422.0 | $ 1,682.0 |
| Rent | 775.0 | $ 767.3 | $ 782.8 | $ 778.8 | $ 3,103.8 |
| Repair & maintenance | 351.0 | $ 347.5 | $ 354.5 | $ 352.7 | $ 1,405.7 |
| Waste removal | 108.0 | $ 106.9 | $ 109.1 | $ 108.5 | $ 432.5 |
| Water | 321.0 | $ 317.8 | $ 324.2 | $ 322.6 | $ 1,285.6 |
| Etc. | 0.0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Total Occupancy Costs | 4,260.0 | $ 4,217.4 | $ 4,302.6 | $ 4,280.7 | $ 17,060.7 |
| Other Expenses | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Mail Delivery expenses | 1,810.0 | $ 1,791.9 | $ 1,828.1 | $ 1,818.8 | $ 7,248.8 |
| Depreciation costs | 1,365.0 | $ 1,351.4 | $ 1,378.7 | $ 1,371.6 | $ 5,466.6 |
| Office changeover fees | 2,119.0 | $ 2,097.8 | $ 2,140.2 | $ 2,129.3 | $ 8,486.3 |
| Forex costs | 342.0 | $ 338.6 | $ 345.4 | $ 343.7 | $ 1,369.7 |
| Total Other Expenses | $ 5,636.00 | $ 5,579.6 | $ 5,692.4 | $ 5,663.3 | $ 22,571.3 |
| Total Expenses | $ 29,849.00 | $ 29,550.5 | $ 30,147.5 | $ 29,993.8 | $ 119,540.8 |
| Quarterly Net Profit / (Loss) | $ 359,678.00 | $ 356,081.2 | $ 363,274.8 | $ 361,422.4 | $ 1,440,456.4 |
