Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Homework Help: Investment Calculator

  1. Feb 24, 2005 #1
    Hi everybody,

    I have given an equation to calculate the final Value (FV) of an investment as follows:

    [tex]FV= Principal*(1+{R/N})^{NT}[/tex]

    Principal = initial investment amount,
    R = annual interest rate,
    N = number of times compounding is performed per year; this can be quaterly (4 times), monthly (12 times), or daily (365)
    T = number of investment years

    i was asked to find the final amount and total profit after x years.
    and also the total amount after the first month, second month, third month, etc....

    actually i'm learning VB6 now, and i have no idea about this equation

    can someone give me some hints to solve this?

    thanks in advance.
  2. jcsd
  3. Feb 24, 2005 #2
    Sometimes you will find that the equation I=PRT, is easier to use for some questions.
    I=interest earned
    P=princepal invested

    EDIT: I didn't notice that you said months, oops
    sorry, disregard my post :)
    Last edited: Feb 24, 2005
  4. Feb 25, 2005 #3


    User Avatar
    Science Advisor

    What you have is the equation for compounding interest from a single payment. In other words, you put "X" amount of dollars into an account, how much will you have after "Y" amount of time. The important part is that it is for a single payment.

    The general term of the equation is:

    F = P (1 + i)^n [/tex]

    F = Future worth of the investment
    P = Present worth of the investment
    i = anual interest rate (IN DECIMAL FORM!)
    n = number of compounding periods

    There's one little snag to this equation. The number that you use for the interest rate is dependent upon how often you are compounding. If you are compounding annually, n will be the number of years compounding and i will be the anual percentage rate (in decimal form). However, if you want to compound monthly, like you said in your question, n will be the number of months compounding and i will be the anual percentage rate divided by 12. If you want to compound daily, divide i by 365. The equation you stated is the same equation I have given except it takes this step into account.

    It's a pretty straight forward equation to use once you get the little trick down. It's very easy to set this up in a spreadsheet. I would suggest doing that and using that as a sanity check on your VB code results.
  5. Feb 25, 2005 #4
    hi, thanks for responding

    but i still dont know how to calculate the "total profit"
    any ideas?
  6. Feb 25, 2005 #5
    Is it simple interest?
  7. Feb 25, 2005 #6


    User Avatar
    Science Advisor

    Using your terminology, "Total Profit" is normally determined from:

    [tex] \ \ \ (Total \ Profit) \ = \ (Final \ Value) \ - \ (Original \ Principle) [/tex]

    Last edited: Feb 25, 2005
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook