Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

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

user-image
Question added by PHILIP MALINAO , Fleet Controller-Operation Supervisor , United Global Services (TM.Co)
Date Posted: 2016/03/13
Nacer Djouadj
by Nacer Djouadj , مسير , eurl bam bam

la fonction  demandée est :  AMORLINC

Guy Anoh
by Guy Anoh , Deputy Director , he Primary School of

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

Ahmed rekabi
by Ahmed rekabi , Broker , Noon FX

use AMORLINC function to do it 

أشرف عبد الرؤوف sari
by أشرف عبد الرؤوف sari , achteur/condicteur , كوبيدا

AMORLINC pour fonctionné etc 

Arslan Azam
by Arslan Azam , Audit Internn , Deloitte Yousaf Adil

Financial is a correct function to calculate depreciation, rate of return, future values, and loan payment.

Jigar Sawla
by Jigar Sawla , Manager , ICICI Bank Ltd.

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

 

Kafeel Sheikh Kafeel Ahmad
by Kafeel Sheikh Kafeel Ahmad , A GRADE , NISHAD COLLEGE OF NURSING AND ALLIED SCIENCES

PMT (RATE,NPER,PV,FV,TYPE)

 

Financial functions (reference)

Imran Bhatti
by Imran Bhatti , Accounts Executive , Road Prince

use =DB() for Dep

use =PMT for rate of return and loan repayment

 

Sufia Tarannum Syed
by Sufia Tarannum Syed , Retention officer , HSBC Global services

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.

More Questions Like This