I wonder if there is a way to calculate monthly mortgage payment through Pyspark. In other words, if I have total term, 360 for 30 years mortgage, interest rate 4% and loan balance 200000, based on Excel pmt function, the monthly payment will be $954. How can I do this in Pyspark?

I search on line but didn't find a solid solution. Thanks.