Capital Needed
EPIC CREATIONS EPIC Start up capital requirement | |
Start up expenses | |
Requirements | |
Registration fees | $3,000.00 |
Salaries | $1,792.00 |
Equipment | $3,000.00 |
Mantainance | $5,000.00 |
Rent | $8,000.00 |
Legal considerations | $5,000.00 |
office supplies | $450.00 |
desks | $500.00 |
stationery | $250.00 |
Computers | $1,000.00 |
start up expenses | $27,992.00 |
Cash required | $5,000.00 |
Start up inventory | $8,000.00 |
Total Requirements | $40,992.00 |
Balance Sheet
EPIC CREATIONZ EPIC balance sheet | |||||||
year 1 | year 2 | year 3 | Year 1 | Year 2 | Year 2 | ||
Assets | Liabilities and capital | ||||||
current assets | current liabilitiees | ||||||
cash | $6,000.00 | $7,000.00 | $8,000.00 | accounts payable | $2,100.00 | $1,500.00 | $1,800.00 |
accounts recievables | $3,000.00 | $4,000.00 | $5,500.00 | current borrowing | $250.00 | $300.00 | $420.00 |
inventory | $450.00 | $900.00 | $1,000.00 | other current liabilities | $0.00 | $0.00 | $0.00 |
total current assets | $9,450.00 | $11,900.00 | $14,500.00 | total current liabilities | $2,350.00 | $1,800.00 | $2,220.00 |
longterm assets | long term liabilities | $0.00 | $0.00 | $0.00 | |||
longterm assets | $0.00 | $0.00 | $0.00 | total liabilities | $2,350.00 | $1,800.00 | $2,220.00 |
accumulated cumulations | $0.00 | $0.00 | $0.00 | paid in capital | $360.00 | $360.00 | $360.00 |
total long term assets | $0.00 | $0.00 | $0.00 | retained earnings | -$330.00 | $700.00 | $300.00 |
TOTAL ASSETS | $9,450.00 | $11,900.00 | $14,500.00 | earnings | $8,000.00 | $2,000.00 | $2,200.00 |
Total capital | $8,030.00 | $3,060.00 | $2,860.00 | ||||
Total liabilities and capital | $10,380.00 | $4,860.00 | $5,080.00 | ||||
net worth | -$930.00 | $7,040.00 | $9,420.00 |
Monthly Income
EPIC CREATIONZ EPIC projected profits | |
month 1 | $1,800.00 |
month 2 | $1,900.00 |
month 3 | $2,000.00 |
month 4 | $4,100.00 |
month 5 | $4,500.00 |
month 6 | $5,000.00 |
month 7 | $4,500.00 |
month 8 | $9,000.00 |
month 9 | $12,000.00 |
month 10 | $11,000.00 |
month 11 | $1,200.00 |
month 12 | $13,000.00 |
Total | $70,000.00 |
mailto:=@sum(B2..B13)
3-Yr Proforma
EPIC CREATIONZ EPIC PROFIT/LOSS ACCOUNTS | ||||
year 1 | year 2 | year 3 | ||
sales | $500.00 | $6,000.00 | $8,000.00 | |
direct cost of sales | $400.00 | $570.00 | $630.00 | |
other costs of sales | $19.00 | $200.00 | $220.00 | |
total cost of sales | $919.00 | $6,770.00 | $8,850.00 | errors!!! |
gross margin | $308.00 | $430.00 | $460.00 | |
gross margin expenses(%) | 80.0% | 88.0% | 89.0% | |
rent | $80.00 | $60.00 | $880.00 | |
salaries | $500.00 | $600.00 | $700.00 | |
total operating expenses | $888.00 | $1,090.00 | $2,040.00 | |
taxes | $250.00 | $300.00 | $830.00 | |
Net profit | -$219.00 | $790.00 | $1,210.00 |
Cash Flow
EPIC CREATIONZ EPIC PROJECTED CASHFLOW | |||
Year 1 | Year 2 | Year 3 | |
Cash received | |||
cash from operations | |||
cash sales | $1,400.00 | $2,000.00 | $2,250.00 |
cash from recievables | $180.00 | $290.00 | $330.00 |
Subtotal cash from operations | $1,580.00 | $2,290.00 | $2,580.00 |
Additional cash received | |||
sales tax received | $0.00 | $0.00 | $0.00 |
new current borrowing | $400.00 | $100.00 | $90.00 |
new other liabilities | $0.00 | $0.00 | $0.00 |
subtotal cash received | $1,980.00 | $2,390.00 | $2,670.00 |
expenditure | |||
cash spendings | $550.00 | $620.00 | $650.00 |
bill payments | $200.00 | $205.00 | $220.00 |
Subtotals spent on operations | $750.00 | $825.00 | $870.00 |
additional cash spent | |||
interest rates | $350.00 | $500.00 | $400.00 |
Subtotal cash spent | $1,100.00 | $1,325.00 | $1,270.00 |
Net cash flow | $6,400.00 | $2,900.00 | $2,590.00 |
cash balance | $6,600.00 | $2,750.00 | $5,300.00 |