Need help with this assignment. can please show how you get your numbers. Thank you!
Year-End Worksheet Assignment The Excel year-end accounting worksheet has been started for a company's year end reportingt This means that the balances for trial balance has been entered. A year-end accounting worksheet is a tool used to help accountants complete the accounting cycle and prepare year-end documents (unadjusted trial balances, adjusting journal entries, adjusted trial balances, and financhal statements.) The accounting worksheet is essentially a spreadsheet that tracks the steps of the accounting cycle's end-of-period tasks. The spreadsheet typically has five sets of columns that start with the unadjusted trial balance accounts and end with the financial statements. The company uses a perpetual inventory system which means that there is no need to adjust ending imventory or cost of goods sold. All the balances from the general ledger have been entered into the worksheet's trial balance. Your task is to enter the adjusting entries (described below) into the Adjustment columns and then enter the balances in the Adjusted Trial Balance columns, Income Statement columns and Balance Sheet columns. Keep these rules in mind: 1. The debit and credit columns of the Adjustments must equal. 2. The Adjusted Trial Balance must balance (debits = credits). 3. For the Income Statement columns, enter only the balances (from the adjusted trial balance) for the revonue and expense accounts. The difference in the totals will be the net income. 4. For the Balance Sheer columns, enter only the balances for the assers, liabilitions, and eatity accounts. The difference in the totals should be exactly equal to the net income The normal process to complete the accounting cycle is as follows 1. Onke the end af,period worksheet is complete, the adjusting entries are founalized fentered into the general journal), posted to the neneral hedger. 2. Next, the firsancial statements are propared fincome Statement, Statement of Fouity, Falance Sheet, and Statement of Cash Flows.) 3. Then the closing entries are fournalized and then posted For this assignment, once you have an accurate yoar end worksheet conpleted, you should go to myCourses, upload the workheet. Here are the descriptions of the adjusting eataks 1 - Bad debe expense is 1\% of net swer. (Ner sales - Sales - Sales returns and allowances - Sales discourts taken] - Deprociation Expense adjustment is 525,000 - Interest owed but not yet recorded (accrued interest) is $1,800. - Expired rent (Prepaid Expenses) is $3,000. - Federal Income Tax is calculated at 21% of pre tax income. - Make this adjustment last. What you should do is nske all the ahove - Bad debt expense is 1% of net sales. (Net sales = 5ales - Sales returns and allowances - Sales discounts taken) - Depreciation Expense adjustment is $25,000 - Interest owed but not yet recorded (accrued interest) is $1,800. - Expired rent (Prepaid Expenses) is $3,000. - Federal Income Tax is calculated at 21% of pre-tax income. - Make this adjustment last. What you should do is make all the above adjustments (enter them in the adjustment columns), then prepare the adjusted trial balance and the income statement columns. Take note of the income (Revenues less Expenses) and multiply that number (pre-tax income) by the 21% tax rate. That will be the federal income tax expense/federal income taxes payable. Make the federal income tax adjusting entries in the Adjustment columns. Then move onto to finish the Adjusted Trial Balance, Income Statement columns, and Balance Sheet columns. PLEASE use cell references and formulas to complete the Adjusted Trial Balance, Income Statement, and Balance Sheet columns. Year-End Worksheet Assignment The Excel year-end accounting worksheet has been started for a company's year end reportingt This means that the balances for trial balance has been entered. A year-end accounting worksheet is a tool used to help accountants complete the accounting cycle and prepare year-end documents (unadjusted trial balances, adjusting journal entries, adjusted trial balances, and financhal statements.) The accounting worksheet is essentially a spreadsheet that tracks the steps of the accounting cycle's end-of-period tasks. The spreadsheet typically has five sets of columns that start with the unadjusted trial balance accounts and end with the financial statements. The company uses a perpetual inventory system which means that there is no need to adjust ending imventory or cost of goods sold. All the balances from the general ledger have been entered into the worksheet's trial balance. Your task is to enter the adjusting entries (described below) into the Adjustment columns and then enter the balances in the Adjusted Trial Balance columns, Income Statement columns and Balance Sheet columns. Keep these rules in mind: 1. The debit and credit columns of the Adjustments must equal. 2. The Adjusted Trial Balance must balance (debits = credits). 3. For the Income Statement columns, enter only the balances (from the adjusted trial balance) for the revonue and expense accounts. The difference in the totals will be the net income. 4. For the Balance Sheer columns, enter only the balances for the assers, liabilitions, and eatity accounts. The difference in the totals should be exactly equal to the net income The normal process to complete the accounting cycle is as follows 1. Onke the end af,period worksheet is complete, the adjusting entries are founalized fentered into the general journal), posted to the neneral hedger. 2. Next, the firsancial statements are propared fincome Statement, Statement of Fouity, Falance Sheet, and Statement of Cash Flows.) 3. Then the closing entries are fournalized and then posted For this assignment, once you have an accurate yoar end worksheet conpleted, you should go to myCourses, upload the workheet. Here are the descriptions of the adjusting eataks 1 - Bad debe expense is 1\% of net swer. (Ner sales - Sales - Sales returns and allowances - Sales discourts taken] - Deprociation Expense adjustment is 525,000 - Interest owed but not yet recorded (accrued interest) is $1,800. - Expired rent (Prepaid Expenses) is $3,000. - Federal Income Tax is calculated at 21% of pre tax income. - Make this adjustment last. What you should do is nske all the ahove - Bad debt expense is 1% of net sales. (Net sales = 5ales - Sales returns and allowances - Sales discounts taken) - Depreciation Expense adjustment is $25,000 - Interest owed but not yet recorded (accrued interest) is $1,800. - Expired rent (Prepaid Expenses) is $3,000. - Federal Income Tax is calculated at 21% of pre-tax income. - Make this adjustment last. What you should do is make all the above adjustments (enter them in the adjustment columns), then prepare the adjusted trial balance and the income statement columns. Take note of the income (Revenues less Expenses) and multiply that number (pre-tax income) by the 21% tax rate. That will be the federal income tax expense/federal income taxes payable. Make the federal income tax adjusting entries in the Adjustment columns. Then move onto to finish the Adjusted Trial Balance, Income Statement columns, and Balance Sheet columns. PLEASE use cell references and formulas to complete the Adjusted Trial Balance, Income Statement, and Balance Sheet columns
