please show how to solve this in excel and please show the formulas needed

Two years ago, you purchase a house of $

$5$

$0$

$0$

$,$

$0$

$0$

$0$

$.$

$$You borrow a mortgage with

$8$

$0$

$\%$

$$of LTV

$($

loan to value ratio

$)$

$.$

$$The interest rate on the mortgage is

$6$

$.$

$2$

$5$

$\%$

$.$

$$ Payment terms are being made monthly to amortize the loan over

$3$

$0$

$$years$.$ You have found another lender who will refinance the current outstanding loan balance plus all the costs associated with the new loan at

$5$

$\%$

$$with monthly payments for

$3$

$0$

$$years$.$ Suppose that the new lender will charge

$2$

$.$

$5$

$$discount points on the new loan and other refinancing costs will equal $

$1$

$0$

$,$

$0$

$0$

$0$

$.$

$$

What is the new loan amount if you choose to refinance?

Should you refinance if you hold the loan for

$3$

$0$

$$years$?$

If you choose to refinance, at least how many years should you stay in the house

$($

do not prepay

$)$

$?$

$$Why$?$