Problem 3 Gilbert City had the following transactions involving resource inflows
ID: 2415070 • Letter: P
Question
Problem 3
Gilbert City had the following transactions involving resource inflows into its general fund for the year ended June 30, 20X8:
1.
The general fund levied $2,700,000 of property taxes in July 20X7. The city estimated that 2 percent of the levy would be uncollectible and that $140,000 of the levy would not be collected until after August 31, 20X8.
2.
On April 1, 20X8, the general fund received $57,000 repayment of an advance made to the internal service fund. Interest on the advance of $1,710 also was received.
3.
During the year ended June 30, 20X8, the general fund received $2,500,000 of the property taxes levied in transaction (1).
4.
The general fund received $265,000 in grant monies from the state to be used solely to acquire computer equipment. During March 20X8, the general fund acquired computer equipment using $234,000 of the grant. The city has not yet determined the use of the remainder of the grant.
5.
During the year ended June 30, 20X8, the general fund received $125,000 from the state as its portion of the sales tax. At June 30, 20X8, the state owed the general fund an additional $26,000 of sales taxes. The general fund does not expect to have the $26,000 available until early August 20X8.
6.
In July 20X7, the general fund borrowed $830,000 from a local bank using the property tax levy as collateral. The loan was repaid in September 20X7 with the proceeds from property tax collections.
7.
In February 20X8, a terminated debt service fund transferred $38,000 to the general fund. The $38,000 represented excess resources left in the debt service fund after a general long-term debt obligation had been paid in full.
8.
On July 1, 20X7, the general fund estimated that it would receive $78,000 from the sale of liquor licenses during the fiscal year ended June 30, 20X8. For the year ended June 30, 20X8, $65,000 had been received from liquor license sales.
9.
The general fund received $11,000 in October 20X7 from one of the city’s special revenue funds. The amount received represented a reimbursement for an expenditure of the special revenue fund that the city’s general fund paid.
10.
In July 20X7, the general fund collected $86,000 of delinquent property taxes that had been classified as delinquent on June 30, 20X7. In the entry to record the property tax levy in July 20X6, the general fund estimated that it would collect all property tax revenues by July 31, 20X7.
Required:
Prepare a schedule showing the amount of revenue that should be reported by Gilbert City’s general fund on the statement of revenues, expenditures, and changes in fund balance for the year ended June 30, 20X8.
Gilbert City had the following transactions involving resource inflows into its general fund for the year ended June 30, 20X8:
Explanation / Answer
1)Property tax levied = 2,700,000
Here 2% is not collected . 27000*2 = 54000
Tax payable = 2646000
Present paid amount = 2506000
2) repayment of an advance = 57000 Interest on the advance = $1,710
3) June 30, 20X8, the general fund received =2,500,000
4) general fund received (for computer equipment) = $265,000
Amount spend for computer equipment = 234000
5)June 30, 20X8, the general fund received (sales tax)= 125,000
general fund does not expect to have the = $26,000
6) loan re payment in sep 2007 = 830000
7) terminated debt service fund transferred = $38,000
8) liquor license sales received =$65,000
9) reimbursement on oct 2007 = 11000
10) delinquent property taxes = 86000
Gilbert City’s income statement at june 30 2008
Gilbert City’s income statement at june 30 2008
Date
Particulars
7/1/2007
loan barrowed
830000
31-Jul-07
Delinquent property taxes
86000
11-Oct-70
Reimbursement
11000
1-Mar-08
fund receved for computer expence
26500
1-Apr-08
repayment of advances
57000
Interest received on advances
1710
30-Jun-08
sales tax
99000
30-Jun-08
liquor license sales received
65000
30-Jun-08
property tax received
2500000
Gross revenue
3676210
1-Mar-08
purchase of computer equipments
234000
1-Sep-07
loan paid
830000
Total Revenue
2612210
Gilbert City’s income statement at june 30 2008
Date
Particulars
7/1/2007
loan barrowed
830000
31-Jul-07
Delinquent property taxes
86000
11-Oct-70
Reimbursement
11000
1-Mar-08
fund receved for computer expence
26500
1-Apr-08
repayment of advances
57000
Interest received on advances
1710
30-Jun-08
sales tax
99000
30-Jun-08
liquor license sales received
65000
30-Jun-08
property tax received
2500000
Gross revenue
3676210
1-Mar-08
purchase of computer equipments
234000
1-Sep-07
loan paid
830000
Total Revenue
2612210
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.