Question: Net float or float is the total amount of float in a bank account. It is calculated by subtracting the disbursement float money spent but

Net float or float is the total amount of float in a bank account. It is calculated by subtracting the disbursement float money spent but not yet taken out of the account from the collection float money deposited but not yet clear.
On a typical day, Park Place Clinic writes $1,000 in checks. It generally takes four days for those checks to clear. Each day the clinic typically receives $1,000 in checks that take three days to clear.
What is the clinic's average net float? Show your work using Excel. Submit the excel sheet below for full credit. Please show the formulas used in excel to put in the cells.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!