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

[1]

If you are a retail business or don't have accounts receivable put 100% for each year.
[2]

In this field put the percentage of your sales that you expect to carry as A/R. If your business sells in cash, put 0%. Otherwise, estimate the percentage that will be paid between 30 and 60 days after sale.
[3]

In this field put the percentage of your sales that you expect to carry as A/R but not paid for more than 60 days. If your business sells in cash, put 0%. Otherwise, estimate the percentage that will be paid more than 60 days after sale.
[4]

Allowance for bad debt is the percentage of total A/R you believe will not be collectable for whatever reason. It could be because your customer becomes insolvent or goes out of business.

If you can find an industry average for your industry, use that percentage. If in doubt, use either 0 or 1%. Many businesses that have good collection processes may have substantially less than 1% during a strong economy. Bankers like to see a figure here because it lets them know you are realistic about discounting the total value of your A/R as collateral for a potential loan.
[5]
How low do you want to let your ending cash balance to get? The minimum should be $0, but you might want to choose $1000, $5000, etc.
[6]

Use this space to add items purchased after the date of the starting point (Tab 1a).