Answered step by step
Verified Expert Solution
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 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 $
b Paid $ to the landlord for rent for October.
c Purchased equipment to be used in the business for $ Paid down and the rest on account to be paid days later.
d Purchased materials and other supplies to be used in the business for $ on account.
e Brought in $ in cash for work performed during the first few weeks of the month.
f Sold other tutoring services on account for $ to be paid within days.
g Appeared as a guest speaker at an after school day care for a fee of $ billing the hosts. The amount is due next month.
h Paid Gecko Insurance $ for the annual insurance premium to cover the business assets.
i Paid the monthly utility bill of $ the same day it arrived in the mail.
j On the last day of the month, paid $ wages to the workers. They are considered independent contractors, so there are no payroll tax issues.
k Returned $ of the supplies purchased earlier because they were the wrong kind.
The supplies had not yet been paid for.
I. Received $ in cash for a partial payment on services billed on account earlier.
Withdrew cash for personal use in the amount of $
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 should record the amount of supplies used for the month. A quick inventory shows supplies on hand totaling $
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 $ and a life of 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 TRANS
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 TRANS
What If Analysis: Mrs Ima Genius initially invested $ 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 B 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 B back to the original $
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 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 TRANSUse a proper line title on your chartand other charts
I NEED HELP ON and PLEASE!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started