Financials MUST BE GOOD WITH USING EXCEL!

profilemj007
ProjectedFinancialStatementAnalysis.xlsx
Home>Business & Finance homework help>Financial markets homework help>Financials MUST BE GOOD WITH USING EXCEL!

Assignment

Rubric

Criteria Percentage Unsatisfactory (0.00%) Less than Satisfactory (74.00%) Satisfactory (79.00%) Good (87.00%) Excellent (100.00%)
Content 100.0%
Questions 40.0% No response is given for each question. A response is given to most of the questions but contains gaps. The responses do not forecast the impact of various implementation decisions. Subject knowledge is unclear or inconsistent. A response is given to all of the questions with minimal detail but no gaps. The level of analysis included in most of the responses forecast the impact of various implementation decisions. Some subject knowledge is evident. A response is given to all of the questions with detail. The level of analysis included in most of the responses forecast the impact of various implementation decisions. Subject knowledge is competent. A response is given to all of the questions with detail. The level of analysis included in all of the responses forecast the impact of various implementation decisions. Rationale demonstrates comprehensive subject knowledge and understanding.
Financials 40.0% The financial components are not provided. The financial components are not provided however subject knowledge is unclear or inconsistent. The financial components are provided and some subject knowledge is evident. The financial components are provided and subject knowledge is competent. The financial components are provided and demonstrates comprehensive subject knowledge and understanding.
Language Use and Audience Awareness (includes sentence construction, word choice, etc.) 10.0% Inappropriate word choice and lack of variety in language use are evident. Writer appears to be unaware of audience. Use of primer prose indicates writer either does not apply figures of speech or uses them inappropriately. Some distracting inconsistencies in language choice (register) or word choice are present. The writer exhibits some lack of control in using figures of speech appropriately. Language is appropriate to the targeted audience for the most part. The writer is clearly aware of audience, uses a variety of appropriate vocabulary for the targeted audience, and uses figures of speech to communicate clearly. The writer uses a variety of sentence constructions, figures of speech, and word choice in distinctive and creative ways that are appropriate to purpose, discipline, and scope.
Mechanics of Writing (includes spelling, punctuation, grammar, language use) 10.0% Slide errors are pervasive enough that they impede communication of meaning. Frequent and repetitive mechanical errors distract the reader. Some mechanical errors or typos are present, but they are not overly distracting to the reader. Slides are largely free of mechanical errors, although a few may be present. Writer is clearly in control of standard, written, academic English.
Total Weightage 100%

Questions

Questions Response Additional considerations
What is the vital financial information needed to determine the viability of your plan ?
What ratios will you use to determine if the proposed plan is a success?
What other, nonfinancial, information did you use to put your plan together?
Consider the assumptions made when completing Part 3. What assumptions are made? List the assumptions that you used to formulate this plan.
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.
Explain how you would determine your pricing model. What seems most appropriate for your business and industry in which you will compete?
Identify your cost structure. Is your business model cost-driven or value driven? Justify your selection.
Review your decision for a revenue model. Based on the financial statements, will this model generate a profit? Provide evidence to prove it. 
Where are you getting capital to meet your strategic initiative? What terms will be most likely deemed acceptable?
Did you have to reevaluate (go back) why?

