Projecting revenue cash receipts

[Derek Cavanagh]

Please see the spreadsheet attached for my inputs and desired outcome. The purpose of this analysis is to determine the cash inflows associated with these assumptions. Cash receipts will be lumpy and not straight line through out the year. We can assume the assumptions start in Jan.


I'm first time modeller and I've found this forum very helpful. Thanks you contributors.