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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!