4-3 Project one
.xlsx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
240 APPLIE
Subject
Finance
Date
Jun 3, 2024
Type
xlsx
Pages
4
Uploaded by DoctorTurtle5212
Region
State
County
listing price $'s per square foot
square feet
Random
West North Central
ks
sedgwick
$ 303,400 $194 1,563 0.090167
West South Central
ar
faulkner
$ 280,500 $129 2,168 0.222218
Northeast
ny
cayuga
$ 265,400 $166 1,602 0.020073
South Atlantic
nc
brunswick
$ 281,000 $155 1,818 0.378145
Mountain
nm
chaves
$ 390,200 $204 1,915
0.61084
East South Central
tn
rutherford
$ 159,900 $87 1,847 0.525483
Mountain
co
pueblo
$ 225,200 $154 1,462 0.400903
Mountain
nm
curry
$ 307,900 $158 1,953 0.878967
Mountain
id
kootenai
$ 351,300 $229 1,536 0.255521
East South Central
ky
hopkins
$ 208,000 $104 2,007
0.47736
West South Central
la
st. charles
$ 171,400 $99 1,724 0.516153
South Atlantic
fl
okaloosa
$ 879,200 $142 6,196 0.198462
Pacific
wa
king
$ 405,700 $225 1,800 0.954023
East South Central
tn
hawkins
$ 269,000 $113 2,385 0.587954
Mid Atlantic
va
chesapeake city $ 343,400 $221 1,555 0.292419
Pacific
or
marion
$ 419,300 $217 1,936 0.757433
West South Central
tx
guadalupe
$ 263,800 $146 1,804 0.234878
South Atlantic
nc
edgecombe
$ 349,400 $170 2,061 0.365995
East South Central
ky
mccracken
$ 229,300 $126 1,824 0.372484
New England
ct
litchfield
$ 324,800 $194 1,673 0.266155
South Atlantic
fl
miami-dade
$ 792,900 $165 4,810 0.852385
South Atlantic
fl
highlands
$ 274,600 $166 1,650 0.252221
West North Central
mn
goodhue
$ 340,200 $148 2,296 0.612688
East South Central
tn
blount
$ 308,500 $135 2,278 0.125591
South Atlantic
fl
marion
$ 560,200 $151 3,717 0.953954
West North Central
mo
st. louis
$ 440,100 $197 2,229 0.897047
Northeast
ny
richmond
$ 320,600 $170 1,887 0.878345
West North Central
ia
polk
$ 393,600 $192 2,048 0.543452
West South Central
tx
harris
$ 196,200 $115 1,700 0.571739
West North Central
mn
st. louis
$ 337,200 $163 2,066
0.83673
East North Central
il
la salle
$ 311,100 $154 2,015 0.326436
Mid Atlantic
va
james city
$ 271,300 $209 1,296 0.365206
South Atlantic
nc
beaufort
$ 411,900 $190 2,163 0.638652
Pacific
wa
cowlitz
$ 420,400 $227 1,856 0.977125
Mid Atlantic
va
loudoun
$ 259,000 $179 1,450 0.636688
Pacific
wa
benton
$ 443,000 $247 1,790 0.057435
Northeast
pa
beaver
$ 315,300 $157 2,010
0.54453
West South Central
ok
creek
$ 362,200 $157 2,305 0.751833
South Atlantic
sc
orangeburg
$ 305,400 $172 1,780 0.346217
Mountain
co
la plata
$ 434,700 $202 2,151 0.043216
Northeast
ny
chemung
$ 614,600 $153 4,022 0.746879
Mid Atlantic
va
richmond city
$ 339,800 $177 1,915 0.973509
Pacific
ca
butte
$ 406,200 $217 1,875 0.466385
East South Central
ky
jessamine
$ 174,900 $98 1,777 0.970061
Mid Atlantic
va
montgomery
$ 277,500 $247 1,122 0.752061
Mountain
mt
missoula
$ 370,300 $177 2,091
0.21894
New England
nh
merrimack
$ 340,300 $198 1,715 0.175727
New England
nh
belknap
$ 397,300 $181 2,196 0.389303
Northeast
pa
lehigh
$ 305,800 $194 1,579 0.135652
East North Central
oh
sandusky
$ 253,900 $146 1,738 0.834504
This chart isn't available in your version of Excel.
Editing this shape or saving this workbook into a different file format will permanently break the chart.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
City of Smithville
General Fund
Operating statement account balances
For year 2023
Estimated Revenues Dr(Cr)
Revenues Dr(Cr)
Balance Dr(Cr)
Acct 3020/4020
Estimated Revenues-Property Taxes
$1,877,413
$1,877,578
($165)
Acct 3030/4030
Estimated Revenues-Sales Taxes
1,578,000
1,579,203
(1,203)
Acct 3040/4040
Estimated Revenues-Interest and Penalties on Taxes
15,000
12,571
2,429
Acct 3050/4050
Estimated Revenues-Licenses and Permits
500,000
497,960
2,040
Acct 3060/4060
Estimated Revenues-Fines and Forfeits
175,000
173,590
1,410
Acct 3070/4070
Estimated Revenues-Intergovernmental Revenue
789,000
789,000
0
Acct 3080/4080
Estimated Revenues-Charges for Services
659,720
661,253
(1,533)
Acct 3090/4090
Estimated Revenues-Miscellaneous Revenues
91,300
91,250
50
Encumberances Dr(Cr)
Expenditures Dr(Cr)
Appropriations Cr(Dr)
Available Balance Cr(Dr)
Acct 5020 / 6020 / 7020
Appropriations-General…
arrow_forward
5
arrow_forward
7 Accounting for Property Taxes Tyler County's general fund starts the fiscal year 2020 wi
$250,000 balance for net property taxes receivable. The balance is net of a $200,000 allowance for un
lectible taxes. The county also starts the year with $125,000 in deferred inflows from taxes collecte
advance, which are available for spending in fiscal 2020. The county records the following transact
in fiscal 2020, related to property tax billings and collections.
Property tax bills totaling $40,000,000 are sent out. The county expects that $500,000 of these
are uncollectible.
1.
2. Property taxes of $39,135,000 are collected in cash. Of this amount, $275,000 is payment for f
2019 taxes, $165,000 is fiscal 2021 taxes paid in advance, and the remainder is payment of f
2020 property taxes.
3.
The uncollected taxes for fiscal 2019 are written off.
Of the uncollected fiscal 2020 property taxes, it is estimated that $950,000 will be collected w
60 days of year-end, and the remainder are…
arrow_forward
Sh18
Please help me
Solution
Thankyou.
arrow_forward
Sh12
Please help me
arrow_forward
GIVEN data for a real property:
Value Description
Amount
P1,000,000
25% of market value
Market Value
Assessment level
The local government unit imposes a real property tax of 2%
In addition, the unit also imposes a 1% Special Education Fund (SEF)
COMPUTE: Local tax in relation to the assessment of the real property.
а. 5,000
b. 7,500
с. 20,000
d. 30,000
arrow_forward
4
arrow_forward
r
0
Chesterfield County had the following transactions.
a. A budget is passed for all ongoing activities. Revenue is anticipated to be $1,023,250, with approved spending of $611,000 and
operating transfers out of $336,000.
Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does
b. A contract is signed with a construction company to build a new central office building for the government at a cost of $9,000,000.
The county previously recorded the budget for this project.
c. Bonds are issued for $9,000,000 (face value) to finance construction of the new office building.
d. The new building is completed. An invoice for $9,000,000 is received by the county and paid.
e. Previously unrestricted cash of $1,600,000 is set aside by county officials to begin paying the bonds issued in (c).
f. A portion of the bonds comes due, and $1,600,000 is paid. Of this total, $115,000 represents interest. The interest had not been
previously accrued.
g.…
arrow_forward
Q22
Washington Arts allocates marketing and administrative costs to its three schools based on total annual tuition revenue for the schools:
School
Longview Campus
Springhill Campus
Center Saint Campus
Total
Tuition revenue
$ 1,400,000
$ 1,200,000
$ 1,400,000
$ 4,000,000
Marketing and administrative
$ 1,600,000
Using revenue as an allocation base, the amount of costs allocated to the Springhill Campus is calculated to be:
Multiple Choice
$640,000.
$560,000.
$400,000.
$480,000.
$760,000.
arrow_forward
Required information
Exercise 6-4 and Exercise 6-5 (Algo)
[The following information applies to the questions displayed below.]
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of
its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Accounts payable
Accounts receivable
Accrued interest payable
Accumulated depreciation
Administrative and selling expenses
Allowance for uncollectible accounts
Capital assets
Cash
Charges for sales and services
Cost of sales and services
Depreciation expense
Due from General Fund
Interest expense
Interest revenue
Transfer in from General Fund
Bank note payable
Supplies inventory
Totals
Exercise 6-4 (Algo)
$
Debits
31,900
55,500
732,000
99,500
509,000
53,500
18, 200
41,400
Credits
$ 117,000
35,100
53,500
13,900
579,000
6,200
128,500
628,500
20,700
$1,561,700 $1,561,700
Required:
a. Prepare the closing entries for December 31.
b. Prepare…
arrow_forward
The following Trial Balance is the financial details of West Municipal Assembly for the year ended 31 December, 2021. $ ’000 $ ’000 District Development Facility (DDF) 58,600 Special Sanitation Grant from Government 30,260 Share of Common fund 587,450 Property Rate (iii) 73,230 Funeral Rate 25,270 Salary Div 1 266,280 Commission to Revenue Collectors 15,790 Printing and Publication 66,110 Utility Bills 20,040 Conferences 14,580 Donations 80,770 Contract Retention 13,970 Market Tolls 25,550 Court Fines 109,400 Marriage and Divorce Registration 43,840 Telecommunication Cost 18,830 Repairs and Maintenance 9,720 Town Hall Meetings 64,890 Special Audit Fees 27,130 Travel and Transport 54,670 Revenue Receivable 208,570 Salary Div 2 315,090 Assembly Members Allowance 79,000 Consultancy Cost 4,750 Hawkers License 37,150 Chop bar License 85,600 Market stalls rent 31,590 Bungalow rent 20,750 Advertisement and Promotions 11,500 Office Consumables (1/1/2021) 18,290 Purchase of Office Consumable…
arrow_forward
The following Trial Balance is the financial details of West Municipal Assembly for the year ended 31 December, 2021. $ ’000 $ ’000 District Development Facility (DDF) 58,600 Special Sanitation Grant from Government 30,260 Share of Common fund 587,450 Property Rate (iii) 73,230 Funeral Rate 25,270 Salary Div 1 266,280 Commission to Revenue Collectors 15,790 Printing and Publication 66,110 Utility Bills 20,040 Conferences 14,580 Donations 80,770 Contract Retention 13,970 Market Tolls 25,550 Court Fines 109,400 Marriage and Divorce Registration 43,840 Telecommunication Cost 18,830 Repairs and Maintenance 9,720 Town Hall Meetings 64,890 Special Audit Fees 27,130 Travel and Transport 54,670 Revenue Receivable 208,570 Salary Div 2 315,090 Assembly Members Allowance 79,000 Consultancy Cost 4,750 Hawkers License 37,150 Chop bar License 85,600 Market stalls rent 31,590 Bungalow rent 20,750 Advertisement and Promotions 11,500 Office Consumables (1/1/2021) 18,290 Purchase of Office Consumable…
arrow_forward
Please help
arrow_forward
The following Trial Balance is the financial details of West Municipal Assembly for the yearended 31 December, 2021
District Development Facility (DDF) $58,600 CreditSpecial Sanitation Grant from Government $30,260 CreditShare of Common Fund $587,450 CreditProperty Rate (ii) $73,230 CreditFuneral Rate $25,270 CreditSalary Div 1 $266,280 DebitCommission to Revenue Collectors $15,790 DebitPrinting and Publication $66,110 DebitUtility Bills $20,040 DebitConferences $14,580 DebitDonations $80,770 CreditContract Retention $13,970 CreditMarket Tolls $25,550 CreditCourt Fines $109,400 CreditMarriage and Divorce Registration $43,840 CreditTelecommunication Cost $18,830 DebitRepairs and Maintenance $9,720 DebitTown Hall Meetings $64,890 DebitSpecial Audit Fees $27,130 DebitTravel and Transport $54,670 DebitRevenue Receivable $208,570 DebitSalary Div 2 $315,090 DebitAssembly Members Allowance $79,000 DebitConsultancy Cost $4,750 DebitHawkers License $37,150 CreditChop bar License $85,600…
arrow_forward
Analyze the statement of operations for the year 2020 and compare it with the year 2019. Identify and explain 5 of the most important issues.
Shawanaga First Nation
Consolidated Statements of Operations and Accumulated Surplus
Year Ended March 31
2020
2019
Actual
Actual
Revenue
Government funding (Note 16)
$8,669,075
$6,530,279
Sales
5,093,432
4,510,928
Rental and other
350,082
555,231
Interest
44,027
24,225
Loss on disposal of equipment
-673,192
-17,344
Loss from investment in government business enterprise (note5)
-117,480
-56,619
13,365,944
11,546,700
Expenses
Capital
152,153
143,708
Community operations
1,116,702
1,166,556
Economic development
5,152,423
4,527,794
Education
1,223,566
1,107,489
First Nation administration
1,939,337
1,741,586
Health services
2,006,262
1,615,067
Other
358,111
420,012
Social services
300,467
342,587
Total
12,249,021
11,064,799
Annual surplus before prior year
subsidy…
arrow_forward
A
arrow_forward
Using the Balance Sheet in the St. Johns County, Florida 2015 CAFR calculate the following ratios for each of the five (5) funds shown and for the “Total Governmental Funds:”a. Current Ratiob. Net Working Capitalc. Debt Ratio 1d. Debt Ratio 2e. Unrestricted Net Assets Ratiof. Response Ratio
arrow_forward
Below is the complete set of Financial Statements of Take-Home University (THU), a PublicUniversity of Ghana, issued on 1st May 2020.Statement of Financial Performance for the Year Ended 31 December, 2018Revenue NotesGOG grant 1,540,000,000Internally Generated Funds 2 14,427,492,000Donations and other income 9,278,258,00025,245,750,000ExpenditureCompensation for employees 3 8,385,270,000Goods and services 4 2,238,083,000Social benefit 1,720,000Interest 1,720,000Capital expenditure (CAPEX) 5 25,542,515,000Other expenses 6 79,100,00036,248,408,000Net Operating Result – Deficit (11,002,658,000)Statement of Financial Position as at 31 December 2018NotesCurrent AssetsCash and cash equivalent 294,233,000Receivable (468,050 -10,000) 458,050,000Inventory 155,254,000907,537,000Liabilities and FundPayable 7 696,325,00020% Loan 8,600,000704,925,000Accumulated fund 8 202,612,000907,537,0004Cash Flow Statement for the Year ended 31st December 2018Cash InflowsGOG grant 1,540,000,000Internally…
arrow_forward
Below is the complete set of Financial Statements of Take-Home University (THU), a PublicUniversity of Ghana, issued on 1st May 2020.Statement of Financial Performance for the Year Ended 31 December, 2018Revenue NotesGOG grant 1,540,000,000Internally Generated Funds 2 14,427,492,000Donations and other income 9,278,258,00025,245,750,000ExpenditureCompensation for employees 3 8,385,270,000Goods and services 4 2,238,083,000Social benefit 1,720,000Interest 1,720,000Capital expenditure (CAPEX) 5 25,542,515,000Other expenses 6 79,100,00036,248,408,000Net Operating Result – Deficit (11,002,658,000)Statement of Financial Position as at 31 December 2018NotesCurrent AssetsCash and cash equivalent 294,233,000Receivable (468,050 -10,000) 458,050,000Inventory 155,254,000907,537,000Liabilities and FundPayable 7 696,325,00020% Loan 8,600,000704,925,000Accumulated fund 8 202,612,000907,537,0004Cash Flow Statement for the Year ended 31st December 2018Cash InflowsGOG grant 1,540,000,000Internally…
arrow_forward
Question ThreeThe following Trial Balance is the financial details of West Municipal Assembly for the yearended 31 December, 2021
District Development Facility (DDF) $58,600 CreditSpecial Sanitation Grant from Government $30,260 CreditShare of Common Fund $587,450 CreditProperty Rate (ii) $73,230 CreditFuneral Rate $25,270 CreditSalary Div 1 $266,280 DebitCommission to Revenue Collectors $15,790 DebitPrinting and Publication $66,110 DebitUtility Bills $20,040 DebitConferences $14,580 DebitDonations $80,770 CreditContract Retention $13,970 CreditMarket Tolls $25,550 CreditCourt Fines $109,400 CreditMarriage and Divorce Registration $43,840 CreditTelecommunication Cost $18,830 DebitRepairs and Maintenance $9,720 DebitTown Hall Meetings $64,890 DebitSpecial Audit Fees $27,130 DebitTravel and Transport $54,670 DebitRevenue Receivable $208,570 DebitSalary Div 2 $315,090 DebitAssembly Members Allowance $79,000 DebitConsultancy Cost $4,750 DebitHawkers License $37,150 CreditChop bar License…
arrow_forward
Question 1 Not complete
Marked out of 7.14
Flag question
Scenario and General Fund budgetary journal entries
The scenario: Croton City maintains four governmental-type funds: a General Fund, a Library Special Revenue Fund, a Capital Projects Fund, and a Debt Service Fund.
Croton City started its calendar year 2019 with the following General Fund balances (all numbers are in thousands of dollars).
Cash
Property taxes receivable
Debits Credits
$1,800
800
Salaries payable
Deferred property tax revenues
Unassigned fund balance
Totals
$700
300
1,600
$2,600
$2,600
Croton has adopted the following budgetary and accounting policies:
• Encumbrance accounting is used only for the acquisition of supplies and for the award of contracts for construction and construction-related activities. Open encumbrances lapse at the end of the year, but are considered in developing the next year's budget.
Because final income tax returns are not required to be filed until April 15 of the year following the end…
arrow_forward
Augusta has a municipal water and gas utility district (MUD). The trial balance on January 1, 20X1, follows:
Debit
$ 93,300
26,200
9,600
120,700
490,000
Cash
Accounts Receivable
Inventory of Supplies
Land
Plant and Equipment
Accumulated Depreciation
Vouchers Payable
Bonds Payable, 5%
Net Position:
Invested in Capital Assets, Net of Related Debt
Unrestricted
Total
$739,800
Credit
$ 80,400
15,500
518,000
12,300
113,600
$739,800
Additional Information for 20X1:
1. Charges to customers for water and gas were $420,500, collections were $432.100.
2. A loan of $25,900 for two years was received from the general fund.
3. The water and gas lines were extended to a new development at a cost of $76,200. The contractor was paid.
4. Supplies were acquired from central stores (internal service fund) for $13,700. Operating expenses were $330,000, and interest
expense was $25,900. Payment was made for the interest and the payable to central stores, and $325,400 of the vouchers were
pald.
5. Adjusting…
arrow_forward
3
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Debits
Credits
Accounts payable
$ 108,000
Accounts receivable
$ 27,400
Accrued interest payable
30,600
Accumulated depreciation
49,000
Administrative and selling expenses
51,000
Allowance for uncollectible accounts
13,000
Capital assets
714,000
Cash
96,800
Charges for sales and services
561,000
Cost of sales and services
500,000
Depreciation expense
49,000
Due from General Fund
17,300
Interest expense
40,500
Interest revenue
5,300
Transfer in from General Fund
117,600
Bank note payable
630,400
Supplies inventory
18,900
Totals
$ 1,514,900
$ 1,514,900
Required:
Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at…
arrow_forward
3
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Debits
Credits
Accounts payable
$ 108,000
Accounts receivable
$ 27,400
Accrued interest payable
30,600
Accumulated depreciation
49,000
Administrative and selling expenses
51,000
Allowance for uncollectible accounts
13,000
Capital assets
714,000
Cash
96,800
Charges for sales and services
561,000
Cost of sales and services
500,000
Depreciation expense
49,000
Due from General Fund
17,300
Interest expense
40,500
Interest revenue
5,300
Transfer in from General Fund
117,600
Bank note payable
630,400
Supplies inventory
18,900
Totals
$ 1,514,900
$ 1,514,900
Required:
Prepare the reconciliation of operating income to net cash provided by operating activities that would appear at the…
arrow_forward
Don't give answer in image format
arrow_forward
Question 5 Not complete Marked out of 3.33
Flag question
Budgetary transactions and events
Prepare journal entries to record the following transactions and events that occurred in Marilyn County during calendar year 2022:
1. The legislature adopted the following budget:
Estimated revenues and other sources
Property taxes
Sales taxes
Use of fund balance
Total
Appropriations:
General government-salaries
General government-supplies
Parks department-salaries
Parks department-plants and supplies
Total
$1,740,000
1.000.000
10,000
$2,750,000
$420,000
30,000
2.000.000
300,000
$2,750,000
2. The Parks department placed PO 2022-1 for shrubbery in the amount of $52,000 and PO 2022-2 for gardening supplies in the amount of $11,000.
The orders were charged to the appropriation for Parks department-plants and supplies.
3. The supplier delivered the shrubbery ordered on PO 2022-1; however, the supplier said he could not deliver some of the shrubs because he no longer carried them.
The invoice for…
arrow_forward
During the month of July, the Town of Lynton recorded the following information related to purchases: Amount of Purchase Order Actual Cost General government $
556, 000 $ 496,000 Public safety 741, 200 726, 013 Public works 960, 845 469, 480 Culture and recreation 60,270 60,320 Total purchase orders and invoices $ 2,318,315 S
1,751,813 At the end of the month, several purchase orders remained outstanding for all functions except Culture and Recreation. Public Works in particular had a large
amount of purchase orders outstanding because it had put in an order for delivery of paving materials to be delivered over the months of July and August. For all but
Culture and Recreation, consider the amounts for purchase orders received the same as the actual cost of the items. Required (1) Prepare the general journal entry to
record the issuance of the purchase orders. (2) Show entries in subsidiary ledger accounts. (1) Prepare the general journal entries to record the receipt of the goods…
arrow_forward
2
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2024, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund.
Debits
Credits
Accounts payable
$ 108,000
Accounts receivable
$ 27,400
Accrued interest payable
30,600
Accumulated depreciation
49,000
Administrative and selling expenses
51,000
Allowance for uncollectible accounts
13,000
Capital assets
714,000
Cash
96,800
Charges for sales and services
561,000
Cost of sales and services
500,000
Depreciation expense
49,000
Due from General Fund
17,300
Interest expense
40,500
Interest revenue
5,300
Transfer in from General Fund
117,600
Bank note payable
630,400
Supplies inventory
18,900
Totals
$ 1,514,900
$ 1,514,900
Required:
Prepare the closing entries for December 31.
Prepare the Statement of Revenues, Expenses, and Changes in Fund…
arrow_forward
The following financial transactions are related to a local government during the year.
General property taxes 100,000,
Proceeds of general bonds RO 50,000,
State grant to construct the school building RO 400,000.
Which one of the following amounts that a local government should report in general funds?
a.
RO 150,000
b.
RO 400,000
c.
None of the options
d.
RO 550,000
arrow_forward
The following chart is published in a local government’s annual financial report.
Identify four significant critiques of this chart. Draw on class instruction/discussion on professional chart design.
arrow_forward
None
arrow_forward
Calculate the property tax rate required to meet the budgetary demands of the community. Note: When calculating budgetary demands, always round up. (Round your answers to two decimal places.) Community Ellingham Total Assessed Property Valuation $56,000,000 Total Taxes Required $2,600,000 Percent X % Property Tax Rate Per $100 (in $) $4.64 X Per $1,000 (in $) $ 46.43 Mills 46.43
arrow_forward
0
1
E 20-7
General fund journal entries (property taxes)
The following events and transactions relate to the levy and collection of property taxes for Jedville Township:
13
14
15
16
March 21, 2011-Property tax bills for $2,500,000 are sent to property owners. An estimated 2% of the
property tax levies are uncollectible. The taxes are due on May 1.
May 4, 2011-$1,900,000 in taxes have been collected. The remaining receivables are reclassified as delinquent.
May 5 to December 31, 2011-An additional $150,000 of taxes are collected.
November 1, 2011-A $5,000 tax receivable account is determined to be uncollectible and is written off.
January 1, 2012, to February 28, 2012-An additional $87,750 of 2011 taxes are collected.
REQUIRED
1. Prepare summary journal entries for the events and transactions described for the Jedville general fund.
2. How will property taxes be presented in the December 31, 2011, balance sheet?
3. What amount of property tax revenues should be reported for 2011?
arrow_forward
sub= 24
arrow_forward
City A has the following financial data. What is the Net Asset Per Capita?
Cash: $ 4,650; Cash Equivalents: $12,350; Market Securities: $3,462; Receivables: $ 12,409; Current Liabilities: $45,690; Net Assets: $139,450; Total Assets: $2,458,360; Total Revenues: $1,367,809; Total Expenditures: $1,450,098; Population: 1,670.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Related Questions
- City of Smithville General Fund Operating statement account balances For year 2023 Estimated Revenues Dr(Cr) Revenues Dr(Cr) Balance Dr(Cr) Acct 3020/4020 Estimated Revenues-Property Taxes $1,877,413 $1,877,578 ($165) Acct 3030/4030 Estimated Revenues-Sales Taxes 1,578,000 1,579,203 (1,203) Acct 3040/4040 Estimated Revenues-Interest and Penalties on Taxes 15,000 12,571 2,429 Acct 3050/4050 Estimated Revenues-Licenses and Permits 500,000 497,960 2,040 Acct 3060/4060 Estimated Revenues-Fines and Forfeits 175,000 173,590 1,410 Acct 3070/4070 Estimated Revenues-Intergovernmental Revenue 789,000 789,000 0 Acct 3080/4080 Estimated Revenues-Charges for Services 659,720 661,253 (1,533) Acct 3090/4090 Estimated Revenues-Miscellaneous Revenues 91,300 91,250 50 Encumberances Dr(Cr) Expenditures Dr(Cr) Appropriations Cr(Dr) Available Balance Cr(Dr) Acct 5020 / 6020 / 7020 Appropriations-General…arrow_forward5arrow_forward7 Accounting for Property Taxes Tyler County's general fund starts the fiscal year 2020 wi $250,000 balance for net property taxes receivable. The balance is net of a $200,000 allowance for un lectible taxes. The county also starts the year with $125,000 in deferred inflows from taxes collecte advance, which are available for spending in fiscal 2020. The county records the following transact in fiscal 2020, related to property tax billings and collections. Property tax bills totaling $40,000,000 are sent out. The county expects that $500,000 of these are uncollectible. 1. 2. Property taxes of $39,135,000 are collected in cash. Of this amount, $275,000 is payment for f 2019 taxes, $165,000 is fiscal 2021 taxes paid in advance, and the remainder is payment of f 2020 property taxes. 3. The uncollected taxes for fiscal 2019 are written off. Of the uncollected fiscal 2020 property taxes, it is estimated that $950,000 will be collected w 60 days of year-end, and the remainder are…arrow_forward
- Sh18 Please help me Solution Thankyou.arrow_forwardSh12 Please help mearrow_forwardGIVEN data for a real property: Value Description Amount P1,000,000 25% of market value Market Value Assessment level The local government unit imposes a real property tax of 2% In addition, the unit also imposes a 1% Special Education Fund (SEF) COMPUTE: Local tax in relation to the assessment of the real property. а. 5,000 b. 7,500 с. 20,000 d. 30,000arrow_forward
- 4arrow_forwardr 0 Chesterfield County had the following transactions. a. A budget is passed for all ongoing activities. Revenue is anticipated to be $1,023,250, with approved spending of $611,000 and operating transfers out of $336,000. Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does b. A contract is signed with a construction company to build a new central office building for the government at a cost of $9,000,000. The county previously recorded the budget for this project. c. Bonds are issued for $9,000,000 (face value) to finance construction of the new office building. d. The new building is completed. An invoice for $9,000,000 is received by the county and paid. e. Previously unrestricted cash of $1,600,000 is set aside by county officials to begin paying the bonds issued in (c). f. A portion of the bonds comes due, and $1,600,000 is paid. Of this total, $115,000 represents interest. The interest had not been previously accrued. g.…arrow_forwardQ22 Washington Arts allocates marketing and administrative costs to its three schools based on total annual tuition revenue for the schools: School Longview Campus Springhill Campus Center Saint Campus Total Tuition revenue $ 1,400,000 $ 1,200,000 $ 1,400,000 $ 4,000,000 Marketing and administrative $ 1,600,000 Using revenue as an allocation base, the amount of costs allocated to the Springhill Campus is calculated to be: Multiple Choice $640,000. $560,000. $400,000. $480,000. $760,000.arrow_forward
- Required information Exercise 6-4 and Exercise 6-5 (Algo) [The following information applies to the questions displayed below.] The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2020, the last day of its fiscal year. The enterprise fund was established this year through a transfer from the General Fund. Accounts payable Accounts receivable Accrued interest payable Accumulated depreciation Administrative and selling expenses Allowance for uncollectible accounts Capital assets Cash Charges for sales and services Cost of sales and services Depreciation expense Due from General Fund Interest expense Interest revenue Transfer in from General Fund Bank note payable Supplies inventory Totals Exercise 6-4 (Algo) $ Debits 31,900 55,500 732,000 99,500 509,000 53,500 18, 200 41,400 Credits $ 117,000 35,100 53,500 13,900 579,000 6,200 128,500 628,500 20,700 $1,561,700 $1,561,700 Required: a. Prepare the closing entries for December 31. b. Prepare…arrow_forwardThe following Trial Balance is the financial details of West Municipal Assembly for the year ended 31 December, 2021. $ ’000 $ ’000 District Development Facility (DDF) 58,600 Special Sanitation Grant from Government 30,260 Share of Common fund 587,450 Property Rate (iii) 73,230 Funeral Rate 25,270 Salary Div 1 266,280 Commission to Revenue Collectors 15,790 Printing and Publication 66,110 Utility Bills 20,040 Conferences 14,580 Donations 80,770 Contract Retention 13,970 Market Tolls 25,550 Court Fines 109,400 Marriage and Divorce Registration 43,840 Telecommunication Cost 18,830 Repairs and Maintenance 9,720 Town Hall Meetings 64,890 Special Audit Fees 27,130 Travel and Transport 54,670 Revenue Receivable 208,570 Salary Div 2 315,090 Assembly Members Allowance 79,000 Consultancy Cost 4,750 Hawkers License 37,150 Chop bar License 85,600 Market stalls rent 31,590 Bungalow rent 20,750 Advertisement and Promotions 11,500 Office Consumables (1/1/2021) 18,290 Purchase of Office Consumable…arrow_forwardThe following Trial Balance is the financial details of West Municipal Assembly for the year ended 31 December, 2021. $ ’000 $ ’000 District Development Facility (DDF) 58,600 Special Sanitation Grant from Government 30,260 Share of Common fund 587,450 Property Rate (iii) 73,230 Funeral Rate 25,270 Salary Div 1 266,280 Commission to Revenue Collectors 15,790 Printing and Publication 66,110 Utility Bills 20,040 Conferences 14,580 Donations 80,770 Contract Retention 13,970 Market Tolls 25,550 Court Fines 109,400 Marriage and Divorce Registration 43,840 Telecommunication Cost 18,830 Repairs and Maintenance 9,720 Town Hall Meetings 64,890 Special Audit Fees 27,130 Travel and Transport 54,670 Revenue Receivable 208,570 Salary Div 2 315,090 Assembly Members Allowance 79,000 Consultancy Cost 4,750 Hawkers License 37,150 Chop bar License 85,600 Market stalls rent 31,590 Bungalow rent 20,750 Advertisement and Promotions 11,500 Office Consumables (1/1/2021) 18,290 Purchase of Office Consumable…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education