Possible CalcError? - Excel Practice: Deduction from Capital Available for Unregistered Reinsurance
The reduction formula is ( E + F + G + H + I ) - ( A + B + C + D)
Why we are using column 79 in the calculation?
And why dont we use the LOC* calculation that was already done in the previous cell?
Comments
Which version of that Excel file are you using? The current version is v8. (The formula should indeed refer to column Q, not column S.)
(By the way, your screenshot looks like the capital required for unregistered reinsurance, not the deduction from capital available.)