Suppose a share was priced at price P 0 at time 0, and suppose that at time 1 it will be priced P1. Then the continuously compounded return is defined as return = In(P₁/P₀). Implement this function in VBA. There are two ways to do this: You can use Worksheetfunction.Ln or the VBA function Log.

Transcribed Image Text:

A В C D 18 Exercise 3 19 20 PO P1 110 200 0.693147181<-- =Exercise3(A22,B22) 110 200 0.693147181 <-- =Exercise3a(A24,B24) 21 100 0.09531018 <-- =Exercise3(A21,B21) 100 100 22 23 0.09531018 <-- =Exercise3a(A23,B23) 24 100