Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You run a small business you started in 2022. You are generating your Financial Statements. Use the following information: - Sales Volume: 4000 units/year -

You run a small business you started in 2022. You are generating your Financial Statements. Use the following information:

- Sales Volume: 4000 units/year
- Sales price per unit: $125/unit
- Labor time to produce one unit: 50 minutes
- Cost of Labor for production: $50/hour
- Cost of Raw Material: $45/unit
- Insurance: $550/month
- YOUR salary: $65,000/year (cost to the company)
- Rent: $3400/month
- Tax rate: 28%
- Checking account balance: $5600
- Raw material on hand: 625 units

Your customers owe you $1750 for items purchased in the past year. This year you purchased office equipment and shelving for production for $16,500 as well as purchasing several machines for a total cost = $76,000. You have a short-term loan from the bank for $5600.

On Excel (show each cell's calculation),

1) Create a Net Income Statement and a Balance Sheet (show both short and long-term values)

2) From the Net Income Statement and Balance Sheet created in the problem above, what are the inventory turns per year?

3) From the Balance Sheet created above, what is the current ratio?

Step by Step Solution

3.48 Rating (161 Votes )

There are 3 Steps involved in it

Step: 1

Solution Net Income Statement and Balance Sheet Net Income Statement ItemAmount Sales Revenue4000 un... 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

Financial Reporting Financial Statement Analysis And Valuation A Strategic Perspective

Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

9th Edition

1337614689, 1337614688, 9781337668262, 978-1337614689

More Books

Students also viewed these Accounting questions

Question

What do I have experience doing?

Answered: 1 week ago

Question

Explain the various methods of job evaluation

Answered: 1 week ago

Question

Differentiate Personnel Management and Human Resource Management

Answered: 1 week ago

Question

Describe the functions of Human resource management

Answered: 1 week ago