please explain in excel with formulas

1) You plan to borrow a fixed payment loan of $400,000 for 2 years at an interest rate of 3.85%. The frequency of your periodic equal payments to be made in a year is 2. a) What should be your periodic(monthly) equal payment to your lender? Group of answer choices $17,343.28 $211,622.71 $104,858.38 $52,189.82 B) What will be the approximate modified duration of this fixed payment loan? Group of answer choices 1.238 2.000 1.192 1.215