Lansing Aviation

Start your own business plan »

Aircraft Rental Instruction Business Plan

Appendix

Sales 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
Sales
Aircraft Rental 0% $693 $1,500 $3,000 $3,750 $4,500 $5,625 $5,625 $4,875 $4,875 $4,875 $4,875 $4,875
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $693 $1,500 $3,000 $3,750 $4,500 $5,625 $5,625 $4,875 $4,875 $4,875 $4,875 $4,875
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Aircraft Rental $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
Subtotal Direct Cost of Sales $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
Owner 0% $0 $0 $0 $0 $833 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Name or title 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Name or title 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 People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $0 $0 $0 $0 $833 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00% 28.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $693 $1,500 $3,000 $3,750 $4,500 $5,625 $5,625 $4,875 $4,875 $4,875 $4,875 $4,875
Direct Cost of Sales $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
Total Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin $693 $1,500 $3,000 $3,750 $4,500 $5,625 $5,625 $4,875 $4,875 $4,875 $4,875 $4,875
Gross Margin % 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 $0 $0 $0 $0 $833 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Fixed Operations Costs $0 $1,300 $2,623 $2,623 $2,623 $2,623 $2,623 $2,623 $2,623 $2,623 $2,623 $2,623
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $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
Payroll Taxes 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Aircraft Upgrades 15% $0 $0 $0 $0 $0 $0 $0 $0 $500 $0 $1,000 $0
Mainenance and Repairs $0 $0 $0 $200 $0 $500 $0 $500 $0 $0 $0 $0
Total Operating Expenses $0 $1,600 $2,923 $3,123 $3,756 $4,423 $3,923 $4,423 $4,423 $3,923 $4,923 $3,923
Profit Before Interest and Taxes $693 ($100) $77 $627 $744 $1,202 $1,702 $452 $452 $952 ($48) $952
EBITDA $693 $200 $377 $927 $1,044 $1,502 $2,002 $752 $752 $1,252 $252 $1,252
Interest Expense $270 $270 $270 $270 $270 $270 $270 $270 $265 $260 $255 $248
Taxes Incurred $127 ($104) ($54) $100 $133 $261 $401 $51 $52 $194 ($85) $197
Net Profit $296 ($266) ($139) $257 $341 $671 $1,031 $131 $135 $498 ($218) $507
Net Profit/Sales 42.73% -17.76% -4.63% 6.85% 7.58% 11.93% 18.33% 2.69% 2.76% 10.22% -4.48% 10.39%
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 Sales $693 $1,500 $3,000 $3,750 $4,500 $5,625 $5,625 $4,875 $4,875 $4,875 $4,875 $4,875
Subtotal Cash from Operations $693 $1,500 $3,000 $3,750 $4,500 $5,625 $5,625 $4,875 $4,875 $4,875 $4,875 $4,875
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 $693 $1,500 $3,000 $3,750 $4,500 $5,625 $5,625 $4,875 $4,875 $4,875 $4,875 $4,875
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 $0 $0 $0 $0 $833 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Bill Payments $13 $433 $1,512 $2,851 $3,187 $3,047 $3,642 $3,299 $3,444 $3,428 $3,101 $3,769
Subtotal Spent on Operations $13 $433 $1,512 $2,851 $4,020 $4,047 $4,642 $4,299 $4,444 $4,428 $4,101 $4,769
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 $600 $600 $600 $800
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 $13 $433 $1,512 $2,851 $4,020 $4,047 $4,642 $4,299 $5,044 $5,028 $4,701 $5,569
Net Cash Flow $680 $1,067 $1,488 $899 $480 $1,578 $983 $576 ($169) ($153) $174 ($694)
Cash Balance $980 $2,047 $3,535 $4,434 $4,914 $6,492 $7,475 $8,051 $7,883 $7,729 $7,904 $7,210
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 $300 $980 $2,047 $3,535 $4,434 $4,914 $6,492 $7,475 $8,051 $7,883 $7,729 $7,904 $7,210
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $300 $980 $2,047 $3,535 $4,434 $4,914 $6,492 $7,475 $8,051 $7,883 $7,729 $7,904 $7,210
Long-term Assets
Long-term Assets $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000 $36,000
Accumulated Depreciation $0 $0 $300 $600 $900 $1,200 $1,500 $1,800 $2,100 $2,400 $2,700 $3,000 $3,300
Total Long-term Assets $36,000 $36,000 $35,700 $35,400 $35,100 $34,800 $34,500 $34,200 $33,900 $33,600 $33,300 $33,000 $32,700
Total Assets $36,300 $36,980 $37,747 $38,935 $39,534 $39,714 $40,992 $41,675 $41,951 $41,483 $41,029 $40,904 $39,910
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 $384 $1,418 $2,744 $3,087 $2,925 $3,532 $3,184 $3,329 $3,326 $2,974 $3,667 $2,966
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 $384 $1,418 $2,744 $3,087 $2,925 $3,532 $3,184 $3,329 $3,326 $2,974 $3,667 $2,966
Long-term Liabilities $32,400 $32,400 $32,400 $32,400 $32,400 $32,400 $32,400 $32,400 $32,400 $31,800 $31,200 $30,600 $29,800
Total Liabilities $32,400 $32,784 $33,818 $35,144 $35,487 $35,325 $35,932 $35,584 $35,729 $35,126 $34,174 $34,267 $32,766
Paid-in Capital $10,450 $10,450 $10,450 $10,450 $10,450 $10,450 $10,450 $10,450 $10,450 $10,450 $10,450 $10,450 $10,450
Retained Earnings ($6,550) ($6,550) ($6,550) ($6,550) ($6,550) ($6,550) ($6,550) ($6,550) ($6,550) ($6,550) ($6,550) ($6,550) ($6,550)
Earnings $0 $296 $30 ($109) $148 $489 $1,160 $2,191 $2,322 $2,457 $2,955 $2,737 $3,244
Total Capital $3,900 $4,196 $3,930 $3,791 $4,048 $4,389 $5,060 $6,091 $6,222 $6,357 $6,855 $6,637 $7,144
Total Liabilities and Capital $36,300 $36,980 $37,747 $38,935 $39,534 $39,714 $40,992 $41,675 $41,951 $41,483 $41,029 $40,904 $39,910
Net Worth $3,900 $4,196 $3,930 $3,791 $4,048 $4,389 $5,060 $6,091 $6,222 $6,357 $6,855 $6,637 $7,144