real estate
bayonne appraisal, foreclosures, house appraisal
Excel Real Estate Spreadsheets
Microsoft Excel Spreadsheets
MS Excel is required to open these spreadsheets on your computer by clicking on the links. To download for future use, right click on spreadsheet and choose 'save as' from the menu.
Note: Our residential mortgage calculators and Investment property analyzers are accessible at each online property listing. Financial information which is displayed in each online property listing can be easily copied into the provided calculator/analyzer on the same page- resulting in timely and accurate financial analysis.
Financial Tools and Amortization Calculators: CHOOSE A ORB
A: This gem produces ready to print results with accompanying color graphs on a white page.
Mortgage Calculator
Principal Loan Balance:
Annual Interest Rate (%):
Mortgage Length in Years:
Starting Month:
Starting Year:
Important Compatibility Issues
B: All of the calculators/analyzers below use Microsoft Web Components and will not work in Netscape Navigator, Mozilla or Firefox. In order for these internet 'spreadsheets' to work in your browser, Internet Explorer 5 plus one Microsoft Office post 2000 product must be installed on your computer. Common examples are MS Office 2000-2003, Office XP, Word, Excel, Powerpoint, and Frontpage.
The 4 Calculators
The 4 calculators listed below use more variables than the basic amortization table- namely rental income and multiple expenses- in order to obtain an amount that accurately represents the monthly cost of ownership. The last 2 calculators provide basic investment property analysis to determine whether or not the purchase of an investment property would result in a positive cash flow that, percentage wise, matches or exceeds the return of other investments currently available (not provided).
To use these finance tools, the buyer must use the data included in the listing he wishes to analyze. Examples are price, rental income (if any) and expenses such as taxes and insurance.
Fill in the variables indicated by gray shading and the spreadsheet will immediately calculate results. The variables are available in each listing we have online. Hit refresh to clear and reset spreadsheets/calculators. Interest rates are fixed and cannot be changed. Use the scroll bars to see the whole workspace. These spreadsheets/calculators are available for individual download here.
A breakdown of what each calculator does is included with each.
1) One Family and Condominium:
Download For Excel users only (click to open or right click to save).
To reset (clear) the form, click your Browser's REFRESH (reload) button.
The first calculator is for Condos and one family homes. In addition to computing the monthly mortgage payment , it improves upon the basic amortization table by adding the property taxes to both property types. For Condos you can enter the unique maintenance fee expense. There is also a provision for a homeowner's insurance expense for the one family home. Condominium insurance is included in the maintenance fee. There is no provision for rental income. The assumption is that the property is owner occupied.
2) Two, Three, and Four Family:
Download For Excel users only (click to open or right click to save).
To reset (clear) the form, click your Browser's REFRESH (reload) button.
The second is for 1 Family+2 Family+3 Family+4 Family Houses. In addition to calculating mortgage expense, total rental income and expenses such as taxes and insurance are factored in. There are two spaces for income. Use the first if you plan to live in the property. Use the second if the property is to be non owner occupied. Or run both scenarios simultaneously. Two interest rate possibilities are given- you can't change these.
3) Investment- Multi-Family, Commercial, Mixed Use- Yearly Version
Use this if your income and expense data is for the entire year.
Download For Excel users only (click to open or right click to save).
To reset (clear) the form, click your Browser's REFRESH (reload) button.
The third calculator is for Investment property such as Commercial Buildings, Multi-Family Houses, Apartment Buildings and Mixed-Use Properties (combo of commercial and residential units under 1 roof). It calculates mortgage payments and annual debt service, breaks down yearly income and expense totals into monthly income and expense totals, and reports the proverbial bottom line- cash flow. It also computes the debt service ratio used by some lenders to determine whether or not the mortgage you are requesting is risky because of too much debt compared to income. Bottom line: Use this tool if you have already totaled income and expenses for the property into yearly figures. If you need to enter monthly rent figures for multiple apartments and enter itemized expenses, use calculator #4.
This calc assumes the minimum 20% down payment. DP, length of mortgage and interest rates are not changeable because they are based on the exact terms and program that a local Bayonne bank (Pamrapo Savings) offers for Investment Property.
