Results 1 to 10 of 10
  1. #1
    Pro
    Points: 33,533, Level: 56
    Level completed: 41%, Points required for next Level: 717
    Overall activity: 23.0%
    Achievements:
    Veteran25000 Experience Points

    Join Date
    Oct 2008
    Posts
    3,216
    Points
    33,533
    Level
    56
    Thumbs Up
    Received: 57
    Given: 30

    Finance Help....

    Looking for a little help...I got the answeres in Excel but I need to setup it the way the teacher wants to see it. The question is below.

    Teacher wants it setup the way below and wants us to use a Finace calculator...
    N I/Y PV PMT FV
    ? ? ? ? ?

    I did it this way...
    How much will $1,500 grow to in 9 years earning an annual rate 9% yet using monthly compounding? What about 22 years?
    A= P(1+ r/q)qt ...where "A" is the future amount, "P" is the beginning amount (or "principal"), "r" is the interest rate (expressed as a decimal), "q" is the number of compoundings a year, and "t" is the total number of yearsAns.A= 1500(1+.09/12)12*9=1500*2.241124$3,361.69in 9 yearsA= 1500(1+.09/12)12*22=1500*7.18943$10,784.15in 22 years



  2. #2
    Rookie
    Points: 20,985, Level: 44
    Level completed: 27%, Points required for next Level: 665
    Overall activity: 2.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Apr 2010
    Location
    Des Moines, IA
    Posts
    552
    Points
    20,985
    Level
    44
    Thumbs Up
    Received: 0
    Given: 0

    Re: Finance Help....

    Quote Originally Posted by 2forISU View Post
    Looking for a little help...I got the answeres in Excel but I need to setup it the way the teacher wants to see it. The question is below.

    Teacher wants it setup the way below and wants us to use a Finace calculator...
    N I/Y PV PMT FV
    ? ? ? ? ?

    I did it this way...
    How much will $1,500 grow to in 9 years earning an annual rate 9% yet using monthly compounding? What about 22 years?
    A= P(1+ r/q)qt ...where "A" is the future amount, "P" is the beginning amount (or "principal"), "r" is the interest rate (expressed as a decimal), "q" is the number of compoundings a year, and "t" is the total number of yearsAns.A= 1500(1+.09/12)12*9=1500*2.241124$3,361.69in 9 yearsA= 1500(1+.09/12)12*22=1500*7.18943$10,784.15in 22 years
    Let me Google that for you:

    How To Calculate Compound Interest in Excel | Excel Formula

    This is what you need to do.



  3. #3
    Pro
    Points: 33,533, Level: 56
    Level completed: 41%, Points required for next Level: 717
    Overall activity: 23.0%
    Achievements:
    Veteran25000 Experience Points

    Join Date
    Oct 2008
    Posts
    3,216
    Points
    33,533
    Level
    56
    Thumbs Up
    Received: 57
    Given: 30

    Re: Finance Help....

    Quote Originally Posted by cjb1978 View Post
    Let me Google that for you:

    How To Calculate Compound Interest in Excel | Excel Formula

    This is what you need to do.

    I know how to do it in excel but not on finance calculator. How do you punch it on a calculator?



  4. #4
    Rookie
    Points: 20,985, Level: 44
    Level completed: 27%, Points required for next Level: 665
    Overall activity: 2.0%
    Achievements:
    10000 Experience PointsVeteran

    Join Date
    Apr 2010
    Location
    Des Moines, IA
    Posts
    552
    Points
    20,985
    Level
    44
    Thumbs Up
    Received: 0
    Given: 0

    Re: Finance Help....

    Quote Originally Posted by 2forISU View Post
    I know how to do it in excel but not on finance calculator. How do you punch it on a calculator?
    How To Calculate Compound Interest


    How to Calculate Compound Interest - Investors Calculate Compound Interest



  5. #5
    Pro
    Points: 28,826, Level: 52
    Level completed: 16%, Points required for next Level: 924
    Overall activity: 0%
    Achievements:
    Veteran25000 Experience Points

    Join Date
    Feb 2008
    Location
    Des Moines
    Posts
    2,466
    Points
    28,826
    Level
    52
    Thumbs Up
    Received: 6
    Given: 0

    Re: Finance Help....

    Quote Originally Posted by 2forISU View Post
    Looking for a little help...I got the answeres in Excel but I need to setup it the way the teacher wants to see it. The question is below.

    Teacher wants it setup the way below and wants us to use a Finace calculator...
    N I/Y PV PMT FV
    ? ? ? ? ?

    I did it this way...
    How much will $1,500 grow to in 9 years earning an annual rate 9% yet using monthly compounding? What about 22 years?
    A= P(1+ r/q)qt ...where "A" is the future amount, "P" is the beginning amount (or "principal"), "r" is the interest rate (expressed as a decimal), "q" is the number of compoundings a year, and "t" is the total number of yearsAns.A= 1500(1+.09/12)12*9=1500*2.241124$3,361.69in 9 yearsA= 1500(1+.09/12)12*22=1500*7.18943$10,784.15in 22 years
    9 Years:
    N = 108 (9yrs*12mos)
    I/Y = .0075 (.09APR/12mos)
    PV = $1,500
    Find for FV

    22 years
    N = 264 (22yrs*12mos)
    I/Y = .0075 (.09APR/12mos)
    PV = $1,500
    Find for FV



  6. #6
    Starter
    Points: 11,585, Level: 32
    Level completed: 48%, Points required for next Level: 365
    Overall activity: 0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Dec 2008
    Location
    Somewhere on Hwy 30
    Posts
    677
    Points
    11,585
    Level
    32
    Thumbs Up
    Received: 11
    Given: 5

    Re: Finance Help....

    Quote Originally Posted by 2forISU View Post
    ...
    Teacher wants it setup the way below and wants us to use a Finace calculator...
    N I/Y PV PMT FV
    ? ? ? ? ?

    I did it this way...
    How much will $1,500 grow to in 9 years earning an annual rate 9% yet using monthly compounding? What about 22 years?
    A= P(1+ r/q)qt ...where "A" is the future amount, "P" is the beginning amount (or "principal"), "r" is the interest rate (expressed as a decimal), "q" is the number of compoundings a year, and "t" is the total number of yearsAns.A= 1500(1+.09/12)12*9=1500*2.241124$3,361.69in 9 yearsA= 1500(1+.09/12)12*22=1500*7.18943$10,784.15in 22 years
    You'll need to set your calculator's "C/Y" to 12 (compound monthly).
    PV = 1,500
    N = 9 (then 22 for the second part)
    I/Y = 9
    Compute the FV
    (fyi ... one of the values might need to be set to a negative, or the FV may be calculated as a negative ... whichever you choose)
    I don't have my calcluator with me ...

    edited.


    Last edited by Max57; 01-26-2011 at 10:15 AM. Reason: Or as CRAZYGREG did it.

  7. #7
    All-Star
    Points: 17,967, Level: 40
    Level completed: 90%, Points required for next Level: 83
    Overall activity: 1.0%
    Achievements:
    Veteran10000 Experience Points

    Join Date
    Mar 2007
    Location
    Ames
    Posts
    1,578
    Points
    17,967
    Level
    40
    Thumbs Up
    Received: 0
    Given: 0

    Re: Finance Help....

    This looks pretty similar to my HW. What class is this for?



  8. #8
    Pro
    Points: 33,533, Level: 56
    Level completed: 41%, Points required for next Level: 717
    Overall activity: 23.0%
    Achievements:
    Veteran25000 Experience Points

    Join Date
    Oct 2008
    Posts
    3,216
    Points
    33,533
    Level
    56
    Thumbs Up
    Received: 57
    Given: 30

    Re: Finance Help....

    Quote Originally Posted by CRAZYGREG View Post
    9 Years:
    N = 108 (9yrs*12mos)
    I/Y = .0075 (.09APR/12mos)
    PV = $1,500
    Find for FV

    22 years
    N = 264 (22yrs*12mos)
    I/Y = .0075 (.09APR/12mos)
    PV = $1,500
    Find for FV

    Thank you!



  9. #9
    Pro
    Points: 33,533, Level: 56
    Level completed: 41%, Points required for next Level: 717
    Overall activity: 23.0%
    Achievements:
    Veteran25000 Experience Points

    Join Date
    Oct 2008
    Posts
    3,216
    Points
    33,533
    Level
    56
    Thumbs Up
    Received: 57
    Given: 30

    Re: Finance Help....

    Quote Originally Posted by nickwc View Post
    This looks pretty similar to my HW. What class is this for?
    I live in St. Louis



  10. #10
    Pro
    Points: 28,826, Level: 52
    Level completed: 16%, Points required for next Level: 924
    Overall activity: 0%
    Achievements:
    Veteran25000 Experience Points

    Join Date
    Feb 2008
    Location
    Des Moines
    Posts
    2,466
    Points
    28,826
    Level
    52
    Thumbs Up
    Received: 6
    Given: 0

    Re: Finance Help....

    My solution is for C/Y set to 1. You can put the PV in as a (-) if you wish since it is coming out of your p[ocket up front.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • Football
  • Iowa State vs. North Dakota State
  • August 30, 2014
  • 11:00 AM