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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started