Question

610A Create a Pro-Forma balance sheet, income statement, and statement of cash flow projecting the first...

610A

Create a Pro-Forma balance sheet, income statement, and statement of cash flow projecting the first year of our product in the business. These preliminary projections are based on research and data collected so far and will likely change, once our products are commercialized. Each statement should address the financial components of features, expenses, and sales of your product or service. It is typical for net income to be negative at this point. Do not assume that you have sales at this point unless you have sold your product or service.

You are starting a new business: You need to create the following:

Balance sheet:

Income statement:

Statement fo cash flow:

Fixed and variable expenses:

Start-up expenses:

Breakeven analysis:

Your start-up is an athletic clothing line for women size 14 and up. To see which way we should go when we put our products out on the market.  (You can use any figures you want, as this is a fictional business). This business will be having a different company manufacturing our clothes at another location. Our 24/7 customer helpline and online ordering will be located in our own offices in Las Vegas, NV. There is no upper management at the start, just the owner, who will draw an initial salary, of $2,000.00 per month. There will initially be 10 phone customer service operators, at $10.00 per hour. Our website is ready to go when we are able to have sufficient inventory. We need to create the statement categories listed above.

Homework Answers

Answer #1
Income Statement
Particulars Expense($) Particulars Income($)
Owners salary 24000 Revenue 500000
Customer service operators salary 292000
Rent 60000
Office Maintenance 12000
Transfer to Capital 112000
Total 500000 Total 500000
Balance Sheet
Particulars Liabilities($) Particulars Asset($)
Accounts payable 21800 Cash 51,324
Capital 112000 Accounts receivable 4,868
Computer supplies 67,608
Start up expenses 10,000
Total 133800 133800
Fixed cost
Rent(5000 per month)
Owners salary($2000 per month)
Maintenace cost($1000 per month)
Variable cost
Customer Service operators
(10 numbers $10 per hour for 8hrs per day 365 days)
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales...
Chapter 4: 3. Fire Corp financial statements: Pro forma income statement Pro forma balance sheet Sales $      32,000 Assets $25,300 Debt $        5,800 Costs $        24,400 ________ Equity $        19,500 Net income $        7,600 Total $25,300 Total $      25,300 It expects 15% sales increase. It also predicts every item on the balance sheet will increase by 15% as well. Create the pro forma statements. What’s the plug variable here?
Indicate which of the financial statements (Income Statement, Statement of cash flow, Balance Sheet, statement of...
Indicate which of the financial statements (Income Statement, Statement of cash flow, Balance Sheet, statement of Changes of in equity) each of the following would be reported? Select as many as are appropriate. Cash Unearned revenue Net income Cost of goods sold Dividends declared Prepaid insurance Service revenue Warranty obligations Dividends paid
This experiential exercise involves creating a pro forma Balance Sheet and a pro forma Income Statement...
This experiential exercise involves creating a pro forma Balance Sheet and a pro forma Income Statement for XYZ Company. Assume the current year is 2015. To assist you in this endeavor, an Excel worksheet containing XYZ’s 2014 Income Statement and Balance Sheet has been provided. Develop the two pro forma financial statements for 2015 based upon the following assumptions:      The company plans to increase sales by an additional 2 percent in 2015 due to minor price increases. In addition, the...
What is the usefulness of the statement of cash flow? Do the balance sheet and income...
What is the usefulness of the statement of cash flow? Do the balance sheet and income statement provide sufficient cash flow information?
How do you prepare projected income statement, balance sheet, and cash flow? I have all the...
How do you prepare projected income statement, balance sheet, and cash flow? I have all the financial statements from the past years, I just need a little head start on where to begin! Thanks!
The cash flow statement provides additional information beyond the income statement and balance sheet. Explain why...
The cash flow statement provides additional information beyond the income statement and balance sheet. Explain why the cash flow statement provides useful information beyond the other statements.
How are the different key financial statements interrelated (Income Statement, Balance Sheet, Cash Flow Statement) ?
How are the different key financial statements interrelated (Income Statement, Balance Sheet, Cash Flow Statement) ?
Please read the below scenario carefully and prepare a brief income statement, balance sheet and cash...
Please read the below scenario carefully and prepare a brief income statement, balance sheet and cash forecast for the next 15 days. Scenario: We are opening a new office in a semi-rural town. We are excited to help the families and kids there, but don’t know how long it will take for the office to ramp up (see enough patients). Our budget for the office was $100,000, composed of $50,000 furniture and equipment, $30,000 supplies, and $20,000 extra cash to...
How does the cash flow statement tie together in the income statement and balance sheet? For...
How does the cash flow statement tie together in the income statement and balance sheet? For a manufacturing firm, what are the three inventory accounts? Using Ford Motor Co. as an example, what would be an example of each kind of inventory the questions have to do with quickbooks
Pro forma Budget You will select any company you would like. Select either the Balance Sheet...
Pro forma Budget You will select any company you would like. Select either the Balance Sheet or Income Statement from the company you choose. Place that information on the first tab. On a second tab build a budget of that financial statement. Increase the total budget by 15%. The 15% should be spread over at least 12 different accounts. Create a third tab. On that tab you will create a budget using the second tab information as the base. The...