# Mortgage Payment Calculator Amortize by cay75596

VIEWS: 78 PAGES: 21

Mortgage Payment Calculator Amortize document sample

• pg 1
```									Main Menu
Mortgage Calculator
Calculate what?

Principal outstanding

Monthly payment

Annual interest rate

Months to payoff

Mortgage Calculator Worksheet      NOTE: Data may be entered only in fields with a green background

Balance Calculation

Balance:
Payment
Annual Interest Rate
Term (in months)

Monthly Payment Calculations

Balance:
Payment
Annual Interest Rate
Term (in months)

Annual Interest Rate Calculation

Balance:
Payment
Rate
Term (in months)

Months to Payoff Calculation

Balance:
Payment
Annual Interest Rate
Term (in months)
ds with a green background
NOTE: Data may be entered only in fields with a green background

Estimated Increased Mortgage Interest Cost

OLD mortgage balance:
OLD mortgage payment:
OLD annnual interest rate:
NEW annual interest rate:
NEW mortgage points:
Estimated Increased Mortgage Interest Cost Report
OLD mortgage balance:     \$     .00                Remaining term < months >:
OLD mortgage payment: \$         .00                Value of new payments:               \$
OLD annual interest rate:     0.00%                Buydown:                             \$
NEW annual interest rate:     0.00%                Points amount:                       \$
NEW mortgage points:          0.00%                Estimate cost:                       \$

The calculations:

\$0.00     for                 months at                0.00%          =         \$              .00
\$0.00     for                 months at                0.00%          =         \$
The buydown is :         \$     .00      -      \$                              =         \$
Points:                  \$              x                       0.00          =         \$
Buydown + points:        \$              +      \$                              =         \$

These figures only apply if the new mortgage
is for more than                      with a term
of more than                          months.
Otherwise you have to use the Final Increased
Mortgage Interest Cost program to see how

Printed: 7/15/2010                                         Page 6 of 21
Months to Payoff C

Ter
Months to Payoff Calculation

Balance:
Payment
Rate
Term (in months)   #DIV/0!   #DIV/0!
Term rounded    #DIV/0!   #DIV/0!
NOTE: Data may be entered only in fi

INCREASED MORTGAGE INTEREST COST, FINAL COMPUTATION

OLD mortgage balance:
OLD mortgage payment:
OLD annual interest rate:
OLD remaining term:

NEW mortgage amount:
NEW mortgage payment:
NEW annual interest rate:
NEW mortgage term:
NEW mortgage points:
Data may be entered only in fields with a green background

UTATION
Compute two present values at both interest rates using the lesser term:
\$0.00 for                     0 months at           0.00%   =   \$0.00
\$0.00 for                     0 months at           0.00%   =   \$0.00

The difference between the two present values is the buydown:
\$0.00 -                \$0.00      =               \$0.00

Proration is not required since the new mortgage is greater than           \$0.00
which is the amount required to maintain the same monthly payments.

No points are computed because the new mortgage has no points.

Printed: 7/15/2010                                                       Page 12 of 21
Compute two present values at both interest rates using the lesser term:

\$0.00 for                   0 months at                0.00%      =   \$0.00
\$0.00 for                   0 months at                0.00%      =   \$0.00

The difference between the two present values is the buydown:
\$0.00 -                \$0.00       =                      \$0.00

Since there are no points on the new mortgage, no points are computed here.

\$0.00    +             \$0.00        =                  \$0.00

Proration is not required since the new mortgage is not less than the mortgage
balance computed in the buydown determination.

Printed: 7/15/2010                                                       Page 13 of 21
Proration not required text:   Proration is not required since the new mortgage is greater than
which is the amount required to maintain the same monthly payments.

Proration required text:       Proration is required because the new                         \$0.00
-- with points                than the                \$0.00 computed amount to maintain the same monthly payme

-- no points

Add buydown and points         Points are based on the unpaid mortgage balance on the displacement dwelling,
then prorate (text):         less the amount determined for the reduction of such mortgage balance.
In this case that amount is                    \$0.00
\$0.00    x            0.00000         =

\$0.00     +              \$0.00       =

Points added text              Points are based on the lesser of the new mortgage amount or the amount
required to maintain the same or computed monthly payment at the new rate:
\$0.00   x           0.00000         =

#DIV/0!        +               \$0.00       =

No points text                 No points are computed because the new mortgage has no points.

\$0.00     /              \$0.00       =

Apply the proration factor to the buydown:
#DIV/0!          x             \$0.00       =

Shorter term                   Since the term of the new mortgage is less than the remaining term on the
old mortgage, cost must be based on the shorter term. The monthly payment to
amortize               \$0.00 over                0.00 months at
\$0.00                  Proration not required text:           Proration is not required since the

mortgage is less                    Proration required text:               Proration is required since the new
n the same monthly payment.                       -- with points                        computed in the buydown determi

placement dwelling,                              Add buydown and points         *****   Points are based on the unpaid m
then prorate (text):                 less the amount determined for th
In this case that amount is
\$0.00

\$0.00

or the amount
t at the new rate:
\$0.00

#DIV/0!

No points text                         Since there are no points on the n

#DIV/0!

#DIV/0!

ng term on the                                   Shorter term                           Since the term of the new mortgag
monthly payment to                                                                     mortgage, cost must be based on
0.0000%   is   #DIV/0!                                          amortize
, then Prorate
Proration is not required since the new mortgage is not less than the mortgage
balance computed in the buydown determination.

Proration is required since the new mortgage is less than the mortgage balance

Points are based on the unpaid mortgage balance on the displacement dwelling,
less the amount determined for the reduction of such mortgage balance.
In this case that amount is                    \$0.00
\$0.00    x            0.00000         =                       \$0.00

\$0.00      +             \$0.00         =                      \$0.00

Since there are no points on the new mortgage, no points are computed here.

Proration factor:
\$0.00        /                     \$0.00          =                #DIV/0!
Prorate the cost:
\$0.00        x              #DIV/0!               =                #DIV/0!

Since the term of the new mortgage is less than the remaining term on the old
mortgage, cost must be based on the shorter term. The monthly payment to
\$0.00 over                0.00 months is               #DIV/0!        <see line 2 above>.
NOTE: Data may be entered only in fields

Mortgage Amortization Schedule

What is the amount being mortgaged:
What is the annual rate of interest:
Amortization based on how many months:
Monthly payment
Enter starting date <mm/dd/yyyy>:
Who is schedule for:
MonthNo    MonthName
1   Jan
2   Feb
3   Mar
4   Apr
5   May
6   Jun
7   Jul
8   Aug
9   Sep
10   Oct
11   Nov
12   Dec
ata may be entered only in fields with a green background
Loan Amount                        -
Annual Interest Rate            0.00%              Schedule for:                                                              -
# of Months                          -
Monthly payment            #DIV/0!

Payment #           Month            Year   Start Balance           Principal   Int. for Month    Payment   End Balance
- - - Loan Year 1 - - -
1                Jan             1900              0.00                              0.00    #DIV/0!     #DIV/0!
#DIV/0!                         #DIV/0!    #DIV/0!                                             #DIV/0!

- - - Loan Year 2 - - -

- - - Loan Year 3 - - -

- - - Loan Year 4 - - -

- - - Loan Year 5 - - -

Printed: 7/15/2010                                         Page 20 of 21
Loan Amount                        -
Annual Interest Rate            0.00%           Schedule for:                                                          -
# of Months                          -
Monthly payment            #DIV/0!

Payment #            Month         Year   Start Balance           Principal   Int. for Month   Payment   End Balance

- - - Loan Year 6 - - -

Printed: 7/15/2010                                      Page 21 of 21

```
To top