5

.docx

School

Northern Arizona University *

*We aren’t endorsed by this school

Course

521

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

2

Uploaded by DoctorOtterPerson4041

Report
1. Your hospital has billed charges of $4,000,000 in February. If your collection experience indicates that 20 percent is paid in the month billed, 40 percent in the second month, 20 percent in the third month, and 5 percent in the fourth month, determine the following values: a. Net patient revenue for February (after deducting the eventual uncollectable) i. $4,000,000 b. Collections of February charges in February i. $4,000,000 x 20% = $800,000 c. Net accounts receivable at the end of March for February billings i. $4,000,000 x 40% = $1,600,000 2. You are reviewing your targets for short-term cash reserves next year. You wish to carry at least twenty days cash on hand. If annual budgeted cash expenses are $48,000,000, what amount of short-term cash reserves should be targeted? Short-term Reserve = (Cash Expenses x Days of Cash on Hand)/365 (Day in a year) = ($48,000,000 x 20)/365 = $2,630,136.99 3. Consider the following cash budgeting example for Mills Pharmaceutical Company. After referring to the information provided below, prepare a cash budget using the cash budget excel spreadsheet for the company for the period July to December 2010. All dollar amounts are in thousands. Gross sales by month May 2010 $5,000 June 5,000 July 10,000 August 15,000 September 20,000 October 10,000 November 10,000 December 5,000 January 2011 10,000 All sales transactions are on credit, with historical data showing that 30% of current revenues are collected in the current month, 50% in the next month and 20% in the second month after sale. Assume that bad debt is negligible.
Except for supplies, assume that operating expenses are paid during the month they are incurred. Operating expenses (monthly unless indicated otherwise) for the period are as follows: Wages and salaries: $ 750 Rent: 400 Insurance: 300 Depreciation: 300 Other expenses:(insurance): 100 Taxes (paid in Sep. and Dec.): 500 Payment for capital equipment in Oct.: 1,000 Supplies purchased in a month must equal 70% of the projected gross sales for the following month. Supplies are paid for in the month after purchase. The corporation must maintain an ending cash balance of $3,500 each month and meet a cash shortfall through a short-term loan. (Ignore interest for purposes of this example.) For simplicity in this example, assume that excess cash remains as cash (i.e., is not reinvested). Assume that at the beginning of July, the company had a cash balance of $3,500 with no short-term loan outstanding.
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