The following is a list of Cash Flows that I am attempting to calculate the present values. I have compared the results to a financial calculator and the results are quite different. I will show you the formula and result and also the result from financial calculator. It appears beyond Yr. 1 my formulas are incorrect.The Discount rate is .12pct. Am i inputing this incorrect.
Yr.1 Yr2 Yr3
Cash Flow 50 57 75
Excel Formula pv(.12,1,50) pv(.12,2,57) pv(.12,3,75)
Results 45 96 180
Financial Calculator 44.64 45.44 53.38
Yr.1 Yr2 Yr3
Cash Flow 50 57 75
Excel Formula pv(.12,1,50) pv(.12,2,57) pv(.12,3,75)
Results 45 96 180
Financial Calculator 44.64 45.44 53.38