Hello, I'm new to excel and not very good with numbers. I would really appreciate some help with my school work. I'm more of a visual learner and would like to know the correct formula for the Rate/Nyper/PV to insert in cell b5.
"The answer will be $52,548.I have attached the worksheet (goal worksheet) I am working on. In cell b5 , insert the PMT function using the data from range b2:b4. Be sure to convert the interest rate and period to reflect monthly payments by dividing the interest rate by 12 and multiplying the years by 12. Display the result as a positive number."
Thank you so much!
Bookmarks