80.2K

Verified Solution

Link Copied!

The following is a list of unadjusted account balances at year-end, as well as additional information regarding year-end ar Select Company Accounts and Additional Information: Account Name Supplies Interest receivable Salaries payable Deferred revenue Account Balance Account Name $14,700 Service revenue 0 Interest revenue 0 Supplies expense 9,500 Salaries expense 1. Supplies remaining at the end of the year. 2. Services remaining to be provided to customers who paid in advance. 3. Employees are owed additional salaries at the end of the year. 4. A note receivable was accepted on March 31. Interest rate on note Required: 1. Use the information provided to prepare year-end adjustments. Account Balance $132,600 0 0 48,100 (Use the cells from the given information above to complete this question. Hint: The credit amount will automatically be set to the debit amount.) 6,200 2,700 4,500 9,000 8%

please answer the excel part

The following is a list of unadjusted account balances at year-end, as well as additional information regarding year-end amounter. Select Company Accounts and Additional Information: 1. Supplies remaining at the end of the year. 2. Services remaining to be provided to rear. 3. Interest rate on note 82 Required: 1. Use the information provided to prepare year-end adjustments. 2. Calculate adjusted balances for each account. 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Use the cells from the given information above to complete this question. Hint: The credit amount will automatically be set to the debit amount.) The following is a list of unadjusted account balances at year-end, as well as additional information regarding year-end ar The following is a list of unadjusted account balances at year-end, as well as additional information regarding year-end amounter. Select Company Accounts and Additional Information: 1. Supplies remaining at the end of the year. 2. Services remaining to be provided to rear. 3. Interest rate on note 82 Required: 1. Use the information provided to prepare year-end adjustments. 2. Calculate adjusted balances for each account. 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Use the cells from the given information above to complete this question. Hint: The credit amount will automatically be set to the debit amount.) The following is a list of unadjusted account balances at year-end, as well as additional information regarding year-end ar

Answer & Explanation Solved by verified expert

See Answer