Hospital payments: Accounts Receivable Aging Schedule
Not what you're looking for?
Hospitals often have many different customers, not all whom make their payments on a timely basis. Millbridge hospital segments its customers into four groups: Medicare, Medicaid, insurance, and self-pay. The self-pay customers owe Millbridge hospital $2 million. Insurers owe twice that amount. Medicare and Medicaid owe $5 million and $3 million respectively. Half of Medicare receivable is current, 20% was billed more than 30 days but less than 61 days ago, and the balance was billed more than 60 days ago but less than 91 days. Medicaid's obligation is 30% current, 30% more than 30 days but less than 61 days, 30% more than 60 but less than 91 days, and 10% more than 90 days. The insurance receivable is half current and half 31 to 60 days. The self-pay receivables are 25% current, 25% in the 31 to 60 day category, 25% in the 61-90 day and 25% over 90 days. Prepare an accounts receivable aging schedule by total dollars and by percent.
Purchase this Solution
Solution Summary
Your tutorial is in excel and puts the total columns in first and then computes the amount in each aging bucket using a percent. Click in the cells to see computations. Then the totals and percents can be figured. Strategy is seen by schedule creation.
Solution Preview
Your tutorial is in excel and puts the total columns in first ...
Education
- BSc, University of Virginia
- MSc, University of Virginia
- PhD, Georgia State University
Recent Feedback
- "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
- "Thank, this is more clear to me now."
- "Awesome job! "
- "ty"
- "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Writing Business Plans
This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.
Operations Management
This quiz tests a student's knowledge about Operations Management
Lean your Process
This quiz will help you understand the basic concepts of Lean.