Robbin PV CF Return Model Exhibit 6A

I am reproducing the exhibit, but cannot determine how to arrive at the Surplus used in the Present Value Column. I am backing into it by using the equity-to-surplus ratio, but it gives a different value.

Attached Files

Exhibit 6A.xlsx (16.9 KB)

Robbin PV CF Return Model Exhibit 6A