[Free ebook]Understanding of Microsoft Excel: Some Important & Basic Points by DK Gupta - KING OF EXCEL

KING OF EXCEL

KINGEXCEL.INFO ( KING OF EXCEL ) Welcome KINGEXCEL.INFO - Nothing Is Unable ... About Excel Tricks, Learning VBA Programming, Dedicated Software, Accounting, Living Skills ...

Saturday, March 28, 2020

[Free ebook]Understanding of Microsoft Excel: Some Important & Basic Points by DK Gupta

[Free ebook]Understanding of Microsoft Excel: Some Important & Basic Points by DK Gupta


DOWNLOAD PDF
DOWNLOAD AZW3

Author:DK Gupta
Language: eng
Format: azw3 + pdf
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
#evba #etipfree #eama #kingexcel

📤How to Download ebooks: https://www.evba.info/2020/02/instructions-for-downloading-documents.html?m=1

No comments:

Post a Comment