Excel Project 1 - Financial Planning Investment Project

99 feb 85 45527849 mar 85 45870368 apr 85 46215171

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: Feb-85 $455,278.49 Mar-85 $458,703.68 Apr-85 $462,151.71 May-85 $465,622.72 Jun-85 $469,116.87 Jul-85 $472,634.32 Aug-85 $476,175.21 Sep-85 $479,739.71 Oct-85 $483,327.98 Nov-85 $486,940.16 Dec-85 $490,576.43 Jan-86 $494,236.94 Feb-86 $497,921.85 Mar-86 $501,631.33 Apr-86 $505,365.54 May-86 $509,124.65 Jun-86 $512,908.81 Jul-86 $516,718.20 Aug-86 $520,552.99 Sep-86 $524,413.34 Oct-86 $528,299.43 Nov-86 $532,211.43 Dec-86 $536,149.50 Jan-87 $540,113.83 Feb-87 $544,104.59 Mar-87 $548,121.96 Apr-87 $552,166.10 May-87 $556,237.21 Jun-87 $560,335.46 Jul-87 $564,461.03 Aug-87 $568,614.10 Sep-87 $572,794.86 Oct-87 $577,003.50 Nov-87 $581,240.18 Dec-87 $585,505.12 Jan-88 $589,798.49 Feb-88 $594,120.48 Mar-88 $598,471.28 Apr-88 $602,851.09 May-88 $607,260.10 Jun-88 $611,698.50 Jul-88 $616,166.49 Aug-88 $620,664.26 Sep-88 $625,192.02 Oct-88 $629,749.97 Nov-88 $634,338.30 Dec-88 $638,957.23 Jan-89 $643,606.94 Feb-89 $648,287.65 Mar-89 $652,999.57 Apr-89 $657,742.90 May-89 $662,517.86 Jun-89 $667,324.64 Jul-89 $672,163.47 Aug-89 $677,034.56 Sep-89 $681,938.13 Oct-89 $686,874.38 Nov-89 $691,843.54 Dec-89 $696,845.83 Jan-90 $701,881.47 Feb-90 $706,950.68 Mar-90 $712,053.69 Apr-90 $717,190.71 May-90 $722,361.98 Jun-90 $727,567.73 Jul-90 $732,808.18 Aug-90 $738,083.57 Sep-90 Employer Matching Contributions Balance (8%) Withdrawal Amount Date At Months End Date Account Balance (8%) Withdrawal Amount $2,057,070.56 $13,713.80 Jan-13 $780.00 Jan-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Feb-13 $1,565.20 Feb-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Mar-13 $2,355.63 Mar-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Apr-13 $3,151.34 Apr-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 May-13 $3,952.35 May-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Jun-13 $4,758.70 Jun-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Jul-13 $5,570.42 Jul-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Aug-13 $6,387.56 Aug-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Sep-13 $7,210.14 Sep-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Oct-13 $8,038.21 Oct-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Nov-13 $8,871.80 Nov-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Dec-13 $9,710.94 Dec-58 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Jan-14 $10,555.68 Jan-59 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Feb-14 $11,406.05 Feb-59 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Mar-14 $12,262.09 Mar-59 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Apr-14 $13,123.84 Apr-59 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 May-14 $13,991.33 May-59 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Jun-14 $14,864.61 Jun-59 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Jul-14 $15,743.71 Jul-59 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Aug-14 $16,628.66 Aug-59 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Sep-14 $17,519.52 Sep-59 $2,468,484.67 $16,456.56 $2,057,070.56 $13,713.80 Oct-14 $18,416.32...
View Full Document

Ask a homework question - tutors are online