Embed
Email

Cashflow

Document Sample
Cashflow
Shared by: HC11111709278
Categories
Tags
Stats
views:
0
posted:
11/17/2011
language:
English
pages:
18
Summary Forecast Actual

Date Inc Exp Extras Sum Total Date Inc

Mortgage 200,000 Sep-05 22,000 Sep-05

Equity 65,000 Oct-05 8,816 8,588 228 22,228 Oct-05 9,806

Interest Paid 145,000 Nov-05 8,816 8,588 0 228 22,455 Nov-05 8,168

Balance 135,000 Dec-05 8,816 8,588 2,100 2,328 24,783 Dec-05 8,716

Charity Jan-06 8,816 8,588 0 228 25,010 Jan-06 7,684

Goal 4,500 Feb-06 8,816 8,588 0 228 25,238 Feb-06 7,085

To Go 1,000 Mar-06 8,816 8,588 2,100 2,328 27,565 Mar-06 10,848

Safety Fund Apr-06 8,816 8,588 4,050 3,822 23,743 Apr-06 9,180

Target (6 months) 20,000 May-06 8,816 8,588 0 228 23,970 May-06 8,322

Current 22,000 Jun-06 8,816 8,588 2,100 2,328 26,298 Jun-06 8,308

Reitrement Jul-06 8,816 8,588 228 26,525 Jul-06 9,118

401(k) 22,000 Aug-06 8,816 8,588 228 26,753 Aug-06 10,548

IRAs 16,000 Sep-06 8,816 8,588 228 26,980 Sep-06 7,048

Oct-06 8,816 8,588 0 228 27,208 Oct-06 0

Forecast Monthly Assumptions Nov-06 8,816 8,588 4,050 3,822 23,385 Nov-06 0

Husband Dec-06 8,816 8,588 228 23,613 Dec-06 0

Salary 4,166 Jan-07 8,816 8,588 0 228 23,840 Jan-07 0

Income tax 1,166 Feb-07 8,816 8,588 0 228 24,068 Feb-07 0

Tithe 420 Mar-07 8,816 8,588 2,100 2,328 26,395 Mar-07 0

401(k) contrib 500 Apr-07 8,816 8,588 4,050 3,822 22,573 Apr-07 0

ESPP 700 May-07 8,816 8,588 0 228 22,800 May-07 0

Secondary Income 400 Jun-07 8,816 8,588 2,100 2,328 25,128 Jun-07 0

Income Tax 112 Jul-07 8,816 8,588 1,800 1,572 23,555 Jul-07 0

Tithe 40 Aug-07 8,816 8,588 0 228 23,783 Aug-07 0

Wife Sep-07 8,816 8,588 2,100 2,328 26,110 Sep-07 0

Salary 3,750 Oct-07 8,816 8,588 0 228 26,338 Oct-07 0

Income Tax 1,050 Nov-07 8,816 8,588 4,050 3,822 22,516 Nov-07 0

Tithe 380 Dec-07 8,816 8,588 2,100 2,328 24,843 Dec-07 0

Secondary Income 500 Jan-08 8,816 8,588 0 228 25,071 Jan-08 0

Income Tax 140 Feb-08 8,816 8,588 0 228 25,298 Feb-08 0

Tithe 50 Mar-08 8,816 8,588 2,100 2,328 27,626 Mar-08 0

Combined Apr-08 8,816 8,588 4,050 3,822 23,803 Apr-08 0

Living 2,200 May-08 8,816 8,588 0 228 24,031 May-08 0

Principal + Interest 1,600 Jun-08 8,816 8,588 2,100 2,328 26,358 Jun-08 0

HOA 230 Jul-08 8,816 8,588 0 228 26,586 Jul-08 0

Subtotals Aug-08 8,816 8,588 0 228 26,813 Aug-08 0

Income 8,816 Sep-08 8,816 8,588 2,100 2,328 29,141 Sep-08 0

Expenses 8,588 Oct-08 8,816 8,588 0 228 29,368 Oct-08 0

Nov-08 8,816 8,588 4,050 3,822 25,546 Nov-08 0

Dec-08 8,816 8,588 2,100 2,328 27,873 Dec-08 0

Jan-09 8,816 8,588 0 228 28,101 Jan-09 0

Feb-09 8,816 8,588 0 228 28,328 Feb-09 0

Mar-09 8,816 8,588 2,100 2,328 30,656 Mar-09 0

Apr-09 8,816 8,588 4,050 3,822 26,833 Apr-09 0

May-09 8,816 8,588 0 228 27,061 May-09 0

Jun-09 8,816 8,588 2,100 2,328 29,388 Jun-09 0

Jul-09 8,816 8,588 0 228 29,616 Jul-09 0

Aug-09 8,816 8,588 0 228 29,843 Aug-09 0

Sep-09 8,816 8,588 2,100 2,328 32,171 Sep-09 0

Oct-09 8,816 8,588 0 228 32,398 Oct-09 0

Nov-09 8,816 8,588 4,050 3,822 28,576 Nov-09 0

Dec-09 8,816 8,588 2,100 2,328 30,904 Dec-09 0

60,000

58,000

56,000

54,000

52,000

50,000

48,000

46,000

44,000

42,000

40,000

38,000

36,000

34,000

32,000

30,000

28,000

26,000

24,000

22,000

20,000

18,000

16,000

14,000

12,000

10,000

8,000

6,000

4,000

2,000

0

Sep-2005 Nov-2005 Jan-2006 Mar-2006 May-2006 Jul-2006 Sep-2006 Nov-2006 Jan-2007 Mar-2007 May-2007 Jul-2007 Sep-2007

Actual Budget

Exp Extras Sum Total Budget Sep-06 Aug-06 Jul-06

22,000 His Salary 4,166.00 0.00 2,050.00 4,100.00

8,708 1,098 23,098 Her Salary 3,750.00 0.00 3,800.00 3,800.00









Income

8,908 0 740 22,358 Stock Sales 700.00 0.00 0.00 0.00

8,201 2,100 2,615 24,973 His Second Income 400.00 0.00 500.00 500.00

8,223 0 539 24,434 Her Second Income 500.00 0.00 0.00 0.00

5,187 0 1,898 26,332 Reimbursement 0.00 0.00 0.00 76.00

