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

Category:

Education

Tags:

• Excel
• RATE
• EFFECT
• NOMINAL
• NPER
• function
• adjusted
• interest
• rate
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[secretarul]

This was a good one ! I need to review this ...

Thank you !

[ExcelIsFun]

You are welcome!

[kiel6282]

When do you use ear, apr, irr, xirr?