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
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
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
Davis and Davis have expected sales of $490, $465, $450, and $570 for the months of
January through April, respectively. The accounts receivable period is 28 days. What is
the accounts receivable balance at the end of March? Assume a year has 360 days. a.
$450 b. $420 c. $440 d. $426
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
Need General Accosting Method Solution
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
Complete all requirements
<><>
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
Answer the question using the picture Required (i) Sales budget.
arrow_forward
The following details have been extracted from the payables' records of X Co:
Invoices paid in the month of purchase 25%
Invoices paid in the first month after purchase 70%
Invoices paid in the second month after purchase 5%
Purchases for July to September are budgeted as follows:
July $250,000
August $300,000
September $280,000
For suppliers paid in the month of purchase, a settlement discount of 5% is received. What is the
amount budgeted to be paid to suppliers in September?
arrow_forward
The management of Marigold Industries estimates that credit sales for August, September, October, and November will be $550,000, $735,000, $885,000, and $480,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
June sales were $6,000 while projected sales for July and August were $6,900 and $2,000, respectively. Sales are 45% cash and 55% credit. All credit sales are collected in the month following the
sale. What are the total expected collections for July?
OA. $7,305
OB. $6,405
OC. $6,495
OD. $4,205
arrow_forward
During October, Keliihoomalu Clinic budgeted for 2,700 patient-visits, but its actual level of activity was 2,200 patient-visits. Revenue should be $27.30 per patient-visit. Personnel expenses should be $21,100 per month plus $6.80
per patient-visit. Medical supplies should be $500 per month plus $4.90 per patient-visit. Occupancy expenses should be $5,700 per month plus $0.90 per patient-visit. Administrative expenses should be $3,700 per month plus $0.40
per patient-visit.
Required:
Prepare the clinic's flexible budget for October based on the actual level of activity for the month. What is net operating income per the flex budget?
arrow_forward
Hillary's Health Food Store has estimated monthly current asset financing requirements for the next six months as follows:
January
February
March
April
May
June
Current
Assets
Temporary
Permanent
$6,000
$4,000
$1,000
$4,000
$2,000
$4,000
$6,500
$4,000
$5,000
$4,000
$2,000
$4,000
Projected annual borrowing rates for the next six months are:
January
February
6.0%
April
12.0%
May
9.0%
June
7.0%
March
9.0%
Short-
Term
Long-
Term
5.0%
9.6%
9.6%
9.6%
9.6%
9.6%
9.6%
Required:
a. Assuming the company follows the hedging strategy, calculate the TOTAL dollar interest payments for the six months.
b. If the company implemented a risky strategy would you expect total dollar interest payments to be higher or lower, briefly explain your
answer (calculation not required).
arrow_forward
Wiggles Right forecasted sales of $5,000 in October, $4,000 in November, and $4,000 in December. All sales are on credit. 40% is collected the month of sale, and the remainder the following month. How much is collected from accounts receivable in November?
Group of answer choices
$6,000
$4,600
$5,400
$4,800
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 $39,000, $37,000, and $42,000, respectively.
Cash paid in
March
Month of purchase
Month after purchase
Total
arrow_forward
Current Attempt in Progress
The management of Riverbed Industries estimates that credit sales for August, September, October, and November will be $575,000,
$700,000, $875,000, and $490,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. (Do not leave any field blank. Enter O for the amounts.)
October
November
Collections from Customers
August Sales
September Sales
October Sales
November Sales
2$
$.
Total budgeted collections
eTextbook and Media
Attempts: 0 of 3 used
Submit Answer.
Savetor La
hp
%24
%24
arrow_forward
Need Help
arrow_forward
am.111.
arrow_forward
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
arrow_forward
Marcel Company projects the following sales for the first three months of the year: $13,500 in January; $12,200 in February, and $10,500 in March. The company expects 60% of the sales to be cash
and the remainder on account Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January 1. Round
to the nearest dollar.
Read the requirements.
Requirements
1. Prepare a schedule of cash receipts for Marcel for January, February, and
March. What is the balance in Accounts Receivable on March 31?
2. Prepare a revised schedule of cash receipts if receipts from sales on account
are 60% in the month of the sale, 30% in the month following the sale, and
10% in the second month following the sale. What is the balance in Accounts
Receivable on March 31?
Ouruary CASH SHIVJ
Print
March-Cash sales
February-Credit sales, collection of February sales in February
February-Credit sales, collection of February sales…
arrow_forward
Nickel City Arcade is forecasting its sales for its peak summer season. One important part of the total sales amount is the daily admissions fees. Nickel City has a maximum capacity of 600 people per day. Each person pays an admission fee of $5. Here are the expected usage rates during the months of June, July, and August. June 30 days 50% July 31 days 70% August 31 days 40% What is the total forecasted amount of admissions fees for the months June through August? $161,100 $158,900 $132,700 $147,300
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Related Questions
- 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_forwardDavis and Davis have expected sales of $490, $465, $450, and $570 for the months of January through April, respectively. The accounts receivable period is 28 days. What is the accounts receivable balance at the end of March? Assume a year has 360 days. a. $450 b. $420 c. $440 d. $426arrow_forwardI 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
- Need General Accosting Method Solutionarrow_forwardThe 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 Novemberarrow_forward7. 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
- Complete all requirements <><>arrow_forwardAssume 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_forwardAnswer the question using the picture Required (i) Sales budget.arrow_forward
- The following details have been extracted from the payables' records of X Co: Invoices paid in the month of purchase 25% Invoices paid in the first month after purchase 70% Invoices paid in the second month after purchase 5% Purchases for July to September are budgeted as follows: July $250,000 August $300,000 September $280,000 For suppliers paid in the month of purchase, a settlement discount of 5% is received. What is the amount budgeted to be paid to suppliers in September?arrow_forwardThe management of Marigold Industries estimates that credit sales for August, September, October, and November will be $550,000, $735,000, $885,000, and $480,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 Novemberarrow_forwardJune sales were $6,000 while projected sales for July and August were $6,900 and $2,000, respectively. Sales are 45% cash and 55% credit. All credit sales are collected in the month following the sale. What are the total expected collections for July? OA. $7,305 OB. $6,405 OC. $6,495 OD. $4,205arrow_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