Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ebay Tips And Tricks To Increase Your Ebay Sales

Authors: Jessica Wilson

1st Edition

1774854015, 978-1774854013

More Books

Students also viewed these Finance questions

Question

Discuss the problems in HR training.

Answered: 1 week ago