need help finding the figures for these problems to enter into an excel assignment/workbook, thank you.
Chapter 7 Recording Transactions Affecting the Enterprise Fund and Business-type Activities The City of Corvalis accounts for its Municipal Municipal Airport activities in an enterprise fund. The balance sheet for the Municipal Airport Fund (EF) as of December 31, 2017 appears below City of Corvalis Municipal Airport Fund Post-closing Trial Balance As of December 31, 2017 unt Title Debits Credits 273,660 138,230 Cash Customer Accou Allowance for Doubtful Accounts Inventories Land Buildings Accumulated Depreciation-Buildings Equipment 12.490 4,850 570,060 1,567,560 712.560 988,440 Vouchers Payable Accrued Payroll and Fringe Benefits Net Position Net Investment in Capital Assets Net Position Unrestricted 619,080 47,830 82,550 1794.420 273,870 3,542,800 Totals 3,542,800 1 17-b-1 Billings to customers of the Municipal Airport Fund (EF) totaled $3,145,000 for the year, including $18,300 billed to City of Corvalis departments accounted for in the General Fund (GF). For the amount billed to City of Corvalis departments you should debit Due from Other Funds. The revenue account used in this journal is "Charges for Services" 2 17-b-2 Equipment was purchased on July 1, 2018. The total cost was $380,000. Cash in the amount of $238,000 was paid at the time of purchase; the vendor accepted revenue anticipation notes in the amount of $142,000 to finance the remainder of the equipment. Of this amount, $71,000 of the notes will be payable on July 1, 2019; the other $71,000 will be payable on July 1, 2020. All notes bear interest at the rate of 5 percent per year. (Record only the purchase and the related payment of cash and issuance of notes at this time; interest will be recorded in a later transaction) 317-b-31 Vouchers for materials and supplies to be used in the operations of the fund were issued in the total amount of $893,000. (Debit Inventories) Chapter 7 Hint A/R Due from other funds xxx Revenue Xxx Eqmt XXx Cash Rev. Anti. N/P-Curr. xxx Rev. Anti. N/P-LT. xxx 3. Inventories xxx V/P XxX