Similar Content
PMT Function - Get the Payment Due for a Loan in Excel
Tutorial: How to calculate the payment amount for a loan or similar financial instrument that has a ...
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...
Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc.
Tutorial: In Excel you can store values in Defined Names.  Often people use a Defined Name to refe...

Highline Excel Class 48: Interest Rates 6 Examples

See the Excel functions RATE, EFFECT, NOMINAL, NPER solve these problems:
1.Calculate Adjusted Interest Rate For Loans With Points using the RATE function
2.See Math formula to calculate the Effective Interest Rate for a loan given the APR or Nominal Rate
3.See the EFFECT function to calculate the Effective Interest Rate for a loan given the APR or Nominal Rate
4.Solve this finance problem: Savings Plan that compounds interest 365 times a year, but you put money in 12 times a year. What is future Value?
5.How long to pay off your credit Card if you pay only the minimum PMT required? See the NPER function.
6.Use the NPER function to calculate how long it takes to pay off your credit card balance when you make only the minimum payment
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Got a Question? Ask it Here in the Forum.