I need help with questions $4$ and $5.$ Please show calculation in excel. I need more than just the answers. I need to know how you arrived at the answers.

$4-$ Average Collection Periods $($ACP$)$ for each quarter$\backslash$table$[[9/1/14,$UNDERSTANDING HEALTHCARE FINANCLAL MANAGEMENT,,$],[,$Chapter $15-$ Revenue Cycle and Current Accounts Management,,$],[,$Mini$-$Case,,$],[,]]$

new prosthetic$/$orthotic supply division of the company. The division would sell primarily to rehab

patients, some of whom pay for the devices themselves and some of whom have the bill paid by a third

party insurer. Sales would be slow during the first few months, rise during the middle of the year,

and then level off by the end of the year. Sales estimates for the first year of operation are shown in

the table below $($in thousands of dollars$).$ Rich estimates that $30$ percent of the division's customers

will pay in the month of sale, $50$ percent will pay in the month following sale, and the remaining $20$

percent will pay in the second month following the sale. Calculate the division's expected:

Accounts receivables $($A$/$R$)$ at the end of each month

Total sales for each quarter of operation

Average daily sales $($ADS$)$ for each quarter of operation

Average collection period $($ACP$)$ for each quarter of operation

Aging schedules for the end of each quarter

ANSWER

End of March

A$/$R

S$0$

Quarterly Report

Sales

ADS

$)$

$$0$

$$0\mathrm{.}00$

$$0\mathrm{.}00$

$$0$

$$0\mathrm{.}00$

$$0$

$$0\mathrm{.}00$

$0\mathrm{.}0$

End of June

End of December of operation

$5-$ Aging Schedules for the end of each quarter.