Evie Excellent is trying to create financial statements for her start-up company, Stinky Soaps. Evie began...
Fantastic news! We've Found the answer you've been seeking!
Question:
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 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: 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:
Expert Answer:
Answer rating: 100% (QA)
SOLUTION I apologize for the confusion but as a textbased AI model I am unable to generate or interact with Excel spreadsheets directly However I can ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Hi, I need help with the Java program for reservation of seat. It's ruunning but it's not prompting the "Enter menu number:" first. At the same time, it should be able to show me the available seats...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Write a program for setting three bits of an unsigned char to 1. The function set 3bits should have four parameters: the unsigned char to be changed and the three bits which are to be set to 1. For...
-
In the planetary gear system shown, the radius of gears A, B, C, and D is 60 mm and the radius of the outer gear E is 180 mm, knowing that gear E has an angular velocity of 120 rpm clockwise and that...
-
A small retail chain has three warehouses and four retail stores. Each warehouse stores a certain amount of goods, and each retail store has a demand for a certain amount of goods. In addition, for...
-
The Student Winner was Ulf Aslak Jensen, for the video "How People Gather: An Interactive Visualization Approach." Watch this video, and answer the following questions: (a) What data are this video...
-
The president of your CPA firms largest client, a medium-size manufacturing company, advises you that the firm is about to acquire its largest supplier. Both companies have been profitable for the...
-
AERO3630 Aerodynamics (Degree) HO Table 1: Atmospheric Data Potential Flow Experiment T 22 C T 295.15 K Patm 103200 Pa Patm 1.278 kg m-3 Table 2: Test Parameters Test 1 Test 2 PT 136 mm HO 205 mm HO...
-
1. What is your assessment of the financial performance of Nelson Nurseries? 2. Do you agree with Christine Barton?s accounts-payable policy? 3. What explains the erosion of the cash balance? 4. What...
-
Q1. For refrigerant 134a, determine the values specified for each of the following conditions: p = 140 lb/in p = 20 lb/in P = 200 psi P = u = 134.09 BTU/lb T = 75F v = 0.1865 ft/lb 150 psi T = BTU/lb...
-
NPV= -29,000 + 14,400 /(1+r) + 12,300/(1+r) 2 + 9,200/(1+r) 3 + 5,100/(1+r) 4 . What is the value of r?
-
Thailand's Central Retail Corporation recently announced US$790m expansion of its existing operation network in Vietnam. Suppose that the Thai MNC is now considering different financing options....
-
Describe the three key employee attitudes and how they impact employee behaviour. Which one would you suggest has the greatest impact, and why. Provide examples.
-
Current Earning is $100 per year and the Index is 2,500 and 10 year yield is 5% per year. (A)Analyze whether it is How much Over-priced or Under-priced or Fairly-priced and (B)Calculate the Fair...
-
Discuss approaches a local district and the state are using for risk management procedures. Is there evidence that employing a risk manager is a fiscally sound move?
-
Read the passage from The Rmyan of Vlmiki His brother, fell before his feet, And cried, "Thy claim all men allow: O come, our lord and king be thou." But Rma nobly chose to be Observant of his sire's...
-
The financial statements of Eastern Platinum Limited (Eastplats) are presented in Appendix A at the end of this textbook. Instructions (a) Does East plats report any investments on its statement of...
-
Old Motors and New Motors are car dealerships that operate in the same community. Although they sell different brands and styles of cars, they are both affiliated with the same auto manufacturer. The...
-
Outline and explain the steps in a typical grievance procedure.
-
What would be the advantages and disadvantages of being represented by a union whose primary membership was in an industry or occupation different from yours?
-
Is an oscillating object in translational equilibrium?
-
If you photograph a flock of birds taking off from ground level, some of the wings will be blurred in the photograph even though the bodies are in focus. In which wing positions are the wings least...
-
Plot kinetic energy and potential energy as a function of time for the cart in Figure 15. 2. Data from Figure 15. 2 (a) t=0 5=0 (b) 0.09 s (c) 0.18 s x=0 E (d) 0.27 s E K U K U KU KU
Study smarter with the SolutionInn App