final project

Year 1

BA 100 Business Plan: Income (Profit-and-Loss) Statement--Simplified
	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	YEAR 1
Expected Unit Sold													0
Price Per Unit
Total Revenue	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Unit Cost of Goods Sold Hu, Jianli: What is the average cost per unit?
Total Cost of Goods Sold	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Gross Profit	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Expenses
Rent Expense													$0.00
Salary/Wage Expenses													$0.00
Supplies Expense													$0.00
Advertising Expense													$0.00
Utilities Expense													$0.00
Telephone/ Internet Expense													$0.00
Insurance Expense													$0.00
Loan Interest (if applicable)													$0.00
Other Expenses													$0.00
Total Expenses	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Net Profit	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00

1. Fill the yellow cells with proper estimates for your business. 2. All green cells are set to calculate automatically. 3. The blue cell (Cell N24) shows your total profit of the first year. Note that this number might be negative if you incur more expenses in the first year. 4. If you have multiple products, you can copy and paste the sheet to a new sheet.