Business Plan Writing

profileDonald Trump
cd__financial_tables_v21_june_2015.xls
Home>Business & Finance homework help>Management homework help>Business Plan Writing

Working Notes

Working Notes Name:
1. Some cells are shaded in green. These are the cells in which you need to enter your data.
2. Shading can be removed by selecting the cell(s) and using no fill colour.
WARNING
Many parts of the financial tables either contain formulae or links
to other tables. Be aware that altering any of these tables may affect
these formulae and / or links.
eg. Deleting or inserting rows

Financial Table 1AB

Financial Table 1A - SCHEDULE OF PERSONAL DRAWINGS (Year 1)
For the year _____/_____
1 2 3 4 5 6 7 8 9 10 11 12 Total
INCOME
Interest 0 0 0 0 0 0 0 0 0 0 0 0 0
Other income 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 0 0 0 9,900
A. Total Income 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 0 0 0 9,900
EXPENSES
Fixed Monthly Expenditure
Mortgage or rent 800 0 0 0 0 0 0 0 0 0 0 0 800
Lay-by or personal loans 0 0 0 0 0 0 0 0 0 0 0 0 0
Insurance / superannuation 80 0 0 0 0 0 0 0 0 0 0 0 80
Child care 0 0 0 0 0 0 0 0 0 0 0 0 0
School fees 0 0 0 0 0 0 0 0 0 0 0 0 0
Credit cards 0 0 0 0 0 0 0 0 0 0 0 0 0
Personal pocket money 0 0 0 0 0 0 0 0 0 0 0 0 0
Planned savings 400 0 0 0 0 0 0 0 0 0 0 0 400
Other 0 0 0 0 0 0 0 0 0 0 0 0 0
Total fixed monthly expenses 1,280 0 0 0 0 0 0 0 0 0 0 0 1,280
Variable Monthly Expenditure
Food 200 0 0 0 0 0 0 0 0 0 0 0 200
Power and gas 100 0 0 0 0 0 0 0 0 0 0 0 100
Clothing 150 0 0 0 0 0 0 0 0 0 0 0 150
Recreation 100 0 0 0 0 0 0 0 0 0 0 0 100
Contributions (religious etc) 0 0 0 0 0 0 0 0 0 0 0 0 0
Fuel (vehicle) 200 0 0 0 0 0 0 0 0 0 0 0 200
Medical expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Other (Telstra) 200 0 0 0 0 0 0 0 0 0 0 0 200
Total variable monthly expenses 950 0 0 0 0 0 0 0 0 0 0 0 950
Fixed Infrequent Expenditure
Insurance (house and car) 70 0 0 0 0 0 0 0 0 0 0 0 70
Annual subscriptions 0 0 0 0 0 0 0 0 0 0 0 0 0
Property rates / taxes 0 0 0 0 0 0 0 0 0 0 0 0 0
Union fees 0 0 0 0 0 0 0 0 0 0 0 0 0
Magazine subscriptions 0 0 0 0 0 0 0 0 0 0 0 0 0
Education 0 0 0 0 0 0 0 0 0 0 0 0 0
Other 0 0 0 0 0 0 0 0 0 0 0 0 0
Total fixed infrequent expenses 70 0 0 0 0 0 0 0 0 0 0 0 70
Variable Infrequent Expenditure
Gifts 0 0 0 0 0 0 0 0 0 0 0 0 0
Holidays 0 0 0 0 0 0 0 0 0 0 0 0 0
Car repairs and registration 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Home maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0
Dental fees 25 0 0 0 0 0 0 0 0 0 0 0 25
Durable goods purchase 0 0 0 0 0 0 0 0 0 0 0 0 0
Donations 0 0 0 0 0 0 0 0 0 0 0 0 0
Other 0 0 0 0 0 0 0 0 0 0 0 0 0
Total variable infrequent expenses 125 100 100 100 100 100 100 100 100 100 100 100 1,225
B. Total Expenses 2,425 100 100 100 100 100 100 100 100 100 100 100 3,525
(A) Total Income available 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 1,100 0 0 0 9,900
(B) Total Expenses 2,425 100 100 100 100 100 100 100 100 100 100 100 3,525
(B - A) Proposed Drawings 1,325 -1,000 -1,000 -1,000 -1,000 -1,000 -1,000 -1,000 -1,000 100 100 100 -6,375
Financial Table 1B - SCHEDULE OF PERSONAL DRAWINGS (Year 2)
For the year _____/_____
1 2 3 4 5 6 7 8 9 10 11 12 Total
INCOME
Interest 0 0 0 0 0 0 0 0 0 0 0 0 0
Other income 0 0 0 0 0 0 0 0 0 0 0 0 0
A. Total Income 0 0 0 0 0 0 0 0 0 0 0 0 0
EXPENSES
Fixed Monthly Expenditure
Mortgage or rent 0 0 0 0 0 0 0 0 0 0 0 0 0
Lay-by or personal loans 0 0 0 0 0 0 0 0 0 0 0 0 0
Insurance / superannuation 0 0 0 0 0 0 0 0 0 0 0 0 0
Child care 0 0 0 0 0 0 0 0 0 0 0 0 0
School fees 0 0 0 0 0 0 0 0 0 0 0 0 0
Credit cards 0 0 0 0 0 0 0 0 0 0 0 0 0
Personal pocket money 0 0 0 0 0 0 0 0 0 0 0 0 0
Planned savings 0 0 0 0 0 0 0 0 0 0 0 0 0
Other 0 0 0 0 0 0 0 0 0 0 0 0 0
Total fixed monthly expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Variable Monthly Expenditure
Food 0 0 0 0 0 0 0 0 0 0 0 0 0
Power and gas 0 0 0 0 0 0 0 0 0 0 0 0 0
Clothing 0 0 0 0 0 0 0 0 0 0 0 0 0
Recreation 0 0 0 0 0 0 0 0 0 0 0 0 0
Contributions (religious etc) 0 0 0 0 0 0 0 0 0 0 0 0 0
Fuel (vehicle) 0 0 0 0 0 0 0 0 0 0 0 0 0
Medical expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Other (Telstra) 0 0 0 0 0 0 0 0 0 0 0 0 0
Total variable monthly expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Fixed Infrequent Expenditure
Insurance (house and car) 0 0 0 0 0 0 0 0 0 0 0 0 0
Annual subscriptions 0 0 0 0 0 0 0 0 0 0 0 0 0
Property rates / taxes 0 0 0 0 0 0 0 0 0 0 0 0 0
Union fees 0 0 0 0 0 0 0 0 0 0 0 0 0
Magazine subscriptions 0 0 0 0 0 0 0 0 0 0 0 0 0
Education 0 0 0 0 0 0 0 0 0 0 0 0 0
Other 0 0 0 0 0 0 0 0 0 0 0 0 0
Total fixed infrequent expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Variable Infrequent Expenditure
Gifts 0 0 0 0 0 0 0 0 0 0 0 0 0
Holidays 0 0 0 0 0 0 0 0 0 0 0 0 0
Car repairs and registration 0 0 0 0 0 0 0 0 0 0 0 0 0
Home maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0
Dental fees 0 0 0 0 0 0 0 0 0 0 0 0 0
Durable goods purchase 0 0 0 0 0 0 0 0 0 0 0 0 0
Donations 0 0 0 0 0 0 0 0 0 0 0 0 0
Other 0 0 0 0 0 0 0 0 0 0 0 0 0
Total variable infrequent expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
B. Total Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
(A) Total Income available 0 0 0 0 0 0 0 0 0 0 0 0 0
(B) Total Expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
(B - A) Proposed Drawings 0 0 0 0 0 0 0 0 0 0 0 0 0

