Lansing Aviation
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 |