Please help support my efforts to spread financial literacy. Any contribution is greatly appreciated. I'm sorry that it's not tax deductible. Thank you for your support!
- No events.
Category Archives: Introduction to Income Valuation and Syndication
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 like […]
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 […]
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 […]
I just uploaded a major update to my course “Introduction to Income Valuation and Syndication” (at http://bit.ly/itivas-1) 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.
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!
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 […]
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 financial […]
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 these parameters, […]
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 YouTube.com version of the video tutorial here.
I just added a new video tutorial “Calculating Capitalization Rate” to my information product “Introduction to Income Valuation and Syndication“. You can see the YouTube.com version here.