Categories: Computational Finance Derivatives Example Middle Office Misc. Options Pricing Treasury Products Treasury Sales

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 known cash income

## Forward Price of a security with known dividend yield

Forward Price of a security with no income is given by the formulap **S _{0}e^{rt}**

.

For example if **S _{0 , }**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 × e^{0.05 ×0.5} = 102.53

You may calculate this in EXCEL in the following manner:

Forward Price of a security with known cash income is given by the formula **(S _{0}-I) e^{rt}**.

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) × e^{0.05 ×0.5} = 92.28

You may calculate this in EXCEL in the following manner:

Forward Price of a security with known dividend yield is given by the formula **S _{0}e^{(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:

Published by

January 30, 2012 6:07 pm

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

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

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

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

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

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.