FINANCIAL MODELING EXAM

profileFefivr1
F380.fall18.exam1.data.solutions1.xlsx
Home>Computer Science homework help>FINANCIAL MODELING EXAM

EARLY

Amount Borrowed $ 300,000.00
Life of Loan (Years) 3
Annual Interest Rate 6.00%
True Payment $9,126.58
+10 Payment $10,039.24
Life of +10 Loan in months 33
Period Beginning Balance Interest Payment Ending Balance Principal Recovery
1 $ 300,000.00 $ 1,500.00 $ (10,039.24) $ 291,460.76 $ 8,539.24
2 $ 291,460.76 $ 1,457.30 $ (10,039.24) $ 282,878.83 $ 8,581.94
3 $ 282,878.83 $ 1,414.39 $ (10,039.24) $ 274,253.98 $ 8,624.85
4 $ 274,253.98 $ 1,371.27 $ (10,039.24) $ 265,586.01 $ 8,667.97
5 $ 265,586.01 $ 1,327.93 $ (10,039.24) $ 256,874.70 $ 8,711.31
6 $ 256,874.70 $ 1,284.37 $ (10,039.24) $ 248,119.84 $ 8,754.87
7 $ 248,119.84 $ 1,240.60 $ (10,039.24) $ 239,321.20 $ 8,798.64
8 $ 239,321.20 $ 1,196.61 $ (10,039.24) $ 230,478.56 $ 8,842.63
9 $ 230,478.56 $ 1,152.39 $ (10,039.24) $ 221,591.72 $ 8,886.85
10 $ 221,591.72 $ 1,107.96 $ (10,039.24) $ 212,660.43 $ 8,931.28
11 $ 212,660.43 $ 1,063.30 $ (10,039.24) $ 203,684.50 $ 8,975.94
12 $ 203,684.50 $ 1,018.42 $ (10,039.24) $ 194,663.68 $ 9,020.82
13 $ 194,663.68 $ 973.32 $ (10,039.24) $ 185,597.76 $ 9,065.92
14 $ 185,597.76 $ 927.99 $ (10,039.24) $ 176,486.51 $ 9,111.25
15 $ 176,486.51 $ 882.43 $ (10,039.24) $ 167,329.70 $ 9,156.81
16 $ 167,329.70 $ 836.65 $ (10,039.24) $ 158,127.11 $ 9,202.59
17 $ 158,127.11 $ 790.64 $ (10,039.24) $ 148,878.51 $ 9,248.60
18 $ 148,878.51 $ 744.39 $ (10,039.24) $ 139,583.66 $ 9,294.85
19 $ 139,583.66 $ 697.92 $ (10,039.24) $ 130,242.34 $ 9,341.32
20 $ 130,242.34 $ 651.21 $ (10,039.24) $ 120,854.31 $ 9,388.03
21 $ 120,854.31 $ 604.27 $ (10,039.24) $ 111,419.34 $ 9,434.97
22 $ 111,419.34 $ 557.10 $ (10,039.24) $ 101,937.20 $ 9,482.14
23 $ 101,937.20 $ 509.69 $ (10,039.24) $ 92,407.65 $ 9,529.55
24 $ 92,407.65 $ 462.04 $ (10,039.24) $ 82,830.45 $ 9,577.20
25 $ 82,830.45 $ 414.15 $ (10,039.24) $ 73,205.36 $ 9,625.09
26 $ 73,205.36 $ 366.03 $ (10,039.24) $ 63,532.15 $ 9,673.21
27 $ 63,532.15 $ 317.66 $ (10,039.24) $ 53,810.57 $ 9,721.58
28 $ 53,810.57 $ 269.05 $ (10,039.24) $ 44,040.38 $ 9,770.19
29 $ 44,040.38 $ 220.20 $ (10,039.24) $ 34,221.34 $ 9,819.04
30 $ 34,221.34 $ 171.11 $ (10,039.24) $ 24,353.21 $ 9,868.13
31 $ 24,353.21 $ 121.77 $ (10,039.24) $ 14,435.74 $ 9,917.47
32 $ 14,435.74 $ 72.18 $ (10,039.24) $ 4,468.68 $ 9,967.06
33 $ 4,468.68 $ 22.34 $ (4,491.02) $ - 0 $ 4,468.68

FVGA

Year 1 Payment $ 1,500.00
Life of Annuity 15
Interest Rate 7.00%
Growth Rate 5.00%
FVGA $ 51,007.75
Year Beginning Balance Interest Payment Ending Balance
1 $ - 0 $ - 0 $ 1,500.00 $ 1,500.00
2 $ 1,500.00 $ 105.00 $ 1,575.00 $ 3,180.00
3 $ 3,180.00 $ 222.60 $ 1,653.75 $ 5,056.35
4 $ 5,056.35 $ 353.94 $ 1,736.44 $ 7,146.73
5 $ 7,146.73 $ 500.27 $ 1,823.26 $ 9,470.26
6 $ 9,470.26 $ 662.92 $ 1,914.42 $ 12,047.60
7 $ 12,047.60 $ 843.33 $ 2,010.14 $ 14,901.08
8 $ 14,901.08 $ 1,043.08 $ 2,110.65 $ 18,054.81
9 $ 18,054.81 $ 1,263.84 $ 2,216.18 $ 21,534.82
10 $ 21,534.82 $ 1,507.44 $ 2,326.99 $ 25,369.25
11 $ 25,369.25 $ 1,775.85 $ 2,443.34 $ 29,588.44
12 $ 29,588.44 $ 2,071.19 $ 2,565.51 $ 34,225.14
13 $ 34,225.14 $ 2,395.76 $ 2,693.78 $ 39,314.69
14 $ 39,314.69 $ 2,752.03 $ 2,828.47 $ 44,895.19
15 $ 44,895.19 $ 3,142.66 $ 2,969.90 $ 51,007.75

RETIRE

Today's Salary $ 60,000.00 Bond Fund Stock Fund Guaranteed Fund
Annual Growth in Salary 3.00% Age Salary Investment Beginning Balance Interest Deposit Ending Balance Beginning Balance Interest Deposit Ending Balance Beginning Balance Interest Deposit Ending Balance Total Portfolio
Proportion Of Salary Invested 5.00% 21 $ 60,000.00 $ 3,000.00 $ 10,000.00 $ 400.00 $ 600.00 $ 11,000.00 $ 20,000.00 $ 2,000.00 $ 2,400.00 $ 24,400.00 $ 35,400.00
22 $ 61,800.00 $ 3,090.00 $ 11,000.00 $ 440.00 $ 618.00 $ 12,058.00 $ 24,400.00 $ 2,440.00 $ 2,472.00 $ 29,312.00 $ 41,370.00
Age Today 21 23 $ 63,654.00 $ 3,182.70 $ 12,058.00 $ 482.32 $ 636.54 $ 13,176.86 $ 29,312.00 $ 2,931.20 $ 2,546.16 $ 34,789.36 $ 47,966.22
Age At Retirement 66 24 $ 65,563.62 $ 3,278.18 $ 13,176.86 $ 527.07 $ 655.64 $ 14,359.57 $ 34,789.36 $ 3,478.94 $ 2,622.54 $ 40,890.84 $ 55,250.41
Age at Death 84 25 $ 67,530.53 $ 3,376.53 $ 14,359.57 $ 574.38 $ 675.31 $ 15,609.26 $ 40,890.84 $ 4,089.08 $ 2,701.22 $ 47,681.15 $ 63,290.40
26 $ 69,556.44 $ 3,477.82 $ 15,609.26 $ 624.37 $ 695.56 $ 16,929.19 $ 47,681.15 $ 4,768.11 $ 2,782.26 $ 55,231.52 $ 72,160.71
Initial Deposit in Bond Fund $ 10,000.00 27 $ 71,643.14 $ 3,582.16 $ 16,929.19 $ 677.17 $ 716.43 $ 18,322.79 $ 55,231.52 $ 5,523.15 $ 2,865.73 $ 63,620.40 $ 81,943.19
Return on Bonds 4.00% 28 $ 73,792.43 $ 3,689.62 $ 18,322.79 $ 732.91 $ 737.92 $ 19,793.63 $ 63,620.40 $ 6,362.04 $ 2,951.70 $ 72,934.13 $ 92,727.76
Initial Deposit in Stock Fund $ 20,000.00 29 $ 76,006.20 $ 3,800.31 $ 19,793.63 $ 791.75 $ 760.06 $ 21,345.44 $ 72,934.13 $ 7,293.41 $ 3,040.25 $ 83,267.79 $ 104,613.23
Return on Stocks 10.00% 30 $ 78,286.39 $ 3,914.32 $ 21,345.44 $ 853.82 $ 1,174.30 $ 23,373.55 $ 83,267.79 $ 8,326.78 $ 2,740.02 $ 94,334.60 $ 117,708.15
Guaranteed Return 3.00% 31 $ 80,634.98 $ 4,031.75 $ 23,373.55 $ 934.94 $ 1,209.52 $ 25,518.02 $ 94,334.60 $ 9,433.46 $ 2,822.22 $ 106,590.28 $ 132,108.30
32 $ 83,054.03 $ 4,152.70 $ 25,518.02 $ 1,020.72 $ 1,245.81 $ 27,784.55 $ 106,590.28 $ 10,659.03 $ 2,906.89 $ 120,156.20 $ 147,940.75
Retirement Benefit $ 268,540.62 33 $ 85,545.65 $ 4,277.28 $ 27,784.55 $ 1,111.38 $ 1,283.18 $ 30,179.11 $ 120,156.20 $ 12,015.62 $ 2,994.10 $ 135,165.92 $ 165,345.03
34 $ 88,112.02 $ 4,405.60 $ 30,179.11 $ 1,207.16 $ 1,321.68 $ 32,707.96 $ 135,165.92 $ 13,516.59 $ 3,083.92 $ 151,766.43 $ 184,474.39
35 $ 90,755.38 $ 4,537.77 $ 32,707.96 $ 1,308.32 $ 1,361.33 $ 35,377.61 $ 151,766.43 $ 15,176.64 $ 3,176.44 $ 170,119.51 $ 205,497.12
36 $ 93,478.04 $ 4,673.90 $ 35,377.61 $ 1,415.10 $ 1,402.17 $ 38,194.88 $ 170,119.51 $ 17,011.95 $ 3,271.73 $ 190,403.20 $ 228,598.08
37 $ 96,282.39 $ 4,814.12 $ 38,194.88 $ 1,527.80 $ 1,444.24 $ 41,166.91 $ 190,403.20 $ 19,040.32 $ 3,369.88 $ 212,813.40 $ 253,980.31
38 $ 99,170.86 $ 4,958.54 $ 41,166.91 $ 1,646.68 $ 1,487.56 $ 44,301.15 $ 212,813.40 $ 21,281.34 $ 3,470.98 $ 237,565.72 $ 281,866.87
39 $ 102,145.98 $ 5,107.30 $ 44,301.15 $ 1,772.05 $ 1,532.19 $ 47,605.39 $ 237,565.72 $ 23,756.57 $ 3,575.11 $ 264,897.40 $ 312,502.79
40 $ 105,210.36 $ 5,260.52 $ 47,605.39 $ 1,904.22 $ 2,104.21 $ 51,613.81 $ 264,897.40 $ 26,489.74 $ 3,156.31 $ 294,543.45 $ 346,157.26
41 $ 108,366.67 $ 5,418.33 $ 51,613.81 $ 2,064.55 $ 2,167.33 $ 55,845.70 $ 294,543.45 $ 29,454.35 $ 3,251.00 $ 327,248.80 $ 383,094.49
42 $ 111,617.67 $ 5,580.88 $ 55,845.70 $ 2,233.83 $ 2,232.35 $ 60,311.88 $ 327,248.80 $ 32,724.88 $ 3,348.53 $ 363,322.21 $ 423,634.08
43 $ 114,966.20 $ 5,748.31 $ 60,311.88 $ 2,412.48 $ 2,299.32 $ 65,023.68 $ 363,322.21 $ 36,332.22 $ 3,448.99 $ 403,103.41 $ 468,127.09
44 $ 118,415.19 $ 5,920.76 $ 65,023.68 $ 2,600.95 $ 2,368.30 $ 69,992.93 $ 403,103.41 $ 40,310.34 $ 3,552.46 $ 446,966.21 $ 516,959.14
45 $ 121,967.65 $ 6,098.38 $ 69,992.93 $ 2,799.72 $ 2,439.35 $ 75,232.00 $ 446,966.21 $ 44,696.62 $ 3,659.03 $ 495,321.86 $ 570,553.86
46 $ 125,626.68 $ 6,281.33 $ 75,232.00 $ 3,009.28 $ 2,512.53 $ 80,753.81 $ 495,321.86 $ 49,532.19 $ 3,768.80 $ 548,622.85 $ 629,376.66
47 $ 129,395.48 $ 6,469.77 $ 80,753.81 $ 3,230.15 $ 2,587.91 $ 86,571.88 $ 548,622.85 $ 54,862.28 $ 3,881.86 $ 607,366.99 $ 693,938.87
48 $ 133,277.34 $ 6,663.87 $ 86,571.88 $ 3,462.88 $ 2,665.55 $ 92,700.30 $ 607,366.99 $ 60,736.70 $ 3,998.32 $ 672,102.01 $ 764,802.31
49 $ 137,275.66 $ 6,863.78 $ 92,700.30 $ 3,708.01 $ 2,745.51 $ 99,153.82 $ 672,102.01 $ 67,210.20 $ 4,118.27 $ 743,430.49 $ 842,584.31
50 $ 141,393.93 $ 7,069.70 $ 99,153.82 $ 3,966.15 $ 3,534.85 $ 106,654.82 $ 743,430.49 $ 74,343.05 $ 3,534.85 $ 821,308.38 $ 927,963.21
51 $ 145,635.75 $ 7,281.79 $ 106,654.82 $ 4,266.19 $ 3,640.89 $ 114,561.91 $ 821,308.38 $ 82,130.84 $ 3,640.89 $ 907,080.11 $ 1,021,642.02
52 $ 150,004.82 $ 7,500.24 $ 114,561.91 $ 4,582.48 $ 3,750.12 $ 122,894.51 $ 907,080.11 $ 90,708.01 $ 3,750.12 $ 1,001,538.25 $ 1,124,432.75
53 $ 154,504.97 $ 7,725.25 $ 122,894.51 $ 4,915.78 $ 3,862.62 $ 131,672.91 $ 1,001,538.25 $ 100,153.82 $ 3,862.62 $ 1,105,554.70 $ 1,237,227.61
54 $ 159,140.11 $ 7,957.01 $ 131,672.91 $ 5,266.92 $ 3,978.50 $ 140,918.33 $ 1,105,554.70 $ 110,555.47 $ 3,978.50 $ 1,220,088.67 $ 1,361,007.00
55 $ 163,914.32 $ 8,195.72 $ 140,918.33 $ 5,636.73 $ 4,097.86 $ 150,652.92 $ 1,220,088.67 $ 122,008.87 $ 4,097.86 $ 1,346,195.39 $ 1,496,848.31
56 $ 168,831.75 $ 8,441.59 $ 150,652.92 $ 6,026.12 $ 4,220.79 $ 160,899.83 $ 1,346,195.39 $ 134,619.54 $ 4,220.79 $ 1,485,035.73 $ 1,645,935.56
57 $ 173,896.70 $ 8,694.83 $ 160,899.83 $ 6,435.99 $ 4,347.42 $ 171,683.24 $ 1,485,035.73 $ 148,503.57 $ 4,347.42 $ 1,637,886.72 $ 1,809,569.96
58 $ 179,113.60 $ 8,955.68 $ 171,683.24 $ 6,867.33 $ 4,477.84 $ 183,028.41 $ 1,637,886.72 $ 163,788.67 $ 4,477.84 $ 1,806,153.23 $ 1,989,181.64
59 $ 184,487.01 $ 9,224.35 $ 183,028.41 $ 7,321.14 $ 4,612.18 $ 194,961.72 $ 1,806,153.23 $ 180,615.32 $ 4,612.18 $ 1,991,380.72 $ 2,186,342.45
60 $ 190,021.62 $ 9,501.08 $ 194,961.72 $ 7,798.47 $ 5,700.65 $ 208,460.84 $ 1,991,380.72 $ 199,138.07 $ 3,800.43 $ 2,194,319.23 $ 2,402,780.07
61 $ 195,722.27 $ 9,786.11 $ 208,460.84 $ 8,338.43 $ 5,871.67 $ 222,670.94 $ 2,194,319.23 $ 219,431.92 $ 3,914.45 $ 2,417,665.60 $ 2,640,336.54
62 $ 201,593.94 $ 10,079.70 $ 222,670.94 $ 8,906.84 $ 6,047.82 $ 237,625.60 $ 2,417,665.60 $ 241,766.56 $ 4,031.88 $ 2,663,464.04 $ 2,901,089.64
63 $ 207,641.75 $ 10,382.09 $ 237,625.60 $ 9,505.02 $ 6,229.25 $ 253,359.88 $ 2,663,464.04 $ 266,346.40 $ 4,152.84 $ 2,933,963.27 $ 3,187,323.15
64 $ 213,871.01 $ 10,693.55 $ 253,359.88 $ 10,134.40 $ 6,416.13 $ 269,910.40 $ 2,933,963.27 $ 293,396.33 $ 4,277.42 $ 3,231,637.02 $ 3,501,547.42
65 $ 220,287.14 $ 11,014.36 $ 269,910.40 $ 10,796.42 $ 6,608.61 $ 287,315.43 $ 3,231,637.02 $ 323,163.70 $ 4,405.74 $ 3,559,206.47 $ 3,846,521.90
66 $ 3,846,521.90 $ 115,395.66 $ (268,540.62) $ 3,693,376.93 $ 3,693,376.93
67 $ 3,693,376.93 $ 110,801.31 $ (268,540.62) $ 3,535,637.62 $ 3,535,637.62
68 $ 3,535,637.62 $ 106,069.13 $ (268,540.62) $ 3,373,166.13 $ 3,373,166.13
69 $ 3,373,166.13 $ 101,194.98 $ (268,540.62) $ 3,205,820.49 $ 3,205,820.49
70 $ 3,205,820.49 $ 96,174.61 $ (268,540.62) $ 3,033,454.49 $ 3,033,454.49
71 $ 3,033,454.49 $ 91,003.63 $ (268,540.62) $ 2,855,917.50 $ 2,855,917.50
72 $ 2,855,917.50 $ 85,677.53 $ (268,540.62) $ 2,673,054.41 $ 2,673,054.41
73 $ 2,673,054.41 $ 80,191.63 $ (268,540.62) $ 2,484,705.42 $ 2,484,705.42
74 $ 2,484,705.42 $ 74,541.16 $ (268,540.62) $ 2,290,705.96 $ 2,290,705.96
75 $ 2,290,705.96 $ 68,721.18 $ (268,540.62) $ 2,090,886.52 $ 2,090,886.52
76 $ 2,090,886.52 $ 62,726.60 $ (268,540.62) $ 1,885,072.50 $ 1,885,072.50
77 $ 1,885,072.50 $ 56,552.17 $ (268,540.62) $ 1,673,084.05 $ 1,673,084.05
78 $ 1,673,084.05 $ 50,192.52 $ (268,540.62) $ 1,454,735.95 $ 1,454,735.95
79 $ 1,454,735.95 $ 43,642.08 $ (268,540.62) $ 1,229,837.41 $ 1,229,837.41
80 $ 1,229,837.41 $ 36,895.12 $ (268,540.62) $ 998,191.91 $ 998,191.91
81 $ 998,191.91 $ 29,945.76 $ (268,540.62) $ 759,597.05 $ 759,597.05
82 $ 759,597.05 $ 22,787.91 $ (268,540.62) $ 513,844.34 $ 513,844.34
83 $ 513,844.34 $ 15,415.33 $ (268,540.62) $ 260,719.05 $ 260,719.05
84 $ 260,719.05 $ 7,821.57 $ (268,540.62) $ (0.00) $ (0.00)

This is the way I had intended the problem; you stop working and start collecting.

Retire(alt)

Today's Salary $ 60,000.00 Bond Fund Stock Fund Guaranteed Fund
Annual Growth in Salary 3.00% Age Salary Investment Beginning Balance Interest Deposit Ending Balance Beginning Balance Interest Deposit Ending Balance Beginning Balance Interest Deposit Ending Balance Total Portfolio
Proportion Of Salary Invested 5.00% 21 $ 60,000.00 $ 3,000.00 $ 10,000.00 $ 400.00 $ 600.00 $ 11,000.00 $ 20,000.00 $ 2,000.00 $ 2,400.00 $ 24,400.00 $ 35,400.00
22 $ 61,800.00 $ 3,090.00 $ 11,000.00 $ 440.00 $ 618.00 $ 12,058.00 $ 24,400.00 $ 2,440.00 $ 2,472.00 $ 29,312.00 $ 41,370.00
Age Today 21 23 $ 63,654.00 $ 3,182.70 $ 12,058.00 $ 482.32 $ 636.54 $ 13,176.86 $ 29,312.00 $ 2,931.20 $ 2,546.16 $ 34,789.36 $ 47,966.22
Age At Retirement 67 24 $ 65,563.62 $ 3,278.18 $ 13,176.86 $ 527.07 $ 655.64 $ 14,359.57 $ 34,789.36 $ 3,478.94 $ 2,622.54 $ 40,890.84 $ 55,250.41
Age at Death 85 25 $ 67,530.53 $ 3,376.53 $ 14,359.57 $ 574.38 $ 675.31 $ 15,609.26 $ 40,890.84 $ 4,089.08 $ 2,701.22 $ 47,681.15 $ 63,290.40
26 $ 69,556.44 $ 3,477.82 $ 15,609.26 $ 624.37 $ 695.56 $ 16,929.19 $ 47,681.15 $ 4,768.11 $ 2,782.26 $ 55,231.52 $ 72,160.71
Initial Deposit in Bond Fund $ 10,000.00 27 $ 71,643.14 $ 3,582.16 $ 16,929.19 $ 677.17 $ 716.43 $ 18,322.79 $ 55,231.52 $ 5,523.15 $ 2,865.73 $ 63,620.40 $ 81,943.19
Return on Bonds 4.00% 28 $ 73,792.43 $ 3,689.62 $ 18,322.79 $ 732.91 $ 737.92 $ 19,793.63 $ 63,620.40 $ 6,362.04 $ 2,951.70 $ 72,934.13 $ 92,727.76
Initial Deposit in Stock Fund $ 20,000.00 29 $ 76,006.20 $ 3,800.31 $ 19,793.63 $ 791.75 $ 760.06 $ 21,345.44 $ 72,934.13 $ 7,293.41 $ 3,040.25 $ 83,267.79 $ 104,613.23
Return on Stocks 10.00% 30 $ 78,286.39 $ 3,914.32 $ 21,345.44 $ 853.82 $ 1,174.30 $ 23,373.55 $ 83,267.79 $ 8,326.78 $ 2,740.02 $ 94,334.60 $ 117,708.15
Guaranteed Return 3.00% 31 $ 80,634.98 $ 4,031.75 $ 23,373.55 $ 934.94 $ 1,209.52 $ 25,518.02 $ 94,334.60 $ 9,433.46 $ 2,822.22 $ 106,590.28 $ 132,108.30
32 $ 83,054.03 $ 4,152.70 $ 25,518.02 $ 1,020.72 $ 1,245.81 $ 27,784.55 $ 106,590.28 $ 10,659.03 $ 2,906.89 $ 120,156.20 $ 147,940.75
Retirement Benefit $ 316,431.03 33 $ 85,545.65 $ 4,277.28 $ 27,784.55 $ 1,111.38 $ 1,283.18 $ 30,179.11 $ 120,156.20 $ 12,015.62 $ 2,994.10 $ 135,165.92 $ 165,345.03
34 $ 88,112.02 $ 4,405.60 $ 30,179.11 $ 1,207.16 $ 1,321.68 $ 32,707.96 $ 135,165.92 $ 13,516.59 $ 3,083.92 $ 151,766.43 $ 184,474.39
35 $ 90,755.38 $ 4,537.77 $ 32,707.96 $ 1,308.32 $ 1,361.33 $ 35,377.61 $ 151,766.43 $ 15,176.64 $ 3,176.44 $ 170,119.51 $ 205,497.12
36 $ 93,478.04 $ 4,673.90 $ 35,377.61 $ 1,415.10 $ 1,402.17 $ 38,194.88 $ 170,119.51 $ 17,011.95 $ 3,271.73 $ 190,403.20 $ 228,598.08
37 $ 96,282.39 $ 4,814.12 $ 38,194.88 $ 1,527.80 $ 1,444.24 $ 41,166.91 $ 190,403.20 $ 19,040.32 $ 3,369.88 $ 212,813.40 $ 253,980.31
38 $ 99,170.86 $ 4,958.54 $ 41,166.91 $ 1,646.68 $ 1,487.56 $ 44,301.15 $ 212,813.40 $ 21,281.34 $ 3,470.98 $ 237,565.72 $ 281,866.87
39 $ 102,145.98 $ 5,107.30 $ 44,301.15 $ 1,772.05 $ 1,532.19 $ 47,605.39 $ 237,565.72 $ 23,756.57 $ 3,575.11 $ 264,897.40 $ 312,502.79
40 $ 105,210.36 $ 5,260.52 $ 47,605.39 $ 1,904.22 $ 2,104.21 $ 51,613.81 $ 264,897.40 $ 26,489.74 $ 3,156.31 $ 294,543.45 $ 346,157.26
41 $ 108,366.67 $ 5,418.33 $ 51,613.81 $ 2,064.55 $ 2,167.33 $ 55,845.70 $ 294,543.45 $ 29,454.35 $ 3,251.00 $ 327,248.80 $ 383,094.49
42 $ 111,617.67 $ 5,580.88 $ 55,845.70 $ 2,233.83 $ 2,232.35 $ 60,311.88 $ 327,248.80 $ 32,724.88 $ 3,348.53 $ 363,322.21 $ 423,634.08
43 $ 114,966.20 $ 5,748.31 $ 60,311.88 $ 2,412.48 $ 2,299.32 $ 65,023.68 $ 363,322.21 $ 36,332.22 $ 3,448.99 $ 403,103.41 $ 468,127.09
44 $ 118,415.19 $ 5,920.76 $ 65,023.68 $ 2,600.95 $ 2,368.30 $ 69,992.93 $ 403,103.41 $ 40,310.34 $ 3,552.46 $ 446,966.21 $ 516,959.14
45 $ 121,967.65 $ 6,098.38 $ 69,992.93 $ 2,799.72 $ 2,439.35 $ 75,232.00 $ 446,966.21 $ 44,696.62 $ 3,659.03 $ 495,321.86 $ 570,553.86
46 $ 125,626.68 $ 6,281.33 $ 75,232.00 $ 3,009.28 $ 2,512.53 $ 80,753.81 $ 495,321.86 $ 49,532.19 $ 3,768.80 $ 548,622.85 $ 629,376.66
47 $ 129,395.48 $ 6,469.77 $ 80,753.81 $ 3,230.15 $ 2,587.91 $ 86,571.88 $ 548,622.85 $ 54,862.28 $ 3,881.86 $ 607,366.99 $ 693,938.87
48 $ 133,277.34 $ 6,663.87 $ 86,571.88 $ 3,462.88 $ 2,665.55 $ 92,700.30 $ 607,366.99 $ 60,736.70 $ 3,998.32 $ 672,102.01 $ 764,802.31
49 $ 137,275.66 $ 6,863.78 $ 92,700.30 $ 3,708.01 $ 2,745.51 $ 99,153.82 $ 672,102.01 $ 67,210.20 $ 4,118.27 $ 743,430.49 $ 842,584.31
50 $ 141,393.93 $ 7,069.70 $ 99,153.82 $ 3,966.15 $ 3,534.85 $ 106,654.82 $ 743,430.49 $ 74,343.05 $ 3,534.85 $ 821,308.38 $ 927,963.21
51 $ 145,635.75 $ 7,281.79 $ 106,654.82 $ 4,266.19 $ 3,640.89 $ 114,561.91 $ 821,308.38 $ 82,130.84 $ 3,640.89 $ 907,080.11 $ 1,021,642.02
52 $ 150,004.82 $ 7,500.24 $ 114,561.91 $ 4,582.48 $ 3,750.12 $ 122,894.51 $ 907,080.11 $ 90,708.01 $ 3,750.12 $ 1,001,538.25 $ 1,124,432.75
53 $ 154,504.97 $ 7,725.25 $ 122,894.51 $ 4,915.78 $ 3,862.62 $ 131,672.91 $ 1,001,538.25 $ 100,153.82 $ 3,862.62 $ 1,105,554.70 $ 1,237,227.61
54 $ 159,140.11 $ 7,957.01 $ 131,672.91 $ 5,266.92 $ 3,978.50 $ 140,918.33 $ 1,105,554.70 $ 110,555.47 $ 3,978.50 $ 1,220,088.67 $ 1,361,007.00
55 $ 163,914.32 $ 8,195.72 $ 140,918.33 $ 5,636.73 $ 4,097.86 $ 150,652.92 $ 1,220,088.67 $ 122,008.87 $ 4,097.86 $ 1,346,195.39 $ 1,496,848.31
56 $ 168,831.75 $ 8,441.59 $ 150,652.92 $ 6,026.12 $ 4,220.79 $ 160,899.83 $ 1,346,195.39 $ 134,619.54 $ 4,220.79 $ 1,485,035.73 $ 1,645,935.56
57 $ 173,896.70 $ 8,694.83 $ 160,899.83 $ 6,435.99 $ 4,347.42 $ 171,683.24 $ 1,485,035.73 $ 148,503.57 $ 4,347.42 $ 1,637,886.72 $ 1,809,569.96
58 $ 179,113.60 $ 8,955.68 $ 171,683.24 $ 6,867.33 $ 4,477.84 $ 183,028.41 $ 1,637,886.72 $ 163,788.67 $ 4,477.84 $ 1,806,153.23 $ 1,989,181.64
59 $ 184,487.01 $ 9,224.35 $ 183,028.41 $ 7,321.14 $ 4,612.18 $ 194,961.72 $ 1,806,153.23 $ 180,615.32 $ 4,612.18 $ 1,991,380.72 $ 2,186,342.45
60 $ 190,021.62 $ 9,501.08 $ 194,961.72 $ 7,798.47 $ 5,700.65 $ 208,460.84 $ 1,991,380.72 $ 199,138.07 $ 3,800.43 $ 2,194,319.23 $ 2,402,780.07
61 $ 195,722.27 $ 9,786.11 $ 208,460.84 $ 8,338.43 $ 5,871.67 $ 222,670.94 $ 2,194,319.23 $ 219,431.92 $ 3,914.45 $ 2,417,665.60 $ 2,640,336.54
62 $ 201,593.94 $ 10,079.70 $ 222,670.94 $ 8,906.84 $ 6,047.82 $ 237,625.60 $ 2,417,665.60 $ 241,766.56 $ 4,031.88 $ 2,663,464.04 $ 2,901,089.64
63 $ 207,641.75 $ 10,382.09 $ 237,625.60 $ 9,505.02 $ 6,229.25 $ 253,359.88 $ 2,663,464.04 $ 266,346.40 $ 4,152.84 $ 2,933,963.27 $ 3,187,323.15
64 $ 213,871.01 $ 10,693.55 $ 253,359.88 $ 10,134.40 $ 6,416.13 $ 269,910.40 $ 2,933,963.27 $ 293,396.33 $ 4,277.42 $ 3,231,637.02 $ 3,501,547.42
65 $ 220,287.14 $ 11,014.36 $ 269,910.40 $ 10,796.42 $ 6,608.61 $ 287,315.43 $ 3,231,637.02 $ 323,163.70 $ 4,405.74 $ 3,559,206.47 $ 3,846,521.90
66 $ 226,895.75 $ 11,344.79 $ 287,315.43 $ 11,492.62 $ 6,806.87 $ 305,614.92 $ 3,559,206.47 $ 355,920.65 $ 4,537.92 $ 3,919,665.03 $ 4,225,279.95
67 $ 4,225,279.95 $ 126,758.40 $ 4,352,038.35 $ 4,352,038.35
68 $ 4,352,038.35 $ 130,561.15 $ (316,431.03) $ 4,166,168.47 $ 4,166,168.47
69 $ 4,166,168.47 $ 124,985.05 $ (316,431.03) $ 3,974,722.49 $ 3,974,722.49
70 $ 3,974,722.49 $ 119,241.67 $ (316,431.03) $ 3,777,533.13 $ 3,777,533.13
71 $ 3,777,533.13 $ 113,325.99 $ (316,431.03) $ 3,574,428.09 $ 3,574,428.09
72 $ 3,574,428.09 $ 107,232.84 $ (316,431.03) $ 3,365,229.90 $ 3,365,229.90
73 $ 3,365,229.90 $ 100,956.90 $ (316,431.03) $ 3,149,755.76 $ 3,149,755.76
74 $ 3,149,755.76 $ 94,492.67 $ (316,431.03) $ 2,927,817.40 $ 2,927,817.40
75 $ 2,927,817.40 $ 87,834.52 $ (316,431.03) $ 2,699,220.89 $ 2,699,220.89
76 $ 2,699,220.89 $ 80,976.63 $ (316,431.03) $ 2,463,766.49 $ 2,463,766.49
77 $ 2,463,766.49 $ 73,912.99 $ (316,431.03) $ 2,221,248.45 $ 2,221,248.45
78 $ 2,221,248.45 $ 66,637.45 $ (316,431.03) $ 1,971,454.87 $ 1,971,454.87
79 $ 1,971,454.87 $ 59,143.65 $ (316,431.03) $ 1,714,167.48 $ 1,714,167.48
80 $ 1,714,167.48 $ 51,425.02 $ (316,431.03) $ 1,449,161.48 $ 1,449,161.48
81 $ 1,449,161.48 $ 43,474.84 $ (316,431.03) $ 1,176,205.29 $ 1,176,205.29
82 $ 1,176,205.29 $ 35,286.16 $ (316,431.03) $ 895,060.41 $ 895,060.41
83 $ 895,060.41 $ 26,851.81 $ (316,431.03) $ 605,481.19 $ 605,481.19
84 $ 605,481.19 $ 18,164.44 $ (316,431.03) $ 307,214.59 $ 307,214.59
85 $ 307,214.59 $ 9,216.44 $ (316,431.03) $ 0.00 $ 0.00

