Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

On October 1 of the current year, Mrs . Ima Genius opened up a Tutoring Business called Genius in Process; a sole proprietorship located in

On October 1 of the current year, Mrs. Ima Genius opened up a Tutoring Business called Genius in Process; a sole proprietorship located in Southern California. The business had the following transactions occur during the first month of business.
a. Opened a business checking account in the name of the business and deposited $25,000.
b. Paid $2,000 to the landlord for rent for October.
c. Purchased equipment to be used in the business for $15,000. Paid 20% down and the rest on account (to be paid 30 days later.)
d. Purchased materials and other supplies to be used in the business for $2,500 on account.
e. Brought in $3,500 in cash for work performed during the first few weeks of the month.
f. Sold other tutoring services on account for $2,100 to be paid within 30 days.
g. Appeared as a guest speaker at an after school day care for a fee of $1,000 billing the hosts. The amount is due next month.
h. Paid Gecko Insurance $1,200 for the annual insurance premium to cover the business assets.
i. Paid the monthly utility bill of $1,500 the same day it arrived in the mail.
j. On the last day of the month, paid $5,000 wages to the workers. (They are considered independent contractors, so there are no payroll tax issues.
k. Returned $200 of the supplies purchased earlier because they were the wrong kind.
(The supplies had not yet been paid for.)
I. Received $500 in cash for a partial payment on services billed on account earlier.
m. Withdrew cash for personal use in the amount of $3,200.
6. The company needs to record several adjustments at month end:
a. Insert three new lines at the bottom of the worksheet. Make sure the totals include the new transactions. (If they do not, then adjust the formulas to include the three adjusting transactions.
b. Record three adjusting transactions to adjust for the following:
i. Transaction n should record the amount of supplies used for the month. A quick inventory shows supplies on hand totaling $250.
11. As of the end of the month, one month of the insurance has expired. Record this in transaction o.
iii. Monthly recording of the depreciation on the equipment should be recorded. Assuming the equipment has a salvage value of $2,500 and a life of 5 years, compute the amount of monthly depreciation. (Round to the nearest whole dollar.) Record this in transaction p. Use the Equipment column to record the decrease... if you were recording a journal entry, you would use the account Accumulated Depreciation.
(This account decreases the book value of assets.)
c. Save your work as TRANS6.
7. On a new worksheet (within the same workbook), prepare a set of financial statements including an Income Statement, a statement of owner's equity (or capital statement) and a classified balance sheet in good form for Genius In Process for the month of October. Label the new worksheet tab FINANCIALS. To earn the MAXIMUM POINTS use cell references for the amounts. (Type in the = sign and then click on the amount in the worksheet you want and press enter.) Save as TRANS7.
8. What If Analysis: Mrs. Ima Genius initially invested $25,000 into the business. Could she have invested less? What is the minimum amount she could have invested and never have her cash fall below zero. To answer this question, change the initial investment in cell B10. Look at the Cumulative Cash balance column. Try different amounts until you have an answer. When you have discovered your answer, create a new "tab" or worksheet called Answers within the same workbook. Write down the answer and an explanation of how you derived it. Once you have discovered and recorded your answer, don't forget to change cell B10 back to the original $25,000.
9. Chart: Open up the most recent file. Open up the Chart tab. Fill in the chart data table provided. Use the chart data table to create a 3-D pie chart showing the relative percentages of the balances in the liability and equity accounts. Save the chart in the same worksheet. Save the File again as TRANS9.(Use a proper 3-line title on your chartand other charts )
I NEED HELP ON 6,7,8, and 9 PLEASE!!
image text in transcribed

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

British And German Banking Strategies

Authors: S. Janssen

1st Edition

0230220487, 9780230220485

More Books

Students also viewed these Accounting questions

Question

How did World War II shape Anna Freuds research and thought?

Answered: 1 week ago

Question

What is the default fetch size in JDBC for a Statement object?

Answered: 1 week ago

Question

Solve the integral:

Answered: 1 week ago

Question

What is meant by Non-programmed decision?

Answered: 1 week ago

Question

What are the different techniques used in decision making?

Answered: 1 week ago

Question

Is this public actively seeking information on this issue?

Answered: 1 week ago

Question

How much loyalty does this public have for your organization?

Answered: 1 week ago

Question

How influential does the organization see this public as being?

Answered: 1 week ago