Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 29th 16, 06:49 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 18
Default Future Value with Interest the 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? See my data below:

Year 1 $100,000.00
Year 2 100,000.00
Year 3 100,000.00
Year 4 106,000.00 6% increase over prior year
Year 5 106,000.00
Year 6 106,000.00
Year 7 112,360.00 6% increase over prior year
Year 8 112,360.00
Year 9 112,360.00
Year 10 119,101.60 6% increase over prior year
Year 11 119,101.60
Year 12 119,101.60
Year 13 126,247.70 6% increase over prior year
Year 14 126,247.70
Year 15 126,247.70
TOTAL $1,691,127.89



Thanks...AJ

  #2   Report Post  
Old July 31st 16, 06:38 AM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2016
Posts: 4
Default

Quote:
Originally Posted by AdmiralAJ View Post
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? See my data below:

Year 1 $100,000.00
Year 2 100,000.00
Year 3 100,000.00
Year 4 106,000.00 6% increase over prior year
Year 5 106,000.00
Year 6 106,000.00
Year 7 112,360.00 6% increase over prior year
Year 8 112,360.00
Year 9 112,360.00
Year 10 119,101.60 6% increase over prior year
Year 11 119,101.60
Year 12 119,101.60
Year 13 126,247.70 6% increase over prior year
Year 14 126,247.70
Year 15 126,247.70
TOTAL $1,691,127.89



Thanks...AJ

A = 100,000

i = 6% = 0.06

x = 1+i = 1.06

n = 15

p = 3

t = 15/3 = 5

FV = A * p * (x^t - 1)/(x - 1)

FV = 100,000 * 3 * (1.06^5 - 1)/(1.06 - 1)

FV = 300,000 * (1.3382255776 - 1)/0.06

FV = 300,000 * 0.3382255776/0.06

FV = 300,000 * 5.63709296

FV = 1,691,127.89


"There exist a closed-form formula for just about anything out there in the Universe" - A Village Idiot from Punjab
  #3   Report Post  
Old July 31st 16, 07:32 PM
Banned
 
First recorded activity by ExcelBanter: Jul 2016
Posts: 4
Default

IN BÓNG BAY – IN LOGO LÊN BÓNG BAY – C* SỞ IN BÓNG BAY GIÁ RẺ 0967 877 586

Cơ sở bóng bay H* Nội phục vụ mọi nhu cầu tối đa của Quý Khách trong lĩnh vực quảng cáo thiết kế bóng bay, khinh kh* cầu, cổng hơi, trang tr* cổng bóng bay, bán bóng bay bơm hydro v* in ấn các loại.

- In logo trên bóng bay; 0967 877 586

- Bán bóng bay bơm hydro ; 0967 877 586

- Bán v* bơm khinh kh* cầu 0967 877 586

- L*m v* trang tr* cổng bóng bay; 0967 877 586

- Bán cổng hơi có rồng v* không rồng các loại; 0967 877 586

- Bán que cầm bóng bay 0967 877 586

Niềm vui và sự hài lòng của Quý Khách là thành công lớn nhất của Cơ sở bóng bay H* Nội .

Mọi chi tiết xin liên hệ:

C* SỞ IN BÓNG BAY HÀ NÔI.
Hotline: 0967 877 586


https://www.youtube.com/watch?v=5YR-L2I7FT8

https://www.youtube.com/watch?v=BNu-K3YXIgE

http://indenhat.com/indenhat.html

http://indenhat.com/new/70/1023/Bao-Gia-In-Logo-Len-Bong-Bay.html

http://indenhat.com/new/70/1021/HUONG-DAN-DAT-IN-LOGO-LEN-BONG-BAY.html

http://indenhat.com/new/74/1020/GIOI-THIEU-IN-DE-NHAT.html

http://indenhat.com/new/70/1019/MAU-BONG-IN-LOGO-THUONG-HIEU.html

http://indenhat.com/new/61/1017/In-bong-bay--In-logo-len-bong-bay--Xuong-in-bong-bay.html

https://www.facebook.com/inbongbay.inlogobongbay.xuonginbongbay0967877586/

https://plus.google.com/+%C4%90%E1%BB%87Nh%E1%BA%A5tIn-chuy%C3%AAnthi%E1%BA%BFtk%E1%BA%BFin%E1%BA%A5ntr%C 3%AAnm%E1%BB%8Dich%E1%BA%A5tli%E1%BB%87u/posts/Zno8FuhDWao

https://plus.google.com/+%C4%90%E1%BB%87Nh%E1%BA%A5tIn-chuy%C3%AAnthi%E1%BA%BFtk%E1%BA%BFin%E1%BA%A5ntr%C 3%AAnm%E1%BB%8Dich%E1%BA%A5tli%E1%BB%87u/posts


Reply
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
Calculate Interest that compounds every 3 Years AdmiralAJ Excel Worksheet Functions 0 June 29th 16 06:43 PM
future value function for compound interest frustrated wife Excel Worksheet Functions 1 August 21st 08 07:40 PM
Compound Interest over the years Rene Excel Worksheet Functions 5 October 2nd 07 10:49 PM
NPV calculations at the end of future years das Excel Discussion (Misc queries) 2 March 19th 06 12:21 PM
need an income statement forecasting worksheet for future years top gun Excel Programming 1 November 28th 05 01:29 PM


All times are GMT +1. The time now is 10:57 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