1. A method for assessing a loan portfolio comprising a plurality of loans, said method comprising the steps of: identifying a milestone for at least one loan in the portfolio at a selected time of assessment; determining planned collections for the loan for the selected time of assessment; determining actual collections for the loan the selected time period of assessment; and populating a spreadsheet identifying a current milestone and a cumulative variance between planned collections and actual collections at the milestone for the loan.