Please provide formulas so I can type in excel.

Create a new worksheet "Original Loan Amortization Table". Use the "Loan Amount", "Original Interest Rate" and "Loan Term" to build a mortgage amortization table (from Month 1-360) like shown below. Assume after X months (given in the information sheet), interest rates drop, you can get a better loan rate to refinance your loan. Your new loan amount should equal to your original loan's remaining balance after X months of payments. Create another worksheet "Refinance Loan Amortization Table". Use the "New Loan Amount" (from your first amortization table), "Refinance Loan Interest Rate (APR)" and "New Loan Term" to build a mortgage amortization table (from Month 1-360) like shown below. B D E $ Loan Amount Original Loan Rate (APR) Loan Term (Years) $ 242,000 5.20% 30 X= After x month refinance rate (APR) Refinance Loan Term (Years) 33 4.06% 30 Example: Mortgage Amortization Table Loan Amount $200,000 Loan Rate (APR) 9.00% Term 30 Required PMT $1,609.25 Month Beg. Principal PMT Interest Principal Deduction 1 $200,000 $1,609.25 $1,500.00 $109.25 Ending Principal $199,890.75 $199.780.69 2 $199,890.75 $1,609.25 $1,499.18 $110.06 3 $199,780.69 $1,609.25 $1,498.36 $110.89 $199,669.80 359 $3,182.64 $1.609.25 $23.87 $1,597.27 360 $1,597.27 $1,609.25 $1,585.38 $1,597.27 $11.98 $0.00 Original Mortgage Monthly Payment (Input numbers only without "$" sign, with two decimal places) * Your answer O This is a required question Mortgage Balance after X months of Payments (Input numbers only without "$" sign, with two decimal places) * Your answer O This is a required question New Mortgage Monthly Payments (Input numbers only without "$" sign, with two decimal places) Your answer O This is a required