Complete the following problems in Excel. Use a different tab for each problems
using the correct number format. Make sure you use two accounts (debit and
credit) for the adjusting entries. Read the problems carefully.
PA10.) Prepare journal entries to record the following transactions. Create a T–account for Interest Payable, post any entries that affect the account, and tally the ending balance for the account (assume Interest Payable beginning balance of $2,500).
A. March 1, paid interest due on note, $2,500
B. December 31, interest accrued on note payable, $4,250
PA13.) Prepare adjusting journal entries, as needed, considering the account balances
excerpted from the unadjusted trial balance and the adjustment data.
A. supplies actual count at year end, $6,500
B. remaining unexpired insurance, $6,000
C. remaining unearned service revenue, $1,200
D. salaries owed to employees, $2,400
E. depreciation on property plant and equipment, $18,000
PA15.) Prepare an adjusted trial balance from the following account information, considering the adjustment; data provided (assume accounts have normal balances). Equipment was recently purchased, so there is neither depreciation expense nor accumulated depreciation.
Adjustments needed:
Salaries due to employees, but unpaid at the end of the period, $2,000
Insurance still unexpired at end of the period, $12,000
Prepare journal entries to record the following transactions. Create a T-account for Interest Payable, post any entries that affect the account, and tally the ending balance for the account.