&"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 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Sundry Income (e.g. Commission earned, frachise fees etc.) $ - 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 Sales $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Less Discounts/Commissions
Sales Discounts given $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Sales Commissions paid $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Discounts/ Commissions $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Net Income $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Cost of Sales
Opening Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Stock Purchased $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Less Closing Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Cost of Sales $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Gross Profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Expenses
General & Administrative
Bank charges $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Credit card commission $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Consultant fees $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Office Supplies $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
License fees $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Business insurance $ - 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 General & Administrative $ 12.00 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Marketing & Promotional
Advertising $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Promotion - General $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
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 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Operating Expenses
Newspapers & magazines $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Parking/Taxis/Tolls $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Entertainment/Meals $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Travel/Accomodation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Laundry/dry cleaning $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Cleaning & cleaning products $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Sundry supplies $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Equipment hire $ - 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 Operating Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Motor Vehicle Expenses
Fuel $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Vehicle service costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Tyres & other replacement costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Registrations $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Motor Vehicle Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Website Expenses
Domain name registration $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Hosting expenses $ - 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 Website Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Employment Expenses
Permanent $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Salaries/Wages $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
PAYE $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Superannuation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other - Employee Benefits $ - 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
Total Perm. Employment Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Casual
Salaries/Wages $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
PAYE $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Superannuation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other - Employee Benefits $ - 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
Total Casual Employment Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Workcover Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Employment Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Occupancy Costs
Electricity/Gas $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Telephones $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Property Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Rates $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Rent $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Repair & maintenance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Waste removal $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Water $ - 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 Occupancy Costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Expenses
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 $ - 0
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Other Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Month Net Profit / (Loss) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Year to Date Net Profit / (Loss) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

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 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Sundry Income (e.g. Commission earned, frachise fees etc.) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Sales $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Less Discounts/Commissions
Sales Discounts given $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Sales Commissions paid $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Discounts/ Commissions $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Net Income $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Cost of Sales
Opening Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Stock Purchased $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Less Closing Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Cost of Sales $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Gross Profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Expenses
General & Administrative
Bank charges $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Credit card commission $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Consultant fees $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Office Supplies $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
License fees $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Business insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total General & Administrative $ 12.00 $ - 0 $ - 0 $ - 0 $ - 0
Marketing & Promotional
Advertising $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Promotion - General $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Promotion - Other $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Marketing & Promotional $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Operating Expenses
Newspapers & magazines $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Parking/Taxis/Tolls $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Entertainment/Meals $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Travel/Accomodation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Laundry/dry cleaning $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Cleaning & cleaning products $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Sundry supplies $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Equipment hire $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Operating Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Motor Vehicle Expenses
Fuel $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Vehicle service costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Tyres & other replacement costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Registrations $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Motor Vehicle Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Website Expenses
Domain name registration $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Hosting expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
etc $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Website Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Employment Expenses
Permanent $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Salaries/Wages $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
PAYE $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Superannuation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other - Employee Benefits $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Recruitment costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Perm. Employment Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Casual
Salaries/Wages $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
PAYE $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Superannuation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other - Employee Benefits $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Recruitment costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Casual Employment Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Workcover Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Employment Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Occupancy Costs
Electricity/Gas $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Telephones $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Property Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Rates $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Rent $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Repair & maintenance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Waste removal $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Water $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Occupancy Costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Expenses
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
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Other Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Month Net Profit / (Loss) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Year to Date Net Profit / (Loss) $ - 0 $ - 0 $ - 0 $ - 0 $ - 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 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Sundry Income (e.g. Commission earned, frachise fees etc.) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Sales $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Less Discounts/Commissions
Sales Discounts given $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Sales Commissions paid $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Discounts/ Commissions $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Net Income $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Cost of Sales
Opening Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Stock Purchased $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Less Closing Stock $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Cost of Sales $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Gross Profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Expenses
General & Administrative
Bank charges $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Credit card commission $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Consultant fees $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Office Supplies $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
License fees $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Business insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total General & Administrative $ 12.00 $ - 0 $ - 0 $ - 0 $ - 0
Marketing & Promotional
Advertising $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Promotion - General $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Promotion - Other $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Marketing & Promotional $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Operating Expenses
Newspapers & magazines $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Parking/Taxis/Tolls $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Entertainment/Meals $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Travel/Accomodation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Laundry/dry cleaning $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Cleaning & cleaning products $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Sundry supplies $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Equipment hire $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Operating Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Motor Vehicle Expenses
Fuel $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Vehicle service costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Tyres & other replacement costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Registrations $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Motor Vehicle Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Website Expenses
Domain name registration $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Hosting expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
etc $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Website Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Employment Expenses
Permanent $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Salaries/Wages $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
PAYE $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Superannuation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other - Employee Benefits $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Recruitment costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Perm. Employment Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Casual
Salaries/Wages $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
PAYE $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Superannuation $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other - Employee Benefits $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Recruitment costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Casual Employment Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Workcover Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Employment Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Occupancy Costs
Electricity/Gas $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Telephones $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Property Insurance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Rates $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Rent $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Repair & maintenance $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Waste removal $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Water $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Etc. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Occupancy Costs $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other Expenses
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
Add an expense description here $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Other Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Expenses $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Month Net Profit / (Loss) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Year to Date Net Profit / (Loss) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0