11,084 2,100 1,864 28,196 Income Other 0.00 0.00 0.00 75.00

4,687 4,040 453 28,649

8,368 0 46 28,603 His Income Tax 1,166.48 0.00 0.00 800.00

8,147 2,100 2,261 30,864 Her Income Tax 140.00 0.00 0.00 0.00

Job

9,851 733 30,131 ESPP 700.00 0.00 0.00 0.00

9,080 0 1,468 31,599 Retirement 500.00 0.00 0.00 105.00

9,515 0 2,467 29,132 Tithe 470.00 0.00 0.00 0.00

0 0 0 #N/A Groceries 400.00 0.00 50.94 129.29

Eat









0 0 0 #N/A Dining Out 200.00 0.00 25.00 176.23

0 0 0 #N/A Cell Phone 70.00 0.00 0.00 0.00

Media









0 0 0 #N/A Internet 30.00 0.00 43.28 43.28

0 0 0 #N/A Phone 6.00

0 0 0 #N/A Cable TV 0.00 0.00 0.00 0.00

0 0 0 #N/A Mortgage 1,600.00 0.00 1,600.00 1,600.00

0 0 0 #N/A HOA 230.00 0.00 23.50 47.00

Expenses

Home









0 0 0 #N/A Power 50.00 0.00 50.49 50.05

0 0 0 #N/A Water 30.00 0.00 10.47 9.37

0 0 0 #N/A Waste 20.00 0.00 0.00 0.00

0 0 0 #N/A Home Other 0.00 0.00 174.77 486.71

0 0 0 #N/A Gas 200.00 0.00 180.72 102.68

Other









0 0 0 #N/A Clothing 20.00 0.00 0.00 0.00

0 0 0 #N/A Gift 20.00 0.00 103.00 5.00

0 0 0 #N/A Expense Other 0.00 0.00 0.00 0.00

0 0 0 #N/A Property Tax 670.00 0.00 0.00 0.00

0 0 0 #N/A Home Insurance 40.00 0.00 0.00 0.00

Non-Monthly









0 0 0 #N/A Home Repair 100.00 0.00 0.00 0.00

0 0 0 #N/A Education 200.00 0.00 1,500.00 1,581.00

0 0 0 #N/A Medical 300.00 0.00 0.00 0.00

0 0 0 #N/A Car Insurance 350.00 0.00 0.00 0.00

0 0 0 #N/A Car Repair 50.00 0.00 0.00 0.00

0 0 0 #N/A Car Tax 20.00 0.00 0.00 0.00

0 0 0 #N/A

0 0 0 #N/A Job 2976.48 0.00 0.00 905.00

0 0 0 #N/A Eat 600.00 0.00 75.94 305.52

Subtotals









0 0 0 #N/A Media 106.00 0.00 43.28 43.28

0 0 0 #N/A Home 1930.00 0.00 1859.23 2193.13

0 0 0 #N/A Other 240.00 0.00 283.72 107.68

0 0 0 #N/A Non-Monthly 1730.00 0.00 1500.00 1581.00

0 0 0 #N/A

0 0 0 #N/A Unaccounted 0.00 0.00 90.00 75.00

0 0 0 #N/A $ Over (Under) 0.00 7,582.48 3,820.31 2,446.87

Totals









0 0 0 #N/A Total Income 9,516.00 0.00 6,350.00 8,551.00

0 0 0 #N/A Total Expenses 7,582.48 0.00 3,762.17 5,135.61

0 0 0 #N/A Difference 1,933.52 0.00 2,587.83 3,415.39

0 0 0 #N/A

0 0 0 #N/A

Sep-2007 Nov-2007 Jan-2008 Mar-2008 May-2008 Jul-2008 Sep-2008 Nov-2008 Jan-2009 Mar-2009 May-2009 Jul-2009 Sep-2009

Date Amount Category Description Additional Information

7/2/2006 $15.00 Fun Other BBQ stuff Gift

7/3/2006 $10.00 Dining Out Taco Bell Gift

7/3/2006 $52.20 Gas US Gas Minivan

7/3/2006 $1,600.00 Mortgage Mortgage principal July

7/6/2006 $23.50 HOA Home owners

7/6/2006 $254.78 Home Other Costco

7/8/2006 $54.84 Home Other Bed, Bath, and Beyond Computer

7/9/2006 $28.32 Groceries Trader Joe's

7/9/2006 $49.03 Dining Out Chick-fil-a

7/10/2006 $3.54 Dining Out Taco Bell

7/12/2006 $54.19 Home Other Microsoft Office 2003 Standard

7/12/2006 $27.17 Groceries Vons

7/12/2006 $1,500.00 Education Tuition

7/13/2006 $5.00 Gift Vegetable peeler For Andy Lasko

7/15/2006 $2,050.00 His Salary

7/15/2006 $9.37 Water July

7/18/2006 $50.05 Power July

7/18/2006 $5.40 Home Other Bed, Bath, and Beyond

7/18/2006 $3,800.00 Her Salary Cash

7/18/2006 $75.00 Income Other One check

7/19/2006 $500.00 His Second Income Sales June

7/21/2006 $43.28 Internet Roadrunner

7/22/2006 $90.00 Tutoring John Doe 2 hours

7/22/2006 $78.27 Home Other Ikea

7/22/2006 $81.00 Education LiveScan services

7/23/2006 $32.76 Home Other Walmart

7/23/2006 $6.47 Home Other Trader Joe's

7/25/2006 $50.48 Gas Shell Accord

7/26/2006 $2,050.00 His Salary Pre-tax salary

7/26/2006 $800.00 His Income Tax Tax on salary

7/28/2006 $105.00 Retirement 401(k)

7/30/2006 $23.50 HOA

7/31/2006 $21.73 Groceries Oakmont Product Market

7/31/2006 $52.07 Groceries Safeway

7/31/2006 $113.66 Dining Out Caleco Restaurant

7/31/2006 $76.00 Reimbursement Caleco Restaurant James Chan

8/1/2006 $25.00 Dining Out James Restaurant

8/3/2006 $96.50 Home Other Table

8/4/2006 $50.94 Groceries Safeway

8/4/2006 $1,500.00 Education

8/5/2006 $1,600.00 Mortgage Mortgage principal August

