Question

In: Accounting

The city of Charleston had the following sales of water for the selected months of 2017:...

The city of Charleston had the following sales of water for the selected months of 2017: Month Sales February $60,000 March 45,000 April 65,000 May 43,350 June 110,000 July 120,000 All sales are on credit. Historically, 60 percent is collected in the month of sale, 30 percent during the first month following the sale, and 10 percent in the second month following the sale. Water purchases by month are as follows: Month February $45,000 March 45,000 April 40,000 May 59,750 June 52,500 July 90,000 Water is purchased in the month of sale. All purchases are paid during the month following the purchase. Operating costs are $18,000 and everything is paid in cash except for depreciation, which totals $8,000 a month. The city plans on purchasing some new equipment in May for $25,000 in exchange for a note payable. The April 1 cash balance is expected to be $5,000. The city must maintain a minimum cash balance of $10,500, and money can be borrowed from a local bank in increments of $1,000. The city borrows money at the beginning on the first day of the month and repays loans and interest on the last day of the month. The bank charges the city an annual interest rate of 15%.

Prepare a cash budget for April, May, June and in for the quarter, and based on your answer complete the following table:

Round to the nearest dollar and DO NOT enter decimals, or commas and if a zero needs to be entered, enter "0".

April

May

June

Quarter

Beginning Cash Balance

$ 5,000

$ 10,500

$10,510

$ 5,000

Cash Collections

$

$

$

$

Water disbursements

$()

$()

$()

$()

Operating Costs

$()

$()

$()

$()

Borrowings

$

$

$

$

Repayments

$

$

$

$

Interest

$

$

$

$

Ending cash balance

$10,500

$10,510

$24,215

$ 24,215

Solutions

Expert Solution

Calculation of cash collection from sales and preparation of cash budget is as follows:-


Interest = $2000 * 15% *3/12 = $75


Related Solutions

Question 1 The city of Charleston had the following sales of water for the selected months...
Question 1 The city of Charleston had the following sales of water for the selected months of 2017: Month Sales February $60,000 March 45,000 April 60,000 May 42,500 June                     100,000 July 120,000 All sales are on credit. Historically, 60 percent is collected in the month of sale, 30 percent during the first month following the sale, and 10 percent in the second month following the sale. Water purchases by month are as follows: Month February $60,000 March 40,000 April...
Robison Manufacturing had the following operating results for 2017: sales = $40,000; cost of goods sold...
Robison Manufacturing had the following operating results for 2017: sales = $40,000; cost of goods sold = $25,000; depreciation expense = $3,200; interest expense = $500; dividends paid = $800. At the beginning of the year, net fixed assets were $22,000, current assets were $3,400, and current liabilities were $2,800. At the end of the year, net fixed assets were $28,000, current assets were $4,200, and current liabilities were $2,100. The tax rate for 2017 was 40 percent. What is...
a) Toole Company had the following transactions during 2017: Sales of $9,200 on account Collected $6,000...
a) Toole Company had the following transactions during 2017: Sales of $9,200 on account Collected $6,000 for services to be performed in 2018 Paid $1,580 cash in salaries Purchased airline tickets for $550 in December for a trip to take place in 2018 What is Toole’s 2017 net income using accrual accounting? b) Toole Company had the following transactions during 2017: Sales of $4,200 on account Collected $6,600 for services to be performed in 2018 Paid $1,630 cash in salaries...
Blossom Corp had sales of $350,000 in 2017. If management expects its sales to be $476,450...
Blossom Corp had sales of $350,000 in 2017. If management expects its sales to be $476,450 in 6 years, what is the rate at which the company’s sales are expected to grow? (If you solve this problem with algebra round intermediate calculations to 4 decimal places, in all cases round your final answer to 2 decimal places, e.g. 8.72%.) Growth rate
On January 1, 2017, the Mount Rogers City water department leases a truck under a noncancelable...
On January 1, 2017, the Mount Rogers City water department leases a truck under a noncancelable lease agreement meeting the requirements for classification as a capital lease. The present value (8% interest) of the minimum lease payment is $45000, and the lease calls for five annual lease payments of $10435 every January 1, beginning in 2017. The leased truck has a five year life and no salvage. 1. Prepare journal entries for the first year of the lease. 2. How...
Comprehensive Set of Transactions . The City of Lynnwood was recently incorporated and had the following transactions for the fiscal year ended December 31, 2017.
Comprehensive Set of Transactions . The City of Lynnwood was recently incorporated and had the following transactions for the fiscal year ended December 31, 2017.· The city council adopted a General Fund budget for the fiscal year. Revenues were estimated at $3,000,000 and appropriations were $2,990,000.· Property taxes in the amount of $2,000,000 were levied. It is estimated that $8,000 of the taxes levied will be uncollectible.· A General Fund transfer of $30,000 in cash and $300,000 in equipment (with...
Windsor, Inc. had net sales in 2017 of $1,410,600. At December 31, 2017, before adjusting entries,...
Windsor, Inc. had net sales in 2017 of $1,410,600. At December 31, 2017, before adjusting entries, the balances in selected accounts were Accounts Receivable $384,800 debit, and Allowance for Doubtful Accounts $1,814 debit. Assume that 11% of accounts receivable will prove to be uncollectible. Prepare the entry to record bad debt expense. (If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts. Credit account titles are automatically indented when the amount is...
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020...
Suppose a firm has had the following historic sales figures. Year: 2016 2017 2018 2019 2020 Sales $1,450,000 $1,710,000 $1,600,000 $2,000,000 $1,850,000 What would be the forecast for next year’s sales using regression to estimate a trend?
Table below shows monthly beer sales at Gordon’s Liquor Store in 2017. The sales manager had...
Table below shows monthly beer sales at Gordon’s Liquor Store in 2017. The sales manager had predicted that January 2017 beer sales would be 950. Month Sales Jan 2017 900 Feb 725 Mar 1000 Apr 800 May 750 Jun 1200 Jul 1000 Aug 1100 Sep 1250 Oct 1050 Nov 1400 Dec 1600 Jan 2018     ??   Forecast beer sales needed for January 2018 using the moving average with 3 periods. Forecast beer sales needed for January 2018 using an exponential smoothing...
On Dec. 31, 2017, the Eastville City water department leased equipment under a noncancelable lease agreement...
On Dec. 31, 2017, the Eastville City water department leased equipment under a noncancelable lease agreement that transferred title to the city after making seven payments of $ 15,250. The present value (6% interest) of the minimum lease payments is $90,250. Payments are to take place on December 31 beginning in 2017.   Required: Prepare journal entries for 2017 and 2018 assuming the estimated useful life of the equipment is 10 years. (B) Big City provides a defined benefit pension plan...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT