Category Archives: Introduction to Income Valuation and Syndication

The Equity Waterfall for a Syndicator

I just wrote an article about my preferred structure for structuring the equity financing with senior equity, preferred equity, and common equity. A syndicator that raises private equity may consider an equity waterfall that is similar to a combination of debt and equity. Treat the senior equity like a 1st lien and the preferred equity […]

Generate a PDF syndication package or a loan request package

I just made a major update to the very affordably priced  “Introduction to Income Valuation and Syndication” course. With the sophisticated macro-enabled Excel 2007 ProFormaStabilized.xlsm spreadsheet, you can now generate a multi-page PDF presentation package for syndicating to your private financiers or for submitting a loan request to a commercial lender. There are several tutorial videos […]

New Video: Master Lease and Option RUBS

I added a powerful spreadsheet for calculating and generating invoices for the Ratio Utility Billing System (RUBS). There are 2 video tutorials showing how to use the spreadsheet and how to generate the mail merge templates. The spreadsheet supports unlimited number of residents, you can bill pro-rated for electric, gas, water, sewer, or any combination […]

New Video: ProFormaStabilized Spreadsheet – Finance Package Tutorial1

I just uploaded a major update to my course “Introduction to Income Valuation and Syndication” (at that updates the ProFormaStabilized.xlsm spreadsheet and a new video tutorial for generating a PDF finance package. You can watch the YouTube version of the video by clicking here.

Update: Introduction to Income Valuation and Syndication

The course is updated with more improvements for the MasterLeaseAndOption.xlsm and for the ProFormaStabilized.xlsm spreadsheets. A new video tutorial is added for demonstrating how to perform “what if” calculations on actual operating data. Check out the course by clicking here. You can review the product update history by clicking here. Thank you for your support!

Update: Pro-Forma Stabilized Spreadsheet

A quick note that I just updated the ProFormaStabilized.xlsm spreadsheet to include an “actual data” input column and a “Seek Actual” button. The button calculates the required gross Return on Equity (ROE) and net cash flow required for the specified actual operating data. Now you can use the spreadsheet to calculate a required Capitalization rate […]

The Infamous Reverse Mortgage

I just added a free PDF special report about the infamous “Reverse Mortgage”. There are finance companies that are offering the “Reverse Mortgage” to seniors (at least age 62). Seniors with a substantial amount of equity in their residence are targets of this aggressive predatory loan. There are many “celebrities” who claim a reputation for […]

Should I Pay Off This Mortgage Loan?

I just heard a personal finance expert recommend paying off a mortgage that has 14 years remaining. Here are the parameters of the 30-year fixed rate loan: Debt Present Value:   229,880Remaining Term:           168  (16 years paid, 14 years left)Annual Interest Rate:     6.6% (fixed over 30 years)Monthly Debt Service:  -2,100  (principal + interest)Annual Debt Service:  -25,200 From […]

Product Update: Pro-Forma Stabilized Income Property Mail Merge Tutorial2

I just updated the ProFormaStabilized.xlsm spreadsheet, added a new mail merge template, and added another video tutorial for the mail merge templates to my Introduction to Income Valuation and Syndication product. You can view the version of the video tutorial here.

Product Update: Calculating Capitalization Rate

I just added a new video tutorial “Calculating Capitalization Rate” to my information product “Introduction to Income Valuation and Syndication“. You can see the version here.