Skip to Main Content
Excel Formulas and Functions For Dummies, 3rd Edition
book

Excel Formulas and Functions For Dummies, 3rd Edition

by Ken Bluttman
February 2013
Beginner content levelBeginner
408 pages
9h 10m
English
For Dummies
Content preview from Excel Formulas and Functions For Dummies, 3rd Edition

Chapter 5

Calculating Loan Payments and Interest Rates

In This Chapter

arrow Formatting monetary values

arrow Estimating loan payments

arrow Determining the number of payments

arrow Calculating the number of periods

arrow Calculating interest

arrow Calculating the principal loan amount

A penny saved is a penny earned. A penny by itself is not much. But add a little savings here and there over the life of a loan, and the sum could be significant! Just think of what you can do with the extra money — extend a vacation, give it to charity, or save it for a rainy day.

Taking out a car loan, a mortgage, or another type of loan involves planning how you want to manage the loan payments. In the simplest terms, all you may need to know is the amount of your monthly payment. But knowing the components of a loan and being able to compare one loan with another can help you to manage your financial resources in your own best interest. ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Formulas & Functions For Dummies, 5th Edition

Excel Formulas & Functions For Dummies, 5th Edition

Ken Bluttman

Publisher Resources

ISBN: 9781118460856Purchase book