If you have Excel, you already have all the financial functions you need already built in. Using Excel functions, you can create your own amortization table.
If you aren’t sure how to do it, send me an e-mail. I’ll attach an amortization table (Excel 97 format) to my reply.
Posted by Anthony Roche on July 30, 2001 at 18:22:56:
Hello,
Does anyone know of a good website or book that explains real estate math for writing up owner financing offers? I’m looking for simple formulas for calculating amortization, interest on loans, etc, that I can put into an Excel spreadsheet to calculate the whole offer before writing it. Any ideas?
Anthony,
The way I became somewhat proficent in “re math” is by buying a Texas Instruments BA II Plus $20 hand held calculator and reading the manual over and over and doing the practice examples until I pretty well understood most of it!! That is what I would recommend.