8/5/2006 $23.50 HOA Home owners

8/6/2006 $180.72 Gas Gas Place

8/15/2006 $2,050.00 His Salary

8/15/2006 $10.47 Water

8/16/2006 $50.49 Power

8/16/2006 $3,800.00 Her Salary Cash

8/22/2006 $90.00 Tutoring John Doe 2 hours

8/23/2006 $500.00 His Second Income

8/23/2006 $103.00 Gift

8/23/2006 $78.27 Home Other

8/24/2006 $43.28 Internet

Payment Reconciled? Check No Cashed

MC Y

MC Y

MC Y

Check 578

Visa Y

Visa Y

MC Y

Cash Y

MC Y

Cash Y

MC Y

MC Y

Check Y

Direct deposit Y

Direct deposit Y

Direct deposit Y

Direct deposit Y

Cash Y

Cash

Check

Cash Y

MC Y

Check

Visa

Cash

MC Y

MC Y

Visa

Cash Y

Cash Y

Cash Y

Check

MC Y

MC Y

MC

Check

MC

MC

MC

Check

Check

Visa

MC

Direct deposit

Direct deposit

Check

Cash

Check

Check

Cash

Cash

Direct deposit

Date Principal Interest Due Payment To Interest To Principal Equity Paid Interest Rate:

Jun-06 230,000.00 1,293.75 1,491.00 1,293.75 197.25 197.25 Y

Jul-06 229,802.75 1,292.64 1,491.00 1,292.64 198.36 395.61 Y

Aug-06 229,604.39 1,291.52 1,491.00 1,291.52 199.48 595.08 Y 300,000

Sep-06 229,404.92 1,290.40 1,491.00 1,290.40 200.60 795.68 Y

Oct-06 229,204.32 1,289.27 1,491.00 1,289.27 201.73 997.41 Y

Nov-06 229,002.59 1,288.14 1,491.00 1,288.14 202.86 1,200.27 250,000

Dec-06 228,799.73 1,287.00 1,491.00 1,287.00 204.00 1,404.27

Jan-07 228,595.73 1,285.85 1,491.00 1,285.85 205.15 1,609.42

Feb-07 228,390.58 1,284.70 1,491.00 1,284.70 206.30 1,815.72 200,000

Mar-07 228,184.28 1,283.54 1,491.00 1,283.54 207.46 2,023.19

Apr-07 227,976.81 1,282.37 1,491.00 1,282.37 208.63 2,231.82

May-07 227,768.18 1,281.20 1,491.00 1,281.20 209.80 2,441.62 150,000

Jun-07 227,558.38 1,280.02 1,491.00 1,280.02 210.98 2,652.60

Jul-07 227,347.40 1,278.83 1,491.00 1,278.83 212.17 2,864.77

Aug-07 227,135.23 1,277.64 1,491.00 1,277.64 213.36 3,078.14 100,000

Sep-07 226,921.86 1,276.44 1,491.00 1,276.44 214.56 3,292.70

Oct-07 226,707.30 1,275.23 1,491.00 1,275.23 215.77 3,508.47

Nov-07 226,491.53 1,274.01 1,491.00 1,274.01 216.99 3,725.46

50,000

Dec-07 226,274.54 1,272.79 1,491.00 1,272.79 218.21 3,943.67

Jan-08 226,056.33 1,271.57 1,491.00 1,271.57 219.43 4,163.10

Feb-08 225,836.90 1,270.33 1,491.00 1,270.33 220.67 4,383.77

0

Mar-08 225,616.23 1,269.09 1,491.00 1,269.09 221.91 4,605.68









Jun-06

Apr-08 225,394.32 1,267.84 1,491.00 1,267.84 223.16 4,828.83

May-08 225,171.17 1,266.59 1,491.00 1,266.59 224.41 5,053.24

Jun-08 224,946.76 1,265.33 1,491.00 1,265.33 225.67 5,278.92

Jul-08 224,721.08 1,264.06 1,491.00 1,264.06 226.94 5,505.86

Aug-08 224,494.14 1,262.78 1,491.00 1,262.78 228.22 5,734.08

Sep-08 224,265.92 1,261.50 1,491.00 1,261.50 229.50 5,963.59

Oct-08 224,036.41 1,260.20 1,491.00 1,260.20 230.80 6,194.38

Nov-08 223,805.62 1,258.91 1,491.00 1,258.91 232.09 6,426.48

Dec-08 223,573.52 1,257.60 1,491.00 1,257.60 233.40 6,659.87

Jan-09 223,340.13 1,256.29 1,491.00 1,256.29 234.71 6,894.59

Feb-09 223,105.41 1,254.97 1,491.00 1,254.97 236.03 7,130.62

Mar-09 222,869.38 1,253.64 1,491.00 1,253.64 237.36 7,367.98

Apr-09 222,632.02 1,252.31 1,491.00 1,252.31 238.69 7,606.67

May-09 222,393.33 1,250.96 1,491.00 1,250.96 240.04 7,846.71

Jun-09 222,153.29 1,249.61 1,491.00 1,249.61 241.39 8,088.10

Jul-09 221,911.90 1,248.25 1,491.00 1,248.25 242.75 8,330.84

Aug-09 221,669.16 1,246.89 1,491.00 1,246.89 244.11 8,574.96

Sep-09 221,425.04 1,245.52 1,491.00 1,245.52 245.48 8,820.44

Oct-09 221,179.56 1,244.14 1,491.00 1,244.14 246.86 9,067.30

Nov-09 220,932.70 1,242.75 1,491.00 1,242.75 248.25 9,315.56

Dec-09 220,684.44 1,241.35 1,491.00 1,241.35 249.65 9,565.21

Jan-10 220,434.79 1,239.95 1,491.00 1,239.95 251.05 9,816.26

Feb-10 220,183.74 1,238.53 1,491.00 1,238.53 252.47 10,068.73

Mar-10 219,931.27 1,237.11 1,491.00 1,237.11 253.89 10,322.62

Apr-10 219,677.38 1,235.69 1,491.00 1,235.69 255.31 10,577.93

May-10 219,422.07 1,234.25 1,491.00 1,234.25 256.75 10,834.68

Jun-10 219,165.32 1,232.80 1,491.00 1,232.80 258.20 11,092.88

