can you help me inputing the exact inputs into excel, I Know the hardcode formula but not how to exactly input in excel. The problem in excel is modified from the book. Thank you. my professor key says pmt should be 1796.18 Im having a hard time getting this

type]) P6-6M (use the changes in bold below for the problem) Emily Morrison purchased a new house for $450,000. She paid $50,000 up front and agreed to pay the rest over the next 30 years in 360 equal monthly payments that include both principal and 3.5 percent compound interest on the unpaid balance. What will these equal paymets be? Hint. Use the PMT function in Excel. For the PV figure use the loan amount as explained on pages 168.169. 23 - 2 PV 1 nper m pmt FV $450,0001 3.5%! 360 30 SMI)