You are interested in buying a brand new jalopy and expect the purchase price to be $19,000. The car dealership can offer financing at a 6% interest rate over 6 years. If you put 1,000 down towards...

You are interested in buying a brand new jalopy and expect the purchase price to be $19,000. The car dealership can offer financing at a 6% interest rate over 6 years. If you put 1,000 down towards the purchase and accept the financing terms, what will your monthly payment for the loan be? In Excel, I need to know all the steps in Excel for the answer. Everything thing needs to be filled in so I have all parts answered for this question. Thank You!Please do not use another example in Excel because that is not the way i am suppose to solve it all arguments in EXCEL need to be entered when using  PMT in Excel I have the answer I need to show how I came up with that answer using all the arguments in one box not broken down to 2 diffrent steps. Thanks and here is the answer.298.31