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.