|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Additional Inputs |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Prepared By: |
Company Name: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sam Miller |
Aviator Inc |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Receivable
(A/R) Days Sales Outstanding |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Percent of Collections |
Year 1 |
Year 2 |
Year 3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Paid within 30 days[1] |
30% |
30% |
30% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Paid between 30 and 60 days[2] |
60% |
60% |
60% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Paid in more than 60 days[3] |
10% |
10% |
10% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Allowance for bad debt[4] |
0% |
0% |
0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This should equal 100% ----> |
100% |
100% |
100% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts Payable
(A/P) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Percent of Disbursements |
Year 1 |
Year 2 |
Year 3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Paid within 30 days |
30% |
30% |
30% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Paid between 30 and 60 days |
70% |
70% |
70% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Paid in more than 60 days |
0% |
0% |
0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This should equal 100% ----> |
100% |
100% |
100% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Line of Credit
Assumptions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Desired
Minimum Cash Balance |
0[5] |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Line of
Credit Interest Rate |
8.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Additional Fixed
Assets Purchases[6] |
|
Fixed Assets |
Depreciation (years) |
Sept |
Oct |
Nov |
Dec |
Jan |
Feb |
Mar |
Apr |
May |
June |
July |
Aug |
Year 1 Totals |
Year 2 Total |
Year 3 Total |
|
Real Estate |
20 |
$
43,000,000 |
|
|
|
|
|
|
|
|
|
|
|
$
43,000,000 |
|
|
|
Leasehold Improvements |
7 |
$
12,000,000 |
|
|
|
|
|
|
|
|
|
|
|
$
12,000,000 |
|
|
|
Equipment |
7 |
$
18,000,000 |
|
|
|
|
|
|
|
|
|
|
|
$
18,000,000 |
|
|
|
Furniture and Fixtures |
5 |
$
5,000,000 |
|
|
|
|
|
|
|
|
|
|
|
$ 5,000,000 |
|
|
|
Vehicles |
5 |
$
22,000,000 |
|
|
|
|
|
|
|
|
|
|
|
$
22,000,000 |
|
|
|
Other Fixed Assets |
5 |
$
3,500,000 |
|
|
|
|
|
|
|
|
|
|
|
$ 3,500,000 |
$ - |
$ - |
|
Total Additional Fixed Assets |
|
$ 103,500,000 |
$ - |
$ - |
$ - |
$ - |
$ - |
$ - |
$ - |
$ - |
$ - |
$ - |
$ - |
$
103,500,000 |
$ - |
$ - |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Income Tax
Assumptions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Effective Income Tax Rate - Year 1 |
35.0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Effective Income Tax Rate - Year 2 |
35.0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Effective Income Tax Rate - Year 3 |
35.0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Amortization of
Start-Up Costs |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Amortization Period in Years |
3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|