Answered step by step
Verified Expert Solution
Question
1 Approved Answer
HealthWorld is a retail store selling home oxygen equipment. HealthWorld also services home oxygen equipment, for which the company bills customers monthly. HealthWorld has budgeted
HealthWorld is a retail store selling home oxygen equipment. HealthWorld also services home oxygen equipment, for which the company bills customers monthly. HealthWorld has budgeted for increases in service revenue of $300 each month due to a recent advertising campaign. The forecast of sales and service revenue for March-June 2021 is as follows: (Click the icon to view the forecast of sales and service revenue.) (Click the icon to view the collection information.) Read the Requirement 1. Calculate the cash that HealthWorld expects to collect in May and in June 2021. Show calculations for each month. Start by showing the cash collections of sales revenue, then complete the schedule by entering in the service revenue collections and the total cash collections for each month. (Complete all input fields. If there were no collections of revenue for a certain month, select "0\%" in the "Collection \%" column and enter a "0" in the appropriate May or June column.) Data table Question 18 1. Calculate the cash that HealthWorld expects to collect in Ap Almost all of the sales revenues of the oxygen equipment are credit card sales; cash sales are negligible. The credit card company deposits 97% of the revenues recorded each day into HealthWorld's account overnight. For the servicing of home oxygen equipment, 70% of oxygen services billed each month is collected in the month of the service, and 30% is collected in the month following the service. Question 19 2. HealthWorld has budgeted expenditures for May of $13,000 and requires a minimum cash balance of $290 at the end of each month. It has a cash balance on May 1 of $650. a. Given your answer to requirement 1 , will HealthWorld need to borrow cash to cover its payments for May and maintain a minimum cash balance of $290 at the end of May? b. Assume (independently for each situation) that (1) May total revenues might be 10% lower Question 20 or that (2) total costs might be 5% higher. Under each of those two scenarios, show the total net cash for May and the amount HealthWorld would have to borrow to cover its cash payments for May and maintain a minim assume a balance of $650 on May 1.) Question 21 3. Why do HealthWorld's managers prepare a cash budget in addition to the revenue, expenses
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started