- A B 1 10 2 Interest Rate 3 4 Year 5 0 Payment 1 200 194 6 1 7 2 1881 8 9 4 1 062 1 250 622 10 5 11 12 Irr The 1 (41.12 KiB) Viewed 32 times
A B 1 10% 2 Interest rate 3 4 Year 5 0 Payment -$1,200 $194 6 1 7 2 $1881 8 9 4 $1,062 $1,250 $622 10 5 11 12 IRR ? The
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
A B 1 10% 2 Interest rate 3 4 Year 5 0 Payment -$1,200 $194 6 1 7 2 $1881 8 9 4 $1,062 $1,250 $622 10 5 11 12 IRR ? The
A B 1 10% 2 Interest rate 3 4 Year 5 0 Payment -$1,200 $194 6 1 7 2 $1881 8 9 4 $1,062 $1,250 $622 10 5 11 12 IRR ? The correct formula for cell B12 is... O IRR(B5:B10) O IRR(BO:B5)+B5 O IRR(B5-B10) O NPV(B2,B6:B10) O IRR(A5:A10)