Please help me PROBLEM

Gomez Inc. signed a mortgage payable on November $30,2024,$

with a bank to obtain financing for a new building. Installment

payments are to be made at the end of each month.

Information for the mortgage follows.

Mortgage loan amount

Mortgage term in years

$$300,000$

$10$

$4\%$

Interest rate

calculate the payment and mathematical formulas with cell references to the Problem area

and work area as indicated.

a$.$ Use Excel's PMT function to calculate the amount of each installment payment.

Mortgage payment calculation

b$.$ Prepare a partial amortization table through January $31,2021.$

b$.$ Prepare a partial amortization table through January $31,2021.$

Nov. $30,2024$

Dec. $31,2024$

Jan. $31,2024$ c$.$ Prepare the entries to record the mortgage on November $30,2024,$ and the first two

payments on December $31,2024,$ and January $31,2025.$