The city council had an amount of US $ 2400 in the bank account as at...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The city council had an amount of US $ 2400 in the bank account as at January 1" as well as an amount of US $0 in the cash drawer of the treasurer of the city council. The outlook for the following three months starting January 1" with regards to expected revenues and expenses are summarized in the following schedule: A. Expected Revenues 1. Property taxes The city council is expecting to receive the Property taxes of $ 40000 in Five equal installments: 1. First in January. 2. Second in March. 3. The third in May. 4. The fourth in June. 5. The Fifth in July. Revenue from Sales taxes amounting are allocated based on a percentage basis 30 % from Property taxes, is expected to be received in March. Fixed assets sales amounting to $ 6000 is expected to be received in March. License fees amounting to $4000 is expected to be received in January. 2. Sales taxes 3. Fixed assets sales 4. License fees B. Expected Expenses 1. Personal services Personal services amounting to $ 30000 are allocated based on a percentage basis as follows: 1. 20 % in January. 2. 30% in March. 3. 50 % in June. Operating expenses are allocated based on a percentage basis 40 % from License fees, is expected payment in January. 2. Operating expenses You are required to prepare ihe city council, cash forecast (first quarter, 2022) projections for the three month period as anote the minimum cash balance is $10000. The city council had an amount of US $ 2400 in the bank account as at January 1" as well as an amount of US $0 in the cash drawer of the treasurer of the city council. The outlook for the following three months starting January 1" with regards to expected revenues and expenses are summarized in the following schedule: A. Expected Revenues 1. Property taxes The city council is expecting to receive the Property taxes of $ 40000 in Five equal installments: 1. First in January. 2. Second in March. 3. The third in May. 4. The fourth in June. 5. The Fifth in July. Revenue from Sales taxes amounting are allocated based on a percentage basis 30 % from Property taxes, is expected to be received in March. Fixed assets sales amounting to $ 6000 is expected to be received in March. License fees amounting to $4000 is expected to be received in January. 2. Sales taxes 3. Fixed assets sales 4. License fees B. Expected Expenses 1. Personal services Personal services amounting to $ 30000 are allocated based on a percentage basis as follows: 1. 20 % in January. 2. 30% in March. 3. 50 % in June. Operating expenses are allocated based on a percentage basis 40 % from License fees, is expected payment in January. 2. Operating expenses You are required to prepare ihe city council, cash forecast (first quarter, 2022) projections for the three month period as anote the minimum cash balance is $10000.
Expert Answer:
Answer rating: 100% (QA)
Ending cash balance 2100000 City Council Cash Projection First Quarter Jan Feb Mar Total Remarks Beg... View the full answer
Related Book For
Intermediate accounting
ISBN: 978-0077647094
7th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson
Posted Date:
Students also viewed these accounting questions
-
Which of the following can possibly be part of the informal information search process for organizational buyers? a. site visits to evaluate a potential vendor b. laboratory test of a new product or...
-
Describe when revenues and expenses are recognized using cash-basis accounting. How does this differ from accrual-basis accounting?
-
A city levies property taxes of $4 billion in June 2015 for its scal year beginning July 1, 2015. The taxes are due by January 31, 2016. The following (in millions) indicates actual and anticipated...
-
A non reactive/conservative contaminant is dumped on the ground level and it leaches to the groundwater vertically and takes half day for reaching the groundwater by travelling through unsaturated...
-
Maquoketa Services was formed on May 1, 2017. The following transactions took place during the first month. Transactions on May 1: 1. Jay Bradford invested $40,000 cash in the company, as its sole...
-
Jobs, Alford, and Norris formed the JAN Partnership to provide landscape design services in Edmonton, by making capital contributions of $150,000, $100,000, and $250,000, respectively, on January 7,...
-
Given the assumption that the energy levels of an harmonic oscillator can take on only the values \(n h v\) and given the Maxwell-Boltzmann distribution of occupation numbers, show that the...
-
Wolverine Incorporated had the following trial balance at the beginning of April. The following transactions occur in April: April 1 Issue common stock in exchange for $15,000 cash. April 2 Purchase...
-
Many employees worked from home, or still may be working from home, during-and-post-COVID-19 pandemic era. What effect is this likely to have on the future of telecommuting? What information...
-
Marcella began to drink in the evenings after work when her husband left her for another woman. As the months went by, the divorce became increasingly acrimonious. There were accusations, attempts to...
-
2. Lupo Corporation uses a job-order costing system with a single plantwide predetermined overhead rate based on machine-hours. The company based Its predetermined overhead rate for the current year...
-
List the activities that must be completed before beginning this phase.
-
Develop a questionnaire for mass employee distribution based on your findings from the previous interviews. Why are we completing the analysis with an anonymous survey?
-
Describe the steps/phases in each of the three case studies.
-
What accounts for the shift from strategic planning to strategic management? In which industries or companies is this essential? Why?
-
List the six factors of BPM maturity.
-
Write a Java program that keeps up with the scores in a baseball games, then reports them. Ask the user for the home team name and the visiting team name. Set up two arrays that will store the number...
-
How do individual companies respond to economic forces throughout the globe? One way to explore this is to see how well rates of return for stock of individual companies can be explained by stock...
-
Samuelson and Messenger (S&M) began 2013 with 200 units of its one product. These units were purchased near the end of 2012 for $25 each. During the month of January, 100 units were purchased on...
-
On January 1, 2013, Rapid Airlines issued $200 million of its 8% bonds for $184 million. The bonds were priced to yield 10%. Interest is payable semiannually on June 30 and December 31. Rapid...
-
On January 1, 2013, Labtech Circuits borrowed $100,000 from First Bank by issuing a three-year, 8% note, and payable on December 31, 2015. Labtech wanted to hedge the risk that general interest rates...
-
Use SecureRandom method ints to generate a stream of 50 random numbers in the range 1 to 999, then filter the resulting stream elements to select only the odd numbers and display the results in...
-
What percentage of the 9,449 survey respondents live in the Eastern part of the county?
-
(a) What percentage of those not completing high school were females? (b) What percentage of those not completing high school were males? (c) What percentage of those completing high school were...
Study smarter with the SolutionInn App