Visigoth Imports Inc
Financial Plan
Forecast
Key assumptions
We assume:
- Everyone appreciates a beautiful spot
- The town and company has a lot to offer tourists
Revenue by Month
Expenses by Month
Net Profit (or Loss) by Year
Financing
Use of funds
Our use of funds are:
Legal $2,000
Insurance $1,000
Rent $2,000
Accounting and bookkeeping fees $2,000
Expensed equipment $2,000
Advertising $4,000
Other $8,000
TOTAL START-UP EXPENSES $21,000
Sources of Funds
Our Planned investment is:
Mr. Frank Curtiss $25,000
Ms. Hannah Mills $23,000
Mr. Steve Iltheus $23,000
Mr. Pierce Bolm $23,000
TOTAL PLANNED INVESTMENT $84,000
Statements
Projected Profit and Loss
2018 | 2019 | 2020 | |
---|---|---|---|
Revenue | $309,000 | $335,000 | $378,000 |
Direct Costs | $101,100 | $112,500 | $129,000 |
Gross Margin | $207,900 | $222,500 | $249,000 |
Gross Margin % | 67% | 66% | 66% |
Operating Expenses | |||
Salaries & Wages | $126,000 | $128,520 | $131,091 |
Employee Related Expenses | $25,200 | $25,704 | $26,218 |
Rent | $36,000 | $36,000 | $36,000 |
Marketing | $6,180 | $6,700 | $7,560 |
Utilities | $3,600 | $3,600 | $3,600 |
Amortization of Other Current Assets | $0 | $0 | $0 |
Total Operating Expenses | $196,980 | $200,524 | $204,469 |
Operating Income | $10,920 | $21,976 | $44,531 |
Interest Incurred | $872 | $582 | $278 |
Depreciation and Amortization | $0 | $0 | $0 |
Gain or Loss from Sale of Assets | |||
Income Taxes | $0 | $0 | $0 |
Total Expenses | $298,952 | $313,606 | $333,747 |
Net Profit | $10,048 | $21,394 | $44,253 |
Net Profit/Sales | 3% | 6% | 12% |
Projected Balance Sheet
Starting Balances | 2018 | 2019 | 2020 | |
---|---|---|---|---|
Cash | $60,000 | $75,909 | $91,735 | $131,257 |
Accounts Receivable | $0 | $0 | $0 | |
Inventory | ||||
Other Current Assets | $15,000 | $15,000 | $15,000 | $15,000 |
Total Current Assets | $75,000 | $90,909 | $106,735 | $146,257 |
Long-Term Assets | $10,000 | $10,000 | $10,000 | $10,000 |
Accumulated Depreciation | $0 | $0 | $0 | |
Total Long-Term Assets | $10,000 | $10,000 | $10,000 | $10,000 |
Total Assets | $85,000 | $100,909 | $116,735 | $156,257 |
Accounts Payable | $2,000 | $13,517 | $13,895 | $15,414 |
Income Taxes Payable | $0 | $0 | $0 | |
Sales Taxes Payable | $0 | $0 | $0 | |
Short-Term Debt | $5,656 | $5,946 | $6,250 | $2,148 |
Prepaid Revenue | ||||
Total Current Liabilities | $7,656 | $19,463 | $20,145 | $17,562 |
Long-Term Debt | $14,344 | $8,398 | $2,148 | $0 |
Long-Term Liabilities | $14,344 | $8,398 | $2,148 | $0 |
Total Liabilities | $22,000 | $27,861 | $22,293 | $17,562 |
Paid-In Capital | $84,000 | $84,000 | $84,000 | $84,000 |
Retained Earnings | ($21,000) | ($21,000) | ($10,952) | $10,442 |
Earnings | $10,048 | $21,394 | $44,253 | |
Total Owner’s Equity | $63,000 | $73,048 | $94,442 | $138,695 |
Total Liabilities & Equity | $85,000 | $100,909 | $116,735 | $156,257 |
Projected Cash Flow Statement
2018 | 2019 | 2020 | |
---|---|---|---|
Net Cash Flow from Operations | |||
Net Profit | $10,048 | $21,394 | $44,253 |
Depreciation & Amortization | $0 | $0 | $0 |
Change in Accounts Receivable | $0 | $0 | $0 |
Change in Inventory | |||
Change in Accounts Payable | $11,517 | $378 | $1,519 |
Change in Income Tax Payable | $0 | $0 | $0 |
Change in Sales Tax Payable | $0 | $0 | $0 |
Change in Prepaid Revenue | |||
Net Cash Flow from Operations | $21,565 | $21,772 | $45,772 |
Investing & Financing | |||
Assets Purchased or Sold | |||
Net Cash from Investing | |||
Investments Received | |||
Dividends & Distributions | |||
Change in Short-Term Debt | $289 | $304 | ($4,102) |
Change in Long-Term Debt | ($5,946) | ($6,250) | ($2,148) |
Net Cash from Financing | ($5,656) | ($5,946) | ($6,250) |
Cash at Beginning of Period | $60,000 | $75,909 | $91,735 |
Net Change in Cash | $15,909 | $15,826 | $39,522 |
Cash at End of Period | $75,909 | $91,735 | $131,257 |