Colli Real Estate

All about real estate and beyond

Colli Real Estate header image 2

amortization mortgage schedule calculator

October 30th, 2009 by admin




I’m trying to understand BALLOON MORTGAGES. Can someone help me understand the following example?

I entered the following into an online mortgage balloon calculator:

Loan amount $100,000.00
Interest rate 6.000%
Term 10 years
Amortization period 30 years

My question is:

After 119 monthly payments of $599.55 why does the balloon payment come out to $84,285.33 ? If everything is due on a 30 year amortization schedule, shouldn’t the amount owed be the remaining 241 payments multiplied by $599.55 ($144,491.55) ? If not, then where does the $84,285.33 come from?

I am not an attorney. I am not in the mortgage business. I am not an accountant. I am not a real estate broker.

The term “Balloon means it goes in the air or goes away.
B1] Picture a hot air balloon on the ground. This is the entire mortgage, with all the interest, as it is – right now today, this minute.
B2] The balloon is filled with air and the propane is lit. The monthly payments are being made, BUT the balloon is STILL on the ground. This is because gravity [the interest] is keeping the loan from being paid in full.
B3] The balloon starts inflating. The monthly payments are being paid.
B4] As the balloon goes along the ground, it very rarely takes off in a vertical direction. [The interest STILL has control.]
B5] It takes a bit to clear the bushes and trees. Eventually it gets above the wires and taller buildings. [The mortgage is being reduced.]
B5] The wind catches the balloon and takes it in whatever direction its blowing, but the balloon is moving.
B6] The propane in the tank eventually is used. BUT the balloonist wants to continue climbing and doing whatever it is balloonists like to do. [The due date for the balloon payment is fast approaching.]
B7] The balloon gets a huge hole in it. [The balloon payment is due.]

The information I am giving is in reference to simple interest, fixed rate, positive amortization mortgages [THAT‘S a mouthful, isn‘t it?]. Lenders KNOW the following facts about mortgages:
1] Long before the actual last payment date, which is stated in the mortgage, the great majority of mortgages will be paid-in-full .
2] The concept with most mortgages: the interest is due on the remaining balance.
3] Contrary to what the great majority of people think or believe, the interest and principal payments are not evenly spread throughout the life of the mortgage. The great majority of the interest is paid in the beginning of the loan. The break-even point – when interest and principal equal each other – does not usually occur until sometime after the mortgage is more than half paid. Many times not until the mortgage is at least 2/3 paid down.

In the case of a balloon mortgage, the payments are made as though it was a 30 year loan, with equal monthly payments over 30 years. In your case: monthly payment is $599.95 for 119 months or payments. Yet, for the explanation I gave, you STILL has the great majority of the principal due on the loan.

Borrowers should request the following:
1] an open-end mortgage.
2] fixed rate, with positive amortization [meaning the mortgage is being reduced.]
3] no pre-payment penalty.
4] an amortization schedule to follow along with how much the mortgage is being reduced.

To save LOTS AND LOTS of money, all the person paying the mortgage has to do is to enclose the additional principal payment for the NEXT month, together with the current month’s payment.

Accompanying the current month with the additional month’s principal, should be a note with the account number and a short message stating: ”Enclosed please find this month’s payment of principal and interest in the amount of [this should always be the same] $—–.
In addition there is the additional amount of $— representing the principal for —– [month and year], which I would like to be applied to the balance of the mortgage. According to the amortization schedule I have, this will reduce the mortgage balance to $—-

Thank you for asking your question. I enjoyed taking the time to answer your question. You did a great job – not only for your information, but for every other person interested in reading my answer.

I wish you well!

VTY,
Ron Berue
Yes, that is my real last name

yt.avi

eBay Logo  

MORTGAGE LOAN CALCULATOR WITH AMORTIZATION SCHEDULE FOR LAPTOP OR PC


MORTGAGE LOAN CALCULATOR WITH AMORTIZATION SCHEDULE FOR LAPTOP OR PC


$3.99


Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide.Book & CD-ROM


Modeling Structured Finance Cash Flows with Microsoft Excel: A Step-by-Step Guide.Book & CD-ROM


