- Based On The Information Below Fcf Tab And Assuming Inputs C 16 Refers To The Discount Rate What Is The Correct Synt 1 (51.31 KiB) Viewed 25 times
Based on the information below (FCF Tab) and assuming Inputs!$C$16 refers to the discount rate, what is the correct synt
-
answerhappygod
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Based on the information below (FCF Tab) and assuming Inputs!$C$16 refers to the discount rate, what is the correct synt
Based on the information below (FCF Tab) and assuming Inputs!$C$16 refers to the discount rate, what is the correct syntax for the NPV? 1234567 7 8 9 A C Initial Investment OCF ANWC After-tax Salvage FCF D 0 -425000 -60000 -485000 O=NPV(Inputs!$C$16,FCF!$D$8:$1$8) O=NPV(FCF!$D$8:$1$8,Inputs!$C$16) E 1 O-FCF!$D$8+NE(FCF!$E$8:$1$8,Inputs!$C$16) O=FCF!$D$8+NPV(Inputs!$C$16,FCF!$E$8:$1$8) Year F 2 149,677 149,677 G 3 149677 149677 149677 H 4 149,677 149,677 149677 5 1 pts 149,677 60000 33000 242677