Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 54 views

    3.NPER Function Excel Template 1

    Uploaded by

    w_fib
    Ms. ABC took out a loan of Rs. 1,000,000 at an 8% annual interest rate. She pays Rs. 10,000 monthly as the EMI. She wants to know how many months it will take to pay back the loan. The NPER function in Excel can calculate this. It provides the number of periods (months or years) based on the present value (loan amount), interest rate, payment amount, and type (whether payments are made at the start or end of period).

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    3.NPER Function Excel Template 1

    Uploaded by

    w_fib
    54 views9 pages
    Ms. ABC took out a loan of Rs. 1,000,000 at an 8% annual interest rate. She pays Rs. 10,000 monthly as the EMI. She wants to know how many months it will take to pay back the loan. The NPER function in Excel can calculate this. It provides the number of periods (months or years) based on the present value (loan amount), interest rate, payment amount, and type (whether payments are made at the start or end of period).

    Original Description:

    NPER functions model

    Original Title

    3.NPER Function Excel Template 1 .Xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Ms. ABC took out a loan of Rs. 1,000,000 at an 8% annual interest rate. She pays Rs. 10,000 monthly as the EMI. She wants to know how many months it will take to pay back the loan. The NPER function in Excel can calculate this. It provides the number of periods (months or years) based on the present value (loan amount), interest rate, payment amount, and type (whether payments are made at the start or end of period).

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    54 views9 pages

    3.NPER Function Excel Template 1

    Uploaded by

    w_fib
    Ms. ABC took out a loan of Rs. 1,000,000 at an 8% annual interest rate. She pays Rs. 10,000 monthly as the EMI. She wants to know how many months it will take to pay back the loan. The NPER function in Excel can calculate this. It provides the number of periods (months or years) based on the present value (loan amount), interest rate, payment amount, and type (whether payments are made at the start or end of period).

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 9

    NPER Function Excel Template

    Visit: www.educba.com

    Email: info@educba.com
    Loan Amount(PV) 1000000
    Interest Rate(Yearly) 8%
    NPER (Years) 13.8
    Monthly Payment -10000 Ms ABC took a loan of Rs.1000000 at an interest rate of
    NPER (Months) 165.3 monthly EMI amount of Rs.10000. She wants to find out
    her loan?

    https://www.educba.com/nper-function-in-excel/ Loan = PV(present value).


    8%=i
    Pmt= 10000
    m=12
    Loan Amount(PV) 1000000 total number of periods=Nper=how long the payme
    Interest Rate(Yearly) 8%
    NPER (Years) 13.78 nper
    Monthly Payment -10000 pv/fv 1000000
    NPER (Months) 165.34 i 8%
    pmt 10000
    .1000000 at an interest rate of 8% per annum(per year). She can pay a
    Rs.10000. She wants to find out the number of months to pay back

    e).

    s=Nper=how long the payment should be made?


    Loan Amount (PV) 1000000
    Interest Rate (Yearly) 8%
    Type 1
    Monthly Payment -10000 In the same above example, we will use Type to get periods in m
    NPER (Years) 13.6133547239314 and year, respectively.
    NPER (Months) 163.360256687177
    There is a difference observed in the value calculated for NPER (
    or NPER (Years) based on the Type.
    If Type is set to 0 or omitted, payments are due at the end of the
    165.34054113031 If Type is set to 1, payments are due at the start of the period.

    Exam
    ple 
    use Type to get periods in month

    e value calculated for NPER (Months)


    ents are due at the end of the period.
    e at the start of the period.
    Annual Interest Rate 15%
    Payment Per Period -15000
    FV 20000000
    Ms ABC is doing financial planning for her retirement. She plans
    PV 0 investing Rs.45000 after each three month at a fixed rate of inte
    Type 0 periods that she needs to make an amount of Rs.2,00,00,000?
    Periods (In Months) 231.16723701935
    Periods (In Years) 8.9 p.a.= per annum=year
    106.80
    for her retirement. She plans to make an amount of Rs.2,00,00,000 by
    e month at a fixed rate of interest of 15% p.a. Calculate the number of
    amount of Rs.2,00,00,000?
    Annual Interest Rate 15%
    Payment Per Period -15000
    FV 20000000
    PV 0
    Type 1 Taking the above example, we will use Type 1 to get
    Periods (In Months)
    Things to Remember About NPER Function in Exce
    Periods (In Years) As per the cash flow convention, outgoing payment
    as positive.
    The currency, by default, is the dollar ($). This can b
    Fv and Type are optional.
    Payment and rate are adjusted with regards to a pe
    annually, etc.
    Annual Interest Rate 15% Always use the “=” sign for writing the formula in th
    Payment Per Period -15000
    FV 20000000
    PV 0
    Type 1
    Periods (In Months) 230.224173694
    Periods (In Years) 19.2
    ple, we will use Type 1 to get periods in month and year, respectively.

    bout NPER Function in Excel


    nvention, outgoing payments are marked as negative and incoming cash flows

    t, is the dollar ($). This can be changed as per the following –


    al.
    djusted with regards to a period such as monthly, quarterly, half-yearly,

    for writing the formula in the active cell.

    You might also like