» 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:
- Now, Discover Your Strengths
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Writing Excel Macros with VBA, 2nd Edition
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- The 11 Immutable Laws of Internet Branding
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
this sucks
TEreba
Screenshot not present.. tip sucks..
Add DR symbol
javed
How can I add DR (Debit) symbol in Excel.
