Final answer:
To calculate the monthly payment using the PMT function, you need to input the interest rate, the number of periods, and the present value of the loan.
Step-by-step explanation:
To calculate the monthly payment using the PMT function, you need to input the interest rate, the number of periods, and the present value of the loan. In this case, the interest rate is 6%, the number of periods is 30*12=360, and the present value is $300,000. The PMT function formula would be:
=PMT(6%/12, 360, -300000)
This will give you the monthly payment for a $300,000 loan with 6% interest over 30 years.