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 year 2023 is over, and Evie needs help 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, 2023. 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. Balanance sheet with formula

CONCEPTS IN FED.TAX.,2020-W/ACCESS
20th Edition
ISBN:9780357110362
Author:Murphy
Publisher:Murphy
Chapter3: Income Sources
Section: Chapter Questions
Problem 79P
icon
Related questions
Question
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 year 2023 is over, and Evie needs help 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, 2023. 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. Balanance sheet with formula
Transcribed Image Text: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 year 2023 is over, and Evie needs help 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, 2023. 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. Balanance sheet with formula
Balance sheet: Create a balance sheet as of 1/1/23 and 12/31/23, which looks like this:
Assets
Cash
Inventory
Bar
Liquid
Total Assets
Liabilities and Owner's Equity
Beginning investment
Net income
Ending investment
Assets = Liabilities and Equity
$ per unit
12/31/23
2.
EQUAL OR
PROBLEM
1/1/2023
EQUAL OR
PROBLEM
You will need to compute your ending cash balance as of 12/31/23; it is within $100 of the beginning
cash balance as of 1/1/23.
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.
Transcribed Image Text:Balance sheet: Create a balance sheet as of 1/1/23 and 12/31/23, which looks like this: Assets Cash Inventory Bar Liquid Total Assets Liabilities and Owner's Equity Beginning investment Net income Ending investment Assets = Liabilities and Equity $ per unit 12/31/23 2. EQUAL OR PROBLEM 1/1/2023 EQUAL OR PROBLEM You will need to compute your ending cash balance as of 12/31/23; it is within $100 of the beginning cash balance as of 1/1/23. 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.
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Accounting for Notes
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
CONCEPTS IN FED.TAX., 2020-W/ACCESS
CONCEPTS IN FED.TAX., 2020-W/ACCESS
Accounting
ISBN:
9780357110362
Author:
Murphy
Publisher:
CENGAGE L