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.

	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

<tbody>
</tbody><colgroup><col><col><col><col></colgroup>

 

[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