$43.07


A practical guide to building fully operational financial cash flow models for structured finance transactionsStructured finance and securitization deals are becoming more commonplace on Wall Street. Up until now, however, market participants have had to create their own models to analyze these deals, and new entrants have had to learn as they go. Modeling Structured Finance Cash Flows with Micros…

Monthly Interest Amortization Tables


Monthly Interest Amortization Tables


$5.19


Loan amounts of $50 to $300,000. Interest rates of 2% to 25.75%. Terms up to 40 years….

Amortization: Learn How To Calculate Your Loan And Interest Payments Using A Loan Calculator With This Guide To An Amortization Schedule, Mortgage Amortization, And Loan Amortization


Amortization: Learn How To Calculate Your Loan And Interest Payments Using A Loan Calculator With This Guide To An Amortization Schedule, Mortgage Amortization, And Loan Amortization



Are you planning on buying a home or taking out a loan? Would you like to know how to calculate how much of each monthly payment goes towards principle and interest? Do you want to learn the components of an amortization schedule and how to understand amortization? Then this comprehensive guide is for you! Amortization will begin by giving you a basic understanding of what amortization is and how …


Texas Instruments BA Real Estate Financial Calculator


Texas Instruments BA Real Estate Financial Calculator


$45.00


BAIIPlus Financial Calculator…

Texas Instruments BA-35 Business Calculator


Texas Instruments BA-35 Business Calculator


$225.00


Texas Instruments BA-35 Business Calculator solves time-value-of-money calculations such as annuities, loans, mortgages, leases, savings, and more. Also generates amortization schedules.One-variable statistics includes results for mean, sample standard deviation, and population standard deviation.Converts between annual percentage rate (APR) and effective rate (EFF) interest, Math functions includ…

HP 12C 12c Financial Calculator, Numeric, Amortization, 10 Digit, Soft Case. Each


HP 12C 12c Financial Calculator, Numeric, Amortization, 10 Digit, Soft Case. Each


$73.54


Manufacturer: HP. Each. 12c Financial Calculator Display Characters x Lines 10 x 1 Display Notation Numeric Formula Notation RPN/Algebraic Storage Memory 20 Registers Programming Steps 400 Programming Subroutines Time-Value-of-Money Amortization Cash Flow

Amortization; ...


Amortization; …


$12.88


This is a pre-1923 historical reproduction that was curated for quality…

Casio FX-9860GII Graphing Calculator


Casio FX-9860GII Graphing Calculator


$84.99


8 Line x 21 Character – LCD Graphing: 20 x Y= Equations to Graph Parametric Polar Sequence Constant(X=) Inequality (auto shading) Zoom Trace Dynamic Transformation Conics Mathematics: Table of Function Values Fixed Decimal Options Scientific Notation(10 + 2) Fraction Operations Interactive Equation Solver Simultaneous Equation Solver(Up to 6) Polynomial Root Finder(Up to 3) Complex Numbers Matrices(Up to 55 x 55) Vectors Recall and Edit Last Entry Spreadsheet Capabilities Computer Math: Calculates in Dec Calculates inHex Calculates inOct Calculates inBinary Logic Operations Discrete Math: Recursive Sequences Geometry: Geometric Constructions and Transformations (add-in) Trigonometry: Sin Cos Tan Inverses Hyperbolic Degrees-Radians-Grads Conversions Stats and Data Analysis: One and Two-Variable Statistics Median Quartiles Intermediate Statistics Combinations Permutations Random Numbers Regression Models 10 x Estimated Values for Regression Graph Degrees of Polynomial Regressions(2,3,4) Histograms Scatter Plots Box and Whisker Plots 26 x Number of Lists 999 x List Length Inferential Statistics Probability Distributions One and Two Sample Z and T tests Chi-Squared Anova F Tests Z and T Interval Tests 7 x Distributions (p.d. and c.d.) Calculus: Numeric Differentiation Integration Maximum Minimum Programming: Interactive Equation Solver Science: Degree-Minute-Second<>Decimal Degree Polar<>Rectagular Formula Solver Periodic Table(add-in) Programs Available for EA-200 Data Analyzer Finance: N % I PMT PV FV Amortization Amortization Schedule Interactive TVM Solver Interest Conversion Annuity Due & Begin Setting Day/Date Calculation Recall of Financial Values Cost Sell Margin IRR NPV PBP NFV Cash Flow Battery Casio Casio Computer Co., Ltd FX-9860GII FX-9860GII Graphing Calculator Graphing Calculator Not Applicable www.casio.com

