How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Lane, JD, CFP, MBA Your Own Question

Lane, JD, CFP, MBA
Lane, JD, CFP, MBA, JD, CFP, MBA, CRPS
Category: Finance
Satisfied Customers: 4511
Experience:  Providing Financial, Tax & Business advice since 1986
1929974
Type Your Finance Question Here...
Lane, JD, CFP, MBA is online now
A new question is answered every 9 seconds

Im looking for a formula or function that allows you to input

Resolved Question:

I'm looking for a formula or function that allows you to input a desired NPV, a term in years, a discount rate and a starting cash flow in year 0...and solve for what rate does cash flow in year 0, need to grow every year for the term, at the discount rate to achieve the NPV specified????
Submitted: 1 year ago.
Category: Finance
Expert:  olwagner replied 1 year ago.

olwagner :

Does that help: http://www.tvmcalcs.com/blog/comments/the_npv_function_doesnt_calculate_net_present_value/

olwagner :

Also, once you have such a spreadsheet, you can use the solver to get the discount rate that will give you a given NPV (for instance)

Customer:

This is not exactly what I'm looking for. I am well aware how to calculate NPV if I input cash flows and use a discount rate. What I'm trying to do is solve for a growth rate that gets me a particular NPV given a term and discount rate. I'm trying to take what I've given you and simplify the equation to X =

Customer:

(30,000 / (12% - X)) * (1 - ((1+X)^10 / (1+12%)^10)) = 375,000 needs to get simplified to X = .....

olwagner :

Make X another cell, then use the solver. I'm using Office 2003 as we speak, so things may be different if you have another version (use Excel help to get the solver).
In 2003: If Solver is not installed, use Tools => Add-ins to install it.
Then, Tools => Solver ; Set Target cell (the cell in which you have NPV), Value of (what you want NPV to be), by changing cells (the cell in which you have the discount rate. And it will solve for the discount rate you're looking for.

olwagner :

Alternatively, you may use "Goal Seek" (in Tools => Goal Seek), which is a simplified version of the solver.

Customer:

Both Solver and Goal Seek will work if I input the target value (in this example the NPV of 375,000 - however I don't want to input it every time. I want to be able to type in a number in a cell and it automatically return the value I need - this doesn't happen with goal seek or solver. This is why I want an equation for X = . that way I won't need to use any fancy excel function and can just solve for x with any level of inputs. Solver and Goal seek help but doesnt get at the meat of it. This is not worth $30

Expert:  Lindie-mod replied 1 year ago.

Hello,

I’m Lindie, and I’m a moderator for this topic. Thank you for your patience, your business is very important to us; we are waiting on another professional with the right expertise to come online. Feel free to let us know if you would like us to continue searching for a professional or if you would like us to close your question. We appreciate your understanding!

Best,

Lindie

Customer: replied 1 year ago.
Yes please continue. Thank you
Expert:  Lindie-mod replied 1 year ago.

Hello,

Thank you, XXXXX XXXXX continue to look for a professional to assist you. Please let me know if I can be of any further assistance while you wait.

Best,

Lindie

Expert:  Lane, JD, CFP, MBA replied 1 year ago.

What you're trying to do can't be done.

... not simply by solving, simplifying to, x.

The rate cash flow in year 0, needs to grow every year for the term will be different for every possible 1st cash flow and different for every possible term.

You're oversimplifying, (pun intended).

You need a differential equation here ... COULD be done if you use diffyQ AND specify some ranges.

Lane, JD, CFP, MBA, JD, CFP, MBA, CRPS
Category: Finance
Satisfied Customers: 4511
Experience: Providing Financial, Tax & Business advice since 1986
Lane, JD, CFP, MBA and 3 other Finance Specialists are ready to help you
Expert:  Lane, JD, CFP, MBA replied 1 year ago.

Thanks for that!

Check this out...

http://www.youtube.com/watch?v=yjz7gMNNqwE

Lane

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
< Last | Next >
  • I really was impressed with the prompt response. Your expert was not only a tax expert, but a people expert!!! Her genuine and caring attitude came across in her response... T.G.W Matteson, IL
  • I WON!!! I just wanted you to know that your original answer gave me the courage and confidence to go into yesterday's audit ready to fight. Bonnie Chesnee, SC
  • Great service. Answered my complex tax question in detail and provided a lot of additional useful information for my specific situation. John Minneapolis, MN
  • Excellent information, very quick reply. The experts really take the time to address your questions, it is well worth the fee, for the peace of mind they can provide you with. Orville Hesperia, California
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
 
 
 

Meet The Experts:

 
 
 
  • Rakhi Vasavada

    Financial and Legal Consultant

    Satisfied Customers:

    2073
    Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years
< Last | Next >
  • http://ww2.justanswer.com/uploads/RA/rakhi.v/2012-7-3_14374_RakhiVasavadaL.64x64.jpeg Rakhi Vasavada's Avatar

    Rakhi Vasavada

    Financial and Legal Consultant

    Satisfied Customers:

    2073
    Graduated in law with Emphasis on Finance and have have been working in financial sector for over 12 Years
  • http://ww2.justanswer.com/uploads/BU/BusinessTutor/2012-2-2_115741_Kouki2.64x64.jpg Manal Elkhoshkhany's Avatar

    Manal Elkhoshkhany

    Tutor

    Satisfied Customers:

    1890
    More than 5000 online tutoring sessions.
  • http://ww2.justanswer.com/uploads/MY/MyVirtualCPA/2012-7-5_44024_cookmegan1.64x64.jpg Megan C's Avatar

    Megan C

    Certified Public Accountant (CPA)

    Satisfied Customers:

    1755
    Licensed CPA, CFE, CMA who teaches accounting courses at Master's Level
  • http://ww2.justanswer.com/uploads/JK/jkcpa/2011-1-16_182614_jkcpa.64x64.jpg JKCPA's Avatar

    JKCPA

    CPA

    Satisfied Customers:

    838
    Bachelors degree and CPA with Accounting experience.
  • http://ww2.justanswer.com/uploads/starside8/2010-2-16_55433_DSCN1175.JPG Eric's Avatar

    Eric

    Financial Manager

    Satisfied Customers:

    558
    Loan servicing, counseling and real estate expert. Foreclosure Expert and Financial Planner.
  • http://ww2.justanswer.com/uploads/FA/fastfile/2011-12-15_23139_Klein2011small.64x64.jpg R. Klein, EA's Avatar

    R. Klein, EA

    Accountant

    Satisfied Customers:

    397
    Intuit Ask a Tax Expert. QuickBooks Certified Pro Advisor (all editions)
  • http://ww2.justanswer.com/uploads/dkaplun/2009-05-17_173121_headshot_1_2.jpg Dimitry K., Esq.'s Avatar

    Dimitry K., Esq.

    Attorney

    Satisfied Customers:

    324
    NASD Licensed Rep, 1997-2001, Business Attorney
 
 
 

Related Finance Questions

Chat Now With A Financial Professional
Lane, JD, CFP, MBA
Lane, JD, CFP, MBA
JD, MBA, CFP, CRPS
766 Satisfied Customers
Providing Financial, Tax & Business advice since 1986