Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Wells Technical Institute (WTI), a school owned by Tristana Wells, provides training to individuals who pay tuition directly to the school. WTI also offers training
Wells Technical Institute (WTI), a school owned by Tristana Wells, provides training to individuals who pay tuition directly to the school. WTI also offers training to groups in off-site locations. Its unadjusted trial balance as of December 31, 2015, follows. WTI initially records prepaid expenses and unearned revenues in balance sheet accounts. Descriptions of items a through h that require adjusting entries on December 31, 2015, follow | |||||||
Required -Highlights may require your input if $0 place a $0 if no value leave as is | |||||||
1. Problem 3-3B Set up a 6 column worksheet as depicted below and input the trial balance amounts- this is not the same as the book | |||||||
Wells Technical Institute (WTI) | |||||||
Unadjusted trail balance | |||||||
December 31 , 2015 | |||||||
Entries a-h | |||||||
Trial Balance | Adjustment Letter | Adjusments | Adjusted Trial balance | ||||
Debit | Credit | Debit | Credit | Debit | Credit | ||
Cash | $34,000 | ||||||
AR | $0 | ||||||
Teaching supplies | $8,000 | ||||||
Prepaid insurance | $12,000 | ||||||
Prepaid rent | $3,000 | ||||||
Professional library | $35,000 | ||||||
Accum depr-Library | $10,000 | ||||||
Equipment | $80,000 | ||||||
Accum depr-Equipment | $15,000 | ||||||
AP | $26,000 | ||||||
Salaries Payable | $0 | ||||||
Unearned Revenue | $12,500 | ||||||
C Alonzo Capital | $90,000 | ||||||
C Alonzo Withdrawals | $50,000 | ||||||
Tuition fees earned | $123,900 | ||||||
Training fees earned | $40,000 | ||||||
Depreciation exp- Library | $0 | ||||||
Depreciation exp- Equipment | $0 | ||||||
Salaries Expense | $50,000 | ||||||
Insurance expense | $0 | ||||||
Rent expense | $33,000 | ||||||
Teaching Supplies expense | $0 | ||||||
Advertisng expense | $6,000 | ||||||
Utilities expense | $6,400 | ||||||
Totals | $317,400 | $317,400 | |||||
2. Prepare the necessary adjusting journal entries for items a through h, and post them to the work sheet. Assume that adjusting entries are made only at year-end. | |||||||
a. An analysis of the WTI's insurance policies shows that $2,400 of coverage has expired. | |||||||
Entry # | Account Titles & explanationas | Debits | Credits | ||||
a | |||||||
b. An inventory count shows that teaching supplies costing $2,800 are available at year-end 2015. | |||||||
Entry # | Account Titles & explanationas | Debits | Credits | ||||
b | |||||||
c. Annual depreciation on the equipment is $13,200 | |||||||
Entry # | Account Titles & explanationas | Debits | Credits | ||||
c | |||||||
d. Annual depreciation on the professional library is $7,200 | |||||||
Entry # | Account Titles & explanationas | Debits | Credits | ||||
d | |||||||
e. On November 1, WTI agreed to do a special six-month course (starting immediately) for a client. The contract calls for a monthly fee of $2,500, and the client paid the first five months fees in advance. When the cash was received, the Unearned Training Fees account was credited. The fee for the sixth month will be recorded when it is collected in 2016 | |||||||
Entry # | Account Titles & explanationas | Debits | Credits | ||||
e | |||||||
f. On October 15, WTI agreed to teach a four-month class (beginning immediately) for an individual for $3,000 tuition per month payable at the end of the class. The class started on October 15, but no pay- ment has yet been received. (WTIs accruals are applied to the nearest half-month; for example, October recognizes one-half month accrual. | |||||||
Entry # | Account Titles & explanationas | Debits | Credits | ||||
f | |||||||
WTIs two employees are paid weekly. As of the end of the year, two days salaries have accrued at the rate of $100 per day for each employee. | |||||||
Entry # | Account Titles & explanationas | Debits | Credits | ||||
g | |||||||
h. The balance in the Prepaid Rent account represents rent for December. | |||||||
Entry # | Account Titles & explanationas | Debits | Credits | ||||
h | |||||||
3- Update balances in the worksheet and prepare an adjusted trial balance | |||||||
Wells Technical Institute (WTI) | |||||||
Adjusted trail balance | |||||||
December 31 , 2015 | |||||||
Entries a-h | |||||||
Trial Balance | Adjustment Letter | Adjusments | Adjusted Trial balance | ||||
Debit | Credit | Debit | Credit | Debit | Credit | ||
Cash | $34,000 | $0 | $0 | ||||
AR | $0 | $0 | $0 | ||||
Teaching supplies | $8,000 | $0 | $0 | ||||
Prepaid insurance | $12,000 | $0 | $0 | ||||
Prepaid rent | $3,000 | $0 | $0 | ||||
Professional library | $35,000 | $0 | $0 | ||||
Accum depr-Library | $10,000 | $0 | $0 | ||||
Equipment | $80,000 | $0 | $0 | ||||
Accum depr-Equipment | $15,000 | $0 | $0 | ||||
AP | $26,000 | $0 | $0 | ||||
Salaries Payable | $0 | $0 | $0 | ||||
Unearned Revenue | $12,500 | $0 | $0 | ||||
C Alonzo Capital | $90,000 | $0 | $0 | ||||
C Alonzo Withdrawals | $50,000 | $0 | $0 | ||||
Tuition fees earned | $123,900 | $0 | $0 | ||||
Training fees earned | $40,000 | $0 | $0 | ||||
Depreciation exp- Library | $0 | $0 | $0 | ||||
Depreciation exp- Equipment | $0 | $0 | $0 | ||||
Salaries Expense | $50,000 | $0 | $0 | ||||
Insurance expense | $0 | $0 | $0 | ||||
Rent expense | $33,000 | $0 | $0 | ||||
Teaching Supplies expense | $0 | $0 | $0 | ||||
Advertisng expense | $6,000 | $0 | $0 | ||||
Utilities expense | $6,400 | $0 | $0 | ||||
Totals | $317,400 | $317,400 | $0 | $0 | $0 | $0 | |
Prepare the companys income statement and statement of owners equity for the year 2015, and prepare its balance sheet as of December 31, 2015. | |||||||
Wells Technical Institute (WTI) | |||||||
Income Statement | |||||||
For Year Ended December 31, 2015 | |||||||
Revenue | |||||||
Tuition fees earned | |||||||
Training fees earned | |||||||
Total Revenue | |||||||
Expenses | |||||||
Depreciation exp- Library | |||||||
Depreciation exp- Equipment | |||||||
Salaries Expense | |||||||
Insurance expense | |||||||
Rent expense | |||||||
Teaching Supplies expense | |||||||
Advertisng expense | |||||||
Utilities expense | |||||||
Total Expenses | |||||||
Net Income | |||||||
Wells Technical Institute (WTI) | |||||||
Statement of Owners Equity | |||||||
For Year Ended December 31, 2015 | |||||||
WTI, Capital, December 31, 2014 | |||||||
Plus: Net income | |||||||
Less: Withdrawals | |||||||
WTI, Capital, December 31, 2015 | |||||||
Wells Technical Institute (WTI) | |||||||
Balance Sheet | |||||||
December 31, 2015 | |||||||
Assets | |||||||
Cash | |||||||
Accounts receivable | |||||||
Teaching supplies | |||||||
Prepaid insurance | |||||||
Professional library | |||||||
Accumulated depreciationProfessional library | |||||||
Equipment | |||||||
Accumulated depreciationEquipment | |||||||
Total assets | |||||||
Liabilities | |||||||
Accounts payable | |||||||
Salaries payable | |||||||
Unearned Revenue | |||||||
Total liabilities | |||||||
Equity | |||||||
C. Alonzo, Capital | |||||||
Total liabilities and equity |
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