Computational Finance: Basics: Calculating forward prices in Excel – Part I

1 min read

How to calculate the forward price of a security in Excel

Forward Price of a security with no income

Forward Price of a security with no income is given by the formulap S0ert

.

For example if S0 , the spot price, of the asset is 100. The time to delivery in the forward contract is 6 months (or 0.5 years) and the annual risk free rate is 5%, then the forward price of the security will be:

100 × e0.05 ×0.5 = 102.53

You may calculate this in EXCEL in the following manner:

Forward Price of a security with known cash income

Forward Price of a security with known cash income is given by the formula (S0-I) ert.

For example a security with spot price of 100, pays a dividend whose present value as of today (time 0) is 10. The risk free rate and tenor of the forward contract are as mentioned earlier, i.e. 5% and 0.5 years respectively. The forward price will be:

(100-10) × e0.05 ×0.5 = 92.28

You may calculate this in EXCEL in the following manner:

Forward Price of a security with known dividend yield

Forward Price of a security with known dividend yield is given by the formula S0e(r-q)t.

For example a security with spot price of 100, pays a 10% annual dividend. The risk free rate and tenor of the forward contract are as mentioned earlier, i.e. 5% and 0.5 years respectively. The forward price will be:

100 × e(0.05-0.1) ×0.5 = 97.53

You may calculate this in EXCEL in the following manner:



Share
Published by
Agnes

Recent Posts

Evaluating portfolio performance. A single metric to rule them all?

What is the best way of evaluating portfolio performance allocation strategies? Should we just compare risk, return or risk adjusted…

February 5, 2019 12:51 pm

Project Plain speak – Sense making for the financial world.

6 mins read Introducing Project Plain speak. Currently a work in progress Plain speak focuses on bringing intelligent financial reporting…

January 22, 2019 6:08 am

Oil markets time machine. Past, present and future.

9 mins read What can we learn about oil markets from the last ten years? The next decade. The final…

January 19, 2019 3:47 pm

Signals in the data. Oil prices, tea leaves and crude price direction.

5 mins read What does the data say about future direction of crude oil markets. We look at OPEC spare…

January 19, 2019 12:44 pm

Building a supply side model for crude oil

5 mins read What factors would impact crude oil supply side equation in 2019? Russian non compliance, lower breakeven for…

January 19, 2019 5:14 am

Modeling demand for liquid fuels

5 mins read How would you model demand for crude oil? What are the key components? What is the long…

January 18, 2019 4:46 pm

This website uses cookies.