Sheet 1: Directions

	
	
	
	
	
	
	
	
	
	
	
	

		
Last revised 5/2016. See revision notes on last tab.
		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Step 1 - Enter info about your company in yellow shaded boxes below.
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		
Preparer Name
		
Company Name
		
Starting Month
		
Starting Year
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Step 2 - Read the following instructions
		


		


		


		


		


		


		


		


	
	

		


		


		


		


		

 
		
		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		

 
		
		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		

 
		
		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		


		
-10000
		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


	
	

		


		
Month 1
		
Month 2
		
Month 3
		
Month 8
		
Month 9
		
Month 10
		
Month 11
		
Month 12
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


	

 




Sheet 2: 1-StartingPoint

	
	
	
	
	
	
	
	
	

		
Start-up Expenses Year 1 (Starting Balance Sheet)
		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
Prepared By:
		
Company Name:
		


		


		


		


		


		


		


		


		


	
	

		
Owner
		
Company 1
		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
Fixed Assets
		
Amount
		
Depreciation (years)
		
Notes
		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


	
	

		
Real Estate-Land
		


		
 Not Depreciated 
		


		


		


		


		


		


		


	
	

		
Real Estate-Buildings
		


		
 20 
		


		


		


		


		


		


		


	
	

		
Leasehold Improvements
		


		
 7 
		


		


		


		


		


		


		


	
	

		
Equipment
		


		
 7 
		


		


		


		


		


		


		


	
	

		
Furniture and Fixtures
		


		
 5 
		


		


		


		


		


		


		


	
	

		
Vehicles
		


		
 5 
		


		


		


		


		


		


		


	
	

		
Other
		


		
 5 
		


		


		


		


		


		


		


	
	

		
Total Fixed Assets
		
 $- 
		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


	
	

		
Operating Capital
		
 Amount 
		
Notes
		


		


		


		


		


		


	
	

		
Pre-Opening Salaries and Wages
		


		


		


		


		


		


		


		


	
	

		
Prepaid Insurance Premiums
		


		


		


		


		


		


		


		


	
	

		
Inventory
		


		


		


		


		


		


		


		


	
	

		
Legal and Accounting Fees
		


		


		


		


		


		


		


		


	
	

		
Rent Deposits
		


		


		


		


		


		


		


		


	
	

		
Utility Deposits
		


		


		


		


		


		


		


		


	
	

		
Supplies
		


		


		


		


		


		


		


		


	
	

		
Advertising and Promotions
		


		


		


		


		


		


		


		


	
	

		
Licenses
		


		


		


		


		


		


		


		


	
	

		
Other Initial Start-Up Costs
		


		


		


		


		


		


		


		


	
	

		
Working Capital (Cash On Hand)
		


		


		


		


		


		


		


		


	
	

		
Total Operating Capital
		
 $- 
		


		


		


		


		


		


		


	
	

		
Total Required Funds
		
 $- 
		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		
Sources of Funding
		
Percentage
		
Totals
		
Loan Rate
		
Term in Months
		
Monthly Payments
		
Notes
		


		


		


		


	
	

		
Owner's Equity
		
0.00%
		


		


		


		


		


		


		


		


		


	
	

		
Outside Investors
		
0.00%
		


		


		


		


		


		


		


		


		


	
	

		
Additional Loans or Debt
		


		


		


		


		


		


		


		


		


		


	
	

		
Commercial Loan
		
0.00%
		


		
9.00%
		
84 
		
 - 
		


		


		


		


		


	
	

		
Commercial Mortgage
		
0.00%
		


		
9.00%
		
240 
		
 - 
		


		


		
See Loan Amortization & Depreciation Schedule
		
	

		
Credit Card Debt
		
0.00%
		


		
7.00%
		
60 
		
 - 
		


		


		
	

		
Vehicle Loans
		
0.00%
		


		
6.00%
		
48 
		
 - 
		


		


		
	

		
Other Bank Debt
		
0.00%
		


		
5.00%
		
36 
		
 - 
		


		


		
	

		
Total Sources of Funding
		
0.00%
		
 $- 
		
Cell D 42 must equal cell C31
		
 $- 
		


		


		


		


		


	
	

		
Total Funding Needed
		


		
 $- 
		
