please answer and explain in excel

The following informotion relates to Problems 1-2. 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. What should be your periodic equal payment to your lender? Group of answer choices 0 A $17,343.28 1 B $211,622.71 2C $104,858.38 BD $52,189.82 IS 16 17 18 What will be the approximate modified duration of this fixed payment loan? 19 Group of answer choices 20 A 1.238 2 22 C 1.192 1.215 24 25 21 B 23 D