Got an account? | login
Loading Screen Recorder
Screen Recorder Loaded.
Recorder already running.
PMT Function on Excel

Send us Feedback
Please use the form below or email us at feedback@screencast-o-matic.com

Your email address:


Your Comment:


 
Requires JAVA 1.5 or later. Test your Java
 

  • Description

    Using the PMT function on MS Excel to determine monthly loan payment and monthly savings plan.

  • Info

    • Created:
      Feb 21 2008
    • Searchable:
      Yes
    • Audio:
      No
    • Language:
      English
    • Views:
      1,743
    • Rating:
      • Currently 0.00/5
      • 1
      • 2
      • 3
      • 4
      • 5
      Average: 0.0 (0 votes)
       

  • Share Link

  • Embed Code

    Choose width:
  • Screencast-O-Matic is a free online screen recorder for recording screen capture video and uploading it from your browser with no install!

  • Notes

    • 0:00
      Let's find out the monthly payment for a $300,000 home at 8% over 30 years.
    • 0:03
      Type in your rate (8%).
    • 0:16
      Type in the number of years (30).
    • 0:31
      Type in the amount of your loan (300000).
    • 0:49
      Use the PMT function by typing "=PMT("
    • 0:54
      Use cell "A1" (your rate) divided by 12 (the number of months in a year) for the rate portion.
    • 1:00
      Use cell "B1" (your years) times 12 for the "nper" (number of periods) portion.
    • 1:06
      Use cell "C1" (your loan) as your PV (present value).
    • 1:09
      Use 0 as your FV (future value). This means that the eventual worth of the loan will be 0 (you will have paid it off). You may also close the function after the PV step.
    • 1:25
      To see the payment at 7% for a $350,000 loan, change the rate and loan cells.
    • 1:42
      See how the change occurs instantaneously?
    • 1:43
      Now let's see how much we would have to save each month in order to save $1 million in 30 years at a 10% annual savings rate.
    • 1:48
      Type in your rate (10%).
    • 2:00
      Type in the number of years (30).
    • 2:15
      Type in your desired savings ($1 million).
    • 2:30
      Use the PMT function the same way you did before.
    • 2:52
      Type in 0 for your PV (you don't have any money right now).
    • 2:54
      Use cell "C10" for your FV.
    • 3:16
      To see your required savings at 12% for 20 years, changes the rate and years cells.
    • 3:25
      There you have it! I hope you have enjoyed my screencast.
  • Add A Comment

    Comments

    • No comments for this screencast. Feel free to add some by clicking on the "Add A Comment" link below.

    name

©2011 Screencast-O-Matic | Terms of Service | Privacy | Credits