Panther City has two major sources of revenues, property tax and sales tax, which are billed...

Panther City has two major sources of revenues, property tax and sales tax, which are billed according to the schedule at the top of the next page. Traditionally, property tax revenue have been received in cash according to the following schedule:

30 percent one month following the billing date 20 percent in second month
20 percent in third month
9 percent in fourth month
8 percent in fifth month
6 percent in sixth month
7 percent are not collected

The state collects the sales tax revenues and will transfer cash to the city on March 1, 2018, for the sales tax revenues earned in the last quarter of 2017.

Panther City is not planning any capital asset purchases during the next three months. Monthly cash disbursements for general operations are $3,500,000. Beginning cash balance for January 1, 2018, is $600,000. Panther City will borrow to ensure that the ending cash balance each month is at least $200,000.

Use this information to prepare a monthly cash budget for Panther City for January, February, and March of 2018.

2017	July	Aug.	Sept.	Oct.	Nov.	Dec.
Prop. Tax			50,000,000
Sales Tax	50,000	55,000	62,000	60,000	68,000	112,000

Solutions

Expert Solution

First, we calculate the property and sales tax receipts in Jan, Feb, March :

Property tax of $50 million is billed in September and received in cash as per this schedule :

September	$0
October	$15,000,000
November	$10,000,000
December	$10,000,000
January	$4,500,000
February	$4,000,000
March	$3,000,000

Sales tax collected in last quarter of 2017 = $60,000 + $68,000 + $112,000 ==> $240,000. This is transferred to the city on 1st March, 2018

Now, we prepare the cash budget as below :

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

what are the major components of government outlays? What are the major sources of government revenues?...

what are the major components of government outlays? What are the major sources of government revenues? Explain how fiscal policy affects the overall economic activity.

What are the two major sources of revenue for a Property & Liability insurance company? (explain in details)

What are total property tax revenues for 2020, related to 2020 tax bills?

At the beginning of 2020, the balance sheet of a county general fund reports $500,000 in property taxes receivable from 2019, of which $350,000 are considered uncollectible. During 2020 the county sends out tax bills in the amount of $10,000,000, of which $600,000 are expected to be uncollectible. Cash collections on 2019 taxes are $140,000, and the remaining uncollected taxes are written off. Cash collections on 2020 taxes are $9,500,000. Of the $500,000 uncollected at the end of 2020, $100,000...

Determining of property tax rate The county legislature approved the budget for 2019. Revenues from property...

Determining of property tax rate The county legislature approved the budget for 2019. Revenues from property taxes are budgeted at $800,000. According to the county assessor, the assessed valuation of all of the property in the county is $50 million. Of this amount, property worth $10 million belongs to the federal government or to religious organizations and, therefore, is not subject to property taxes. In addition, certificates for the following exemptions have been filed: Homestead $2,500,000 Veterans 1,000,000 Old age,...

Which of the following best illustrates a regressive tax(Income, sales property or excise)?

The City of Roanoke adopted the following budget for fiscal year 2019: Anticipated Revenues: Property...

The City of Roanoke adopted the following budget for fiscal year 2019: Anticipated Revenues: Property Taxes Licenses and Permits Fines and Forfeits Total - $6,060,000 402,000 308,000 $6,770,000 Approved spending levels: General Government Public Safety Public Works Total - $1,860,000 2,500,000 1,785,000 $6,145,000 In addition, the City reported the following actual amounts for the same fiscal year. Revenues: Property Taxes Licenses and Permits Fines and Forfeits Total - $5,862,000 391,000 311,000 $6,564,000 Expenditures –...

In the City of Albany, suppose the mill rate for the property tax is $33 for...

In the City of Albany, suppose the mill rate for the property tax is $33 for the year 2020 and the appraised value for your home is $300,000, how much would your property tax be in 2020?

One of the major sources of revenue for the government is Tax. The government spends the...

One of the major sources of revenue for the government is Tax. The government spends the tax that it collected on various activities which include nation building and social welfare of citizens and residents. The government charges tax to individuals and corporates as per the tax provision in the country, but there have been many incidences where the payers have not paid taxes to the government. The country’s tax authority is empowered to implement the tax laws and also penalise...

The property tax paid by homeowners in a large city was determined to be normally distributed...

The property tax paid by homeowners in a large city was determined to be normally distributed with a mean of $2,800 and a standard deviation of $400. A random sample of 4 homes was drawn. a. what is the probability distribution of the mean of the sample of four homes? b. Determine the probability the sample mean falls between $2,500 and $2,900. c. How would you answer this question if property tax is not normally distributed?

implement a step by step property tax policy to raise the revenue of a city in...

implement a step by step property tax policy to raise the revenue of a city in order to reduce the dependence on state and federal aid. take under consideration the local businesses so that the poor dont get affected by the policy Implement a policy to raise property tax on businesses in order to raise revenue for a city

Subjects