Understanding of Microsoft Excel: Some Important & Basic Points by DK Gupta

Author:DK Gupta
Language: eng
Format: azw3
Published: 2017-08-19T07:00:00+00:00

Q. Suppose you are borrowing a loan of Rs.500000/- for a period of 10 years at 10% rate of interest per year. Write Spreadsheet function to find principal part and interest part of loan payment for 20th and 40th installment.

Ans:

=PPMT(10%/12,20,120,-500000,0,0) in cell A2 and press enter key.

=IPMT(10%/12,20,120,-500000,0,0) in cell B2 and press enter key.

=PPMT(10%/12,40,120,-500000,0,0) in cell A2 and press enter key.

=IPMT(10%/12,40,120,-500000,0,0) in cell B2 and press enter key.

NPER:

The NPER function returns the number of payment periods for a loan, given the loan’s amount, interest rate, and periodic payment amount.

The syntax for the NPER function is

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.