Annual discount factor break down

[JDJong]

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.

[TABLE="width: 285"]
<tbody>[TR]
[TD][/TD]
[TD]Annual rate[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]8,00%[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Discount factor[/TD]
[TD]PV [/TD]
[/TR]
[TR]
[TD="align: right"]2018[/TD]
[TD] $ 150.000 [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]2019[/TD]
[TD] $ 216.667 [/TD]
[TD="align: right"]0,9259[/TD]
[TD] $ 200.617 [/TD]
[/TR]
[TR]
[TD="align: right"]2020[/TD]
[TD] $ 216.667 [/TD]
[TD="align: right"]0,8573[/TD]
[TD] $ 185.757 [/TD]
[/TR]
[TR]
[TD="align: right"]2021[/TD]
[TD] $ 216.667 [/TD]
[TD="align: right"]0,7938[/TD]
[TD] $ 171.997 [/TD]
[/TR]
[TR]
[TD][/TD]
[TD] $ 650.000 [/TD]
[TD][/TD]
[TD] $ 558.371 [/TD]
[/TR]
</tbody><colgroup><col><col><col><col></colgroup>[/TABLE]

 

[cerfani]

That's not an excel question, here read this maybe https://corporatefinanceinstitute.com/resources/knowledge/modeling/discount-factor/

 

[JDJong]

I was trying with nominal formula, but it doesn't really get the result