This interpretation allows a one year lag between work and collecting retirement.

BREWSKI

State BCPC INC MB TAX FPCT POP TEMP BCPC INC MBPC FPCT TDUM SUMMARY OUTPUT
Alabama 30.2 $44,765 28 $1.05 51.5 4.87 62.8 30.2 $ 44,765 5.75 51.5 1
Alaska 28.7 $73,355 32 $1.07 47.6 0.74 26.6 28.7 $ 73,355 43.24 47.6 0 Regression Statistics
Arizona 29.5 $51,492 86 $0.16 50.3 7.02 60.3 29.5 $ 51,492 12.25 50.3 1 Multiple R 0.4806534661
Arkansas 26.7 $41,995 28 $0.35 50.9 3.00 60.4 26.7 $ 41,995 9.33 50.9 1 R Square 0.2310277545
California 25.5 $64,500 623 $0.20 50.3 39.54 59.4 25.5 $ 64,500 15.76 50.3 0 Adjusted R Square 0.1641606027
Colorado 30.0 $63,909 334 $0.08 49.8 5.61 45.1 30.0 $ 63,909 59.54 49.8 0 Standard Error 4.8913685678
Connecticut 22.0 $71,346 49 $0.23 51.2 3.59 49.0 22.0 $ 71,346 13.65 51.2 0 Observations 51
Delaware 33.6 $61,255 19 $0.16 51.6 0.96 55.3 33.6 $ 61,255 19.79 51.6 0
Florida 27.4 $49,426 195 $0.48 51.1 20.98 70.7 27.4 $ 49,426 9.29 51.1 1 ANOVA
Georgia 25.7 $51,244 53 $1.01 51.1 10.43 63.5 25.7 $ 51,244 5.08 51.1 1 df SS MS F Significance F
Hawaii 30.4 $73,486 14 $0.93 49.5 1.43 70.0 30.4 $ 73,486 9.79 49.5 1 Regression 4 330.6527206046 82.6631801511 3.4550260982 0.0150046199
Idaho 27.8 $48,275 53 $0.15 49.9 1.72 44.4 27.8 $ 48,275 30.81 49.9 0 Residual 46 1100.5723774346 23.925486466
Illinois 29.1 $59,588 181 $0.23 50.9 12.80 51.8 29.1 $ 59,588 14.14 50.9 0 Total 50 1431.2250980392
Indiana 25.9 $50,532 127 $0.12 50.7 6.67 51.7 25.9 $ 50,532 19.04 50.7 0
Iowa 33.6 $54,736 70 $0.19 50.4 3.15 47.8 33.6 $ 54,736 22.22 50.4 0 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0%
Kansas 28.3 $53,906 31 $0.18 50.2 2.91 54.3 28.3 $ 53,906 10.65 50.2 0 Intercept 120.7751921167 45.1573483899 2.6745412745 0.0103265882 29.8781642839 211.6722199496 29.8781642839 211.6722199496
Kentucky 24.4 $45,215 34 $0.84 50.8 4.45 55.6 24.4 $ 45,215 7.64 50.8 0 INC -0.0001226766 0.0000771387 -1.5903380795 0.1186086612 -0.0002779487 0.0000325955 -0.0002779487 0.0000325955
Louisiana 33.9 $45,727 26 $0.32 51.1 4.68 66.4 33.9 $ 45,727 5.56 51.1 1 MBPC 0.0963616881 0.0447876252 2.1515248402 0.0367193339 0.0062088745 0.1865145017 0.0062088745 0.1865145017
Maine 34.0 $51,494 77 $0.35 51.0 1.34 41.0 34.0 $ 51,494 57.46 51.0 0 FPCT -1.7023823917 0.8762370585 -1.9428331353 0.0581715754 -3.4661561104 0.061391327 -3.4661561104 0.061391327
Maryland 23.2 $75,847 65 $0.49 51.5 6.05 54.2 23.2 $ 75,847 10.74 51.5 0 TDUM 1.6813266908 1.9521119711 0.8612859896 0.3935480129 -2.2480709044 5.610724286 -2.2480709044 5.610724286
Massachusetts 26.2 $70,628 110 $0.11 51.5 6.86 47.9 26.2 $ 70,628 16.03 51.5 0
Michigan 26.8 $51,084 222 $0.20 50.9 9.96 44.4 26.8 $ 51,084 22.29 50.9 0 Significant at 5%
Minnesota 28.5 $63,488 112 $0.47 50.3 5.58 41.2 28.5 $ 63,488 20.07 50.3 0 Significant at 10%
Mississippi 33.9 $40,593 9 $0.43 51.4 2.98 63.4 33.9 $ 40,593 3.02 51.4 1
Missouri 31.0 $50,238 78 $0.06 51.0 6.11 54.5 31.0 $ 50,238 12.77 51.0 0
Montana 41.0 $49,509 68 $0.14 49.8 1.05 42.7 41.0 $ 49,509 64.76 49.8 0
Nebraska 35.2 $54,996 42 $0.31 50.2 1.92 48.8 35.2 $ 54,996 21.88 50.2 0
Nevada 35.8 $52,431 37 $0.16 49.6 3.00 49.9 35.8 $ 52,431 12.33 49.6 0
New Hampshire 43.9 $70,303 54 $0.30 50.6 1.34 43.8 43.9 $ 70,303 40.30 50.6 0
New Jersey 22.4 $72,222 82 $0.12 51.2 9.01 52.7 22.4 $ 72,222 9.10 51.2 0
New Mexico 32.4 $45,382 57 $0.41 50.4 2.09 53.4 32.4 $ 45,382 27.27 50.4 0
New York 22.4 $60,850 269 $0.14 51.5 19.85 45.4 22.4 $ 60,850 13.55 51.5 0
North Carolina 27.1 $47,830 200 $0.62 51.3 10.27 59.0 27.1 $ 47,830 19.47 51.3 0
North Dakota 45.8 $60,557 10 $0.39 48.9 0.76 40.4 45.8 $ 60,557 13.16 48.9 0
Ohio 30.1 $51,075 177 $0.18 51.1 11.66 50.7 30.1 $ 51,075 15.18 51.1 0
Oklahoma 28.3 $48,568 20 $0.40 50.5 3.93 59.6 28.3 $ 48,568 5.09 50.5 0
Oregon 30.3 $54,148 243 $0.08 50.5 4.14 48.4 30.3 $ 54,148 58.70 50.5 0
Pennsylvania 28.6 $55,702 205 $0.08 51.1 12.81 48.8 28.6 $ 55,702 16.00 51.1 0
Rhode Island 26.3 $58,073 15 $0.12 51.6 1.06 50.1 26.3 $ 58,073 14.15 51.6 0
South Carolina 32.7 $47,238 50 $0.77 51.3 5.02 62.4 32.7 $ 47,238 9.96 51.3 1
South Dakota 38.9 $53,017 15 $0.27 49.8 0.87 45.2 38.9 $ 53,017 17.24 49.8 0
Tennessee 26.2 $47,275 66 $1.29 51.2 6.72 57.6 26.2 $ 47,275 9.82 51.2 0
Texas 34.4 $55,653 201 $0.20 50.3 28.30 64.8 34.4 $ 55,653 7.10 50.3 1
Utah 20.2 $62,912 27 $0.41 49.7 3.10 48.6 20.2 $ 62,912 8.71 49.7 0
Vermont 35.3 $56,990 50 $0.27 50.7 0.62 42.9 35.3 $ 56,990 80.65 50.7 0
Virginia 26.7 $66,262 164 $0.26 50.8 8.47 55.1 26.7 $ 66,262 19.36 50.8 0
Washington 24.8 $64,129 334 $0.26 50.0 7.41 48.3 24.8 $ 64,129 45.07 50.0 0
Washington DC 28.3 $75,628 12 $0.64 52.6 0.69 55.7 28.3 $ 75,628 17.39 52.6 0
West Virginia 30.3 $42,019 15 $0.18 50.6 1.82 51.8 30.3 $ 42,019 8.24 50.6 0
Wisconsin 36.2 $55,638 138 $0.06 50.3 5.80 43.1 36.2 $ 55,638 23.79 50.3 0
Wyoming 33.0 $60,214 23 $0.02 49.0 0.58 42.0 33.0 $ 60,214 39.66 49.0 0

