Due in 9 hours

profilets7it
cashflowandincomestatemetn.xlsx

Income Statement

Income Statement Summary for the 1st Year of Operation
When budgeting, include all the expenses of setting up the store and ordering merchandise. Due to the considerable expenditure assume the 1st 3-6 months of operation have a negative net income.
You may add line items to any of the income or expense categories.
When calculating the Total net income use the following equation = Income - cost of sales - expenses
When estimating the figures, list your assumptions on bottom of the page.
Business name: xx
January February March April May June July August September October November December
Income
Web site N/A
Store location 3,250/month
Add more items if applicable
Subtotal: 3,250
Cost of sales
Inventory 2000
Shipping 0
Add more items if applicable
Subtotal: 2000
G&A Expenses
Retail lease 4,000
Utilities 100
Phone 30
Internet 30
Marketing 1500
Supplies 1000
Merchandise 590
Subtotal: 7250
Total net income (income - cost of sales - expenses) -6000
Assumptions: There will be more merchandise in there store therefore there will be more sale, as of right now I've got a negative number for the net income which means the business cannot survive.
When estimating the figures, list your assumptions on bottom of the page.
Assuming that the sales go up having at least 10 customers a day spending $100, the montley income would be $30,000. It could also be higher depending on the month. For example during Holiday season, November and December sales would go up . Assumin up.
Assuming that the sales increase by $30,000 for November and December. $40,000 by promoting and Marketing and also during summertime. A decrease after the Holidays, around January, February could decrease the sales to $15,000.

Cash Flow

Budget Template
By using the figures from the Budget 2008 template use this template to calculate your quarterly and yearly cash flow for the 1st year.
Gross Sales Cost of Sales Gross Margin = Gross Sales – Cost of Sales Gross Margin % = Gross Margin/Gross Sales X 100 Operating Expenses Net Income = Gross Margin – Operating Expenses
Quarter 1
Quarter 2
Quarter 3
Quarter 4
Annual