Distressed / Non-Performing / Orphaned Assets One Pager Model Assignment

We need a relatively robust model, yet "modest" in it's complexity, that can be used to price and present (more present than price) non-performing loans that we look to acquire. We have the template for how we want these opportunities presented and are actively pricing, buying and asset managing deals today. However, we need to have an overlay (i.e. this model to codify all the facts of the deal, modeling assumptions and sensitivity tables) to fully present all necessary details in one succinct output document.

More specifically it needs to be dynamic so we can measure deals both on a levered and unlevered.

We have a model we have used in the past but I believe it needs to be both updated, improved and simplified. Even though I specifically outlined NPL's above we would expect the model to be used for any and all types of "liquid" or illiquid forms of off-the-run or orphaned debt opportunities we would look to acquire.