# Trinomial Model Update - Variable Risk Free, Volatility, Dividend Yield

I have an employee stock options trinomial model that was coded in VBA in Excel that is currently working properly, however, there is a need to have varying risk-free, dividend yield, and volatility over time. Essentially, the problem I'm having is I cannot figure out the underlying mathematics of doing so, such that the trinomial tree is a recombining tree. I need help in this regard if anyone has the expertise to assist me. I may have the approach on this one wrong as well, and quite possibly another solution is the way to go to allow for varying rates, but I could use someone with the expertise to assist. I will provide the options file later, but need to know that you understand the solution to the problem before we begin.

Skills: Finance, Mathematics, Statistics, Visual Basic

Project ID: #4497743

## Awarded to:

Hi there, As head of quantitative analysis, i came across the same problem as yours and solved it as follows: Assuming you have a spot volatility curve v(t) dependent only on time from 0 to T(option expiry), using the More

\$777 USD in 5 days
(0 Reviews)
0.0

## 10 freelancers are bidding on average \$497 for this job

WebDesignall

Hi We are a very serious team, math graduated an master degree in Financial Math, we have the expertise to help you, please check our profile and reviews, thanks in advances best regards

\$644 USD in 5 days
(31 Reviews)
6.4
samitXI

\$670 USD in 10 days
(54 Reviews)
5.8
bchandra1955

Professional from academic institute working in this area can take care

\$555 USD in 3 days
(16 Reviews)
4.0
ouyongbin

I have a phd degree in mathematics and an MS degree in computer science. I am also an option trader, and I understand the concepts well.

\$300 USD in 5 days
(1 Review)
3.7
Solver86

Dear, do you have a formal specification of your problem? Thanks

\$277 USD in 10 days
(8 Reviews)
3.5
akhilturai

Hello Sir,lets discuss about the project!

\$277 USD in 3 days
(7 Reviews)
2.8
gitapodder1989

I am ready to start the project.

\$333 USD in 10 days
(2 Reviews)
1.7
rouxelite

Hello, My bid includes the completion of task including any further consultation regarding my work. I have also sent you a private message regarding my offer.

\$333 USD in 10 days
(1 Review)
1.0
sammir87

Hi, I am an Indian Chartered Accountant (Equivalent to US CPA). Please send me the file along with your specific problem. I can solve your problem. Regards, Samir Ajmerwala

\$555 USD in 5 days
(0 Reviews)
0.0
D3v3loper