Lab6 Spreadsheet

Lab6 Spreadsheet - PLIC Life 15-Mar-00 Assumptions Interest...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: PLIC Life 15-Mar-00 Assumptions Interest InvestmentBase Mortality Expenses Duration Rate Expense Mortality Factors Lapses Per 1000 Per Pol % of Prem Prem Tax Commissions 1 0.08 0.79000 60.00% 10.00% $1.00 $300.00 5.00% 2.50% 100.00% 2 0.08 1.02000 60.00% 10.00% $- $40.00 0.00% 2.50% 6.00% 3 0.08 1.45000 60.00% 10.00% $- $40.00 0.00% 2.50% 6.00% 4 0.08 1.73000 60.00% 10.00% $- $40.00 0.00% 2.50% 6.00% 5 0.08 2.00000 60.00% 10.00% $- $40.00 0.00% 2.50% 6.00% 6 0.08 2.23000 60.00% 10.00% $- $40.00 0.00% 2.50% 6.00% 7 0.08 2.51000 60.00% 10.00% $- $40.00 0.00% 2.50% 6.00% 8 0.08 2.79000 60.00% 10.00% $- $40.00 0.00% 2.50% 6.00% 9 0.08 3.13000 60.00% 10.00% $- $40.00 0.00% 2.50% 6.00% 10 0.08 3.51000 60.00% 10.00% $- $40.00 0.00% 2.50% 6.00% 11 0.08 3.94000 60.00% 10.00% $- $40.00 0.00% 2.50% 3.00% 12 0.08 4.47000 60.00% 10.00% $- $40.00 0.00% 2.50% 3.00% 13 0.08 5.13000 60.00% 10.00% $- $40.00 0.00% 2.50% 3.00% 14 0.08 5.82000 60.00% 10.00% $- $40.00 0.00% 2.50% 3.00% 15 0.08 6.48000 60.00% 10.00% $- $40.00 0.00% 2.50% 3.00% 16 0.08 7.27000 60.00% 10.00% $- $40.00 0.00% 2.50% 3.00% 17 0.08 8.01000 60.00% 10.00% $- $40.00 0.00% 2.50% 3.00% 18 0.08 8.82000 60.00% 10.00% $- $40.00 0.00% 2.50% 3.00% 19 0.08 9.73000 60.00% 10.00% $- $40.00 0.00% 2.50% 3.00% 20 0.08 10.75000 60.00% 10.00% $- $40.00 0.00% 2.50% 3.00% Average Size: 150 Policy Fee: 50 Net Inv...
View Full Document

This note was uploaded on 01/19/2012 for the course MA 17000 taught by Professor Nicholaswegman during the Fall '11 term at Purdue University.

Page1 / 4

Lab6 Spreadsheet - PLIC Life 15-Mar-00 Assumptions Interest...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online