Tag Archives: spreadsheet

Buy or Refinance Now

The valuation of income properties is directly tied to the cost and structure of financing. Real estate is a “borrowed money” business. As interest rates rise, the capitalization rate required to service the debt for a purchase or refinance also rises, and thus the valuation falls. As the valuation falls, existing debt Loan to Value […]

Guru Interest Rates

I am often astonished at the real estate “Guru” who charge outrageous (unpublished) interest rates for their products. As if their astronomical pricing isn’t bad enough, they offer time payment plans that are nothing short of usurious, making high credit card interest rates seem reasonable in comparison. I recently sat through a yet another long-winded video […]

Capitalization Rate and Cash on Cash Return

I just added a new article on the correct way to calculate the Capitalization Rate (CAP) according to the cost and structure of financing. An income property is generally valued on its cash flow, either the current cash flow or the anticipated future cash flow after repositioning. The valuation of the cash flow is calculated […]

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 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.

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 […]

New Wealth Creation Information Product

I just released my latest wealth creation information product. It is called (drum roll, please): “How to Pyramid Your Equity to Create Wealth and Financial Freedom” It’s a thick, jam-packed (over 100 pages) special report PDF with forms and spreadsheets. It explains several ways of creating or leveraging equity so that you can, with very diligent […]

Product Update: Property Analysis Worksheet Short Form

I just updated my Property Analysis Worksheet Short Form product. I added more detail lines to the RepairEstimates worksheet. If you purchased this product within the last 12 months, then you will receive an email with your free download link for the update. If you want to learn more about analyzing properties for quick-turning (fix-and-sell […]