Jul-10 218,907.12 1,231.35 1,491.00 1,231.35 259.65 11,352.52

Aug-10 218,647.48 1,229.89 1,491.00 1,229.89 261.11 11,613.63

Sep-10 218,386.37 1,228.42 1,491.00 1,228.42 262.58 11,876.21

Oct-10 218,123.79 1,226.95 1,491.00 1,226.95 264.05 12,140.26

Nov-10 217,859.74 1,225.46 1,491.00 1,225.46 265.54 12,405.80

Dec-10 217,594.20 1,223.97 1,491.00 1,223.97 267.03 12,672.83

Jan-11 217,327.17 1,222.47 1,491.00 1,222.47 268.53 12,941.37

Feb-11 217,058.63 1,220.95 1,491.00 1,220.95 270.05 13,211.41

Mar-11 216,788.59 1,219.44 1,491.00 1,219.44 271.56 13,482.98

Apr-11 216,517.02 1,217.91 1,491.00 1,217.91 273.09 13,756.07

May-11 216,243.93 1,216.37 1,491.00 1,216.37 274.63 14,030.70

Jun-11 215,969.30 1,214.83 1,491.00 1,214.83 276.17 14,306.87

Jul-11 215,693.13 1,213.27 1,491.00 1,213.27 277.73 14,584.60

Aug-11 215,415.40 1,211.71 1,491.00 1,211.71 279.29 14,863.88

Sep-11 215,136.12 1,210.14 1,491.00 1,210.14 280.86 15,144.74

Oct-11 214,855.26 1,208.56 1,491.00 1,208.56 282.44 15,427.18

Nov-11 214,572.82 1,206.97 1,491.00 1,206.97 284.03 15,711.21

Dec-11 214,288.79 1,205.37 1,491.00 1,205.37 285.63 15,996.84

Jan-12 214,003.16 1,203.77 1,491.00 1,203.77 287.23 16,284.07

Feb-12 213,715.93 1,202.15 1,491.00 1,202.15 288.85 16,572.92

Mar-12 213,427.08 1,200.53 1,491.00 1,200.53 290.47 16,863.39

Apr-12 213,136.61 1,198.89 1,491.00 1,198.89 292.11 17,155.50

May-12 212,844.50 1,197.25 1,491.00 1,197.25 293.75 17,449.24

Jun-12 212,550.76 1,195.60 1,491.00 1,195.60 295.40 17,744.65

Jul-12 212,255.35 1,193.94 1,491.00 1,193.94 297.06 18,041.71

Aug-12 211,958.29 1,192.27 1,491.00 1,192.27 298.73 18,340.45

Sep-12 211,659.55 1,190.58 1,491.00 1,190.58 300.42 18,640.86

Oct-12 211,359.14 1,188.90 1,491.00 1,188.90 302.10 18,942.97

Nov-12 211,057.03 1,187.20 1,491.00 1,187.20 303.80 19,246.77

Dec-12 210,753.23 1,185.49 1,491.00 1,185.49 305.51 19,552.28

Jan-13 210,447.72 1,183.77 1,491.00 1,183.77 307.23 19,859.51

Feb-13 210,140.49 1,182.04 1,491.00 1,182.04 308.96 20,168.47

Mar-13 209,831.53 1,180.30 1,491.00 1,180.30 310.70 20,479.17

Apr-13 209,520.83 1,178.55 1,491.00 1,178.55 312.45 20,791.62

May-13 209,208.38 1,176.80 1,491.00 1,176.80 314.20 21,105.82

Jun-13 208,894.18 1,175.03 1,491.00 1,175.03 315.97 21,421.79

Jul-13 208,578.21 1,173.25 1,491.00 1,173.25 317.75 21,739.54

Aug-13 208,260.46 1,171.47 1,491.00 1,171.47 319.53 22,059.07

Sep-13 207,940.93 1,169.67 1,491.00 1,169.67 321.33 22,380.40

Oct-13 207,619.60 1,167.86 1,491.00 1,167.86 323.14 22,703.54

Nov-13 207,296.46 1,166.04 1,491.00 1,166.04 324.96 23,028.50

Dec-13 206,971.50 1,164.21 1,491.00 1,164.21 326.79 23,355.29

Jan-14 206,644.71 1,162.38 1,491.00 1,162.38 328.62 23,683.91

Feb-14 206,316.09 1,160.53 1,491.00 1,160.53 330.47 24,014.38

Mar-14 205,985.62 1,158.67 1,491.00 1,158.67 332.33 24,346.71

Apr-14 205,653.29 1,156.80 1,491.00 1,156.80 334.20 24,680.91

May-14 205,319.09 1,154.92 1,491.00 1,154.92 336.08 25,016.99

Jun-14 204,983.01 1,153.03 1,491.00 1,153.03 337.97 25,354.96

Jul-14 204,645.04 1,151.13 1,491.00 1,151.13 339.87 25,694.84

Aug-14 204,305.16 1,149.22 1,491.00 1,149.22 341.78 26,036.62

Sep-14 203,963.38 1,147.29 1,491.00 1,147.29 343.71 26,380.33

Oct-14 203,619.67 1,145.36 1,491.00 1,145.36 345.64 26,725.96

Nov-14 203,274.04 1,143.42 1,491.00 1,143.42 347.58 27,073.55

Dec-14 202,926.45 1,141.46 1,491.00 1,141.46 349.54 27,423.09

Jan-15 202,576.91 1,139.50 1,491.00 1,139.50 351.50 27,774.59

Feb-15 202,225.41 1,137.52 1,491.00 1,137.52 353.48 28,128.07

Mar-15 201,871.93 1,135.53 1,491.00 1,135.53 355.47 28,483.54

Apr-15 201,516.46 1,133.53 1,491.00 1,133.53 357.47 28,841.01

May-15 201,158.99 1,131.52 1,491.00 1,131.52 359.48 29,200.50

Jun-15 200,799.50 1,129.50 1,491.00 1,129.50 361.50 29,562.00

Jul-15 200,438.00 1,127.46 1,491.00 1,127.46 363.54 29,925.53

Aug-15 200,074.47 1,125.42 1,491.00 1,125.42 365.58 30,291.12

