Lazarus
Home
Help
TinyPortal
Search
Login
Register
Lazarus
»
Forum
»
Free Pascal
»
General
(Moderators:
FPK
,
Tomas Hajny
) »
CAGR Formula
Free Pascal
Website
Downloads
Wiki
Documentation
Bugtracker
Mailing List
Lazarus
Website
Downloads (Laz+FPC)
Packages (OPM)
FAQ
Wiki
Documentation (RTL/FCL/LCL)
Bugtracker
CCR Bugs
IRC channel
GIT
Mailing List
Other languages
Foundation
Website
Useful Wiki Links
Project Roadmap
Getting the Source
Screenshots
How to use the forum
About donations (wiki)
Bookstore
Computer Math and Games in Pascal
(preview)
Lazarus Handbook
Search
Advanced search
Recent
Your best UI design - con...
by
circular
[
Today
at 09:36:11 am]
ZeosDBO and querys using ...
by
Zvoni
[
Today
at 09:27:17 am]
Using KeyPress event, how...
by
Zvoni
[
Today
at 09:13:47 am]
STARS with line border st...
by
Boleeman
[
Today
at 09:13:29 am]
JEDI error but unit compi...
by
DomingoGP
[
Today
at 08:28:17 am]
Configure JCF messages
by
DomingoGP
[
Today
at 08:19:10 am]
Any upgrades to fpWeb pag...
by
AlexTP
[
Today
at 08:10:55 am]
Zeos components. Had to c...
by
dbannon
[
Today
at 07:26:11 am]
IDE instability on Raspbe...
by
rvk
[
Today
at 07:08:49 am]
A button require administ...
by
Fibonacci
[
Today
at 05:57:21 am]
How to detect one externa...
by
d2010
[
Today
at 12:24:32 am]
Center Lost Window featur...
by
Tony Stone
[
Today
at 12:06:16 am]
Complex package installat...
by
wp
[March 27, 2024, 10:47:45 pm]
Controlling the behavior ...
by
wp
[March 27, 2024, 10:43:40 pm]
A "leisure" question on W...
by
EventHorizon
[March 27, 2024, 10:18:38 pm]
need advice about the fol...
by
jamie
[March 27, 2024, 09:56:39 pm]
[SOLVED] Completion box s...
by
Martin_fr
[March 27, 2024, 08:44:09 pm]
Dialog ShowModal and an i...
by
d7_2_laz
[March 27, 2024, 08:25:18 pm]
Offical launch of the 1 B...
by
Gustavo 'Gus' Carreno
[March 27, 2024, 07:41:48 pm]
Understanding and adjusti...
by
ArchChem
[March 27, 2024, 06:04:25 pm]
Problem setting length of...
by
Remy Lebeau
[March 27, 2024, 05:41:10 pm]
TDBLookupcombobox seems u...
by
Fantablup
[March 27, 2024, 05:18:04 pm]
Poll: Watches and Display...
by
Martin_fr
[March 27, 2024, 03:58:57 pm]
Help needed with Cairo / ...
by
AL
[March 27, 2024, 02:35:10 pm]
I encountered onDatachang...
by
Fantablup
[March 27, 2024, 02:34:08 pm]
« previous
next »
Print
Pages: [
1
]
Author
Topic: CAGR Formula (Read 4274 times)
tMinuszero
Newbie
Posts: 5
CAGR Formula
«
on:
September 16, 2016, 10:24:59 pm »
Hi,
Could somebody explain how to implement the following formula in object pascal code please? Sticky point is implementing (^) power bit.
y = a(1 + r)^x
where:
y = future compounded value
a = initial value
r = growth rate
x = number of periods
Logged
Bart
Hero Member
Posts: 5274
Re: CAGR Formula
«
Reply #1 on:
September 16, 2016, 10:27:23 pm »
Take a look at the Power() function (unit math).
Bart
Logged
tMinuszero
Newbie
Posts: 5
Re: CAGR Formula
«
Reply #2 on:
September 16, 2016, 11:03:45 pm »
Thanks Bart..
I don't know enough coding to use IDE yet.
Just wanted to know sample code implementing the above formula.
Logged
lainz
Hero Member
Posts: 4460
Re: CAGR Formula
«
Reply #3 on:
September 16, 2016, 11:12:43 pm »
Go to Lazarus and do Project > New Project > select Simple Program and copy this (hope the formula is OK typed, else fix it yourself):
program Project1;
Code: Pascal
[Select]
[+]
[-]
uses
Math
;
function
CAGR
(
initial_value
,
grouth_rate
,
number_of_periods
:
double
)
:
double
;
begin
result
:
=
initial_value
*
Power
(
(
1
+
grouth_rate
)
,
number_of_periods
)
;
end
;
begin
writeln
(
CAGR
(
5.1
,
10.4
,
2.2
)
:
0
:
2
)
;
readln
(
)
;
end
.
Logged
https://lainz.github.io/
JD
Hero Member
Posts: 1848
Re: CAGR Formula
«
Reply #4 on:
September 16, 2016, 11:15:02 pm »
@tMinusZero
Look in the Math unit. It has some basic financial functions that can help you with
capital budgeting
calculations. You can use them to put together more complicated equations.
Code: Pascal
[Select]
[+]
[-]
{ Financial functions }
function
FutureValue
(
ARate
:
Float
;
NPeriods
:
Integer
;
APayment
,
APresentValue
:
Float
;
APaymentTime
:
TPaymentTime
)
:
Float
;
function
InterestRate
(
NPeriods
:
Integer
;
APayment
,
APresentValue
,
AFutureValue
:
Float
;
APaymentTime
:
TPaymentTime
)
:
Float
;
function
NumberOfPeriods
(
ARate
,
APayment
,
APresentValue
,
AFutureValue
:
Float
;
APaymentTime
:
TPaymentTime
)
:
Float
;
function
Payment
(
ARate
:
Float
;
NPeriods
:
Integer
;
APresentValue
,
AFutureValue
:
Float
;
APaymentTime
:
TPaymentTime
)
:
Float
;
function
PresentValue
(
ARate
:
Float
;
NPeriods
:
Integer
;
APayment
,
AFutureValue
:
Float
;
APaymentTime
:
TPaymentTime
)
:
Float
;
You are looking for the future value of y so use the FutureValue function OR the solution
lainz
proposed above.
JD
«
Last Edit: September 16, 2016, 11:20:15 pm by JD
»
Logged
Windows - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe),
Linux Mint - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe)
mORMot; Zeos 8; SQLite, PostgreSQL & MariaDB; VirtualTreeView
tMinuszero
Newbie
Posts: 5
Re: CAGR Formula
«
Reply #5 on:
September 16, 2016, 11:36:48 pm »
Thanks a lot guys................
Appreciated.
Logged
Print
Pages: [
1
]
« previous
next »
Lazarus
»
Forum
»
Free Pascal
»
General
(Moderators:
FPK
,
Tomas Hajny
) »
CAGR Formula
TinyPortal
© 2005-2018