Reference no: EM132872602

Question - During the month, the university received an unrestricted appropriation of $4,000,000 from the state.

The following information pertains to Northern State University, a government owned university, for the month of March, 20X1.

1. The university billed tuition and fees totaling $3,400,000 and provided $280,000 in scholarship waivers.

2. An alumnus donated $900,000 in cash with $200,000 earmarked for construction of a new library.

3. Equipment for the student computer labs was purchased for cash in the amount of $485,000.

4. Interest of $32,000 on bonds payable was paid.

5. Investment income of $49,000 was earned and collected.

6. The university collected $2,485,000 of the tuition and fees billed earlier.

7. Refunds of $97,200 were made for tuition and fees.

8. General expenses of 3,976,000 related to administration of academic programs was paid.

9. Accrued liabilities of $16,800 were paid.

10. Month end entries included the following: Depreciation - $74,000; Allowance for doubtful accounts - 17,800; accrued interest earned on investments - $1,460.

Required - Prepare journal entries for each of the foregoing transactions in an Excel worksheet. Label each entry clearly and use Excel formulas for all calculated numbers.