1 | Year | Target's Salary | Child Support Revenue | Expenses | Profit |
|---|---|---|---|---|---|
2 | 2015 | $188,069 | $31,972 | $4,300 | $27,672 |
3 | 2016 | $191,831 | $32,611 | $4,386 | $28,225 |
4 | 2017 | $195,667 | $33,263 | $4,474 | $28,790 |
5 | 2018 | $199,580 | $33,929 | $4,563 | $29,365 |
6 | 2019 | $203,572 | $34,607 | $4,654 | $29,953 |
7 | 2020 | $207,644 | $35,299 | $4,748 | $30,552 |
8 | 2021 | $211,796 | $36,005 | $4,842 | $31,163 |
9 | 2022 | $216,032 | $36,725 | $4,939 | $31,786 |
10 | 2023 | $220,353 | $37,460 | $5,038 | $32,422 |
11 | 2024 | $224,760 | $38,209 | $5,139 | $33,070 |
12 | 2025 | $229,255 | $38,973 | $5,242 | $33,732 |
13 | 2026 | $233,840 | $39,753 | $5,347 | $34,406 |
14 | 2027 | $238,517 | $40,548 | $5,453 | $35,094 |
15 | 2028 | $243,287 | $41,359 | $5,563 | $35,796 |
16 | 2029 | $248,153 | $42,186 | $5,674 | $36,512 |
17 | 2030 | $253,116 | $43,030 | $5,787 | $37,243 |
18 | 2031 | $258,179 | $43,890 | $5,903 | $37,987 |
19 | 2032 | $263,342 | $44,768 | $6,021 | $38,747 |
20 | 2033 | $268,609 | $45,664 | $6,141 | $39,522 |
21 | 2034 | $273,981 | $46,577 | $6,264 | $40,313 |
22 | 2035 | $279,461 | $47,508 | $6,390 | $41,119 |
23 | 2036 | $285,050 | $48,459 | $6,517 | $41,941 |
24 | |||||
25 | Raw total | $872,796 | $755,411 | ||
26 | Net present value | $555,774 | $481,026 | ||
27 | Life Insurance | $250,000 | |||
28 | Child support difference | $231,026 | |||
29 | |||||
30 | Assumptions | ||||
31 | inflation rate | 0.02 | |||
32 | discount rate | 0.04 | |||
33 | |||||
34 | Vince Viafore's salary was $167,000 in 2009. Used inflation rate to estimate salary in later years | ||||
35 | |||||
36 | Expenses of a child: Professor William Comanor, UCLA based on CEX data set. |