I am trying to figure out how to get the previous quarter collections for next years Q1. I know that for all of the others that the formula would be: previous quarter sales*((90-33)/90). The 33 is from 90-57. I think the uncollected percentage comes into play but I do not know how to put that into the formula.

A/R $675,000

Percent uncollectible 10%

Collection period 57

% of purchases for next Q sales 50%

Suppliers paid 53

% of sales for expenses25%

Interest and dividends $185,000

Outlay in third Q $390,000

Beginning cash balance $210,000

Target cash balance $135,000

Borrowing rate1.2%

Invested securities 0.5%

Beginning short-term borrowing $ 0

Last years sales

Q1$1,102,000

Q2 $1,141,000

Q3$1,125,000

Q4 $1,063,000

Current forecasted sales

Q1 $1,333,420.00

Q2 $1,380,610.00

Q3 $1,361,250.00

Q4 $1,286,230.00