Open main menu
Home
Random
Log in
Settings
About ZCubes Wiki
Disclaimers
ZCubes Wiki
Search
Changes
← Older edit
Newer edit →
Manuals/calci/IRR
(view source)
Revision as of 06:39, 31 March 2014
1 byte removed
,
06:39, 31 March 2014
→Examples
Line 24:
Line 24:
|+1..10@SQRT
|+1..10@SQRT
|-
|-
−
! !! A !! B
+
! !! A !! B
−
! 1
|-
|-
−
| -100000 || -500000
+
! 1
−
! 2
+
| -100000 || -500000
|-
|-
+
! 2
| 10000 || 32000
| 10000 || 32000
+
|-
! 3
! 3
+
|28000 || 45000
|-
|-
−
|28000 || 45000
! 4
! 4
+
|20000 || 100000
|-
|-
−
|20000 || 100000
! 5
! 5
+
| 32500 || 150000
|-
|-
−
| 32500 || 150000
! 6
! 6
+
| 59000 || 275000
|-
|-
−
| 59000 || 275000
+
! 7
−
! 7
−
|-
|1000 ||67000
|1000 ||67000
|}
|}
Line 52:
Line 52:
#=IRR(B1:B7) = 6.7%
#=IRR(B1:B7) = 6.7%
#=IRR(B1:B5,5%)= -160.99%
#=IRR(B1:B5,5%)= -160.99%
−
==See Also==
==See Also==
Devika
writer
6,694
edits