Data: $5M loan
Rate: 7% annual; compounded daily (360 day year)
Amort: 30 years

How to calculate MONTHLY payment?

Can't figure out how to structure PMT function with different compounding
period than payment period...