How to use PMT, PPMT, IPMT, FV, PV function in Excel 365


For soft Exercise File Click Download Button

Use  of PMT, PPMT, IPMT, FV, PV function in Excel 365
PMT: Calculates the payment for a loan based on constant payments and a constant interest rates.
PPMT: Returns the payments on the principal for a given investment based on periodic, constant payments and a constant interest rate.
IPMT: Returns the interest payment for a given period for a investment based on periodic, constant payments and a constant interest rate.
NPER: Returns the number of periods for an investment based on periodic, constant payments and constant interests’ rate
PV: Returns the present value of an investment. The total amount that a series of future payments is worth now.

FV: Returns the future value of an investment based on periodic, constant payments and a constant interest rate. 


Comments

Post a Comment

Popular posts from this blog

How to use Absolute, Mixed and Relative cell references in Excel 365

Image
Using $ sing - absolute cell reference in Excel The dollar sign fixes the reference to a given cell no so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references permission you to copy the formula in Excel without changing cell references.   Mixed Cell Reference in Excel Absolute column and relative row, like $B2. When a formula with this reference type is copied to other cells, the $ sign in front of the column letter locks the reference to the specific column so that it never modified. The relative row reference, without the dollar sign, varies depending on the row to which the formula is copied. Relative column and absolute row, like B$2. In this reference type, it's the row's reference that won't change, and the column's reference will. Using F4 key to switch between the absolute, relative, and mixed references   Through the F4 key to you must be able to modify   your form...
Read more

How to use layout tab in Excel 365

Image
Page Layout Tab: This  tab  is used to make changes to the  layout  of the Excel Sheet like orientation, page size, print area, print title, margins, page breaks, scale to fit, gridline, heading, and many options.  this tab in Ribbon consists of 5 groups it deals with layout and page sitting. 
Read more