Excel Project

Help Wanted Using Excel for Aging Accounts Receivable.
The Lake Lucerne Company uses the allowance method of estimating bad debt expenses. An aging schedule is prepared in order to calculate the balance in the allowance account. The percentage uncollectible is calculated as follows.