No Borrowing This spreadsheet is from your Busine
In the businessplan #4 assignment, in
Startup Expenses You must make guesses (as realistic
Legal 1,000.00
Prototype Dev 12,000.00 The numbers in these spreadsheets a
Initial Advertising 5,000.00 formulas are working.
Insurance 500.00
Rent 8,400.00 These spreadsheets are not perfect,
Office Supplies 2,000.00
Expensed Equipment 5,000.00
Consultants 5,000.00
Other 1,000.00 R. Reese/Oct 2006
Total Startup Expenses 39,900.00
Startup Assets needed
Cash Balance on Starting date 25,000.00
Startup Inventory 0.00
Capital Assets 7,000.00
Total Current Assets 32,000.00 Total Capital
Total Startup Requirements 71,900.00
Funding
Investment
Investor1 - Christopher Heering 10,000.00
Investor2 - David Close 10,000.00
Investor3 - Larita Copprue 10,000.00
Investor4 - Johnathan Parnell 10,000.00
Investor5 - Friends & Family 10,000.00
Investor6 - Hunting Clubs 10,000.00
Total Investment 60,000.00 Investors have covered total costs
Current Liabilities
Accounts Payable 0.00
Current Borrowing 11,900.00 no liabilities to start
Other Current Liabilities 0.00
Total Current Liabilities 11,900.00
Long-term Liabilities 0.00
Total Liabilities 11,900.00
Left To Finance 0.00
Loss at Start-up 39,900.00 total investment-total capital = startup expense
Total Capital 20,100.00 total assets - total liabilities
Total Capital and Liabilities 32,000.00
Checkline 0.00 Should always be zero
adsheet is from your Business plan #1 assignment.
inessplan #4 assignment, include projected cashflow, profit/loss, balance sheet for a three year period.
make guesses (as realistic as you can) at these numbers over a three year period.
bers in these spreadsheets are just test numbers used to determine if
eadsheets are not perfect, but give you an idea of what is in the four different spreadsheets.
Receives data from Startup Sheet, Cashflow Sheet
Startup 2007 2008 2009
Current Assets
Cash Balance 25,000.00 38,101.80 900,000.00 1,800,000.00
Merchandise Inventory 0.00 0.00 0.00 0.00
Subtotal 25,000.00 38,101.80 900,000.00 1,800,000.00
Capital Assets (can be depreciated) 7,000.00 7,000.00 5,600.00 4,200.00
Depreciation 1,400.00 1,400.00 1,400.00
Subtotal 7,000.00 5,600.00 4,200.00 2,800.00
Total Assets 32,000.00 43,701.80 904,200.00 1,802,800.00
Liabilities
Current Liabilities 11,900.00
Long Term Liabilities 11,900.00
Total Liabilities 23,800.00 0.00 0.00 0.00
Capital, aka Net Worth (assets-liabilities) 8,200.00 43,701.80 904,200.00 1,802,800.00
Total Liabilities and Capital 32,000.00 43,701.80 904,200.00 1,802,800.00
Some data comes from Balance sheet, misc income is from the cashflow sheet.
Profit/Loss shows how well a company buys and sells inventory (or services) to make a profit
Year 2007 2008
Sales $472,500.00 $900,000.00
Materials (cost of sales) $168,000.00 $320,000.00
Wages (cost of sales) $156,422.00 $172,065.00
Subtotal (Cost of sales) $324,422.00 $492,065.00
Gross Profit $148,078.00 $407,935.00
Gross Profit (%) 31.34% 45.33%
OPERATING EXPENSES
OPERATING EXPENSES 2007 2008
Recurring Salaries $156,422.00 $172,065.00
Recurring Wages $20,000.00 $40,000.00
Rent $8,400.00 $8,400.00
Utilities(Elec/Gas/Phone) $2,280.00 $2,500.00
Insurance $5,000.00 $5,000.00
Bldg Maintenance $250.00 $250.00
Travel $1,500.00 $2,000.00
Advertising $5,000.00 $5,000.00
Bank Finance Charges $900.00 $300.00
Capital Expenditure $1,000.00 $1,000.00
Loan Payments $4,324.00 $4,324.00
Misc $500.00 $500.00
Depreciation $1,400.00 $1,400.00
Total Operating Expenses $206,976.00 $242,739.00
Operating Profit -$58,898.00 $165,196.00
Misc Income $71,900.00 $0.00
Net Profit (before tax) $13,002.00 $165,196.00
Taxes $1,300.20 $16,519.60
Net Profit (after tax) $11,701.80 $148,676.40
Net Profit/Sales 2.48% 16.52%
2009
$1,800,000.00
$640,000.00
$208,875.00
$848,875.00
$951,125.00
52.84%
2009
$208,875.00
$60,000.00
$8,400.00
$3,000.00
$5,000.00
$250.00
$2,500.00
$5,000.00
$100.00
$1,000.00
$4,324.00
$500.00
$1,400.00
$300,349.00
$650,776.00
$0.00
$650,776.00
$65,077.60
$585,698.40
32.54%
Cashflow sheet shows sources of cash and expenditures of cash
Data comes from profit/sheet, just looking at it a different way. Income other than sales is used by profit/loss sheet.
Startup (cash in
bank at startup) 2007 2008 2009
INCOME (cash in)
Sales $472,500.00 $900,000.00 $1,800,000.00
Capital Received/Loans $11,900.00 $0.00 $0.00
Other Income (investments) $60,000.00 $0.00 $0.00
Total Inflow $544,400.00 $900,000.00 $1,800,000.00
EXPENDITURE (cash out)
Materials (cost of sales) $168,000.00 $320,000.00 $640,000.00
Wages (cost of sales) $156,422.00 $172,065.00 $208,875.00
Recurring Salaries $156,422.00 $172,065.00 $208,875.00
Recurring Wages $20,000.00 $40,000.00 $60,000.00
Rent $8,400.00 $8,400.00 $8,400.00
Utilities(Elec/Gas/Phone) $2,280.00 $2,500.00 $3,000.00
Insurance $5,000.00 $5,000.00 $5,000.00
Bldg Maintenance $250.00 $250.00 $250.00
Travel $1,500.00 $2,000.00 $2,500.00
Advertising $5,000.00 $5,000.00 $5,000.00
Bank Finance Charges $900.00 $300.00 $100.00
Capital Expenditure $1,000.00 $1,000.00 $1,000.00
Loan Payments $4,324.00 $4,324.00 $4,324.00
Misc $500.00 $500.00 $500.00
Taxes $1,300.20 $16,519.60 $65,077.60
Total Outgo $531,298.20 $749,923.60 $1,212,901.60
Income less Expenditure $13,101.80 $150,076.40 $587,098.40
Cash Balance $25,000.00 $38,101.80 $188,178.20 $775,276.60
sed by profit/loss sheet.