I need to the excel formulas please as I am getting a negative amount for monthly payment, which throws my principal balance off. Thanks

Suppose you bought a house and took out a mortgage for $400,000. The NORMINAL interest rate is 5%, and you must amortize the loan over 30 years of MONTHLY PAYMENTS with equal end-of-month payments. Set up an amortization schedule that shows the MONTYLY payments and the amount of each payment that goes to pay off the principal and the amount that constitutes interest expense to the borrower and interest income to the lender. Original amount of mortgage: Term of mortgage: Interest rate: Monthly payment (use PMT function): Month Beg. Amt. Pmt Interest Principal End. Bal.