Dear all, Can you please help me understand the difference between the output in SAS vs Excel when using NPV function? I have the below example: No Cashflow 1 6000 2 5000 3 4500 4 4000 5 3500 6 2500 Rate 5.53% When computing NPV in SAS : NPV=(rate, freq, cashflows) -> NPV =(5.53%, 6, 6000,5000,4500,4000,3500,2500)=25495.37. The excel output is NPV=21713.68. I can not figure out the difference or if i computed wrongly in SAS. Thank you very much,
... View more