Executive Summary and Consolidated Presentation
sheyitqan
ProjectedFinancialStatementAnalysis.xlsxQuestions
| 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 |