RAISE

This panel assumes fractional bonuses; the incentive bonus does NOT include the gender bonus. This panel assumes whole percentage bonuses; the incentive bonus does NOT include the gender bonus.
Worker Gender This Year's Salary Minimum Production Maximum Production Adjusted Salary Production Bonus Gender Bonus Total Salary Worker Gender This Year's Salary Minimum Production Maximum Production Adjusted Salary Production Bonus Gender Bonus Total Salary
Alex M $ 59,269 10,000 13,546 $ 61,479.81 $ 950.48 $ - 0 $ 62,430.28 Alex M $ 59,269 10,000 13,546 $ 61,818.53 $ 618.19 $ - 0 $ 62,436.71
Bob M $ 64,972 10,000 18,214 $ 67,395.54 $ 4,187.96 $ - 0 $ 71,583.49 Bob M $ 64,972 10,000 18,214 $ 67,766.85 $ 4,066.01 $ - 0 $ 71,832.86
Cyndie F $ 51,191 10,000 20,536 $ 53,100.49 $ 4,532.66 $ 2,500.00 $ 60,133.15 Cyndie F $ 51,191 10,000 20,536 $ 53,393.04 $ 4,271.44 $ 2,500.00 $ 60,164.49
Dave M $ 58,320 10,000 21,490 $ 60,495.41 $ 5,741.01 $ - 0 $ 66,236.42 Dave M $ 58,320 10,000 21,490 $ 60,828.70 $ 5,474.58 $ - 0 $ 66,303.29
Ed M $ 60,250 10,000 18,634 $ 62,497.40 $ 4,146.08 $ - 0 $ 66,643.48 Ed M $ 60,250 10,000 18,634 $ 62,841.73 $ 3,770.50 $ - 0 $ 66,612.23
Francine F $ 45,765 10,000 15,656 $ 47,472.09 $ 1,735.58 $ 2,500.00 $ 51,707.67 Francine F $ 45,765 10,000 15,656 $ 47,733.64 $ 1,432.01 $ 2,500.00 $ 51,665.65
Georgina F $ 34,512 10,000 16,384 $ 35,799.34 $ 1,569.44 $ 2,500.00 $ 39,868.78 Georgina F $ 34,512 10,000 16,384 $ 35,996.58 $ 1,439.86 $ 2,500.00 $ 39,936.44
Hillary F $ 37,896 10,000 12,511 $ 39,309.57 $ 200.87 $ 2,500.00 $ 42,010.44 Hillary F $ 37,896 10,000 12,511 $ 39,526.14 $ - 0 $ 2,500.00 $ 42,026.14
Ida F $ 39,786 10,000 15,445 $ 41,270.07 $ 1,421.75 $ 2,500.00 $ 45,191.82 Ida F $ 39,786 10,000 15,445 $ 41,497.44 $ 1,244.92 $ 2,500.00 $ 45,242.37
Jennifer F $ 41,061 10,000 14,477 $ 42,592.63 $ 1,055.02 $ 2,500.00 $ 46,147.65 Jennifer F $ 41,061 10,000 14,477 $ 42,827.29 $ 856.55 $ 2,500.00 $ 46,183.83
Kevin M $ 69,733 10,000 19,914 $ 72,334.13 $ 5,724.52 $ - 0 $ 78,058.65 Kevin M $ 69,733 10,000 19,914 $ 72,732.65 $ 5,091.29 $ - 0 $ 77,823.93
Lani F $ 39,240 10,000 15,877 $ 40,703.70 $ 1,578.08 $ 2,500.00 $ 44,781.78 Lani F $ 39,240 10,000 15,877 $ 40,927.96 $ 1,227.84 $ 2,500.00 $ 44,655.79
Marcy F $ 41,220 10,000 15,820 $ 42,757.56 $ 1,633.34 $ 2,500.00 $ 46,890.90 Marcy F $ 41,220 10,000 15,820 $ 42,993.13 $ 1,289.79 $ 2,500.00 $ 46,782.92
Norman M $ 56,438 10,000 19,559 $ 58,543.21 $ 4,425.28 $ - 0 $ 62,968.49 Norman M $ 56,438 10,000 19,559 $ 58,865.75 $ 4,120.60 $ - 0 $ 62,986.35
Total $ 699,653 $ 784,653.00 Total $ 699,653 $ 784,653.00
Increase $ 85,000.00 Increase $ 85,000.00
COLA 3.73% COLA 4.30%
This panel assumes fractional bonuses; the incentive bonus INCLUDES the gender bonus. This panel assumes whole percentage bonuses; the incentive bonus INCLUDES the gender bonus.
Worker Gender This Year's Salary Minimum Production Maximum Production Adjusted Salary Production Bonus Gender Bonus Total Salary Worker Gender This Year's Salary Minimum Production Maximum Production Adjusted Salary Production Bonus Gender Bonus Total Salary
Alex M $ 59,269 10,000 13,546 $ 61,418.09 $ 949.52 $ - 0 $ 62,367.61 Alex M $ 59,269 10,000 13,546 $ 61,765.98 $ 617.66 $ - 0 $ 62,383.64
Bob M $ 64,972 10,000 18,214 $ 67,327.88 $ 4,183.75 $ - 0 $ 71,511.63 Bob M $ 64,972 10,000 18,214 $ 67,709.24 $ 4,062.55 $ - 0 $ 71,771.80
Cyndie F $ 51,191 10,000 20,536 $ 53,047.18 $ 4,741.51 $ 2,500.00 $ 60,288.69 Cyndie F $ 51,191 10,000 20,536 $ 53,347.65 $ 4,467.81 $ 2,500.00 $ 60,315.47
Dave M $ 58,320 10,000 21,490 $ 60,434.68 $ 5,735.25 $ - 0 $ 66,169.93 Dave M $ 58,320 10,000 21,490 $ 60,777.00 $ 5,469.93 $ - 0 $ 66,246.93
Ed M $ 60,250 10,000 18,634 $ 62,434.66 $ 4,141.92 $ - 0 $ 66,576.57 Ed M $ 60,250 10,000 18,634 $ 62,788.31 $ 3,767.30 $ - 0 $ 66,555.60
Francine F $ 45,765 10,000 15,656 $ 47,424.43 $ 1,825.24 $ 2,500.00 $ 51,749.67 Francine F $ 45,765 10,000 15,656 $ 47,693.06 $ 1,505.79 $ 2,500.00 $ 51,698.85
Georgina F $ 34,512 10,000 16,384 $ 35,763.40 $ 1,677.47 $ 2,500.00 $ 39,940.87 Georgina F $ 34,512 10,000 16,384 $ 35,965.98 $ 1,538.64 $ 2,500.00 $ 40,004.61
Hillary F $ 37,896 10,000 12,511 $ 39,270.10 $ 213.45 $ 2,500.00 $ 41,983.55 Hillary F $ 37,896 10,000 12,511 $ 39,492.54 $ - 0 $ 2,500.00 $ 41,992.54
Ida F $ 39,786 10,000 15,445 $ 41,228.64 $ 1,506.45 $ 2,500.00 $ 45,235.09 Ida F $ 39,786 10,000 15,445 $ 41,462.17 $ 1,318.87 $ 2,500.00 $ 45,281.03
Jennifer F $ 41,061 10,000 14,477 $ 42,549.87 $ 1,115.89 $ 2,500.00 $ 46,165.75 Jennifer F $ 41,061 10,000 14,477 $ 42,790.88 $ 905.82 $ 2,500.00 $ 46,196.70
Kevin M $ 69,733 10,000 19,914 $ 72,261.51 $ 5,718.78 $ - 0 $ 77,980.29 Kevin M $ 69,733 10,000 19,914 $ 72,670.82 $ 5,086.96 $ - 0 $ 77,757.78
Lani F $ 39,240 10,000 15,877 $ 40,662.84 $ 1,673.42 $ 2,500.00 $ 44,836.26 Lani F $ 39,240 10,000 15,877 $ 40,893.16 $ 1,301.79 $ 2,500.00 $ 44,694.96
Marcy F $ 41,220 10,000 15,820 $ 42,714.63 $ 1,727.20 $ 2,500.00 $ 46,941.83 Marcy F $ 41,220 10,000 15,820 $ 42,956.58 $ 1,363.70 $ 2,500.00 $ 46,820.28
Norman M $ 56,438 10,000 19,559 $ 58,484.43 $ 4,420.84 $ - 0 $ 62,905.27 Norman M $ 56,438 10,000 19,559 $ 58,815.71 $ 4,117.10 $ - 0 $ 62,932.81
Total $ 699,653 $ 784,653.00 Total $ 699,653 $ 784,653.00
Increase $ 85,000.00 Increase $ 85,000.00
COLA 3.63% COLA 4.21%

