5
docx
keyboard_arrow_up
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
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
Related Documents
Related Questions
Projected revenue for year 20X1 is as follows:
$823,155 in January, $685,546 in February, $454,050 in March, and $811,904 in April.
Historical net revenues categorized by payer:
Payer
Revenue Percent
Medicare 8,931,228
Medicaid 11,906,868
Blue Cross 10,159,306
Private
5,082,192
Total
?
Collection patterns by payer:
Payer Within 1 Month Within 2 Months Within 3 Months Within 4 Months Total
Medicare
18%
26%
28%
? 100%
Medicaid
6%
20%
49%
? 100%
Blue Cross
11%
43%
26%
? 100%
Private
59%
28%
6%
? 100%
How much revenue do we expect to collect in total in March? (Do not round intermediate
calculations. Round your final answer to 2 decimal places. Omit the "$" sign and commas
in your response. For example, $12.3456 should be entered as 12.35.)
arrow_forward
Projected revenue for year 20X1 is as follows:
$845,622 in January, $517,629 in February, $528,674 in March,
and $847,032 in April.
Historical net revenues categorized by payer:
Payer
Medicare
Medicaid
Blue
Cross
Private
Payer Revenue Percent
Medicare 8,331,224
Medicaid 12,723,238
Blue Cross 10,763,087
Collection patterns by payer:
Private
Total
Within 1
Month
21%
9%
5%
54%
5,527,687
Within 2
Months
33%
17%
40%
30%
?
Within 3
Months
35%
48%
36%
5%
Within
4 Months
Total
? 100%
? 100%
? 100%
? 100%
How much revenue do we expect to collect in total in March? (Do
arrow_forward
At Inner City Health Care, the total account receivable at the end of May is $100,00 and the monthly receipts total is 75.000, the total accounts receivable ath the end of june is 82.000 and the monthly receipts total is $31.000, the totat accounts receivable at the end of july is $86,000 and the monthly receipts total $20,000; the total accounts receivable at the end of August is $93,000 an the monthly receipts total is $45,000. What is the account receivable ratio for each month? Show your calculations in the space provided. Which month has the healthiest accounts receivable ratio? Why?
arrow_forward
Godo
A medical practice bills $10,000 worth of patient visits in the month of May, but only collects $5,000 of this amount before month ends. In addition, the practice collects $3,000 from prior months' bills to patients. During May, the practice had $9,000 in total expenses but only paid $7,500 of these expenses in cash during the month. Further, the practice paid out $1,000 of expenses from prior months. What are the revenues, expenses and net income of the practice for May if it uses the cash basis of accounting?
arrow_forward
A. What are the expected revenues for S2BU for each month, April through September? Revenues are recorded in the month of the occasion.
B. What are the expected cash receipts for each month, April through July?
arrow_forward
Valley Hospital measures the in-patient occupancy of the hospital by determining the number of patient days divided by the number of available bed days in the hospital for a time period. The following in-patient data are available for the months of April, May, and June: April May JuneAdmitted patients 1, 440 1, 860 2, 250 Average length of stay per patient 4.0 days 3.5 days 3.0 daysThe hospital has 200 rooms. One hundred rooms are private and have a single bed per room. The other 100 rooms are semi-private with two beds per room. a. Determine the number of in-patient days for each month.b. Determine the available bed days rate for each month.c. Determine the occupancy rate for each month.d. Interpret the results in (c).
arrow_forward
The Valley Hospital measures the in-patient occupancy of the hospital by determining the number of patient days divided by the number of available bed days in the hospital for a time period. The following in-patient data are available for the months of April, May, and June:
April
May
June
Admitted patients
1,440
1,860
2,250
Average length of stay per patient
4.0
days
3.5
days
3.0
days
The hospital has 200 rooms. One hundred rooms are private and have a single bed per room.The other hundred rooms are semi-private with two beds per room.
a. Determine the number of in-patient days for each month.
Number of in-patient Days
April
fill in the blank 1
May
fill in the blank 2
June
fill in the blank 3
b. Determine the available bed days for each month.
Available Bed Days
April
fill in the blank 4
May
fill in the blank 5
June
fill in the blank 6
c. Determine the occupancy…
arrow_forward
32. If Adel allows a 2 percent cash discount if collected in the month of sale, it isexpected that 60 percent will be collected in the month of sale and the balance in the
month following. How much will be collected from customers in December under the newpercentages?a. P17,500b. P18,500c. P16,290d. P20,000
arrow_forward
Please answer parts D, E, and F from the attached instructions
arrow_forward
I only need the Unpaid Expenses x Percent to Pay help. Thank you.
Schedule of Cash Payments for a Service Company
EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $15,000. The budgeted expenses for the next three months are as follows:
January
February
March
Salaries
$56,900
$ 68,100
$ 72,200
Utilities
2,400
2,600
2,500
Other operating expenses
32,300
41,500
44,700
Total
$91,600
$112,200
$119,400
Other operating expenses include $3,000 of monthly depreciation expense and $500 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December.
Prepare a schedule of cash payments for…
arrow_forward
What is the amount of the April collections?
arrow_forward
Directions:
1. At the beginning of the month, you have a balance due of $3,000 and plan to pay off $200 a month
while making additional purchases of $115 each month.
2. Use the interest of 18% and an annual fee of $49 to complete the repayment chart below.
Interest Rate: 18% (APR); 1.5% monthly
Annual Fee: $49
Month
Balance
Payments
Purchases
Interest and
Interest and
Fee (Month)
Fee (Total)
1
$3,000
$200
$115
$49
$45
$94
$3,009
$2,969.14
$200
$115
$45.14
$139.14
5
6.
7.
8.
9.
10
11
12
Month #2 (Model): $3,000 (Balance) - $200 (Payment) + $115 (Purchases) + $49 (Annual Fee) + $45
(Monthly Interest Payment) = $3,009
Month #3 (Model): $3,009 (Balance) - $200 (Payment) + $115 (Purchases) + $45.14 (Interest) = $2,969.14
Month #4
Month #5
Month #6
Month #7
Month #8
Month #9
Month #10
Month #11
Month #12
Summary: What can you do as a wise consumer to avoid this debt in the first place or to pay it off quickly if
you make mistakes and end up in a similar situation?
arrow_forward
Please provide correct answer general accounting question
arrow_forward
Kathy Hansen has a revolving credit account. The finance charge is calculated on the previous month's balance, and the annual percentage rate is 21%. Complete the account activity table for Kathy.
Month
PreviousMonth'sBalance
FinanceCharge(in $)
Purchasesand CashAdvances
Paymentsand Credits
New BalanceEnd of Month(in $)
March
$720.00
$
$129.97
$65.00
$
arrow_forward
The management of Sheffield Industries estimates that credit sales for August, September, October, and November will be $525,000, $705,000, $880,000, and $465,000, respectively. Experience has shown that collections are made as follows: In month of sale 25% In first month after sale 60% In second month after sale 10% Determine the collections from customers in October and November
arrow_forward
7. The Jacobs' expenditures for the past 7 months were: January,
$1,084.45; February, $886.40; March, $968.45; April, $1,142.60;
May, $995.80; June, $1,379.86; and July, $1,042.88. What is their
average monthly expenditure?
reserved.
arrow_forward
Find the new balance at the end of the billing
cycle using the average daily balance method.
Assume one month between billing dates and
find the finance charge using an 18% annual
rate.
Billing date: October 5 with a balance of
$550.77
October 5: Plane ticket
$405.98
October 12: Payment
$350.00
October 30: Halloween costume rental $
45.00
arrow_forward
Assume receivables of $20,000 at the start of the January are all collected during the month; if sales for January and
February are $400,000 and $300,000 respectively; the company typically receives payment from 20% of its customers
within the same month, 60% the following month, and the remaining 20% by the end of the second following month,
how much would accounts receivable be at the end of February?
arrow_forward
Please need help
arrow_forward
Desiccate purchases direct materials each month. Its payment history shows that 70% is paid in the month of purchase with the remaining balance paid the month after purchase. Prepare a cash payment schedule for March if in January through March, it purchased $31,413, $30,349, and $34,668, respectively. Round to the nearest penny, two decimal places.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Related Questions
- Projected revenue for year 20X1 is as follows: $823,155 in January, $685,546 in February, $454,050 in March, and $811,904 in April. Historical net revenues categorized by payer: Payer Revenue Percent Medicare 8,931,228 Medicaid 11,906,868 Blue Cross 10,159,306 Private 5,082,192 Total ? Collection patterns by payer: Payer Within 1 Month Within 2 Months Within 3 Months Within 4 Months Total Medicare 18% 26% 28% ? 100% Medicaid 6% 20% 49% ? 100% Blue Cross 11% 43% 26% ? 100% Private 59% 28% 6% ? 100% How much revenue do we expect to collect in total in March? (Do not round intermediate calculations. Round your final answer to 2 decimal places. Omit the "$" sign and commas in your response. For example, $12.3456 should be entered as 12.35.)arrow_forwardProjected revenue for year 20X1 is as follows: $845,622 in January, $517,629 in February, $528,674 in March, and $847,032 in April. Historical net revenues categorized by payer: Payer Medicare Medicaid Blue Cross Private Payer Revenue Percent Medicare 8,331,224 Medicaid 12,723,238 Blue Cross 10,763,087 Collection patterns by payer: Private Total Within 1 Month 21% 9% 5% 54% 5,527,687 Within 2 Months 33% 17% 40% 30% ? Within 3 Months 35% 48% 36% 5% Within 4 Months Total ? 100% ? 100% ? 100% ? 100% How much revenue do we expect to collect in total in March? (Doarrow_forwardAt Inner City Health Care, the total account receivable at the end of May is $100,00 and the monthly receipts total is 75.000, the total accounts receivable ath the end of june is 82.000 and the monthly receipts total is $31.000, the totat accounts receivable at the end of july is $86,000 and the monthly receipts total $20,000; the total accounts receivable at the end of August is $93,000 an the monthly receipts total is $45,000. What is the account receivable ratio for each month? Show your calculations in the space provided. Which month has the healthiest accounts receivable ratio? Why?arrow_forward
- Godo A medical practice bills $10,000 worth of patient visits in the month of May, but only collects $5,000 of this amount before month ends. In addition, the practice collects $3,000 from prior months' bills to patients. During May, the practice had $9,000 in total expenses but only paid $7,500 of these expenses in cash during the month. Further, the practice paid out $1,000 of expenses from prior months. What are the revenues, expenses and net income of the practice for May if it uses the cash basis of accounting?arrow_forwardA. What are the expected revenues for S2BU for each month, April through September? Revenues are recorded in the month of the occasion. B. What are the expected cash receipts for each month, April through July?arrow_forwardValley Hospital measures the in-patient occupancy of the hospital by determining the number of patient days divided by the number of available bed days in the hospital for a time period. The following in-patient data are available for the months of April, May, and June: April May JuneAdmitted patients 1, 440 1, 860 2, 250 Average length of stay per patient 4.0 days 3.5 days 3.0 daysThe hospital has 200 rooms. One hundred rooms are private and have a single bed per room. The other 100 rooms are semi-private with two beds per room. a. Determine the number of in-patient days for each month.b. Determine the available bed days rate for each month.c. Determine the occupancy rate for each month.d. Interpret the results in (c).arrow_forward
- The Valley Hospital measures the in-patient occupancy of the hospital by determining the number of patient days divided by the number of available bed days in the hospital for a time period. The following in-patient data are available for the months of April, May, and June: April May June Admitted patients 1,440 1,860 2,250 Average length of stay per patient 4.0 days 3.5 days 3.0 days The hospital has 200 rooms. One hundred rooms are private and have a single bed per room.The other hundred rooms are semi-private with two beds per room. a. Determine the number of in-patient days for each month. Number of in-patient Days April fill in the blank 1 May fill in the blank 2 June fill in the blank 3 b. Determine the available bed days for each month. Available Bed Days April fill in the blank 4 May fill in the blank 5 June fill in the blank 6 c. Determine the occupancy…arrow_forward32. If Adel allows a 2 percent cash discount if collected in the month of sale, it isexpected that 60 percent will be collected in the month of sale and the balance in the month following. How much will be collected from customers in December under the newpercentages?a. P17,500b. P18,500c. P16,290d. P20,000arrow_forwardPlease answer parts D, E, and F from the attached instructionsarrow_forward
- I only need the Unpaid Expenses x Percent to Pay help. Thank you. Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $15,000. The budgeted expenses for the next three months are as follows: January February March Salaries $56,900 $ 68,100 $ 72,200 Utilities 2,400 2,600 2,500 Other operating expenses 32,300 41,500 44,700 Total $91,600 $112,200 $119,400 Other operating expenses include $3,000 of monthly depreciation expense and $500 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for…arrow_forwardWhat is the amount of the April collections?arrow_forwardDirections: 1. At the beginning of the month, you have a balance due of $3,000 and plan to pay off $200 a month while making additional purchases of $115 each month. 2. Use the interest of 18% and an annual fee of $49 to complete the repayment chart below. Interest Rate: 18% (APR); 1.5% monthly Annual Fee: $49 Month Balance Payments Purchases Interest and Interest and Fee (Month) Fee (Total) 1 $3,000 $200 $115 $49 $45 $94 $3,009 $2,969.14 $200 $115 $45.14 $139.14 5 6. 7. 8. 9. 10 11 12 Month #2 (Model): $3,000 (Balance) - $200 (Payment) + $115 (Purchases) + $49 (Annual Fee) + $45 (Monthly Interest Payment) = $3,009 Month #3 (Model): $3,009 (Balance) - $200 (Payment) + $115 (Purchases) + $45.14 (Interest) = $2,969.14 Month #4 Month #5 Month #6 Month #7 Month #8 Month #9 Month #10 Month #11 Month #12 Summary: What can you do as a wise consumer to avoid this debt in the first place or to pay it off quickly if you make mistakes and end up in a similar situation?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College