Question
Roche City has two major sources of revenues, property tax and sales tax, which are billed according to the schedule at the bottom of the
Roche City has two major sources of revenues, property tax and sales tax, which are billed according to the schedule at the bottom of the page. Traditionally, property tax revenues have been received in cash according to the following schedule: 40 percent one month following the billing date, 20 percent in second month, 10 percent in third month, 10 percent in fourth month, 8 percent in fifth month, 5 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, 2012, for the sales tax revenues earned in the last quarter of 2011. Roche City is not planning any capital asset purchases during the next three months. Monthly cash disbursements for general operations are $3,700,000. Beginning cash balance for January 1, 2012, is $500,000. Roche City will borrow to ensure that the ending cash balance each month is at least $100,000. Q: Use this information to prepare a monthly case budget for Roche City for January, February, and March of 2012.
2011 | July | Aug. | Sept. | Oct. | Nov. | Dec. |
Prop. Tax |
|
| 45,000,000 |
|
|
|
Sales Tax | 50,000 | 55,000 | 62,000 | 50,000 | 68,000 | 112,000 |
I know this is a big problem. Any help would be appreciated, especially formatting the table (required) to show my work and organize all of this information.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started