Sep-15 199,708.88 1,123.36 1,491.00 1,123.36 367.64 30,658.75

Oct-15 199,341.25 1,121.29 1,491.00 1,121.29 369.71 31,028.46

Nov-15 198,971.54 1,119.21 1,491.00 1,119.21 371.79 31,400.24

Dec-15 198,599.76 1,117.12 1,491.00 1,117.12 373.88 31,774.12

Jan-16 198,225.88 1,115.02 1,491.00 1,115.02 375.98 32,150.10

Feb-16 197,849.90 1,112.91 1,491.00 1,112.91 378.09 32,528.19

Mar-16 197,471.81 1,110.78 1,491.00 1,110.78 380.22 32,908.41

Apr-16 197,091.59 1,108.64 1,491.00 1,108.64 382.36 33,290.77

May-16 196,709.23 1,106.49 1,491.00 1,106.49 384.51 33,675.29

Jun-16 196,324.71 1,104.33 1,491.00 1,104.33 386.67 34,061.96

Jul-16 195,938.04 1,102.15 1,491.00 1,102.15 388.85 34,450.81

Aug-16 195,549.19 1,099.96 1,491.00 1,099.96 391.04 34,841.84

Sep-16 195,158.16 1,097.76 1,491.00 1,097.76 393.24 35,235.08

Oct-16 194,764.92 1,095.55 1,491.00 1,095.55 395.45 35,630.53

Nov-16 194,369.47 1,093.33 1,491.00 1,093.33 397.67 36,028.20

Dec-16 193,971.80 1,091.09 1,491.00 1,091.09 399.91 36,428.11

Jan-17 193,571.89 1,088.84 1,491.00 1,088.84 402.16 36,830.26

Feb-17 193,169.74 1,086.58 1,491.00 1,086.58 404.42 37,234.68

Mar-17 192,765.32 1,084.30 1,491.00 1,084.30 406.70 37,641.38

Apr-17 192,358.62 1,082.02 1,491.00 1,082.02 408.98 38,050.36

May-17 191,949.64 1,079.72 1,491.00 1,079.72 411.28 38,461.65

Jun-17 191,538.35 1,077.40 1,491.00 1,077.40 413.60 38,875.24

Jul-17 191,124.76 1,075.08 1,491.00 1,075.08 415.92 39,291.17

Aug-17 190,708.83 1,072.74 1,491.00 1,072.74 418.26 39,709.43

Sep-17 190,290.57 1,070.38 1,491.00 1,070.38 420.62 40,130.04

Oct-17 189,869.96 1,068.02 1,491.00 1,068.02 422.98 40,553.03

Nov-17 189,446.97 1,065.64 1,491.00 1,065.64 425.36 40,978.39

Dec-17 189,021.61 1,063.25 1,491.00 1,063.25 427.75 41,406.14

Jan-18 188,593.86 1,060.84 1,491.00 1,060.84 430.16 41,836.30

Feb-18 188,163.70 1,058.42 1,491.00 1,058.42 432.58 42,268.88

Mar-18 187,731.12 1,055.99 1,491.00 1,055.99 435.01 42,703.89

Apr-18 187,296.11 1,053.54 1,491.00 1,053.54 437.46 43,141.35

May-18 186,858.65 1,051.08 1,491.00 1,051.08 439.92 43,581.27

Jun-18 186,418.73 1,048.61 1,491.00 1,048.61 442.39 44,023.66

Jul-18 185,976.34 1,046.12 1,491.00 1,046.12 444.88 44,468.55

Aug-18 185,531.45 1,043.61 1,491.00 1,043.61 447.39 44,915.93

Sep-18 185,084.07 1,041.10 1,491.00 1,041.10 449.90 45,365.84

Oct-18 184,634.16 1,038.57 1,491.00 1,038.57 452.43 45,818.27

Nov-18 184,181.73 1,036.02 1,491.00 1,036.02 454.98 46,273.25

Dec-18 183,726.75 1,033.46 1,491.00 1,033.46 457.54 46,730.78

Jan-19 183,269.22 1,030.89 1,491.00 1,030.89 460.11 47,190.89

Feb-19 182,809.11 1,028.30 1,491.00 1,028.30 462.70 47,653.59

Mar-19 182,346.41 1,025.70 1,491.00 1,025.70 465.30 48,118.89

Apr-19 181,881.11 1,023.08 1,491.00 1,023.08 467.92 48,586.81

May-19 181,413.19 1,020.45 1,491.00 1,020.45 470.55 49,057.36

Jun-19 180,942.64 1,017.80 1,491.00 1,017.80 473.20 49,530.56

Jul-19 180,469.44 1,015.14 1,491.00 1,015.14 475.86 50,006.42

Aug-19 179,993.58 1,012.46 1,491.00 1,012.46 478.54 50,484.96

Sep-19 179,515.04 1,009.77 1,491.00 1,009.77 481.23 50,966.18

Oct-19 179,033.82 1,007.07 1,491.00 1,007.07 483.93 51,450.12

Nov-19 178,549.88 1,004.34 1,491.00 1,004.34 486.66 51,936.78

Dec-19 178,063.22 1,001.61 1,491.00 1,001.61 489.39 52,426.17

Jan-20 177,573.83 998.85 1,491.00 998.85 492.15 52,918.32

Feb-20 177,081.68 996.08 1,491.00 996.08 494.92 53,413.23

Mar-20 176,586.77 993.30 1,491.00 993.30 497.70 53,910.93

Apr-20 176,089.07 990.50 1,491.00 990.50 500.50 54,411.43

May-20 175,588.57 987.69 1,491.00 987.69 503.31 54,914.75

Jun-20 175,085.25 984.85 1,491.00 984.85 506.15 55,420.89

Jul-20 174,579.11 982.01 1,491.00 982.01 508.99 55,929.88

Aug-20 174,070.12 979.14 1,491.00 979.14 511.86 56,441.74

Sep-20 173,558.26 976.27 1,491.00 976.27 514.73 56,956.47

Oct-20 173,043.53 973.37 1,491.00 973.37 517.63 57,474.10

Nov-20 172,525.90 970.46 1,491.00 970.46 520.54 57,994.65

Dec-20 172,005.35 967.53 1,491.00 967.53 523.47 58,518.12

