Before completing this assignment, you can watch a you tube video about percentages. Follow the link below to watch the video.

https://www.youtube.com/watch?v=Uf-Rl1e2I4Q

(Links to an external site.)

One of the standard reports generated by most patient accounting software programs is the accounts receivable aging report. An aging report shows how long patient accounts have been outstanding or unpaid. The aging report is broken down into categories by length of time outstanding.

When analyzing a patient accounts receivable aging report, the total money owed that is 120 day or older should be small compared with the total accounts receivable. According to the text, if 20% of the practices unpaid revenues are 120 days or older, steps should be taken to improve collections.

Study the example below and answer the following questions.

What percent of the total dollar amounts on this page are current?

What percent of the total dollar amounts on this page are more than 30 days old?

What percent of the total dollar amounts on this page are more than 60 days old?

What percent of the total dollar amounts on this page are more than 90 days old?

What percent of the total dollar amounts on this page are more than 120 days old?

(Hint: add the totals for each of the columns together to get the total dollar amount)

Note round up to the nearest whole percentage.

According to the report, does the practice have more than 20% of unpaid revenue older than 120 days? If yes, what should be done about this problem

Aging Report
Broadmoor Medical Clinic accounts Receivable Aging Report
Name	Current	> 30 days	> 60 days	> 90 days	> 120 days
Abel, Paul		419.50
Allen, Tricia			860.25
Asner, Robert			90.00
Benson, Ted			155.50
Boles, Fred					334.19
Bumgardner, Leona				11.60
Callison, Tanner		120.00
Colby, Ruth		85.00
Cullen, Vincent			456.30
Dawson, Cynthia	190.00
Daymeri, Tao	211.90
Ditmer, Pauling				142.35
Dolby, Nelda				96.80
Dunison, Arthur					1211.42
Edwards, Lois	77.00
Effinger, Dorothy		62.50
Ekdale, Wesley		175.22		200.00
Eversmeire, Theo
Page Totals	478.90	862.22