Mastery Assignment Ch. 4

 
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 Taccount 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