Results 1 to 4 of 4

PMT Formula help

Threaded View

  1. #1
    Registered User
    Join Date
    02-02-2011
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4

    PMT Formula help

    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!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1