future value

  1. W

    calculating FV of an investment

    Hi all, quick question. I am looking to calculate the future value (FV) of an investment. I have a lump sum to start with, a known rate of return and I would be making consistent, monthly contributions ($100). However, I would also like to add a large payment once a year into the investment...
    • williamwallace
    • Thread
    • cash flow modeling financial analysis future value investment analysis portfolio portfolio analysis
    • Replies: 6
    • Forum: Excel Questions
  2. M

    How can I find out a annual increasing PMT for a value

    I have a future value of 2307936 (after 5 years) and need to make an investment every month, with an annual increase of 10%. The rate of return on investment is 9% per annum. If there is no annual increase of 10% I am getting 30882 as PMT. How do I calculate with 10% annual increase.
  3. B

    FV of Monthly Deposits over Schedule of Varying Interest Rates

    Hello, I want to compute FV of fixed monthly deposits over 30 years of historical rates of return I am familiar with the FVSCHEDULE formula which will compute the future value of a lump sum over a schedule of varying interest rates I am also familiar with the FV formula which will compute the...
  4. J

    Apparent discrepancy between FV and XIRR results

    I use the XIRR function / formula a lot when I research stocks and mutual funds to get a feel for how the investments are doing over time. I don't just accept the printed return; I do my own research. I don't use the FV function a lot, but today as I was looking at the difference in the...
  5. V

    Target future value to Yield 12%, cash flows compounded quarterly

    I'm able to fairly successfully calculate a future payoff required to achieve a targeted return (say 12%), on an annual basis, with the following formula =-NPV(12%,cash flows)*(1+12%)^COUNTA(Periods) However, I'm trying to adapt this formula for cash flows that are compounded quarterly. For...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top