Question: APPLICATION ASSIGNMENT # 5 - ACCT 3 0 5 ( Accounting Cycle ) Students - For this application assignment, you are going to complete

APPLICATION ASSIGNMENT \#5- ACCT305(Accounting Cycle)
Students - For this application assignment, you are going to complete A WORKSHEET, INCOME STATEMENT, STATEMENT OF RETAINED EARNINGS, AND A BALANCE SHEET. PROVIDE ALL FORMULAS, CELL REFRENCES, NO HARD ANSWERS!!!! You are to use the worksheet to prepare the adjusting entries, statement information, closing entries, and post-closing trial balance. Use cell references, formulas, and summation functions where applicable and appropriate. Specific instructions are outlined below.
Instructions:
1. KJW has a fiscal year end of June 30. Journalize the following adjusting entries for 6/30/24 in the Journal and then transfer to the worksheet in the appropriate Adjusting Entries column. (provide descriptions of the entries for a complete journal entry) Keep everyting in whole dollars.
a) The company estimates uncollectible accounts using the '\% of receivables' allowance method.
As of June 30th, the company estimates that 4.5\% of the accounts receivable balance is uncollectible. (HINT: Be sure to account for what is already in the Allowance account)
b) Supplies on hand are determined to be \$2,300
c)\(50\%\) of the Prepaid Insurance balance has expired as of June 30.
d) The Prepaid Rent balance represents 6 months of rent expense. Those months include May through October 2024. Adjust accordingly for June 30.
e) Depreciation of assets is recognized as follows for the year end:
Buildings -\$7,500
Equipment -\$7,900
f) Invoices for utilities expenses of \(\$ 1250\) have been received related to June.
g) Employees working the last 3 business days of June will be paid in July. The daily expense for employee wages is \(\$ 1,350\).(Ignore payroll tax expenses)
h)\(40\%\) of the unearned revenue has been earned as of June 30.
i) The interest rate on the Mortgage Payable is 7.5\%. Interest expense was last updated 12/31/23.
2. Update the Adjusted Trial Balance columns in the worksheet. Make sure you carry the correct debit/credit columns across. Use references and formulas to create the adjusted balances.
Carry over the applicable balances to the Income Statement and Balance Sheet columns. Remember the difference
in debits/credits will be the Net Income - which should be added to the bottom of the worksheet columns for each.
Use the other provided blank worksheets to prepare, in proper format, the Income Statement, Statement of Retained
Earnings, and classified Balance Sheet for the period ending. Formatting and labeling should be appropriate,
consistent, and user-friendly. (USE Spellcheck for each worksheet) Please refer to examples in the book if you
question titles and classifications.
$8,000 of the Mortgage Payable is due December 1,2024.
Write up the closing journal entries in the Journal and transfer to the Worksheet. Remember, all temporary accounts
are closed during this process. There are four journal entries involved.
Carry over the balances, after closing entries, to the Post Closing Trial Balance on the worksheet. Only permanent
accounts should have balances.
Complete these requirements and rename the application file as directed. Attach the completed
file to the assignment link in Blackboard by the due date provided in Blackboard.
(For general and closing journal entries)
^(**) Always provide descriptions for your journal entries below each entry
Ref Date General Journal Account Titles Debit Credit
Journal Worksheet Income Statement Statement of Retained Earnings Balance Sheet
(For general and closing journal entries)
^(**) Always provide descriptions for your journal entries below each entry
Ref Date General Journal Account Titles Debit Credit
KJW Company Worksheet For the Year Ended June 30,2024
Trial Balance Adjusting Entries Adjusted Trial Balance Income Statement Balance Sheet Closing Entries Post-Closing Trial Balance Account Titles Db . Cr. Ref Db. Cr. Ref Db. Cr. Db. Cr. Db. Cr. Ref Db. Cr. Ref Db. Cr. Cash 36,500 Accounts Receivable 54,400 Allowance for Doubtful Accounts 700 Supplies 15,300 Prepaid Insurance 28,000 Prepaid Rent 18,000 Land 65,000 Buildings 150,000 Accum. Depreciation-Bldgs.35,000 Equipment 115,000 Accum. Depreciation-Equip. 52,000 Goodwill 285,000 Patents 49,500 Accounts Payable 33,650 Unearned Revenue 9,400 interest Payable Salaries and Wages Payable Mortgage Payable 60,000 Common Stock ($1 par)100,000 Paid in Capital in Excess of par-CS 25,000 Dividends 12,000 Retained Earnings 316,230 Income Summary Sales Revenue 357,200 Supplies Expense 1,480 Salaries and Wages Expense 115,600 Maint. and Repairs Expense 14,250 Adv
APPLICATION ASSIGNMENT \ # 5 - ACCT 3 0 5 (

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!