Morgan is considering purchasing a new home. Her banker has presented a 25-year mortgage at a fixed rate of 4.5%. The cost of the home is $164000 and Morgan will be required to provide a 15% down payment. If we use Excel to determine her monthly payment, which of the following Excel commands could be used to determine her payment? (Choose all that apply. There can be more than one way to enter the values in Excel to get the desired outcome.)
A. =PMT((0.045)/(12),300,-164000+24600)
B. =PMT((0.045)/(12),300,-139400)
C. =PMT((4.5)/(12),12*25,-139400)
D. =PMT((0.045)/(12),25*12,-$139400)
E. =PMT(4.5,25,-164000)
F. =PMT(4.5(%)/(12),12*25,-139400)