Jan-21 171,481.88 964.59 1,491.00 964.59 526.41 59,044.53

Feb-21 170,955.47 961.62 1,491.00 961.62 529.38 59,573.91

Mar-21 170,426.09 958.65 1,491.00 958.65 532.35 60,106.26

Apr-21 169,893.74 955.65 1,491.00 955.65 535.35 60,641.61

May-21 169,358.39 952.64 1,491.00 952.64 538.36 61,179.97

Jun-21 168,820.03 949.61 1,491.00 949.61 541.39 61,721.35

Jul-21 168,278.65 946.57 1,491.00 946.57 544.43 62,265.79

Aug-21 167,734.21 943.50 1,491.00 943.50 547.50 62,813.28

Sep-21 167,186.72 940.43 1,491.00 940.43 550.57 63,363.86

Oct-21 166,636.14 937.33 1,491.00 937.33 553.67 63,917.53

Nov-21 166,082.47 934.21 1,491.00 934.21 556.79 64,474.31

Dec-21 165,525.69 931.08 1,491.00 931.08 559.92 65,034.23

Jan-22 164,965.77 927.93 1,491.00 927.93 563.07 65,597.30

Feb-22 164,402.70 924.77 1,491.00 924.77 566.23 66,163.53

Mar-22 163,836.47 921.58 1,491.00 921.58 569.42 66,732.95

Apr-22 163,267.05 918.38 1,491.00 918.38 572.62 67,305.58

May-22 162,694.42 915.16 1,491.00 915.16 575.84 67,881.42

Jun-22 162,118.58 911.92 1,491.00 911.92 579.08 68,460.50

Jul-22 161,539.50 908.66 1,491.00 908.66 582.34 69,042.84

Aug-22 160,957.16 905.38 1,491.00 905.38 585.62 69,628.46

Sep-22 160,371.54 902.09 1,491.00 902.09 588.91 70,217.37

Oct-22 159,782.63 898.78 1,491.00 898.78 592.22 70,809.59

Nov-22 159,190.41 895.45 1,491.00 895.45 595.55 71,405.15

Dec-22 158,594.85 892.10 1,491.00 892.10 598.90 72,004.05

Jan-23 157,995.95 888.73 1,491.00 888.73 602.27 72,606.32

Feb-23 157,393.68 885.34 1,491.00 885.34 605.66 73,211.98

Mar-23 156,788.02 881.93 1,491.00 881.93 609.07 73,821.05

Apr-23 156,178.95 878.51 1,491.00 878.51 612.49 74,433.54

May-23 155,566.46 875.06 1,491.00 875.06 615.94 75,049.48

Jun-23 154,950.52 871.60 1,491.00 871.60 619.40 75,668.89

Jul-23 154,331.11 868.11 1,491.00 868.11 622.89 76,291.77

Aug-23 153,708.23 864.61 1,491.00 864.61 626.39 76,918.17

Sep-23 153,081.83 861.09 1,491.00 861.09 629.91 77,548.08

Oct-23 152,451.92 857.54 1,491.00 857.54 633.46 78,181.54

Nov-23 151,818.46 853.98 1,491.00 853.98 637.02 78,818.56

Dec-23 151,181.44 850.40 1,491.00 850.40 640.60 79,459.16

Jan-24 150,540.84 846.79 1,491.00 846.79 644.21 80,103.37

Feb-24 149,896.63 843.17 1,491.00 843.17 647.83 80,751.20

Mar-24 149,248.80 839.52 1,491.00 839.52 651.48 81,402.68

Apr-24 148,597.32 835.86 1,491.00 835.86 655.14 82,057.82

May-24 147,942.18 832.17 1,491.00 832.17 658.83 82,716.64

Jun-24 147,283.36 828.47 1,491.00 828.47 662.53 83,379.17

Jul-24 146,620.83 824.74 1,491.00 824.74 666.26 84,045.43

Aug-24 145,954.57 820.99 1,491.00 820.99 670.01 84,715.44

Sep-24 145,284.56 817.23 1,491.00 817.23 673.77 85,389.21

Oct-24 144,610.79 813.44 1,491.00 813.44 677.56 86,066.78

Nov-24 143,933.22 809.62 1,491.00 809.62 681.38 86,748.15

Dec-24 143,251.85 805.79 1,491.00 805.79 685.21 87,433.36

Jan-25 142,566.64 801.94 1,491.00 801.94 689.06 88,122.42

Feb-25 141,877.58 798.06 1,491.00 798.06 692.94 88,815.36

Mar-25 141,184.64 794.16 1,491.00 794.16 696.84 89,512.20

Apr-25 140,487.80 790.24 1,491.00 790.24 700.76 90,212.95

May-25 139,787.05 786.30 1,491.00 786.30 704.70 90,917.65

Jun-25 139,082.35 782.34 1,491.00 782.34 708.66 91,626.31

Jul-25 138,373.69 778.35 1,491.00 778.35 712.65 92,338.96

Aug-25 137,661.04 774.34 1,491.00 774.34 716.66 93,055.62

Sep-25 136,944.38 770.31 1,491.00 770.31 720.69 93,776.31

Oct-25 136,223.69 766.26 1,491.00 766.26 724.74 94,501.05

Nov-25 135,498.95 762.18 1,491.00 762.18 728.82 95,229.87

Dec-25 134,770.13 758.08 1,491.00 758.08 732.92 95,962.79

Jan-26 134,037.21 753.96 1,491.00 753.96 737.04 96,699.83

Feb-26 133,300.17 749.81 1,491.00 749.81 741.19 97,441.01

Mar-26 132,558.99 745.64 1,491.00 745.64 745.36 98,186.37

Apr-26 131,813.63 741.45 1,491.00 741.45 749.55 98,935.92

May-26 131,064.08 737.24 1,491.00 737.24 753.76 99,689.68

Jun-26 130,310.32 733.00 1,491.00 733.00 758.00 100,447.69

Jul-26 129,552.31 728.73 1,491.00 728.73 762.27 101,209.95

Aug-26 128,790.05 724.44 1,491.00 724.44 766.56 101,976.51

Sep-26 128,023.49 720.13 1,491.00 720.13 770.87 102,747.38

Oct-26 127,252.62 715.80 1,491.00 715.80 775.20 103,522.58

