Excel Forum



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.