I created a function on SQL to calculate Present Value SET @pv = -(@pmt * (1 + @rate * @type) * (1 – POWER(1 + @rate, -@nper)) / @rate + @fv / POWER(1 + @rate, @nper))
and I passed this values to It SET @pv = -(52843.00 * (1 + 0.00631333 * 1) * (1 – POWER(1 + 0.00631333, -240.5689440)) / 0.00631333 + 0 / POWER(1 + 0.00631333, 240.5689440))
and it resulted to -6569663.24 while on excel I got -6569663.04
What am I doing wrong
I tried to get the same value as the value from the excel
New contributor
Muawiyya is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.