Using Financial Functions

Problem:

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube