Note Analysis File

[Brian Larson]

I have uploaded a file that you might find useful. This is similar to my BRRR Calculator but trimmed down due to notes being a little more straight forward (at least from a variable/output perspective).

I have certain things I want to know about a note before purchasing so this allows me to enter the details (bold items) and get a good picture of its value and return over a period of time. 

Here is a screen shot (note that there is also an amortization data tab that has the raw details):

Please note that I have my own stoplight thresholds that you can change to meet your needs. I also only calculated the first 10 years of average cashflow all up in order to get a picture of what it will look like. 

Last note, I come from the position that you do not calculate the principal as cashflow so that is not included in the calculations. 

Would love to know what others use or factors they like to have in and I can evolve this over time. I hope someone finds it useful. 

The file is here