writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 24:
Line 24: − + − ! 1 − + − ! 2 + + + + − |28000 || 45000 + − |20000 || 100000 + − | 32500 || 150000 + − | 59000 || 275000+ − − |- Line 52:
Line 52: −
→Examples
|+1..10@SQRT
|+1..10@SQRT
|-
|-
! !! A !! B
! !! A !! B
|-
|-
| -100000 || -500000
! 1
| -100000 || -500000
|-
|-
! 2
| 10000 || 32000
| 10000 || 32000
|-
! 3
! 3
|28000 || 45000
|-
|-
! 4
! 4
|20000 || 100000
|-
|-
! 5
! 5
| 32500 || 150000
|-
|-
! 6
! 6
| 59000 || 275000
|-
|-
! 7
! 7
|1000 ||67000
|1000 ||67000
|}
|}
#=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==