LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 29th 16, 06:43 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
First recorded activity by ExcelBanter: Apr 2007
Posts: 18
Default Calculate Interest that compounds every 3 Years

I'm working on a trying to set up a formula for services where the cost increases 6% every 3 years over the next 15 years. The standard FV function doesn't seem to be the right formula because its based on annual compounding.

Anyone have a good formula for what I'm trying to achieve?


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
How do I calculate interest? darkwing_duck Excel Discussion (Misc queries) 1 March 4th 10 01:07 AM
Compound Interest over the years Rene Excel Worksheet Functions 5 October 2nd 07 10:49 PM
compute interest at 1.05% compounded daily on $77,000 for 5 years larionova New Users to Excel 4 July 22nd 06 05:17 AM
Function for interest rate over several years Ozborne787 Excel Worksheet Functions 1 November 9th 05 05:39 PM
interest rate when compounded daily for 5 years Tom Excel Programming 1 September 27th 04 03:35 AM

All times are GMT +1. The time now is 11:51 AM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017