Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Tricky FV function
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="davidm, post: 3602121"] I agree with Ron's handling of the first 2 parts of the question. You can double-check your results with the following approach: The FV of $500 p.a. at 10% p.a. interest (compounding monthly) for 30 years is calculated as follows: FV= ((Amt of $500 over 30years*12 months @ 10%/12)-1)/10%/12 =500*((((1+(0.1/12))^30*12)-1))/(0.1/12) =$86,3541.09 The 3rd part is easier with a spreadsheet layout: The 3% increments will produce a cash flow of: 1st year 12 monthly instals.: 500 *(1.03)^0-500 = 0 2nd year 12 monthly instals.: 500*(1.03) ^1-500 per month 3rd year 12 monthly instals.: 500*(1.03)^2-500 per month [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Tricky FV function
Top