[go: up one dir, main page]
Scribd
Upload
33 views13 pages

Cash Flow Dates 100.19 Discount Rate: XNPV Function 1 2 3 4 5

The document provides various financial functions and their calculations, including XNPV, XIRR, MIRR, PMT, IPMT, EFFECT, DB, Duration, RATE, FV, and SLOPE. Each function is accompanied by cash flow data, dates, and relevant financial metrics such as NPV, IRR, PMT amounts, and depreciation. Additionally, it includes formulas for calculating future value and slope in relation to stock and index changes.

Uploaded by

Naresh Kumar
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
33 views13 pages

Cash Flow Dates 100.19 Discount Rate: XNPV Function 1 2 3 4 5

The document provides various financial functions and their calculations, including XNPV, XIRR, MIRR, PMT, IPMT, EFFECT, DB, Duration, RATE, FV, and SLOPE. Each function is accompanied by cash flow data, dates, and relevant financial metrics such as NPV, IRR, PMT amounts, and depreciation. Additionally, it includes formulas for calculating future value and slope in relation to stock and index changes.

Uploaded by

Naresh Kumar
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
You are on page 1/ 13

XNPV Function

1 2 3 4 5

Cash Flow (500) 150 125 175 350

Dates 8/17/2017 12/31/2017 12/31/2018 12/31/2019 6/30/2020

NPV 160 ₹ 100.19

Discount Rate 10%


XIRR Function

1 2 3 4 5

Cash Flow (500) 150 125 175 350

Dates 8/17/2017 12/31/2017 12/31/2018 12/31/2019 6/30/2020

IRR 27% 18%


MIRR Function

1 2 3 4 5

Cash Flow (500) 150 125 175 350

Dates 8/17/2017 12/31/2017 12/31/2018 12/31/2019 6/30/2020

MIRR 15%

Borrowing Cost 5%

Reinvestment 8%
PMT Function

Rate (per period) 4.5%

# of Periods 30

Present value 1,000,000

PMT (61,392)

Monthly PMT (5,115.96)


IPMT Function

Rate (per period) 4.5%

Current Period 10

# of Periods 30

Present value 1,000,000

IPMT (37,032)
EFFECT Function

Interest Rate 20.00%


Compounding frequency
# of periods per year 2 10% 1

Annual Interest Rate 21.00% m FV = PV*(1+r/m)^mn


ompounding frequency
10%

V = PV*(1+r/m)^mn
DB Function

Cost 1,000,000

Salvage value 50,000

Life (# of periods) 12

Current Period 3

DB Depreciation 134,112
Duration Function

Settlement 6/30/2018

Maturity 6/30/2029

Coupon 5.0%

Yield 12.0%

Duration 7.90
RATE Function

# of Periods 10

Coupon (per period) 100

Cost of Bond (950)

Face Value of Bond 1,000

Yield to Maturity (YTM) 12.1%


FV Function

Rate (per period) 4.5%

# of Periods 30

Payments (per period) 1,000,000

Starting Value 25,000,000

Future Value (154,640,023)


SLOPE Function y = a+bx
change change
Index Stock a = y intercept
-1% -2% BetA 1.5
-1% -2% b = slope
-6% -9%
9% 14%
11% 17%
3% 5%
10% 15%
-5% -8%
3% 5%
5% 8%
6% 9%
1% 2%
-2% -3%

Beta (slope) 1.5


y = dependent variable
x = independent variable
a = y intercept

You might also like