[BattleCards] calculate DPAE (modeled on Fall.2015 #12

chrisboersmachrisboersma
in CIA.PrLiabs

The:
PV factor @ i%
PV factor @ i-mfad%
do not refresh when you hit "new"

It appears as though the system still uses the unrefreshed values in the next calculations (although they are based on incorrect discount rates).

Refreshing the page refreshes the factor calculations.

Comments

  • grahamgraham

    I made a typo last week when I edited the javascript for that page. I've corrected it. Thanks for bringing it to my attention.

  • jc2018jc2018

    There seems to be an error in the formula when you click "cheat".

    PVfctr @ discount rate = 0.8929 = 0.8857 x (1 + 1.05)(0.5 - 1/3)
    PVfctr with MfAD = 0.9129 = 0.907 x (1 + 1.04)(0.5 - 1/3)

    it says 1 + 1.05 but it should just be 1.05 (or 1+ 0.05) and same for the one with MfAD.

  • grahamgraham

    Oops, thanks. I've correct it now.

  • grahamgraham

    I think it's your APV formula. The last summand in your Excel formula is:

    • (F1 - K1) * B10 * D4

    But the right parenthesis is in the wrong place. It should be:

    • (F1 - K1*B10) * D4

    When I do the calculation, I get a final answer of DPAE = 2,565, PolLiabs(UPR) = 70,965, and APV = 61,645.

    I hope I read your Excel spreadsheet correctly. Let me know if I didn't.

Sign In or Register to comment.