Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Barbie is trying to create financial statements for her start - up company, Movie Monguls. Barbie began the business on Jan 1 , 2 0

Barbie is trying to create financial statements for her start-up company, Movie Monguls. Barbie began the business on Jan 1,2023 with a $10,000 investment from her parents. The year 2023 is over, and Barbie needs help to generate a profit and loss statement (Income statement) and Balance sheet. She can look online and see that her cash is about even with what she started the year with ($10,000). Barbie has two products, streaming videos and podcasts. She purchased an initial inventory of 100 units of each product in mid-January, 2023. The streaming videos cost $15 per video and the podcast rights were $10 per unit. Sales have been good. Barbie advertises solely on her internet website. She has sold 1,000 videos and 800 podcasts. She charges $30 and $20 each for the products, respectively. Her website hosting site charges $2.00 for each unit sold. Barbie has replenished her inventory by purchasing 1,500 units of each type of product from the movie studio at the same cost as her initial inventory purchases. Barbies only other cost is stickers; she sends a thank you sticker to each customer at a cost of $1.00 including shipping. She does not currently pay herself a salary as she is running the business after her acting job. TO DO: 1. Generate an income statement and balance sheet for Barbie using Excel. You will have 3 worksheets within one workbook: - Input sheet: Type in the data given in this case; - Income statement: Create an income statement for the year ended 12/31/23. The income statement should look like this: - Balance sheet: Create a balance sheet as of 1/1/23 and 12/31/23, which looks like this: - You will need to compute your ending cash balance as of 12/31/23; it is within $1,000 of the beginning cash balance as of 1/1/23.2. Create a conditional if statement showing that Assets = Liabilities + Owners Equity. If the condition is met, it should say EQUAL. If the condition is not met, it should say PROBLEM. Include this formula on your balance sheet, last line (see format above).3. All numbers on the income statement and balance sheet MUST BE either a formula or a cell reference. No numbers can be input on these sheets. You will cell reference back to the input sheet. 4. Use good workpaper documentation. This means that a reviewer (me in this case) can visually follow your work without looking at excel formulas. For example, show the quantity and price for sales, not just the revenue amount. In other words, show your work.

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_2

Step: 3

blur-text-image_3

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

Inventory Best Practices

Authors: Steven M. Bragg

2nd Edition

1118000749, 9781118000748

More Books

Students also viewed these Accounting questions

Question

S 1 o W R U ou S 1 o W R U ou

Answered: 1 week ago

Question

=+What action steps will you take to handle this situation?

Answered: 1 week ago