• Brock Wiscott
  • NEWBIE
  • 0 Points
  • Member since 2019

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
I am tring to create a formula that will provide the same output as Excel's Rate function. Havent been abe to find anything online or in the forum. Any help is greatly appreciated!

Example from Excel:  =RATE(120,-468.67,27483,,0)*12
This formula produces a value of 16.48%
 
Term Months120
Monthly Loan Payment468.67
Financed Amount27,483.00