Register now or log in to join your professional community.
la fonction demandée est : AMORLINC
use AMORLINC function to do it
AMORLINC pour fonctionné etc
Financial is a correct function to calculate depreciation, rate of return, future values, and loan payment.
AMORLINC can be used for straight line depreciation. IRR and XIRR can be used for Internal rate of return, FV for future value and PMT for loan payment
FVCalculates the future value of an investment with periodic constant payments and a constant interest rateFVSCHEDULECalculates the future value of an initial principal, after applying a series of compound interest ratesNPVCalculates the net present value of an investment, based on a supplied discount rate, and a series of future payments and incomePVCalculates the present value of an investment (ie. the total amount that a series of future payments is worth now)RECEIVEDCalculates the amount received at maturity for a fully invested SecurityXNPVCalculates the net present value for a schedule of cash flows
PMT (RATE,NPER,PV,FV,TYPE)
use =DB() for Dep
use =PMT for rate of return and loan repayment
To illustrate Excel's most popular financial functions, we consider a loan with monthly payments, an annual interest rate of 6%, a 20-year duration, a present value of $150,000 (amount borrowed) and a future value of 0 (that's what you hope to achieve when you pay off a loan).
We make monthly payments, so we use 6%/12 = 0.5% for Rate and 20*12 = 240 for Nper (total number of periods). If we make annual payments on the same loan, we use 6% for Rate and 20 for Nper.