ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل PHILIP MALINAO , Fleet Controller-Operation Supervisor , United Global Services (TM.Co)
تاريخ النشر: 2016/03/13
Guy Anoh
من قبل 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
من قبل Ahmed rekabi , Broker , Noon FX

use AMORLINC function to do it 

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

AMORLINC pour fonctionné etc 

Arslan Azam
من قبل 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
من قبل 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

ayman income
من قبل ayman income

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
من قبل Kafeel Sheikh Kafeel Ahmad , A GRADE , NISHAD COLLEGE OF NURSING AND ALLIED SCIENCES

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

Imran Bhatti
من قبل Imran Bhatti , Accounts Executive , Road Prince

use =DB() for Dep

use =PMT for rate of return and loan repayment

 

Sufia Tarannum Syed
من قبل 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.

المزيد من الأسئلة المماثلة