Software Templates

All templates are designed for ease of use and require limited knowledge of the software used for their development.  We have attempted to make the use of our templates as straight forward as possible, so that your learning curve is limited.  If you don’t find a template listed below that satisfies your needs, we will try to develop one that will.

“Car Lease or Buy Analyzer”

The analyzer will help you decide whether to lease or buy your next vehicle or analyze the decision you made on your last lease or purchase. It will tell you whether it is more cost effective to buy or lease the same vehicle by analyzing both the purchase and lease on a cost per mile basis. This is the best car lease or buy analyzer available today. So follow the link for more information and to download your copy of the Car Lease or Buy Analyzer.

“Six Functions of $1”

This template calculates the factors applicable for the six function of one dollar used by mortgage bankers, real estate investors, real estate brokerage companies and real estate appraisers. These templates are virtually unavailable in spreadsheet form anywhere else. The templates allow the user to input the terms applicable to that function and obtain the factor to be used to calculate the dollar value for those terms. If like myself you have struggled with the printed tables and wished you could have the tables at your finger tips for any terms you desire, then you can now have them the way you want. The functions are in one spreadsheet and look very similar to what you will find in the Appraisal Institutes “The Appraisal of Real Estate”.  Also included are spreadsheet templates for each of the six functions in separate workbooks.  Each template includes drop down messages telling your what to do at each input cell. If you are working on a report you can link the answer to your report or copy the entire function or table into your report.  So download the Six Functions of $1 template and never have to search for those pesky tables again.

Car Payment Calculator

The Car Payment Calculator will provide you with a month by month amortization schedule based on your input of loan terms for your next car loan. The calculator provides a monthly breakdown of principal, interest and remaining balance. All you have to do is inject the terms of the loan; annual interest rate, term (length of loan in years) and the loan amount. It is a very simple template to use and it is invaluable as a check against improper loan calculations by your lender. So follow the link for more information and to download your copy of the Car Payment Calculator.

Mortgage Loan Calculator

The Mortgage Loan Calculator will provide you with a month by month amortization schedule based on your input of loan terms for your next car loan. The calculator provides a monthly breakdown of principal, interest and remaining balance. All you have to do is inject the terms of the loan; annual interest rate, term (length of loan in years) and the loan amount. It is a very simple template to use and it is invaluable as a check against improper loan calculations by your lender. So follow the link for more information and to download your copy of the Mortgage Loan Calculator.

Capitalization of Net Income  – Mortgage Equity Analysis

The Capitalization Templates available for download to your computer will allow you to select the mortgage terms and equity yield for the valuation of the net operating income you wish to value and print out a detailed report of the analysis. These templates are designed to allow you to change any terms you wish and instantly see the result. These templates produce the estimated value of the cash flows over any holding period and at whatever terms you wish. You have complete control of the input.  For Real Estate Professionals and Investors involved with Cash Flow Properties.

Capitalization of Net Income – Band of Investment

Capitalization of Net Income – Market Cap Rate

Capitalization of Net Income – Gross Income Multiplier

Discounted Cash Flow (DCF)

This is a series of templates that include an income and projection template based on contract and economic rent and actual and projected expenses for a ten year holding period. This series of templates produces three values for the property. These three values include an average value over the holding period, the estimated value of the equity (Ye) and the estimated value of the property (Yo).

Sales Comparison Approach

Cost Approach

Land Value Analyzer

Land Sales Comparison in the appraisal process is calculated using sales of comparable parcels of land in the same or similar market area. The sales are adjusted for differences in comparability with the resultant adjusted values correlated (reconciled) into a value estimate for the subject parcel. The Land Sales Comparison Analyzer includes a comparison Grid and Adjustment table in a spreadsheet template that calculates the value based on your input of the subject and comparable sales data. The sales data is also compared in chart form and includes a trend-line analysis of the sales and subject data. The sales are charted for Time of Sale, Frontage/Acre and Lot Size. The Land Sales Comparison Analyzer produces four values for the subject parcel from which the final estimate of value is selected.

Appraisal Package