Financial Table 2

Financial Table 2 - STATEMENT OF PERSONAL NET WORTH
Date:
ASSETS LIABILITIES
(You Own) (You Owe)
Cash available $ 15,800 Bills unpaid $ 130
Bonds and shares $ 2,500 Balance owing under lease contracts $ - 0
Surrender value of life policies $ - 0 Personal loans $ - 0
House $ - 0 Amount owing on house $ - 0
Other real estate $ - 0 Credit cards $ 50
Furniture and personal effects $ 6,000 Store credit cards $ - 0
Vehicles $ 13,000 Other $ - 0
Other $ - 0
TOTAL (A) $ 37,300 TOTAL (B) $ 180
Total Assets (A) $ 37,300
Total Liabilities (B) $ 180
Personal Net Worth (A) - (B) $ 37,120

Financial Table 3AB

Financial Table 3A - SALES MIX (Year 1)
Business Name:
Year: 0 0 0 0 0 0 0 0 0 0 0
1 2 3 4 5 6 7 8 9 10 11 12 Total
ITEM OR SERVICE
cleaning services strata block of 8 units
Number sold per month 1 2 4 3 2 4 2 4 3 2 4 3 34
Selling price per item/service (exc GST) 160.00 160.00 160.00 160.00 160.00 160.00 160.00 160.00 160.00 160.00 160.00 160.00
Total sales (exc GST) 160.00 320.00 640.00 480.00 320.00 640.00 320.00 640.00 480.00 320.00 640.00 480.00 5,440.00
ITEM OR SERVICE
Cleaning services strata block of 15 units
Number sold per month 2 3 4 1 4 3 2 4 2 3 4 1 33
Selling price per item/service (exc GST) 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00 400.00
Total sales (exc GST) 800.00 1,200.00 1,600.00 400.00 1,600.00 1,200.00 800.00 1,600.00 800.00 1,200.00 1,600.00 400.00 13,200.00
ITEM OR SERVICE
Cleaning services strata Block of 20 units
Number sold per month 4 2 4 3 2 4 1 3 4 2 3 2 34
Selling price per item/service (exc GST) 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00
Total sales (exc GST) 6,000.00 3,000.00 6,000.00 4,500.00 3,000.00 6,000.00 1,500.00 4,500.00 6,000.00 3,000.00 4,500.00 3,000.00 51,000.00
ITEM OR SERVICE
Cleaning services strata Block of 40 units
Number sold per month 1 3 4 2 3 1 4 2 3 1 4 2 30
Selling price per item/service (exc GST) 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00 2,400.00
Total sales (exc GST) 2,400.00 7,200.00 9,600.00 4,800.00 7,200.00 2,400.00 9,600.00 4,800.00 7,200.00 2,400.00 9,600.00 4,800.00 72,000.00
ITEM OR SERVICE
Number sold per month 0
Selling price per item/service (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total sales (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
ITEM OR SERVICE
Number sold per month 0
Selling price per item/service (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total sales (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL MONTHLY SALES (exc GST) 9,360.00 11,720.00 17,840.00 10,180.00 12,120.00 10,240.00 12,220.00 11,540.00 14,480.00 6,920.00 16,340.00 8,680.00 141,640.00
Financial Table 3B - SALES MIX (Year 2)
Business Name: 0
Year: 0 0 0 0 0 0 0 0 0 0 0 0
1 2 3 4 5 6 7 8 9 10 11 12 Total
ITEM OR SERVICE
Number sold per month 0
Selling price per item/service (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total sales (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
ITEM OR SERVICE
Number sold per month 0
Selling price per item/service (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total sales (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
ITEM OR SERVICE
Number sold per month 0
Selling price per item/service (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total sales (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
ITEM OR SERVICE
Number sold per month 0
Selling price per item/service (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total sales (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
ITEM OR SERVICE
Number sold per month 0
Selling price per item/service (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total sales (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
ITEM OR SERVICE
Number sold per month 0
Selling price per item/service (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Total sales (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL MONTHLY SALES (exc GST) 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

Financial Table 4

Financial Table 4 - ESTABLISHMENT COSTS
Business Name: 0
Description Owned To Be Purchased Total
(Market Value) (Cost excluding GST) Value
Fixed Assets
Vacum Cleaner $ 400 $ 400
Clothes $ 140 $ 140
Mop and Bucket $ 150 $ 150
Steam $ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
Expense Items
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
$ -
Working Capital $ -
GST on Establishment Purchases $ -
OWNER AMOUNT TO BE TOTAL
INVESTMENT PURCHASED ASSET REQUIRED
$ - $ 690 $ 690
Owner Funds Available
TOTAL FUNDING TO BE OBTAINED $ 690

Financial Table 5

Financial Table 5 - SOURCE OF FUNDS
Business Name: 0
Business Loan Details
Name of lender
Estimated loan $ - 0 Total loan $ - 0
Stamp duty $ - 0 Loan term (years)
Application fees $ - 0 Interest rate 0.00%
Other loan costs $ - 0 Monthly payments $ - 0
Total required $ - 0 Annual principal payment $ - 0
Annual interest payment $ - 0
Total amount to be repaid $ - 0
Other Loan Details (ie. personal loan, second mortgage)
Name of lender
Estimated loan $ - 0 Total loan $ - 0
Stamp duty $ - 0 Loan term (years)
Application fees $ - 0 Interest rate 0.00%
Other loan costs $ - 0 Monthly payments $ - 0
Total required $ - 0 Annual principal payment $ - 0
Annual interest payment $ - 0
Total amount to be repaid $ - 0
Other Loan Details (ie. personal loan, second mortgage)
Name of lender
Estimated loan $ - 0 Total loan $ - 0
Stamp duty $ - 0 Loan term (years)
Application fees $ - 0 Interest rate 0.00%
Other loan costs $ - 0 Monthly payments $ - 0
Total required $ - 0 Annual principal payment $ - 0
Annual interest payment $ - 0
Total amount to be repaid $ - 0
TOTAL LOANS MONTHLY REPAYMENT $ - 0

Financial Table 6AB

Financial Table 6A - CASH FLOW FORECAST (Year 1)
Business Name: 0
0 0 0 0 0 0 0 0 0 0 0 0
1 2 3 4 5 6 7 8 9 10 11 12 Totals
CASH INFLOW
Cash sales (excluding GST) 9,360 11,720 17,840 10,180 12,120 10,240 12,220 11,540 14,480 6,920 16,340 8,680 141,640
Bank loans 0 0 0 0 0 0 0 0 0 0 0 0 0
Other income (specify) (excluding GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
A. RECEIPTS 9,360 11,720 17,840 10,180 12,120 10,240 12,220 11,540 14,480 6,920 16,340 8,680 141,640
CASH OUTFLOW
Purchases - stock and materials (cost of sales) 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Purchases - plant and equipment 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 12,000
Purchases - sundry materials not in cost of goods sold 0 0 0 0 0 0 0 0 0 0 0 0 0
Accounting fees 400 400 400 400 400 400 400 400 400 400 400 400 4,800
Advertising 400 400 400 400 400 400 400 400 400 400 400 400 4,800
Electricity / gas 50 50 50 50 50 50 50 50 50 50 50 50 600
Insurances 70 70 70 70 70 70 70 70 70 70 70 70 840
Leasing of equipment 600 600 600 600 600 600 600 600 600 600 600 600 7,200
Legal expenses 300 300 300 300 300 300 300 300 300 300 300 300 3,600
Motor vehicle expenses 200 200 200 200 200 200 200 200 200 200 200 200 2,400
Printing and postage 100 100 100 100 100 100 100 100 100 100 100 100 1,200
Rent / lease of property 284 284 284 284 284 284 284 284 284 284 284 284 3,408
Repairs and maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0
Stationery and office supplies 80 80 80 80 80 80 80 80 80 80 80 80 960
Telephone 135 135 135 135 135 135 135 135 135 135 135 135 1,620
Others (specify) 300 300 300 300 300 300 300 300 300 300 300 300 3,600
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
Bank interest and charges (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Commissions (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Employee wages (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Hire purchase payments (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Loan repayments (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Owner's drawings (no GST) 1,325 -1,000 -1,000 -1,000 -1,000 -1,000 -1,000 -1,000 -1,000 100 100 100 -6,375
B. BUSINESS EXPENSES 5,444 3,119 3,119 3,119 3,119 3,119 3,119 3,119 3,119 4,219 4,219 4,219 43,053
C. GST RECEIVED 936 1,172 1,784 1,018 1,212 1,024 1,222 1,154 1,448 692 1,634 868 14,164
Input Tax Credits (GST Paid) 374 374 374 374 374 374 374 374 374 374 374 374 4,493
D. NET GST PAYABLE 2,769 2,131 2,701
Tax Instalment Rate
E. TAX PAYABLE 0 0 0
F. NET CASH FLOW [(A+C)-(B+D+E)] 4,852 9,773 16,505 5,310 10,213 8,145 8,192 9,575 12,809 692 13,755 5,329
G. OPENING BALANCE (cash at start of month) 4,852 14,625 31,130 36,440 46,653 54,798 62,991 72,566 85,375 86,067 99,822
H. CLOSING BALANCE (cash at end of month (G+F)) 4,852 14,625 31,130 36,440 46,653 54,798 62,991 72,566 85,375 86,067 99,822 105,151
Financial Table 6B - CASH FLOW FORECAST (Year 2)
Business Name: 0
0 0 0 0 0 0 0 0 0 0 0 0
1 2 3 4 5 6 7 8 9 10 11 12 Totals
CASH INFLOW
Cash sales (excluding GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Bank loans 0 0 0 0 0 0 0 0 0 0 0 0 0
Other income (specify) (excluding GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
A. RECEIPTS 0 0 0 0 0 0 0 0 0 0 0 0 0
CASH OUTFLOW
Purchases - stock and materials (cost of sales) 0 0 0 0 0 0 0 0 0 0 0 0 0
Purchases - plant and equipment 0 0 0 0 0 0 0 0 0 0 0 0 0
Purchases - sundry materials not in cost of goods sold 0 0 0 0 0 0 0 0 0 0 0 0 0
Accounting fees 0 0 0 0 0 0 0 0 0 0 0 0 0
Advertising 0 0 0 0 0 0 0 0 0 0 0 0 0
Electricity / gas 0 0 0 0 0 0 0 0 0 0 0 0 0
Insurances 0 0 0 0 0 0 0 0 0 0 0 0 0
Leasing of equipment 0 0 0 0 0 0 0 0 0 0 0 0 0
Legal expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Motor vehicle expenses 0 0 0 0 0 0 0 0 0 0 0 0 0
Printing and postage 0 0 0 0 0 0 0 0 0 0 0 0 0
Rent / lease of property 0 0 0 0 0 0 0 0 0 0 0 0 0
Repairs and maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0
Stationery and office supplies 0 0 0 0 0 0 0 0 0 0 0 0 0
Telephone 0 0 0 0 0 0 0 0 0 0 0 0 0
Others (specify) 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0
Bank interest and charges (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Commissions (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Employee wages (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Hire purchase payments (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Loan repayments (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
Owner's drawings (no GST) 0 0 0 0 0 0 0 0 0 0 0 0 0
B. BUSINESS EXPENSES 0 0 0 0 0 0 0 0 0 0 0 0 0
C. GST RECEIVED 0 0 0 0 0 0 0 0 0 0 0 0 0
Input Tax Credits (GST Paid) 0 0 0 0 0 0 0 0 0 0 0 0 0
D. NET GST PAYABLE 2,071 0 0 0
Tax Instalment Rate
E. TAX PAYABLE 0 0 0 0
F. NET CASH FLOW [(A+C)-(B+D+E)] 0 0 0 0 0 0 0 0 0 0 0 0
G. OPENING BALANCE (cash at start of month) 105,151 105,151 105,151 105,151 105,151 105,151 105,151 105,151 105,151 105,151 105,151 105,151
H. CLOSING BALANCE (cash at end of month (G+F)) 105,151 105,151 105,151 105,151 105,151 105,151 105,151 105,151 105,151 105,151 105,151 105,151

Financial Table 7AB

Financial Table 7A - PROFIT AND LOSS PROJECTION (Year 1)
Business Name: 0
Income
Total sales from Sales Mix $ 141,640
Other income from Cash Flow $ -
A. TOTAL BUSINESS INCOME $ 141,640
B. COST OF SALES (Puchases - stock/materials) $ 2,182
C. GROSS PROFIT (A - B) $ 139,458
Expenditure
Accounting fees $ 4,800
Advertising $ 4,800
Bank interest and charges $ -
Commissions $ -
Electricity / gas $ 600
Employees wages $ -
Hire purchase payments $ -
Insurances $ 840
Leasing of equipment $ 7,200
Legal expenses $ 3,600
Motor vehicle expenses $ 2,400
Purchases - sundry materials (not in cost of goods sold) $ -
Printing and postage $ 1,200
Rent / lease of property $ 3,408
Repairs and maintenance $ -
Stationery and office supplies $ 960
Telephone $ 1,620
Others (specify) $ 3,600
0 $ -
0 $ -
0 $ -
(Input Tax Credits excluding Cost of Sales) $ 4,275
D. TOTAL EXPENSES $ 30,753
E. NET PROFIT (C - D)* $ 108,705
* The net profit should be sufficient to cover the following:
Coverage
Estimated tax liability $ -
Loan repayments $ -
Owners drawings $ (6,375)
Purchases - plant and equipment $ 12,000
F. TOTAL COVERAGE $ 5,625
G. PROFIT RESERVES $ 103,080
Financial Table 7B - PROFIT AND LOSS PROJECTION (Year 2)
Business Name: 0
Income
Total sales from Sales Mix $ -
Other income from Cash Flow $ -
A. TOTAL BUSINESS INCOME $ -
B. COST OF SALES (Puchases - stock/materials) $ -
C. GROSS PROFIT (A - B) $ -
Expenditure
Accounting fees $ -
Advertising $ -
Bank interest and charges $ -
Commissions $ -
Electricity / gas $ -
Employees wages $ -
Hire purchase payments $ -
Insurances $ -
Leasing of equipment $ -
Legal expenses $ -
Motor vehicle expenses $ -
Purchases - sundry materials (not in cost of goods sold) $ -
Printing and postage $ -
Rent / lease of property $ -
Repairs and maintenance $ -
Stationery and office supplies $ -
Telephone $ -
Others (specify) $ -
0 $ -
0 $ -
0 $ -
(Input Tax Credits excluding Cost of Sales) $ -
D. TOTAL EXPENSES $ -
E. NET PROFIT (C - D)* $ -
* The net profit should be sufficient to cover the following:
Coverage
Estimated tax liability $ -
Loan repayments $ -
Owners drawings $ -
Purchases - plant and equipment $ -
F. TOTAL COVERAGE $ -
G. PROFIT RESERVES $ -

Sheet10
&A
Page &P

Sheet11
&A
Page &P

Sheet12
&A
Page &P

Sheet13
&A
Page &P

Sheet14
&A
Page &P

Sheet15
&A
Page &P

Sheet16
&A
Page &P