Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Mortgage Payment Calculator Amortize

VIEWS: 78 PAGES: 21

Mortgage Payment Calculator Amortize document sample

More Info
									Main Menu
        Mortgage Calculator
Calculate what?

                  Principal outstanding

                  Monthly payment

                  Annual interest rate

                  Months to payoff

                  Return to main page
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
                                                                 your cost would be reduced.




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.




              Buydown plus points:
                                     $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
Prorate first then add buydown:
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         =

                               Buydown plus points:
                                                      $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         =

                               Add points to the buydown for the total cost:
                                                #DIV/0!        +               $0.00       =


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


Add Proration factor           Proration factor:
                                                      $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
                                                 Add buydown and points, then Prorate
                          $0.00                  Proration not required text:           Proration is not required since the
                                                                                        balance computed in the buydown




             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

                                                 Buydown plus points            *****   Buydown plus points:
                          $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


                                                 Add Proration factor
                     #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
 computed in the buydown determination.




 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

 Buydown plus points:
                        $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