Question: Please help me create a opening day balance sheet. seeking a total funding of $200,000 of debt capital to open the business Month Salaries Office
Please help me create a opening day balance sheet. seeking a total funding of $200,000 of debt capital to open the business
| Month | Salaries | Office Supplies | Headquarters | Marketing | Office supplies | Sales Revenue | Monthly Debt
| Accumulated Debt
|
| Jan | $25000 | $1000 | $0 | $0 | $0 | $0 | $26,000 | $26,000 |
| Feb | $25000 | $2000 | $0 | $0 | $0 | $0 | $27,000 | $53,000 |
| March | $41,667 | $3000 | $0 | $10,000 | $0 | $0 | $54,667 | $107,667 |
| April | $63,334 | $8,000 | $2500 | $10,000 | $10,000 | $10,000 | $93,834 | $201,501 |
| May | $63,334 | $8,000 | $2500 | $10,000 | $10,000 | $50,000 | $93,834 | $295,335 |
| June | $63,334 | $9,000 | $2500 | $10,000 | $10,000 | $250,000 | $94,834 | $390,169 |
| July | $63,334 | $0 | $2500 | $10,000 | $0 | $470,000 | $75,834 | $466,003 |
|
| Year 1 | Year 2 | Year 3 |
| Cash Flow from Operations |
|
|
|
| Booking Fees | $ 480,000 | $ 1,440,000 | $ 2,880,000 |
| Pro Membership | $ 300,000 | $ 150,000 | $ 200,000 |
| Premium Membership | $ 300,000 | $ 125,000 | $ 200,000 |
| Premium Plus Membership | $ 450,000 | $ 112,500 | $ 600,000 |
| Total Sales | $ 1,530,000 | $ 1,827,500 | $ 3,880,000 |
| Cash from Debt / Loans | $ 200,000 | $ - | $ - |
| Total Revenue | $ 1,730,000 | $ 1,827,500 | $ 3,880,000 |
|
|
|
|
|
| Expenses & Costs |
|
|
|
| Lease | $ 30,000 | $ 35,000 | $ 40,000 |
| Marketing | $ 100,000 | $ 100,000 | $ 150,000 |
| Salaries | $ 598,339 | $ 760,008 | $ 760,008 |
| Office Supplies | $ 30,000 | $ 30,000 | $ 30,000 |
| Other Expenses | $ 20,000 | $ 20,000 | $ 20,000 |
| Total Expenses and Costs | $ 778,339 | $ 945,008 | $ 1,000,008 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
