+ Reply to Thread
Results 1 to 4 of 4

Solving for an exponential variable (x) of e

  1. #1
    Registered User
    Join Date
    03-23-2012
    Location
    orlando
    MS-Off Ver
    Excel 2007
    Posts
    1

    Solving for an exponential variable (x) of e

    Not sure if this would be able to be solved using solver, having trouble, help greatlyy appreciated

    97.5=100e^(-x(1/4))

    How would I solve for this using excel. Answer= 0.10127


    97.5=100e^(-x(1/4))

    (divided by 100 both sides, mult by -4)

    -4* ln(97.5/100)=-x(1/4) *-4

    This is for determing continuously compounded zero rates

    Bond price= Bond principle (e)^r(t)

  2. #2
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Solving for an exponential variable (x) of e

    I do not understand the "-x" part of "100e^(-x(1/4))"

    is it e^(-1/4) ??

    or

    is it e^(-X*(1/4)) where X is an input variable ??

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Solving for an exponential variable (x) of e

    =-4*ln(0.975)
    Entia non sunt multiplicanda sine necessitate

  4. #4
    Valued Forum Contributor
    Join Date
    03-14-2012
    Location
    Arizona USA
    MS-Off Ver
    Excel 2000/2007
    Posts
    408

    Re: Solving for an exponential variable (x) of e

    Ok, you are solving for X. This is more a math question than an Excel issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1