Main Profile

At A Glance

Excel Finance Trick #6: RATE function and Loan Points

See how to use the RATE function to calculate an adjusted rate when there are Loan Points. Period rate = RATE function. In This Series learn 17 amazing Finance Tricks. Learn about the PMT, PV, FV, NPER, RATE, SLN, DB, EFFECT, NOMINAL, NPV, XNPV, and the CUMIPMT functions that can make your financing tasks much easier in Excel. See how to use the PMT function in the standard way, but also see how to use it while incorporating a Balloon payment or a delayed payment. Lean how to translate a Nominal interest rate into an Effective Interest rate. Learn how to calculate how long it takes to pay off a credit card balance. Lean how to calculate the Effect Rate on a Payday loan. And many more financing Tricks!! The Excel Finance Tricks 1-17 will show an assortment of Excel Financing Tricks! Formula
Length: 04:13

Contact

Questions about Excel Finance Trick #6: RATE function and Loan Points

Want more info about Excel Finance Trick #6: RATE function and Loan Points? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question