- 1 (49.42 KiB) Viewed 29 times
A B. В 1 2 Interest rate 15% 3 4 Year 5 0 Payment -$1,000 $853) 6 1 7 2 $351 8 3 9 4 $1,024 $1,435 $1,101 10 5 11 12 Net
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
A B. В 1 2 Interest rate 15% 3 4 Year 5 0 Payment -$1,000 $853) 6 1 7 2 $351 8 3 9 4 $1,024 $1,435 $1,101 10 5 11 12 Net
A B. В 1 2 Interest rate 15% 3 4 Year 5 0 Payment -$1,000 $853) 6 1 7 2 $351 8 3 9 4 $1,024 $1,435 $1,101 10 5 11 12 Net Present Value The correct formula for cell B12 is... O NPV(B2,B6:B10)+B5 O NPV(B2,B6:B10)-B5 O NPV(A2,B6:B10) O NPV(B2,B6:B10)+B2 O IRR(BO:B5)+B5