Nov-26 126,477.42 711.44 1,491.00 711.44 779.56 104,302.15

Dec-26 125,697.85 707.05 1,491.00 707.05 783.95 105,086.10

Jan-27 124,913.90 702.64 1,491.00 702.64 788.36 105,874.45

Feb-27 124,125.55 698.21 1,491.00 698.21 792.79 106,667.25

Mar-27 123,332.75 693.75 1,491.00 693.75 797.25 107,464.50

Apr-27 122,535.50 689.26 1,491.00 689.26 801.74 108,266.24

May-27 121,733.76 684.75 1,491.00 684.75 806.25 109,072.49

Jun-27 120,927.51 680.22 1,491.00 680.22 810.78 109,883.27

Jul-27 120,116.73 675.66 1,491.00 675.66 815.34 110,698.61

Aug-27 119,301.39 671.07 1,491.00 671.07 819.93 111,518.54

Sep-27 118,481.46 666.46 1,491.00 666.46 824.54 112,343.08

Oct-27 117,656.92 661.82 1,491.00 661.82 829.18 113,172.26

Nov-27 116,827.74 657.16 1,491.00 657.16 833.84 114,006.11

Dec-27 115,993.89 652.47 1,491.00 652.47 838.53 114,844.64

Jan-28 115,155.36 647.75 1,491.00 647.75 843.25 115,687.89

Feb-28 114,312.11 643.01 1,491.00 643.01 847.99 116,535.89

Mar-28 113,464.11 638.24 1,491.00 638.24 852.76 117,388.65

Apr-28 112,611.35 633.44 1,491.00 633.44 857.56 118,246.21

May-28 111,753.79 628.62 1,491.00 628.62 862.38 119,108.60

Jun-28 110,891.40 623.76 1,491.00 623.76 867.24 119,975.84

Jul-28 110,024.16 618.89 1,491.00 618.89 872.11 120,847.95

Aug-28 109,152.05 613.98 1,491.00 613.98 877.02 121,724.97

Sep-28 108,275.03 609.05 1,491.00 609.05 881.95 122,606.92

Oct-28 107,393.08 604.09 1,491.00 604.09 886.91 123,493.84

Nov-28 106,506.16 599.10 1,491.00 599.10 891.90 124,385.74

Dec-28 105,614.26 594.08 1,491.00 594.08 896.92 125,282.66

Jan-29 104,717.34 589.04 1,491.00 589.04 901.96 126,184.62

Feb-29 103,815.38 583.96 1,491.00 583.96 907.04 127,091.66

Mar-29 102,908.34 578.86 1,491.00 578.86 912.14 128,003.80

Apr-29 101,996.20 573.73 1,491.00 573.73 917.27 128,921.07

May-29 101,078.93 568.57 1,491.00 568.57 922.43 129,843.50

Jun-29 100,156.50 563.38 1,491.00 563.38 927.62 130,771.12

Jul-29 99,228.88 558.16 1,491.00 558.16 932.84 131,703.96

Aug-29 98,296.04 552.92 1,491.00 552.92 938.08 132,642.05

Sep-29 97,357.95 547.64 1,491.00 547.64 943.36 133,585.41

Oct-29 96,414.59 542.33 1,491.00 542.33 948.67 134,534.08

Nov-29 95,465.92 537.00 1,491.00 537.00 954.00 135,488.08

Dec-29 94,511.92 531.63 1,491.00 531.63 959.37 136,447.45

Jan-30 93,552.55 526.23 1,491.00 526.23 964.77 137,412.22

Feb-30 92,587.78 520.81 1,491.00 520.81 970.19 138,382.41

Mar-30 91,617.59 515.35 1,491.00 515.35 975.65 139,358.06

Apr-30 90,641.94 509.86 1,491.00 509.86 981.14 140,339.20

May-30 89,660.80 504.34 1,491.00 504.34 986.66 141,325.86

Jun-30 88,674.14 498.79 1,491.00 498.79 992.21 142,318.07

Jul-30 87,681.93 493.21 1,491.00 493.21 997.79 143,315.86

Aug-30 86,684.14 487.60 1,491.00 487.60 1,003.40 144,319.26

Sep-30 85,680.74 481.95 1,491.00 481.95 1,009.05 145,328.30

Oct-30 84,671.70 476.28 1,491.00 476.28 1,014.72 146,343.03

Nov-30 83,656.97 470.57 1,491.00 470.57 1,020.43 147,363.46

Dec-30 82,636.54 464.83 1,491.00 464.83 1,026.17 148,389.63

Jan-31 81,610.37 459.06 1,491.00 459.06 1,031.94 149,421.57

Feb-31 80,578.43 453.25 1,491.00 453.25 1,037.75 150,459.31

Mar-31 79,540.69 447.42 1,491.00 447.42 1,043.58 151,502.90

Apr-31 78,497.10 441.55 1,491.00 441.55 1,049.45 152,552.35

May-31 77,447.65 435.64 1,491.00 435.64 1,055.36 153,607.71

Jun-31 76,392.29 429.71 1,491.00 429.71 1,061.29 154,669.00

Jul-31 75,331.00 423.74 1,491.00 423.74 1,067.26 155,736.26

Aug-31 74,263.74 417.73 1,491.00 417.73 1,073.27 156,809.53

Sep-31 73,190.47 411.70 1,491.00 411.70 1,079.30 157,888.83

Oct-31 72,111.17 405.63 1,491.00 405.63 1,085.37 158,974.21

Nov-31 71,025.79 399.52 1,491.00 399.52 1,091.48 160,065.69

Dec-31 69,934.31 393.38 1,491.00 393.38 1,097.62 161,163.31

Jan-32 68,836.69 387.21 1,491.00 387.21 1,103.79 162,267.10

Feb-32 67,732.90 381.00 1,491.00 381.00 1,110.00 163,377.10

Mar-32 66,622.90 374.75 1,491.00 374.75 1,116.25 164,493.35

Apr-32 65,506.65 368.47 1,491.00 368.47 1,122.53 165,615.88

May-32 64,384.12 362.16 1,491.00 362.16 1,128.84 166,744.71

Jun-32 63,255.29 355.81 1,491.00 355.81 1,135.19 167,879.90

