Scribd
Upload
35 views5 pages

Financial Functions Formulas

The document contains examples and explanations of various date, time, and financial functions in Microsoft Excel including: 1. Date functions such as NOW(), TODAY(), and DAYS360() 2. Time functions such as converting times to a decimal number format 3. Financial functions including FUTURE VALUE, PRESENT VALUE, NET PRESENT VALUE, RATE, NPER, and INTERNAL RATE OF RETURN. 4. Examples are provided of calculating loan amounts, interest rates, payment amounts, and rates of return on investments using the different financial functions.

Uploaded by

Nithesh P
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
35 views5 pages

Financial Functions Formulas

The document contains examples and explanations of various date, time, and financial functions in Microsoft Excel including: 1. Date functions such as NOW(), TODAY(), and DAYS360() 2. Time functions such as converting times to a decimal number format 3. Financial functions including FUTURE VALUE, PRESENT VALUE, NET PRESENT VALUE, RATE, NPER, and INTERNAL RATE OF RETURN. 4. Examples are provided of calculating loan amounts, interest rates, payment amounts, and rates of return on investments using the different financial functions.

Uploaded by

Nithesh P
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

date

7/24/2023 DATE AND FUNCTIONS


1
time 2
2:24 PM 3
4
3/20/2024 10:28 now 5
3/20/2024 today 6
7
day 6/15/2021 6/15/2023 8
6 7/15/2023
-43725 22
5/12/2000 may 2020
6/15/2023 june 2021 23.4277778
8313

5/1/2023
6/1/2023
24

23
DATE AND FUNCTIONS
DATE
TIME
DAY
DATEVALUE
TODAY
DAYS360
NETWORKDAYS
YEARFRAC
FINANCIAL FUNCTIONS
1 FUTURE VALUE(FV) 4 INTERNAL RATE OF RETURN(IRR)
FV=100000 INITIAL INVESTMENT=1000
RATE=5% FV(RATE,NPER,PMT,(FV),(TYPE)) RETURN 1ST YEAR=300
TERM=0 FV(RATE/12,TERM*12,-FV) RETURN 2ND YEAR=400
PERIODS=12 ENTER RETURN3RD YEAR=400
RETURN 4TH YAER=300
2 PRESENT VALUE(PV)
INT RATE=5% 5 NPER
NO OF PMT=20 PV(RATE,NO OF PMT,AMT,FV) LOAN AMT=5000
PMT AMT=10000 INTEREST RATE=4.5%
FV=5000 MONTHLY PMT=93
PERIODS=12
3 NET PRESENT VALUE(NPV)
RATE OF DISCOUNT=5% 6 RATE
INITIAL INVESTMENT=1000 IRR(SELECT ALL) YEAR=6 RATE(YEAR,-PMT,LOAN)
RETURN 1ST YEAR=300 PMT=-200
RETURN 2ND YEAR=400 LOAN=1000
RETURN 3RD VALUE=400
RETURN 4TH VALUE=300
RATE OF RETURN(IRR)
VESTMENT=1000
1ST YEAR=300 IRR(SELECT ALL)
2ND YEAR=400
RD YEAR=400
4TH YAER=300

NPER(RATE/12,PMT,-AMT)
RATE=4.5%

RATE(YEAR,-PMT,LOAN)
₹ 695,823,971.33
₹ 15,528,227.94

₹ 122,737.66

₹ 240.87

-1000 -5000
300 500
400 490
300 600
400 550
14% -27%

5000
4.50%
93
12
60

5%

12%
12
0.13

You might also like