NPV

Year Project A Project B Difference
0 $ (300,000) $ (100,000) $ (200,000)
1 $ 47,656 $ 22,067 $ 25,589
2 $ 76,807 $ 23,998 $ 52,809
3 $ 49,337 $ 28,380 $ 20,957
4 $ 51,997 $ 18,767 $ 33,230
5 $ 62,734 $ 27,047 $ 35,687
6 $ 66,521 $ 29,219 $ 37,302
7 $ 43,077 $ 27,618 $ 15,459
8 $ 64,423 $ 14,424 $ 49,999
9 $ 58,134 $ 20,800 $ 37,334
10 $ 41,594 $ 18,119 $ 23,475
NPV $21,101.85 $32,764.39
IRR 13.72% 19.76% 10.55% Crossover Rate
r Project A Project B
0% $262,280.00 $ 130,439.00
1% $233,167.89 $ 118,714.93
2% $206,214.50 $ 107,846.57
3% $181,226.49 $ 97,758.18
4% $158,030.25 $ 88,381.70
5% $136,469.67 $ 79,655.84
6% $116,404.16 $ 71,525.40
7% $97,706.99 $ 63,940.53
8% $80,263.72 $ 56,856.21
9% $63,970.90 $ 50,231.67
10% $48,734.91 $ 44,030.01
11% $34,470.89 $ 38,217.72
12% $21,101.85 $ 32,764.39
13% $8,557.84 $ 27,642.35
14% ($3,224.75) $ 22,826.41
15% ($14,303.85) $ 18,293.61
16% ($24,732.26) $ 14,023.01
17% ($34,558.19) $ 9,995.44
18% ($43,825.66) $ 6,193.42
19% ($52,574.96) $ 2,600.91
20% ($60,842.97) $ (796.80)
21% ($68,663.48) $ (4,013.17)
22% ($76,067.52) $ (7,060.61)
23% ($83,083.57) $ (9,950.49)
24% ($89,737.84) $ (12,693.31)
25% ($96,054.42) $ (15,298.71)
26% ($102,055.54) $ (17,775.61)
27% ($107,761.66) $ (20,132.22)
28% ($113,191.70) $ (22,376.15)
29% ($118,363.11) $ (24,514.42)
30% ($123,292.05) $ (26,553.54)

