I am stuck on an excel formula. Cash from Recievables Recievables Sales Discount Collections Discounted Paid in 19 Days Collections Outstanding paid in 36 Total Collected in Quarter End Q1 Q2 03 Q4 05 Projected 516000 313142.4 332265.6 344217.6 1310000 1390000 1440000 1530000 1405000 5240 5560 5760 6120 521904 553776 573696 609552 985713.6 811540.8 848592 892814.4 1507617.6 1365316.8 1422288 1502366.4 313142.4 332265.6 344217.6 365731.2 Q1 Q2 Q3 1390000 Q4 1440000 1310000 1530000 336000 357000 Payments for Supplies Based on Sales Sales Accounts Payable Purchases Supplier Payments Ending AP 0 324333.3333 695000 720000 765000 702500 370666.6667 708333.3333 324333.3333 336000 744000 731666.6667 357000 327833.3333 Net Cash Inflow Cash from Sales on Account Cash payments to supplies Wages and Salaries Q1 Q2 Q3 1507617.6 1365316.8 -370666.667-708333.333 Q4 1422288 1502366.4 -744000 -731666.667 -393000 -417000 -432000 -459000 I am stuck on an excel formula. Cash from Recievables Recievables Sales Discount Collections Discounted Paid in 19 Days Collections Outstanding paid in 36 Total Collected in Quarter End Q1 Q2 03 Q4 05 Projected 516000 313142.4 332265.6 344217.6 1310000 1390000 1440000 1530000 1405000 5240 5560 5760 6120 521904 553776 573696 609552 985713.6 811540.8 848592 892814.4 1507617.6 1365316.8 1422288 1502366.4 313142.4 332265.6 344217.6 365731.2 Q1 Q2 Q3 1390000 Q4 1440000 1310000 1530000 336000 357000 Payments for Supplies Based on Sales Sales Accounts Payable Purchases Supplier Payments Ending AP 0 324333.3333 695000 720000 765000 702500 370666.6667 708333.3333 324333.3333 336000 744000 731666.6667 357000 327833.3333 Net Cash Inflow Cash from Sales on Account Cash payments to supplies Wages and Salaries Q1 Q2 Q3 1507617.6 1365316.8 -370666.667-708333.333 Q4 1422288 1502366.4 -744000 -731666.667 -393000 -417000 -432000 -459000