Google it, and the 1st link from office.mircosoft.com should be the template you need.3. for the Excel spreadsheet, think of time progressing downwards; the further down in the rows you are, the further through the months4. to map each property, give each one 5 columns {Month #, Mortgage Balance, Principal, Interest, Additional Payment} * that is the month you're on in your repayment to the bank (1-360) * balance due to the bank * that month's principal payment (this is why it's handy to have the amortiation worksheet) * interest for that month * and what additional payments you'll kick in from the other properties.5. when adding a new property to the sheet, just list the following as headers so you can add them into your equations {purchase price, down payment, P&I, cashflow when mortgaged, cashflow when paid-off}.6. to make this all work, you take an iterative process * start by charting your 1st and only property, and plot it out so it takes 360 months to pay off * add in your 2nd property, and add its cashflow to the "additional payments" on you 1st (or have your 1st property's cashflow pushed into your 2nd .. whatever you like) * keep doing this up to your 15th (or in my spreadsheet's case, my 5th property)Some insights I've gained:* the snowball effect works!

I was wondering if I could use transactional lending to get the property then put renters in there and do a cash out refi.

When the IRS tax code was changed in 1986, limiting the losses to essentially $25,000 per year, there was a drastic effect on resort property.

Usually the most effective treatment that will kill them and their eggs is heat...then the question is what can you and can't you heat treat.

.* I do not know anything about how to evaluate real estate values (but I think I can learn), or the costs of renovation.All that said, I believe that I could be successful in scouring near and far for properties with equity that could be purchased or optioned at attractive prices IF I can partner up with investors with cash and with individuals who know how to renovate cost effectively.

A seperate bank account,used only for the deposits from your transaction is a good idea as it will show the accounting necessary for payments.

The list you want to target will have an big effect on the criteria.Sharon

You need to become more of a transactional engineer to facilitate the desired outcome Brian, it goes with experience and knowing how to apply your talents and knowledge to achieve the ultimate goal, just as in life.

http://homeguides.sfgate.com/effect-prime-rate-mortgage-interest-rates-8866.html

Was the transaction closed with a professional or privately?