250000.0 Question 22 (1 point) C 1 Nisha plans to purchase a property that wil cost her $250,000. 2 She will take a 10 year mortgage with monthly payments. 3. Interest rate is 5%. Nisha wants to know her monthly payment. 4 she structures her calculations as follows. 5 6 Initial Mortgage 7 Yearly rate 5.00% 8 9 Monthly rate 10 Total Mortgage months 11 PVAF 9428 12 13 Monthly payment 14 15 The appropriate formula in cell B13 is: 0.42% 120 =B6/((1-(1/(1+B9)^B10))/B9) No correct answer option is given =((1-(1/(1+B9)^B10))/B9)/B6 =B9/((1-(1/(1+B9)^B10))/B9) O=((1-(1/(1+B9)^B10))/B9) Question 23 (1 point) 1 Using following information, you would like to calculate difference in two dates 2 3 Tanine's birth date 06-Jul-09 4 Sylvan's birth date 07-Nov-09 5 Shanon's birth date 06-Oct-11 6 Current date 07-Aug-20 7 8 Number of days between Tanine's birth date and current date: 9 4050 10 Number of days between Shanon's birth date and current date: 11 3228 12 Number of days between Shanon's birth date and Tanine's birth date: 13 14 15 An appropriate formula for cell B13 is: =DAYSDIF(B3,B6,"d")-DATEDIF(B5,B6,"d") =DATEDIF(B3,B6,"d")-DATEDIF(B5,B6,"d") No correct answer option is given =B9-B11+1 =DATEDIF(B3,B6,"yd")-DATEDIF(B5, B6,"d")