Function Type: Financial
Description:
Returns the number of periods for an investment.
Function Structure:
=NPER(rate, pmt, pv, [fv], [type]).
Argument Breakdown:
rate – The interest rate per period.
pmt – The payment made each period.
pv – The present value, or total value of all payments now.
fv – The future value, or a cash balance you want after the last payment is made. Defaults to 0.
type – When payments are due. 0 = end of period. 1 = beginning of period. Default is 0.
Example:
Still need help with Excel and Google Sheets? Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.
We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.
or you can help me through https://www.buymeacoffee.com/cashheaven 😉
One thought on “NPER”