In excel, Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

la fonction  demandée est :  AMORLINC

In excel, the function  used to calculate depreciation, rates of return, future values and loan payment amounts is 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)

 

Financial functions (reference)

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.