Casio FX-9750GII Graphing Calculator


Casio FX-9750GII Graphing Calculator


$59.99


0.94″ Height x 3.56″ Width x 7.19″ Length 12 – 26 KB Flash 7.60 oz 8 Line x 21 Character – LCD Graphing: 20 x Function(Y= equations to graph) Parametric Polar Sequence Constant (X=) Inequality (auto shading) Zoom Trace Dynamic/Transformation Conics Mathematics: Table of function values Fixed decimal options Scientific notation Fraction operations Interactive equation solver 6 x Simultaneous equation solver 3 x Polynomial root finder Complex number 55 x 55 Matrices Recall and edit last entry Symbolic manipulation Computer Math: Calculates in Dec, Hex, Oct, Binary Logic operations Recursive sequences Trigonometry: Sin, Cos, Tan, and Inverses Hyperbolic Degrees-Radians-Grads conversion Stats & Data Analysis: One and two-variable statistics Median Quartiles Intermediate statistics Combination Permutation Random numbers 10 x Regression models Estimated values for regression graph Degrees of polynomial regressions(2,3,4) Histogram Scatter plot Box and whisker plots 36 x Number of lists 255 x List length Inferential statistics & probability distributions One and two sample Z and T tests Chi-Squared Anova F tests Z and T interval tests 7 x Distributions (p.d. and c.d.) Calculus: Numeric differentiation Numeric Integration Maximum Minimum Programming: Interactive equation solver Science: Degree-minute-second<>Decimal degree Polar<>Rectagular Metric conversion Formula solver Programs for EA-200 data analyzer Finance: N % I PMT PV FV Amortization Amortization schedule Interactive TVM solver Interest conversion Annuity due & begin setting Day/Date calculation Recall of financial values Cost/Sell/Margin IRR NPV PBP NFV Cash flow Battery Casio Casio Computer Co., Ltd FX-9750GII FX-9750GII Graphing Calculator FX9750GII-WE Graphing Calculator Not Applicable White www.casio.com

Victor 1560-6 Printing Calculator


Victor 1560-6 Printing Calculator


$148.99


12 Character – Fluorescent 12 Digit – Dual Color Ribbon 1560-6 1560-6 Printing Calculator 3 Year 5.2lps 6 lb 8.50″ x 12.25″ x 2.75″ Cost-sell-margin keys Units Price Mode Mark Up/Down Delta Percent Item Count Averaging Time Calculations Square Root Function Installment Loan Calculations Days Between Dates Calculations Future/Present Value Calculations Independent Tax Keys Four-key Memory Backspace Key Automatic Tax Keys Gramd Total Percent Key Time/Calander Printing calculator offers an extra large fluorescent display with 12 digits and built-in metal paper arm. Print 5.2 lines per second in two colors. For amortization issues, print or display an entire schedule, specific month or any range of months. Add, subtract, multiply or divide hours and minutes or minutes and seconds for time billing or payroll applications. Cost-sell-margin keys allow you to quickly and easily solve CSM problems. Enter two variables, and the third appears and prints. Days-between-dates function computes the number of days between dates or you can compute the proper date by entering the number of days. Use financial features to enter amount, term and interest rate to solve for payment. Other functions include two independent tax keys, four-key memory, backspace key, automatic tax keys, units price mode, grand total, percent key, markup/down key, delta percent key, averaging and square root and time/calendar. Calculator runs on AC power. AC Supply Big Display Clock Date Gray Printing Calculator Victor Victor Technology www.victortech.com


Tags:   · · · · No Comments

Leave a Comment

 

0 responses so far ↓

There are no comments yet...Kick things off by filling out the form below.