You are fully funded (Balanced)
		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		

 
		
		


		


		


		


		


		


	
	

		
Existing Businesses ONLY -- Calculating Cash on Hand
		


		


		


		


		


		


	
	

		
Cash
		
 - 
		


		


		


		


		


		


	
	

		
+ Accounts Receivable
		
 - 
		


		


		


		


		


		


	
	

		
+ Prepaid Expenses
		
 - 
		


		


		


		


		


		


	
	

		
- Accounts Payable 
		
 - 
		


		


		


		


		


		


	
	

		
- Accrued Expenses
		
 - 
		


		


		


		


		


		


	
	

		
Total Cash on Hand
		
 $- 
		


		


		


		


		


		


	



Sheet 3: 2a-PayrollYear1

	
	
	
	
	
	
	
	
	
	
	

		


		
Payroll Year 1
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Prepared By:
		
Company Name:
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		
Owner
		
Company 1
		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Employee Types
		
Number of Owners /Employees
		
Average Hourly Pay (to 2 decimal places, ex. $15.23)
		
Estimated Hrs./Week (per person)
		
Estimated Pay/Month (Total)
		
Month 1
		
Month 2
		
Month 3
		
Month 4
		
Month 5
		
Month 6
		
Month 7
		
Month 8
		
Month 9
		
Month 10
		
Month 11
		
Month 12
		
Annual Totals
	
	

		
Owner(s)
		


		


		


		
 $- 
		

		These cells have been auto-populated, but can be overwritten if your payroll expenses increase over time. To restore the auto-population, enter this formula in the cell: =F[insert row number]. For example, the first row in this section would use: =F8. 

		 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Full-Time Employees
		


		


		


		
 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Part-Time Employees
		


		


		


		
 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Independent Contractors
		


		


		


		
 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Total Salaries and Wages
		
0 
		
 $-   
		
0 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Payroll Taxes and Benefits
		

		The Wage Base limit is the maximum earned gross income on which a given tax may be imposed. If you are paying a salary above that amount, you'll need to factor that into your calculation. The amounts below are for 2012.


		Wage Base Limit
		
Percentage of Salary/Wage
		


		
Estimated Taxes & Benefits/Month (Total)
		
Month 1
		
Month 2
		
Month 3
		
Month 4
		
Month 5
		
Month 6
		
Month 7
		
Month 8
		
Month 9
		
Month 10
		
Month 11
		
Month 12
		
Annual Totals
	
	

		
Social Security
		
 $117,000 
		

		This number will be an approximation of the FICA taxes. If the salaries of individuals exceed the wage base limit, this number will overstate the FICA tax and should be adjusted.

		6.20%
		


		
 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Medicare
		
--
		
1.45%
		


		
 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Federal Unemployment Tax (FUTA)
		
 $7,000 
		

		The Federal Unemployment tax rate was 6.2% from January 1, 2011 through June 30, 2011; and decreased to 6.0% as of July 1, 2011. It is currently still set at that rate, less a maximum credit of 5.4% for amounts paid under State unemployment insurance laws.  Accordingly, the normal net FUTA tax is 0.6%. This information is as-of November 2015. Check with the IRS for current information. 


		0.60%
		


		
 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
State Unemployment Tax (SUTA)
		
 $7,000 
		

		Each state has different SUTA rates and wage base limits. Tailor this cell to reflect your state's information.

		3.45%
		


		
 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Employee Pension Programs
		
--
		
0.00%
		


		

		
For these benefits, the formula assumes part-time employees are included. If this is not the case, change the formula accordingly.
		 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Worker's Compensation
		
--
		
0.00%
		


		

		
For these benefits, the formula assumes part-time employees are included. If this is not the case, change the formula accordingly.

		 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Employee Health Insurance
		
--
		
0.00%
		


		

		
For these benefits, the formula assumes part-time employees are included. If this is not the case, change the formula accordingly.

		 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Other Employee Benefit Programs
		
--
		
0.00%
		


		

		
For these benefits, the formula assumes part-time employees are included. If this is not the case, change the formula accordingly.

		 $- 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 - 
		
 $- 
	
	

		
Total Payroll Taxes and Benefits
		


		
11.70%
		


		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
	
	

		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


		


	
	

		
Total Salaries and Related Expenses
		


		


		


		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $- 
		
 $-