Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need help resolving that was all the information Evie Excellent is trying to create financial statements for her start-up company, Stinky Soaps. Evie began the

need help resolving
image text in transcribed
image text in transcribed
image text in transcribed
that was all the information
Evie Excellent is trying to create financial statements for her start-up company, Stinky Soaps. Evie began the business on Jan 1, 2023 with a $1,000 investment from her parents. The first six months of 2023 have passed, and Evie has been unable to generate a profit and loss statement (Income statement) and Balance sheet. She is only able to ascertain that her cash is about even with what she started the year with ($1,000). Evie has two products, bar and liquid soap. She purchased initial inventory of 100 units of each product in mid-January. The bar soap cost $2 per bar and the liquid was a bit more expensive at $4 per unit. Sales have been good. Evie advertises solely on her internet website. Stinky has sold 60 bars and 80 liquid soap dispensers. She charges $5 and $10 each for the products, respectively. Her website hosting site charges $.60 for each unit sold. Evie has replenished her inventory by purchasing 50 units of each type of soap from the manufacturer at the same cost as her initial inventory purchases. Evie's only other cost is shipping; she pays $1 per unit sold to ship to the retail customers. She does not currently pay herself a salary as she is running the business after her regular job. TO DO: 1. Generate an income statement and balance sheet for Evie 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 6 months ended 6/30/23. The income statement should look like this: 1. Generate an income statement and balance sheet for Evie 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 6 months ended 6/30/23. The income statement should look like this: Balance sheet: Create a balance sheet as of 6/30/23 and 1/1/23, which looks like this: You will need to compute your ending cash balance as of 6/30/23; it is within $100 of the beginning cash balance as of 1/1/23. 2. Create a conditional "if" statement showing that Assets = Liabilities + Owner's Equity. If the condition is met, it should say EQUAL. If the condition is not met, it should say PROBLEM. 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. Evie Excellent is trying to create financial statements for her start-up company, Stinky Soaps. Evie began the business on Jan 1, 2023 with a $1,000 investment from her parents. The first six months of 2023 have passed, and Evie has been unable to generate a profit and loss statement (Income statement) and Balance sheet. She is only able to ascertain that her cash is about even with what she started the year with ($1,000). Evie has two products, bar and liquid soap. She purchased initial inventory of 100 units of each product in mid-January. The bar soap cost $2 per bar and the liquid was a bit more expensive at $4 per unit. Sales have been good. Evie advertises solely on her internet website. Stinky has sold 60 bars and 80 liquid soap dispensers. She charges $5 and $10 each for the products, respectively. Her website hosting site charges $.60 for each unit sold. Evie has replenished her inventory by purchasing 50 units of each type of soap from the manufacturer at the same cost as her initial inventory purchases. Evie's only other cost is shipping; she pays $1 per unit sold to ship to the retail customers. She does not currently pay herself a salary as she is running the business after her regular job. TO DO: 1. Generate an income statement and balance sheet for Evie 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 6 months ended 6/30/23. The income statement should look like this: 1. Generate an income statement and balance sheet for Evie 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 6 months ended 6/30/23. The income statement should look like this: Balance sheet: Create a balance sheet as of 6/30/23 and 1/1/23, which looks like this: You will need to compute your ending cash balance as of 6/30/23; it is within $100 of the beginning cash balance as of 1/1/23. 2. Create a conditional "if" statement showing that Assets = Liabilities + Owner's Equity. If the condition is met, it should say EQUAL. If the condition is not met, it should say PROBLEM. 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

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

ISE Fundamentals Of Cost Accounting

Authors: William N. Lanen, Shannon Anderson, Michael W. Maher

7th Edition

1265117705, 9781265117702

More Books

Students also viewed these Accounting questions