Hi all,

I have the following table to Discount the annual rate to get the present value.

I am wondering if there is any formula that i could implement to get the monthly Discount factor so that i can figure out the difference.


Annual rate
8,00%
Discount factor PV
2018 $ 150.000
2019 $ 216.667 0,9259 $ 200.617
2020 $ 216.667 0,8573 $ 185.757
2021 $ 216.667 0,7938 $ 171.997
$ 650.000 $ 558.371