LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MPuser
 
Posts: n/a
Default Investment FV


Hypothetically I want to save $500 per month into an investment
portfolio that earns 10% What is the future value after 30 years?

The real issue is...do I compound interest monthly or annually?
Remember, lets call this investment a collection of funds in a
portfolio. So I'm sure the difference in compounding methods would be
pretty significant. Which would be more accurate? I'd be curious to
see an FV function solution and a non-array solution if anyone has the
talents.

Thanks!


--
MPuser
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Earn $100,000.00 monthly income with only $5.99 investment Israel Fagbemi---Top Rank business Associates Grou Links and Linking in Excel 0 November 6th 05 07:21 AM
Future Value of single investment bomotu Excel Worksheet Functions 0 August 13th 05 10:45 AM
Capital Investment Jim C Excel Discussion (Misc queries) 0 April 14th 05 03:21 PM
Interest Earned on Investment w/Daily Compounding Liz Excel Worksheet Functions 2 February 7th 05 07:49 PM
Excel function for FV of daily investment at compound rates rbwm Excel Worksheet Functions 2 December 9th 04 01:53 PM


All times are GMT +1. The time now is 06:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"