ASTI - Advanced Science and Technology Institute

Start your own business plan »

Government Services Business Plan

Appendix

Funding Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Funding
University Funding 0% $160,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Full Memberships 0% $9,000 $9,000 $9,000 $9,000 $9,000 $9,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Associate Memberships 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total Funding $172,000 $12,000 $12,000 $12,000 $12,000 $12,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Direct Cost of Funding Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
University Funding $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Full Memberships $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Associate Memberships $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cost of Funding $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Director 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Research Associate 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Communication Associate 0% $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Administrative Assistant 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total People 4 4 4 4 4 4 4 4 4 4 4 4
Total Payroll $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Surplus and Deficit
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Funding $172,000 $12,000 $12,000 $12,000 $12,000 $12,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Direct Cost $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Direct Cost $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Surplus $172,000 $12,000 $12,000 $12,000 $12,000 $12,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Gross Surplus % 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Sales and Marketing and Other Expenses $6,917 $6,917 $6,917 $6,917 $6,917 $6,917 $6,917 $6,917 $6,917 $6,917 $6,917 $6,917
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167 $167
Insurance $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Rent $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Payroll Taxes 15% $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800 $1,800
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033
Surplus Before Interest and Taxes $149,967 ($10,033) ($10,033) ($10,033) ($10,033) ($10,033) ($13,033) ($13,033) ($13,033) ($13,033) ($13,033) ($13,033)
EBITDA $149,967 ($10,033) ($10,033) ($10,033) ($10,033) ($10,033) ($13,033) ($13,033) ($13,033) ($13,033) ($13,033) ($13,033)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Surplus $149,967 ($10,033) ($10,033) ($10,033) ($10,033) ($10,033) ($13,033) ($13,033) ($13,033) ($13,033) ($13,033) ($13,033)
Net Surplus/Funding 87.19% -83.61% -83.61% -83.61% -83.61% -83.61% -144.81% -144.81% -144.81% -144.81% -144.81% -144.81%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Funding $172,000 $12,000 $12,000 $12,000 $12,000 $12,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Subtotal Cash from Operations $172,000 $12,000 $12,000 $12,000 $12,000 $12,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $172,000 $12,000 $12,000 $12,000 $12,000 $12,000 $9,000 $9,000 $9,000 $9,000 $9,000 $9,000
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000 $12,000
Bill Payments $334 $10,033 $10,033 $10,033 $10,033 $10,033 $10,033 $10,033 $10,033 $10,033 $10,033 $10,033
Subtotal Spent on Operations $12,334 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $12,334 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033 $22,033
Net Cash Flow $159,666 ($10,033) ($10,033) ($10,033) ($10,033) ($10,033) ($13,033) ($13,033) ($13,033) ($13,033) ($13,033) ($13,033)
Cash Balance $313,866 $303,832 $293,799 $283,766 $273,732 $263,699 $250,666 $237,632 $224,599 $211,566 $198,532 $185,499
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $154,200 $313,866 $303,832 $293,799 $283,766 $273,732 $263,699 $250,666 $237,632 $224,599 $211,566 $198,532 $185,499
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $154,200 $313,866 $303,832 $293,799 $283,766 $273,732 $263,699 $250,666 $237,632 $224,599 $211,566 $198,532 $185,499
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $154,200 $313,866 $303,832 $293,799 $283,766 $273,732 $263,699 $250,666 $237,632 $224,599 $211,566 $198,532 $185,499
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $0 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699
Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699 $9,699
Paid-in Capital $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000 $160,000
Accumulated Surplus/Deficit ($5,800) ($5,800) ($5,800) ($5,800) ($5,800) ($5,800) ($5,800) ($5,800) ($5,800) ($5,800) ($5,800) ($5,800) ($5,800)
Surplus/Deficit $0 $149,967 $139,933 $129,900 $119,867 $109,833 $99,800 $86,767 $73,733 $60,700 $47,667 $34,633 $21,600
Total Capital $154,200 $304,167 $294,133 $284,100 $274,067 $264,033 $254,000 $240,967 $227,933 $214,900 $201,867 $188,833 $175,800
Total Liabilities and Capital $154,200 $313,866 $303,832 $293,799 $283,766 $273,732 $263,699 $250,666 $237,632 $224,599 $211,566 $198,532 $185,499
Net Worth $154,200 $304,167 $294,133 $284,100 $274,067 $264,033 $254,000 $240,967 $227,933 $214,900 $201,867 $188,833 $175,800