Online resource/spreadsheet for projecting future income?

Question

I am a long time investor of residential single and multi-family housing, primarily buy and holds.

I've played around with creating a spreadsheet to project income over varied periods of time as well as plot out when each property will be paid off.  While it's ok, it's lacking.  Is anyone familiar with a BP resource or have a spreadsheet you'd be willing to share?  Thanks in advance!

Tina Peters · Answer

@Charles Wiegert,  thank you. I will go check it out.!

Tina Peters · Answer

Thanks for the quick reply

@Daniel Karbownik. To answer the questions, minr just seems very basic. I guess I envision one more robust. For comparison, let's take all the 401k calculators out there. They show you in a more visual form where you're headed. I envision you punch in X for your passive income goal, then plug in your properties with the loan maturity date, Piti separated ( as you'll still have Iti once each loan is paid) and you'd see a dated graph of what your income would be at each data point.

Daniel Karbownik · Answer

Tina,

How exactly is yours lacking?  What do you think it's missing?  What else are you looking for out there that yours doesn't have?

My suggestion would be that since you've already spent some time and effort making some spread sheets, continue working on them to tailor them to how you want them.  I think that no matter how you answer my first few questions, and no matter what you can find out there, it will never be exactly how you want it and will always want to tweak something or change something, so you might as well make your own custom one anyways.