Jul-32 62,120.10 349.43 1,491.00 349.43 1,141.57 169,021.48

Aug-32 60,978.52 343.00 1,491.00 343.00 1,148.00 170,169.47

Sep-32 59,830.53 336.55 1,491.00 336.55 1,154.45 171,323.93

Oct-32 58,676.07 330.05 1,491.00 330.05 1,160.95 172,484.87

Nov-32 57,515.13 323.52 1,491.00 323.52 1,167.48 173,652.35

Dec-32 56,347.65 316.96 1,491.00 316.96 1,174.04 174,826.40

Jan-33 55,173.60 310.35 1,491.00 310.35 1,180.65 176,007.04

Feb-33 53,992.96 303.71 1,491.00 303.71 1,187.29 177,194.33

Mar-33 52,805.67 297.03 1,491.00 297.03 1,193.97 178,388.30

Apr-33 51,611.70 290.32 1,491.00 290.32 1,200.68 179,588.99

May-33 50,411.01 283.56 1,491.00 283.56 1,207.44 180,796.42

Jun-33 49,203.58 276.77 1,491.00 276.77 1,214.23 182,010.65

Jul-33 47,989.35 269.94 1,491.00 269.94 1,221.06 183,231.71

Aug-33 46,768.29 263.07 1,491.00 263.07 1,227.93 184,459.64

Sep-33 45,540.36 256.16 1,491.00 256.16 1,234.84 185,694.48

Oct-33 44,305.52 249.22 1,491.00 249.22 1,241.78 186,936.26

Nov-33 43,063.74 242.23 1,491.00 242.23 1,248.77 188,185.03

Dec-33 41,814.97 235.21 1,491.00 235.21 1,255.79 189,440.82

Jan-34 40,559.18 228.15 1,491.00 228.15 1,262.85 190,703.67

Feb-34 39,296.33 221.04 1,491.00 221.04 1,269.96 191,973.63

Mar-34 38,026.37 213.90 1,491.00 213.90 1,277.10 193,250.73

Apr-34 36,749.27 206.71 1,491.00 206.71 1,284.29 194,535.02

May-34 35,464.98 199.49 1,491.00 199.49 1,291.51 195,826.53

Jun-34 34,173.47 192.23 1,491.00 192.23 1,298.77 197,125.30

Jul-34 32,874.70 184.92 1,491.00 184.92 1,306.08 198,431.38

Aug-34 31,568.62 177.57 1,491.00 177.57 1,313.43 199,744.81

Sep-34 30,255.19 170.19 1,491.00 170.19 1,320.81 201,065.62

Oct-34 28,934.38 162.76 1,491.00 162.76 1,328.24 202,393.87

Nov-34 27,606.13 155.28 1,491.00 155.28 1,335.72 203,729.58

Dec-34 26,270.42 147.77 1,491.00 147.77 1,343.23 205,072.81

Jan-35 24,927.19 140.22 1,491.00 140.22 1,350.78 206,423.59

Feb-35 23,576.41 132.62 1,491.00 132.62 1,358.38 207,781.98

Mar-35 22,218.02 124.98 1,491.00 124.98 1,366.02 209,148.00

Apr-35 20,852.00 117.29 1,491.00 117.29 1,373.71 210,521.71

May-35 19,478.29 109.57 1,491.00 109.57 1,381.43 211,903.14

Jun-35 18,096.86 101.79 1,491.00 101.79 1,389.21 213,292.35

Jul-35 16,707.65 93.98 1,491.00 93.98 1,397.02 214,689.37

Aug-35 15,310.63 86.12 1,491.00 86.12 1,404.88 216,094.25

Sep-35 13,905.75 78.22 1,491.00 78.22 1,412.78 217,507.03

Oct-35 12,492.97 70.27 1,491.00 70.27 1,420.73 218,927.75

Nov-35 11,072.25 62.28 1,491.00 62.28 1,428.72 220,356.47

Dec-35 9,643.53 54.24 1,491.00 54.24 1,436.76 221,793.23

Jan-36 8,206.77 46.16 1,491.00 46.16 1,444.84 223,238.06

Feb-36 6,761.94 38.04 1,491.00 38.04 1,452.96 224,691.03

Mar-36 5,308.97 29.86 1,491.00 29.86 1,461.14 226,152.16

Apr-36 3,847.84 21.64 1,491.00 21.64 1,469.36 227,621.52

May-36 2,378.48 13.38 1,491.00 13.38 1,477.62 229,099.14

Jun-36 900.86 5.07 1,491.00 5.07 1,485.93 230,585.07

Jun-08

6.75%



Jun-10





Jun-12





Jun-14





Jun-16





Jun-18





Jun-20





Jun-22





Jun-24





Jun-26





Jun-28





Jun-30





Jun-32





Jun-34





Jun-36

Date Bank 1 Bank 2 Bank 3 Stock Mutual Funds Credit Card 1 Credit Card 2 Credit Card 3

6/1/2006 2,050.00 500.00 5,000.00 6,000.00 1,800.00 300.00 500.00 1,500.00

7/1/2006 3,840.00 300.00 5,000.00 7,000.00 1,900.00 580.00 210.00 1,600.00

8/1/2006 3,900.00 400.00 5,100.00 7,000.00 2,000.00 100.00 0.00 1,800.00

Liquid Total 401(k) Roth IRA Traditional IRA Total

13,050.00 18,000.00 3,500.00 6,000.00 40,550.00

15,650.00 19,500.00 3,550.00 6,500.00 45,200.00

16,500.00 21,000.00 3,600.00 6,800.00 47,900.00


Related docs
Other docs by HC11111709278
Est Temp Instructions
Views: 0  |  Downloads: 0
Basic Credit Analysis
Views: 1  |  Downloads: 0
Cashflow
Views: 0  |  Downloads: 0
Sheet1
Views: 1  |  Downloads: 0
?????
Views: 17  |  Downloads: 0
Sheet1
Views: 0  |  Downloads: 0
Choosing between Blue Cross plans�
Views: 1  |  Downloads: 0
Tax Study Questions Ch 1 2
Views: 211  |  Downloads: 0
Elegant Letter
Views: 0  |  Downloads: 0
By registering with docstoc.com you agree to our
privacy policy

You are almost ready to download!

You are almost ready to download!