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
36. Accounts receivable management. Given the information below, compute the days in
accounts receivable, aging schedule, and accounts receivable as a percentage of net
patient revenues for quarter 1 and quarter 2 of fiscal year 20X2, which runs from October
20X1 through September 20X2. Compare the two quarters to determine if the organiza-
tion's collection procedure is improving. (Hint: For simplicity, assume that each month is
thirty days. Dollar figures are expressed in thousands.)
Quarter 1, 20X1
Dec
Nov
Oct
Quarter
Days outstanding
1-30
31-60
61-90
1-90
Net accounts receivable
$1,000
$4,600
$14,000
$19,600
Net patient revenues
$4,000
$20,000
$36,000
$60,000
Quarter 2, 20X2
Mar
Feb
Jan
Quarter
Days outstanding
1-30
31-60
61-90
1-90
Net accounts receivable
$14,000
$4,600
$1,000
$19,600
Net patient revenues
$36,000
$20,000
$4,000
$60,000
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
This problem
arrow_forward
Answer
arrow_forward
Accounting for patient service revenue
Ruby Ruth Hospital had the following transactions during the year ended December 31:1. The hospital provided services to patients insured by third-party payer A amounting to $9.0 millionat its established billing rates. The hospital’s prospective billing arrangement with this third partystipulates payment to the hospital of 70 percent of its established rates for services performed.All billings were paid during the year.2. The hospital provided services to patients insured by third-party payer B amounting to $5.4 millionat its established billing rates. Its retrospective billing arrangement with this third party stipulatesthat the hospital should receive payment at an interim rate of 90 percent of its established rates,subject to retrospective adjustment based on agreed-upon allowable costs. By year-end, B had paidall the billings. Before issuing its financial statements, the hospital estimated that the probableamount it will need to refund to B…
arrow_forward
Home Infusion provides an average of 14 home health visits a day at an average net charge of $94 per visit. They provide services approximately 250 days per year. All services are paid by two third-party payers: One pays for 29 percent of the billing 19 days after the service is provided and the second pays for the remaining billings in 29 days. Average cost of debt (i.e. the interest rate on bank loans) is 3%.
What is the average accounts receivable balance?
(Round your final answer to 2 decimal places. Omit the "$" sign and commas in your response. For example, $123,456.789 should be entered as 123456.79.)
Give typing answer with explanation and conclusion
arrow_forward
Subject :- Accounting
arrow_forward
Sawchuk's Home and Garden Centre in Toronto files
monthly HST returns. The purchases on which it paid the
HST and the sales on which it collected the HST for the last
four months were as follows: (assume HST in Toronto is
13%) Month Purchases ($) Sales ($) May 176,730 313,245
Based on an HST rate of 13%, calculate the HST remittance
or refund due for each month Calculate the difference
between GST Collected on Sales and GST Paid on
Purchases?
arrow_forward
Problem #1. You have a Visa credit card account with a 26.49% annual percentage rate calculated on the average daily balance. The billing date is the first day of each month, and the billing cycle is the number of days in that month. Your credit card balance on April 1 was $552. On April 10th you made a $119 purchase. You made another purchase, a $25 gift card, on April 24th. You made a $150 payment on April 29th. Show your work for all parts of the problem.
(a) What is the average daily balance for April?
(b) What is your finance charge on the account as of May 1st?
(c) What is your new credit card balance?
arrow_forward
The pharmacy receives a monthly capitation fee of $535.00. Within a month, it fills 79 prescriptions totaling $389.75. How much profit does the capitation fee provide?
Group of answer choices
$108.52
$283.93
$57.55
$145.25
arrow_forward
Problem #1. You have a Visa credit card account with a
22.75% annual percentage rate calculated on the
average daily balance. The billing date is the first day of
each month, and the billing cycle is the number of days in
that month. Your credit card balance on June 1 was
$307. On June 9th you made a $139 purchase. You made
another purchase, a $150 gift card, on June 25th. You
made a $250 payment on July 27th. Show your work for
all parts of the problem.
(a) What is the average daily balance for June?
(b) What is your finance charge on the account as of July
1st?
(c) What is your new credit card balance?
arrow_forward
Can you please answer the financial accounting question?
arrow_forward
What will be the steady state receivables balance of this general accounting question?
arrow_forward
Assume that you start with a balance of $3900 on your credit card.During the first month you charge $400. During the second month you charge $650 and make a payment of $280. Assume that your credit card charges a 29% APR and each month you make the minimum payment of 2.5% of the balance. Complete the following table. Round your answer to the nearest cent.
Month 1
Previous balance- $3900 Finance charge- $94.25 Purchase- 400
Payment ?97.50 New balance?
Month 2
Previous balance- finance charge- purchase- payments- New balance
arrow_forward
G
Curtis Party Rentals offers party equipment such as tents, tables, chairs, and so on for outdoor events. The rental fees average $870
per event. Curtis receives a 15 percent deposit two months before the event, 60 percent the month before, and the remainder on the
day the equipment is delivered and set up. Planners at Curtis estimate the following number of events for the last half of the current
year:
July
August
September
October
November
December
260
280
330
240
200
230
Required:
a. What are the expected revenues for Curtis Party Rentals for each month, July through December? Revenues are recorded in the
month of the event.
b. What are the expected cash receipts for each month, July through October?
Complete this question by entering your answers in the tabs below.
arrow_forward
The average daily balance of a credit card for the month of February was $1600$1600 and the unpaid balance at the end of the month was $900$900. If the annual percentage rate is 37.2%37.2% of the average daily balance, what is the total balance on the next billing date, March 1?
Round your answer to the nearest cent.
arrow_forward
13. For the credit card account, assume one month between billing dates (with the appropriate
number of days) and interest of 1.4% per month on the average daily balance. Find (a) the
average daily balance, (b) the monthly finance charge, and (c) the account balance for the next
billing.
Previous Balance: $449.50
January 13 Billing Date
January 15 Returns
January 22 Clothes
January 27 Bus tickets
February 2 Payment
February 6 Flowers
$105.58
$122.54
$77.74
$120
$65.22
(a) The average daily balance is $
(Round to the nearest cent as needed.).
(b) The finance charge is $
(Round to the nearest cent as needed.)
(c) The account balance for the next billing is $
(Round to the nearest cent as needed.)
C
O
a
IS
ry
ry
av
to
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
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
A pharmacist orders medication for a total of $6439.65. A 6 1/4% discount is given if payment is made within 15 days, and 82.5% discount is given if payment is made within 30 days. How much money can be saved by paying in 15 days instead of 30 days?
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. (Round your answers to the nearest cent.)
Month
PreviousMonth'sBalance(in $)
FinanceCharge(in $)
Purchasesand CashAdvances
Paymentsand Credits
New BalanceEnd of Month(in $)
April
$641.17
$11.22
$31.45
$85.00
$598.84
May
$283.33
$135.00
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Related Questions
- 36. Accounts receivable management. Given the information below, compute the days in accounts receivable, aging schedule, and accounts receivable as a percentage of net patient revenues for quarter 1 and quarter 2 of fiscal year 20X2, which runs from October 20X1 through September 20X2. Compare the two quarters to determine if the organiza- tion's collection procedure is improving. (Hint: For simplicity, assume that each month is thirty days. Dollar figures are expressed in thousands.) Quarter 1, 20X1 Dec Nov Oct Quarter Days outstanding 1-30 31-60 61-90 1-90 Net accounts receivable $1,000 $4,600 $14,000 $19,600 Net patient revenues $4,000 $20,000 $36,000 $60,000 Quarter 2, 20X2 Mar Feb Jan Quarter Days outstanding 1-30 31-60 61-90 1-90 Net accounts receivable $14,000 $4,600 $1,000 $19,600 Net patient revenues $36,000 $20,000 $4,000 $60,000arrow_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_forwardThis problemarrow_forward
- Answerarrow_forwardAccounting for patient service revenue Ruby Ruth Hospital had the following transactions during the year ended December 31:1. The hospital provided services to patients insured by third-party payer A amounting to $9.0 millionat its established billing rates. The hospital’s prospective billing arrangement with this third partystipulates payment to the hospital of 70 percent of its established rates for services performed.All billings were paid during the year.2. The hospital provided services to patients insured by third-party payer B amounting to $5.4 millionat its established billing rates. Its retrospective billing arrangement with this third party stipulatesthat the hospital should receive payment at an interim rate of 90 percent of its established rates,subject to retrospective adjustment based on agreed-upon allowable costs. By year-end, B had paidall the billings. Before issuing its financial statements, the hospital estimated that the probableamount it will need to refund to B…arrow_forwardHome Infusion provides an average of 14 home health visits a day at an average net charge of $94 per visit. They provide services approximately 250 days per year. All services are paid by two third-party payers: One pays for 29 percent of the billing 19 days after the service is provided and the second pays for the remaining billings in 29 days. Average cost of debt (i.e. the interest rate on bank loans) is 3%. What is the average accounts receivable balance? (Round your final answer to 2 decimal places. Omit the "$" sign and commas in your response. For example, $123,456.789 should be entered as 123456.79.) Give typing answer with explanation and conclusionarrow_forward
- Subject :- Accountingarrow_forwardSawchuk's Home and Garden Centre in Toronto files monthly HST returns. The purchases on which it paid the HST and the sales on which it collected the HST for the last four months were as follows: (assume HST in Toronto is 13%) Month Purchases ($) Sales ($) May 176,730 313,245 Based on an HST rate of 13%, calculate the HST remittance or refund due for each month Calculate the difference between GST Collected on Sales and GST Paid on Purchases?arrow_forwardProblem #1. You have a Visa credit card account with a 26.49% annual percentage rate calculated on the average daily balance. The billing date is the first day of each month, and the billing cycle is the number of days in that month. Your credit card balance on April 1 was $552. On April 10th you made a $119 purchase. You made another purchase, a $25 gift card, on April 24th. You made a $150 payment on April 29th. Show your work for all parts of the problem. (a) What is the average daily balance for April? (b) What is your finance charge on the account as of May 1st? (c) What is your new credit card balance?arrow_forward
- The pharmacy receives a monthly capitation fee of $535.00. Within a month, it fills 79 prescriptions totaling $389.75. How much profit does the capitation fee provide? Group of answer choices $108.52 $283.93 $57.55 $145.25arrow_forwardProblem #1. You have a Visa credit card account with a 22.75% annual percentage rate calculated on the average daily balance. The billing date is the first day of each month, and the billing cycle is the number of days in that month. Your credit card balance on June 1 was $307. On June 9th you made a $139 purchase. You made another purchase, a $150 gift card, on June 25th. You made a $250 payment on July 27th. Show your work for all parts of the problem. (a) What is the average daily balance for June? (b) What is your finance charge on the account as of July 1st? (c) What is your new credit card balance?arrow_forwardCan you please answer the financial accounting question?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