Software & Templates

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 Auto Lease or Buy Analyzer.

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.

6 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 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 table into your report. So download the Six Functions of a Dollar template and never have to search for those pesky tables again.

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 seeries 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 comparabilty with the resultant adjusted values correlated (reconcilled) 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 trendline 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 value for the subject parcels from which the final estimate of value is selected.

Appraisal Package