» Using Financial Functions
CATEGORY - Excel Financial Formulas
VERSION - All Microsoft Excel Versions
The range B2:G6 contains some of the following parameters for a number of different loans (each occupying a separate column):
Principal, interest rate, total number of payments, and monthly payment.
Based on those details, we want to calculate the following:
1. Monthly payment for the loan detailed in column B.
2. Principal payments in the first month, first year, and last year for the loan detailed in column C.
3. Total number of payments for the loan detailed in column D.
4. Interest rate for the loan detailed in column E.
5. Present value of the loan detailed in column F.
6. First month's interest payment for the loan detailed in column G.
Solution:
Use the formulas as shown in the screenshot.
Book Store:
Recommended Books:
- Microsoft Excel 2002 Simply Visual
- Business Analysis with Microsoft Excel (2nd Edition)
- Microsoft Office XP Step-By-Step (With CD-ROM)
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Now, Discover Your Strengths
- How to Use Financial Statements: A Guide to Understanding the Numbers
this sucks
TEreba
Screenshot not present.. tip sucks..
Add DR symbol
javed
How can I add DR (Debit) symbol in Excel.
