Start-up Expenses Year 1 (Starting Balance Sheet)
Prepared By: Company Name:
Sam Miller Aviator Inc
Fixed Assets Amount Depreciation (years)[1] Notes  
         
Real Estate-Land          20,000,000  Not Depreciated     
Real Estate-Buildings          43,000,000                                 20    
Leasehold Improvements          12,000,000                                  7    
Equipment          18,000,000                                  7    
Furniture and Fixtures           5,000,000                                  5    
Vehicles          22,000,000                                  5    
Other           3,500,000                                  5    
Total Fixed Assets  $    123,500,000      
   
Operating Capital  Amount  Notes
Pre-Opening Salaries and Wages           3,300,000  
Prepaid Insurance Premiums              450,000  
Inventory          54,000,000  
Legal and Accounting Fees              500,000  
Rent Deposits                50,000  
Utility Deposits                50,000  
Supplies              150,000  
Advertising and Promotions          38,000,000  
Licenses           4,500,000  
Other Initial Start-Up Costs          12,500,000  
Working Capital (Cash On Hand)[2]          22,000,000  
Total Operating Capital  $    135,500,000  
Total Required Funds  $    259,000,000  
Sources of Funding Percentage Totals Loan Rate Term in Months Monthly Payments Notes
Owner's Equity 3.47%                      9,000,000       Stocks Exchanged
Outside Investors 96.53%                   250,000,000 9.00% 60 1,875,000.00  
Additional Loans or Debt            
Commercial Loan 0.00%                                   - 9.00% 84 0.00  
Commercial Mortgage 0.00%                                   - 9.00% 240 0.00   See Loan Amortization & Depreciation Schedule
Credit Card Debt 0.00%                                   - 7.00% 60 0.00  
Vehicle Loans 0.00%                                   - 6.00% 48 0.00  
Other Bank Debt 0.00%                                   - 5.00% 36 0.00  
Total Sources of Funding 100.00%  $               259,000,000 Cell D 42 must equal cell C31 0.00  
Total Funding Needed    $                               - You are fully funded (Balanced)  
Need Help? Ask SCORE.
Existing Businesses ONLY -- Calculating Cash on Hand
Cash                        -
+ Accounts Receivable                        -
+ Prepaid Expenses                        -
- Accounts Payable                         -
- Accrued Expenses                        -
Total Cash on Hand  $                    -
[1]
Years of depreciation must be 3 or more for the calculations in this workbook to work correctly.
[2]
Existing businesses should use the calculator at the bottom of this page to determine the Working Capital amount. Calculate the number, then enter it here.