Net Present Value Profiles

Project A 0 0.01 0.02 0.03 0.04 0.05 6.0000000000000005E-2 7.0000000000000007E-2 0.08 0.09 9.9999999999999992E-2 0.10999999999999999 0.11999999999999998 0.12999999999999998 0.13999999999999999 0.15 0.16 0.17 0.18000000000000002 0.19000000000000003 0.20000000000000004 0.21000000000000005 0.22000000000000006 0.23000000000000007 0.24000000000000007 0.25000000000000006 0.26000000000000006 0.27000000000000007 0.28000000000000008 0.29000000000000009 0.3000000000000001 262280 233167.88994414534 206214.49659150327 181226.48670489638 158030.24856701517 136469.66540716152 116404.1623480561 97706.990729709971 80263.718762113014 63970.901792052668 48734.909161641379 34470.887787229149 21101.845280949783 8557.8377433359274 -3224.7506670054863 -14303.847582268761 -24732.261427650461 -34558.188053295889 -43825.662386866228 -52574.961559812073 -60842.965149143856 -68663.47747365103 -76067.51627381405 -83083.57157502824 -89737.838073082821 -96054.42397962237 -102055.53891544064 -107761.66313395553 -113191.70009014639 -118363.11413646207 -123292.05492235126 Project B 0 0.01 0.02 0.03 0.04 0.05 6.0000000000000005E-2 7.0000000000000007E-2 0.08 0.09 9.9999999999999992E-2 0.10999999999999999 0.11999999999999998 0.12999999999999998 0.13999999999999999 0.15 0.16 0.17 0.18000000000000002 0.19000000000000003 0.20000000000000004 0.21000000000000005 0.22000000000000006 0.23000000000000007 0.24000000000000007 0.25000000000000006 0.26000000000000006 0.27000000000000007 0.28000000000000008 0.29000000000000009 0.3000000000000001 130439 118714.93006209927 107846.57063448662 97758.183312792738 88381.695683691476 79655.839821437985 71525.396371429146 63940.530277483515 56856.206176009204 50231.673152504722 44030.009980356292 38217.72317739384 32764.391254519636 27642.349420037455 22826.409765811943 18293.612616189319 14023.005283774284 9995.444961247078 6193.4228968540992 2600.9073627002508 -796.7967622923461 -4013.1737019591092 -7060.6094571529684 -9950.4929126508505 -12693.306667046651 -15298.708721254399 -17775.606026311274 -20132.220773331894 -22376.150205433587 -24514.420641250472 -26553.536320590807

