06-04-2003, 11:00 PM
|
|
Executive Editor
Join Date: Aug 2006
Posts: 29,160
|
|
Mortgage SIM by Visual Byte Inc.
"Are you taking advantage of low interest rates? Using Mortgage SIM may help you save even more. Canadian and US style mortgage scenarios can be tested and analyzed with just a few clicks of your stylus. Real-estate agents, financial planners, real-estate lawyers, bankers, lenders or anyone shopping for a mortgage will benefit from the valuable information generated by this mortgage simulator. The program calculates payments for virtually any term, any rate and any principal mortgage amount.
Three common �Fast-Pay� methods are used to provide comparative payments for Weekly, Bi-Weekly and Semi-Monthly payment schedules. So in a glance you can easily compare and analyze the savings and term lengths of ten different payment approaches. If you need more information this program also generates detailed Amortization Schedules for any of the ten different payment options in each mortgage simulation. The flexibility of this tool also allows prospective buyers to calculate the size of mortgage that they could afford based on a predetermined monthly payment, rate and term. Modifying and reworking any scenario is as simple as adjusting a number and hitting the Calc key again. This program was designed specifically with the use of a stylus on the Pocket PC in mind, and provides a convenient input keypad for entering numbers right on screen."
You can download the free trial or purchase it for $19.99.
|
| |
|
|
|
06-05-2003, 03:12 AM
|
|
Intellectual
Join Date: Feb 2002
Posts: 209
|
|
This looks interesting but where do you enter your down payment, homeowners insurance, flood insurance, taxes, homeowners dues, possible mortgage insurance....all of the things that make up escrow and are used to calculate your true monthly expense. I may not see it. These things might be there, but if their not, this is good to calculate a number that you will never see, unless it is as part of your actual mortgage payment which contians all of the other variables.
Am I off base? I see that the currency selector is set to Canadian dollars. Are these things not part of a mortgage payment in Canada?
Don't get me wrong. I have been toyuing with these calculations in ecel for years. I really think this kind of thing could be very useful.
I think that this and other application related to real estate could create a really good niche in the PDA market for realtors. They just need to be marketed. 
__________________
And there you are.
I was just thinking, "What could take this headache I have over that edge to a full blown migrane?"
And there you are.
- Dr. Cox, Scrubs
|
| |
|
|
|
06-05-2003, 03:30 AM
|
|
Magi
Join Date: Sep 2005
Posts: 2,341
|
|
Hey jpaq
I think the idea here is to figure out what your options are for a mortgage so that you know what to plug in with the rest of the numbers you mentioned. It's a mortgage sim. Not a monthly bill sim.
Besides all that other stuff you mentioned is free here in Canada. 
Dave
|
| |
|
|
|
06-05-2003, 03:38 AM
|
|
5000+ Posts? I Should OWN This Site!
Join Date: Jul 2003
Posts: 5,133
|
|
Quote:
|
Originally Posted by jpaq
This looks interesting but where do you enter your down payment, homeowners insurance, flood insurance, taxes, homeowners dues, possible mortgage insurance....all of the things that make up escrow and are used to calculate your true monthly expense. I may not see it. These things might be there, but if their not, this is good to calculate a number that you will never see, unless it is as part of your actual mortgage payment which contians all of the other variables.
|
As far as I'm aware, the mortgage is the price of the house minus the down payment. So you wouldn't enter it. For a $200K house with a 20% down payment, you wouldn't create a $200K mortgage then put a payment of $40K, you'd just create a $160K mortgage. As for all of the others but taxes, those were all separate bills, and not part of the mortgage payments in my case (but I didn't have mortgage insurance, so I don't know about that one). But my homeowner's insurance is paid to Allstate, not my mortgage company. Which means it wouldn't make sense to include here.
|
| |
|
|
|
06-05-2003, 03:49 AM
|
|
Sage
Join Date: Mar 2004
Posts: 717
|
|
I really dig this program, I use it quite a lot - every time I want to buy a new toy I look at it to see how much interest the bank is stealing from me this month. I highly recommend it.
|
| |
|
|
|
06-05-2003, 03:53 AM
|
|
Thinker
Join Date: Jul 2003
Posts: 361
|
|
Quote:
|
Originally Posted by kati42
As far as I'm aware, the mortgage is the price of the house minus the down payment. So you wouldn't enter it. For a $200K house with a 20% down payment, you wouldn't create a $200K mortgage then put a payment of $40K, you'd just create a $160K mortgage. As for all of the others but taxes, those were all separate bills, and not part of the mortgage payments in my case (but I didn't have mortgage insurance, so I don't know about that one). But my homeowner's insurance is paid to Allstate, not my mortgage company. Which means it wouldn't make sense to include here.
|
Realtor alert! Realtor alert! :-)
Your mortgage usually consists of the price of the house less down payments and/or allowances. At closing it may also include: - - Bundled mortgage costs (recording fees, doc prep fees, etc)
- Doc stamps on notes, deeds
- Miscellaneous state taxes
- Title insurance
- Bank funding fees
- Prorated taxes, association fees, etc
Separate from your mortgage is usually your monthly escrow. This is designed to be a simple savings plan that pays for the following at certain intervals: - - Homeowners insurance
- Flood, hurricane, tornado insurance
- Property taxes
In a nutshell, tons of things can go into a mortgage. This program could definitely benefit from having fields to enter some of this stuff into. Too often buyers don't consider all these things when shopping. Of course, a lot of these things vary from state to state, so there's no way they could cover all the bases. The basics as mentioned by others - insurance, property taxes - should definitely be in there.
One other thing. Why the heck are they charging so much? This thing is basically a spruced up spreadsheet/calculator!
- Drew
|
| |
|
|
|
06-05-2003, 05:28 AM
|
|
Ponderer
Join Date: Jun 2002
Posts: 65
|
|
There is a company called Calculated Industries. They make mortgage calculators, construction calculators, ect. As far as I'm concerned they make the very best mortgage calc available (most functions, fewest keystrokes necessary to reach varible, ect.) I've been talking with them for a while about creating an emulator for PPC. Lygea offers one for the HP 12-C. I'm far from a developer so I have no idea what's envolved.
I am in the mortgage business. The reason why a realtor or mortgage broker would want functions for insurance, MI, taxes, etc. is because qualifying for a mortgage is partially based on ratios between your total housing expense (including the above mentioned figures) and your income (front end) and your entire debt to income ratio (back end). The bank will allow the total cost of your housing to be 38%, for example, of your gross monthly income. And your entire debt load, including the housing expense, to be 45%.
|
| |
|
|
|
06-05-2003, 06:05 AM
|
|
Thoughts Media Review Team
Join Date: Aug 2006
Posts: 749
|
|
I think people have to be careful here in the differences between what can be paid via a mortgage in Canada vs. the States.
In Canada, the mortgage is usually taken out for the price of the house minus the down payment, and then adding in amounts for 'closing fees', brokerage fees, legal fees, etc. in setting up the mortgage (although many financial institutions here up north will throw those in for free). Plus, you can also ask the mortgager (in some cases -- most notably banks) to take additional amounts to cover your local property taxes. You can also take out mortgage insurance, if you wish.
All the other 'escrow' costs I saw listed by our US friends, are billed separately from other agencies (house insurance, fire insurance, tornado, etc.)
__________________
/drt
|
| |
|
|
|
06-05-2003, 06:13 AM
|
|
5000+ Posts? I Should OWN This Site!
Join Date: Jul 2003
Posts: 5,133
|
|
Quote:
|
Originally Posted by Don Tolson
I think people have to be careful here in the differences between what can be paid via a mortgage in Canada vs. the States.
|
And I think there are different options in general. I paid closing costs up front. Property taxes were paid through the mortgage company (escrow), but other than that, it was just the principal and interest of the mortgage in the mortgage payments.
|
| |
|
|
|
06-05-2003, 06:21 AM
|
|
Ponderer
Join Date: Dec 2004
Posts: 54
|
|
When I bought my house last year I used Greg Fisher's MortgageCALC application. It is freeware for individual non-commercial use. It allows most of what I see in this app, plus a field for Fees/Other. I plugged an estimate on PMI, property taxes, insurance and other fees I pay through escrow. It also makes amortization tables. Sorry, but I don't recall where I got it. I just don't see paying $19.95 for this.
|
| |
|
|
|
|
|
Linear Mode
