can you please help me with solve A and B for this problem, please show steps of how you got the answers. thanks

is this everything, there's no data or information missing!

PV 3 years ago John borrowed $350,000 with payments calculated on an 30 year payout at 5%. He now seeks to refinance with a $400,000 at 4% on a 27 year basis with 3 points. What is the difference in the monthly loan payment? PV N I FV PMT PV N 1 FV PMT PMT 3 Years ago John borrowed $350,000 with payments calculated on an 30 year payout at 5%. He now seeks to refinance with a $400,000 at 4% on a 27 year basis with 3 points. What is the incremental costs of Funds? PV 27 N PMT FV I John wants to buy a property for $125,000 and wants an 80% Loan-to-Value (LTV). He is presented with a 30 year monthly payment loan at 6.5% with 4 points? How much will the lender actually disburse? 120,000 a) What is the effective rate of interest assuming the loan is held to full term? PV N FV PV N FV PMT 1 1 PMT b) What is the effective rate of interest assuming the loan is paid off in 5 years? Outstanding Amount FV PMT PV PV N N FV PV PMT FV PV N FV PMT I 3 years ago John borrowed $350,000 on an interest only loan at 5%. He now seeks to refinance with a $400,000 loan at 4% with no closing costs. What is the amount of incremental loan proceeds? 50.196 3 Years ago John borrowed $350,000 on an interest only loan at 5%. He now seeks to refinance with a $400,000 interest only loan at 4% with no closing costs. What is the difference in the monthly loan payment? PV N I FV PMT 400,000 324 0.333% 0 (52,020.83) $ $2,020.83 3 Years ago John borrowed $350,000 with payments calculated on an 30 year payout at 5%. He now seeks to refinance with a $400,000 loan at 4% on a with 3 points. What is the amount of incremental loan proceeds? PV N 1 FV PV PMT 3 Years ago John borrowed $350,000 with payments calculated on an 30 year payout at 5%. He now seeks to refinance with a $400,000 at 4% on a 27 year basis with 3 points. What is the difference in the monthly loan payment? PV N I FV PMT 350,000 360 0.42% $0.00 (51,878.88) PV N I FV PMT 400,000 324 0.34% $0.00 ($2.047.90) -169.03 PMT 3 Years ago John borrowed $350,000 with payments calculated on an 30 year payout at 5%. He now seeks to refinance with a $400,000 at 4% on a 27 year basis with 3 points. What is the incremental costs of Funds? PV N PMT FV I 27 -169.029 0 John wants to buy a property for $125,000 and wants an 80% Loan-to-Value (LTV). He is presented with a 30 year monthly payment loan at 6.5% with 4 points? How much will the lender actually disburse? 120,000