Discount Rate

NPV

IRR A = 13.72%

If the two NPVs are equal, the NPV of the difference =0. You can use the IRR function on the differences, or use SOLVER.

SIM

X Y
-4 144
-3 165
-3 165
9 105
-6 0
3 -45
-4 144
3 -45
7 -65
2 0
7 -65
-2 160
0 96
5 -99
1 49
3 -45
4 -80
5 -99
-1 135
5 -99
-2 160
8 0
4 -80
0 96
-5 91
2 0
-1 135
6 -96
1 49
7 -65
-2 160
10 256
-9 -561
8 0
6 -96
-7 -135
-10 -864
1 49
7 -65
0 96
5 -99
1 49
-5 91
4 -80
-6 0
-9 -561
3 -45
6 -96
4 -80
4 -80
6 -96
3 -45
-9 -561
-7 -135
3 -45
-7 -135
-9 -561
0 96
7 -65
7 -65
-5 91
2 0
3 -45
1 49
-5 91
0 96
10 256
10 256
-4 144
2 0
9 105
-2 160
6 -96
0 96
9 105
1 49
6 -96
-3 165
8 0
1 49
7 -65
9 105
-2 160
-6 0
10 256
-5 91
-7 -135
9 105
-8 -320
-2 160
6 -96
-9 -561
3 -45
0 96
-10 -864
-10 -864
-6 0
8 0
-8 -320
2 0

Y=X3 - 4X2 - 44X + 96

Y -4 -3 -3 9 -6 3 -4 3 7 2 7 -2 0 5 1 3 4 5 -1 5 -2 8 4 0 -5 2 -1 6 1 7 -2 10 -9 8 6 -7 -10 1 7 0 5 1 -5 4 -6 -9 3 6 4 4 6 3 -9 -7 3 -7 -9 0 7 7 -5 2 3 1 -5 0 10 10 -4 2 9 -2 6 0 9 1 6 -3 8 1 7 9 -2 -6 10 -5 -7 9 -8 -2 6 -9 3 0 -10 -10 -6 8 -8 2 144 165 165 105 0 -45 144 -45 -65 0 -65 160 96 -99 49 -45 -80 -99 135 -99 160 0 -80 96 91 0 135 -96 49 -65 160 256 -561 0 -96 -135 -864 49 -65 96 -99 49 91 -80 0 -561 -45 -96 -80 -80 -96 -45 -561 -135 -45 -135 -561 96 -65 -65 91 0 -45 49 91 96 256 256 144 0 105 160 -96 96 105 49 -96 165 0 49 -65 105 160 0 256 91 -135 105 -320 160 -96 -561 -45 96 -864 -864 0 0 -320 0

AOI

Amount Borrowed $ 35,000.00
Life of Loan 3
Annual Interest Rate 4.50%
Add-on Interest Payment $ 1,103.47
Effective Interest Rate 8.41%
Actual Payment $1,041.14

WEEK

Amount Borrowed $ 200,000.00
Annual Interest Rate 5.00%
Life of Loan 25 Years
Monthly Payment $1,169.18
Bi-weekly payment $584.59
Life of loan with bi-weekly payments 21.48 Years

1

2

3

4

5

6

7

8

A

B

Amount Borrowed

300,000.00

$

Life of Loan (Years)

3

Annual Interest Rate

6.00%

True Payment

$9,126.58

+10 Payment

$10,039.24

Life of +10 Loan in months

33