Answered step by step
Verified Expert Solution
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 startup company, Movie Monguls. Barbie began the business on Jan with a $ investment from her parents. The year 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 $ Barbie has two products, streaming videos and podcasts. She purchased an initial inventory of units of each product in midJanuary, The streaming videos cost $ per video and the podcast rights were $ per unit. Sales have been good. Barbie advertises solely on her internet website. She has sold videos and podcasts. She charges $ and $ each for the products, respectively. Her website hosting site charges $ for each unit sold. Barbie has replenished her inventory by purchasing 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 $ including shipping. She does not currently pay herself a salary as she is running the business after her acting job. TO DO: Generate an income statement and balance sheet for Barbie using Excel. You will have worksheets within one workbook: Input sheet: Type in the data given in this case; Income statement: Create an income statement for the year ended The income statement should look like this: Balance sheet: Create a balance sheet as of and which looks like this: You will need to compute your ending cash balance as of ; it is within $ of the beginning cash balance as of 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 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. 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
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