C A S H   F L O W   S T A T E M E N T

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2011

2012

2013

2014

2015

Age:

41/40

42/41

43/42

44/43

45/44

BEGINNING OF YEAR

Idle Cash On Hand

1,000

1,000

1,000

1,000

1,000

SOURCES OF CASH

Cash Income

Matt's Salary

122,723

126,404

130,197

134,103

138,126

Tammy's Consulting

65,564

67,531

69,556

71,643

73,792

Interest+Dividends

857

860

864

867

871

Municipal Bonds

              405

              405

              405

              405

              405

189,548

195,200

201,022

207,018

213,194

Investments

BeachHouse

         29,504

         30,389

         31,300

         32,239

         33,207

29,504

30,389

31,300

32,239

33,207

Total Cash Inflow

219,052

225,589

232,322

239,257

246,400

Tot Cash Available

220,052

226,589

233,322

240,257

247,400

USES OF CASH

Fully Tax Deductible

Matt's 401k

16,500

16,500

14,000

14,000

14,500

Tammy's SEP

9,835

10,130

10,433

10,746

11,069

Home Mortgage

         12,013

         11,689

         11,346

         10,982

         10,597

38,348

38,319

35,779

35,728

36,166

Partly Deductible

Medicine & Drugs

3,934

4,052

4,173

4,299

4,428

Charity

1,311

1,351

1,391

1,433

1,476

Tax & Financial Fee

              273

              281

              290

              299

              307

5,518

5,684

5,854

6,030

6,211

Not Tax Deductible

Food

9,835

10,130

10,433

10,746

11,069

Clothing

5,245

5,402

5,565

5,731

5,903

Entertainment

6,556

6,753

6,956

7,164

7,379

Vacations

6,556

6,753

6,956

7,164

7,379

Gas

3,934

4,052

4,173

4,299

4,428

Future Car Leases

0

0

0

7,200

7,416

Matt's Term

600

600

600

600

600

Tammmy's VUL

900

900

900

900

900

Repair/Maintenance

2,623

2,701

2,782

2,866

2,952

Household Exp.

5,245

5,402

5,565

5,731

5,903

Utilities

7,868

8,104

8,347

8,597

8,855

Tammy's Roth IRA

           2,900

           1,750

                 0

                 0

                 0

52,261

52,547

52,276

60,999

62,784


 

 

 

 

 

 

 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T (cont.)

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2011

2012

2013

2014

2015

Age:

41/40

42/41

43/42

44/43

45/44

Taxes Paid

Fed Tax Paid

30,320

33,507

42,739

45,263

47,706

State Tax Paid

6,815

7,236

7,831

8,278

8,706

FICA/Soc Sec Tax

6,265

8,994

9,328

9,682

10,057

Real Estate Tax

         15,399

         16,015

         16,656

         17,322

         18,015

58,800

65,752

76,554

80,546

84,484

Purchase/Deposits

Excess Cash Fund

         35,696

         34,330

         32,347

         25,861

         26,053

35,696

34,330

32,347

25,861

26,053

Investments

BeachHouse

         22,935

         23,139

         23,350

         23,568

         23,792

22,935

23,139

23,350

23,568

23,792

Liability Liquidation

Home Mortgage

           5,494

           5,818

           6,161

           6,525

           6,910

5,494

5,818

6,161

6,525

6,910

Tot Cash Outflow

219,052

225,589

232,322

239,257

246,400

END OF YEAR

Cash Balance

1,000

1,000

1,000

1,000

1,000


 

 

 

 

 

 

 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2016

2017

2018

2019

2020

Age:

46/45

47/46

48/47

49/48

50/49

BEGINNING OF YEAR

Idle Cash On Hand

1,000

1,000

1,000

1,000

1,000

SOURCES OF CASH

Cash Income

Matt's Salary

142,269

146,537

150,934

155,462

160,125

Tammy's Consulting

76,006

78,286

80,635

83,054

85,546

Interest+Dividends

874

878

882

887

891

Municipal Bonds

              405

              405

              405

              405

              405

219,555

226,107

232,856

239,807

246,967

Investments

BeachHouse

         34,203

         35,229

         36,286

         37,374

         38,496

34,203

35,229

36,286

37,374

38,496

Total Cash Inflow

253,758

261,336

269,142

277,182

285,463

Tot Cash Available

254,758

262,336

270,142

278,182

286,462

USES OF CASH

Fully Tax Deductible

Matt's 401k

14,500

15,000

15,000

15,500

15,500

Tammy's SEP

11,401

11,743

12,095

12,458

12,832

Home Mortgage

         10,189

           9,757

           9,299

           8,815

           8,301

36,090

36,500

36,394

36,773

36,633

Partly Deductible

Medicine & Drugs

4,560

4,697

4,838

4,983

5,133

Charity

1,520

1,566

1,613

1,661

1,711

Tax & Financial Fee

              317

              326

              336

              346

              356

6,397

6,589

6,787

6,990

7,200

Not Tax Deductible

Food

11,401

11,743

12,095

12,458

12,832

Clothing

6,080

6,263

6,451

6,644

6,844

Entertainment

7,601

7,829

8,063

8,305

8,555

Vacations

7,601

7,829

8,063

8,305

8,555

Gas

4,560

4,697

4,838

4,983

5,133

Future Car Leases

7,638

7,868

8,104

8,347

8,597

Tammmy's VUL

900

900

900

900

900

Repair/Maintenance

3,040

3,131

3,225

3,322

3,422

Household Exp.

6,080

6,263

6,451

6,644

6,844

Utilities

           9,121

           9,394

           9,676

           9,966

         10,265

64,023

65,917

67,867

69,876

71,946


 

 

 

 

 

 

 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T (cont.)

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2016

2017

2018

2019

2020

Age:

46/45

47/46

48/47

49/48

50/49

Taxes Paid

Fed Tax Paid

50,395

53,009

55,875

58,782

62,046

State Tax Paid

9,181

9,638

10,143

10,630

11,167

FICA/Soc Sec Tax

10,433

10,830

11,247

11,666

12,105

Real Estate Tax

         18,736

         19,485

         20,265

         21,075

         21,918

88,744

92,962

97,529

102,154

107,236

Purchase/Deposits

Excess Cash Fund

         27,163

         27,359

         27,852

         27,940

         28,226

27,163

27,359

27,852

27,940

28,226

Investments

BeachHouse

         24,022

         24,260

         24,504

         24,756

         25,016

24,022

24,260

24,504

24,756

25,016

Liability Liquidation

Home Mortgage

           7,318

           7,750

           8,208

           8,692

           9,206

7,318

7,750

8,208

8,692

9,206

Tot Cash Outflow

253,758

261,336

269,142

277,182

285,462

END OF YEAR

Cash Balance

1,000

1,000

1,000

1,000

1,000


 

 

 

 

 

 

 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2021

2022

2023

2024

2025

Age:

51/50

52/51

53/52

54/53

55/54

BEGINNING OF YEAR

Idle Cash On Hand

1,000

1,000

1,000

1,000

1,000

SOURCES OF CASH

Cash Income

Matt's Salary

164,929

169,877

174,973

180,223

185,629

Tammy's Consulting

88,112

90,755

93,478

96,282

99,171

Interest+Dividends

896

900

905

910

916

Municipal Bonds

              405

              405

              405

              405

              405

254,342

261,938

269,762

277,820

286,121

Investments

BeachHouse

         39,650

         40,840

         42,065

         43,327

         44,627

39,650

40,840

42,065

43,327

44,627

Sale/Withdrawals

529 Plans

                 0

                 0

                 0

         40,000

         40,000

0

0

0

40,000

40,000

Total Cash Inflow

293,992

302,778

311,827

361,147

370,748

Tot Cash Available

294,992

303,777

312,827

362,147

371,747

USES OF CASH

Fully Tax Deductible

Matt's 401k

16,000

16,000

16,000

16,500

16,500

Tammy's SEP

13,217

13,613

14,022

14,442

14,876

Home Mortgage

           7,758

           7,182

           6,573

           5,927

           5,244

36,975

36,795

36,595

36,869

36,620

Partly Deductible

Medicine & Drugs

5,287

5,445

5,609

5,777

5,950

Charity

1,762

1,815

1,870

1,926

1,983

Tax & Financial Fee

              367

              378

              389

              401

              413

7,416

7,639

7,868

8,104

8,347

Not Tax Deductible

Jacob's College Exp

0

0

0

40,000

40,000

Food

13,217

13,613

14,022

14,442

14,876

Clothing

7,049

7,260

7,478

7,703

7,934

Entertainment

8,811

9,076

9,348

9,628

9,917

Vacations

8,811

9,076

9,348

9,628

9,917

Gas

5,287

5,445

5,609

5,777

5,950

Future Car Leases

8,855

9,121

9,394

9,676

9,966

Tammmy's VUL

900

900

900

900

900

Repair/Maintenance

3,524

3,630

3,739

3,851

3,967


 

 

 

 

 

 

 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T (cont.)

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2021

2022

2023

2024

2025

Age:

51/50

52/51

53/52

54/53

55/54

Household Exp.

7,049

7,260

7,478

7,703

7,934

Utilities

         10,573

         10,891

         11,217

         11,554

         11,901

74,077

76,272

78,533

120,862

123,261

Taxes Paid

Fed Tax Paid

65,240

68,720

72,438

75,994

79,862

State Tax Paid

12,006

12,577

13,165

13,739

14,460

FICA/Soc Sec Tax

12,566

12,996

13,385

13,787

14,201

Real Estate Tax

         22,795

         23,707

         24,655

         25,641

         26,667

112,607

117,999

123,642

129,161

135,190

Purchase/Deposits

Excess Cash Fund

         27,886

         28,188

         28,413

         28,436

         28,631

27,886

28,188

28,413

28,436

28,631

Investments

BeachHouse

         25,283

         25,559

         25,842

         26,134

         26,435

25,283

25,559

25,842

26,134

26,435

Liability Liquidation

Home Mortgage

           9,749

         10,325

         10,934

         11,580

         12,263

9,749

10,325

10,934

11,580

12,263

Tot Cash Outflow

293,993

302,777

311,827

361,147

370,747

END OF YEAR

Cash Balance

1,000

1,000

1,000

1,000

1,000


 

 

 

 

 

 

 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2026

2027

2028

2029

2030

Age:

56/55

57/56

58/57

59/58

60/59

BEGINNING OF YEAR

Idle Cash On Hand

1,000

1,000

1,000

1,000

1,000

SOURCES OF CASH

Cash Income

Matt's Salary

191,198

196,934

202,842

208,927

215,195

Tammy's Consulting

102,146

105,210

108,367

111,618

114,966

Interest+Dividends

921

927

933

939

946

Municipal Bonds

              405

              405

              405

              405

              405

294,670

303,476

312,547

321,889

331,512

Investments

BeachHouse

         45,966

         47,345

         48,765

         50,228

         51,735

45,966

47,345

48,765

50,228

51,735

Sale/Withdrawals

529 Plans

         40,000

         37,427

                 0

                 0

                 0

40,000

37,427

0

0

0

Total Cash Inflow

380,636

388,248

361,312

372,117

383,247

Tot Cash Available

381,636

389,248

362,311

373,117

384,246

USES OF CASH

Fully Tax Deductible

Matt's 401k

17,000

17,000

17,500

18,000

18,000

Tammy's SEP

15,322

15,782

16,255

16,743

17,245

Home Mortgage

           4,520

           3,752

           2,941

           2,081

           1,170

36,842

36,534

36,696

36,824

36,415

Partly Deductible

Medicine & Drugs

6,129

6,313

6,502

6,697

6,898

Charity

2,043

2,104

2,167

2,232

2,299

Tax & Financial Fee

              426

              438

              452

              465

              479

8,597

8,855

9,121

9,394

9,676

Not Tax Deductible

Jacob's College Exp

40,000

40,000

0

0

0

Food

15,322

15,782

16,255

16,743

17,245

Clothing

8,172

8,417

8,669

8,929

9,197

Entertainment

10,215

10,521

10,837

11,162

11,497

Vacations

10,215

10,521

10,837

11,162

11,497

Gas

6,129

6,313

6,502

6,697

6,898

Future Car Leases

10,265

10,573

10,891

11,217

11,554

Tammmy's VUL

900

900

900

900

900

Repair/Maintenance

4,086

4,208

4,335

4,465

4,599


 

 

 

 

 

 

 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T (cont.)

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2026

2027

2028

2029

2030

Age:

56/55

57/56

58/57

59/58

60/59

Household Exp.

8,172

8,417

8,669

8,929

9,197

Utilities

         12,258

         12,625

         13,004

         13,394

         13,796

125,732

128,277

90,898

93,598

96,379

Taxes Paid

Fed Tax Paid

83,721

88,488

93,610

97,881

102,479

State Tax Paid

15,072

15,848

16,683

17,357

18,085

FICA/Soc Sec Tax

14,627

15,065

15,517

15,983

16,462

Real Estate Tax

         27,733

         28,843

         29,996

         31,196

         32,444

141,153

148,244

155,807

162,417

169,470

Purchase/Deposits

Excess Cash Fund

         28,580

         25,519

         26,830

         26,726

         26,888

28,580

25,519

26,830

26,726

26,888

Investments

BeachHouse

         26,745

         27,064

         27,393

         27,732

         28,081

26,745

27,064

27,393

27,732

28,081

Liability Liquidation

Home Mortgage

         12,987

         13,755

         14,566

         15,426

         16,337

12,987

13,755

14,566

15,426

16,337

Tot Cash Outflow

380,637

388,248

361,312

372,117

383,246

END OF YEAR

Cash Balance

1,000

1,000

1,000

1,000

1,000


 

 

 

 

 

 

 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2031

2032

2033

2034

2035

Age:

61/60

62/61

63/62

64/63

65/64

BEGINNING OF YEAR

Idle Cash On Hand

1,000

1,000

952

962

950

SOURCES OF CASH

Cash Income

Matt's Salary

221,651

0

0

0

0

Tammy's Consulting

118,415

121,968

0

0

0

Interest+Dividends

952

959

967

974

982

Municipal Bonds

              405

              405

              405

              405

              405

341,424

123,332

1,372

1,379

1,387

Investments

BeachHouse

         53,287

         54,885

         56,532

         58,228

         59,975

53,287

54,885

56,532

58,228

59,975

Sale/Withdrawals

Excess Cash Fund

                 0

         76,171

       140,786

       146,666

       152,108

0

76,171

140,786

146,666

152,108

Total Cash Inflow

394,711

254,389

198,690

206,273

213,470

Tot Cash Available

395,711

255,389

199,642

207,235

214,420

USES OF CASH

Fully Tax Deductible

Matt's 401k

18,500

0

0

0

0

Tammy's SEP

17,762

18,295

0

0

0

Home Mortgage

              247

                 0

                 0

                 0

                 0

36,509

18,295

0

0

0

Partly Deductible

Medicine & Drugs

7,105

7,318

7,538

7,764

7,997

Charity

2,368

2,439

2,513

2,588

2,666

Tax & Financial Fee

              493

              508

              523

              539

                 0

9,967

10,266

10,574

10,891

10,662

Not Tax Deductible

Food

17,762

18,295

18,844

19,409

19,992

Clothing

9,473

9,757

10,050

10,352

10,662

Entertainment

11,842

12,197

12,563

12,940

13,328

Vacations

11,842

12,197

12,563

12,940

13,328

Gas

7,105

7,318

7,538

7,764

7,997

Future Car Leases

11,901

12,258

12,625

13,004

13,394

Tammmy's VUL

900

900

900

900

900

Repair/Maintenance

4,737

4,879

5,025

5,176

5,331

Household Exp.

9,473

9,757

10,050

10,352

10,662


 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T (cont.)

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2031

2032

2033

2034

2035

Age:

61/60

62/61

63/62

64/63

65/64

Utilities

14,210

14,636

15,075

15,527

15,993

Tammy's Roth IRA

                 0

           2,000

                 0

                 0

                 0

99,244

104,194

105,233

108,363

111,587

Taxes Paid

Fed Tax Paid

106,890

49,610

14,335

16,140

17,926

State Tax Paid

18,804

8,170

2,852

3,353

3,792

FICA/Soc Sec Tax

16,956

0

0

0

0

Real Estate Tax

         33,742

         35,092

         36,495

         37,955

         39,473

176,391

92,872

53,683

57,448

61,192

Purchase/Deposits

Excess Cash Fund

         32,736

                 0

                 0

                 0

                 0

32,736

0

0

0

0

Investments

BeachHouse

         28,440

         28,810

         29,191

         29,584

         29,988

28,440

28,810

29,191

29,584

29,988

Liability Liquidation

Home Mortgage

         11,424

                 0

                 0

                 0

                 0

11,424

0

0

0

0

Tot Cash Outflow

394,711

254,436

198,680

206,285

213,428

END OF YEAR

Cash Balance

1,000

952

962

950

991


 

 

 

 

 

 

 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2040

2045

2050

2055

2060

Age:

70/69

75/74

80/79

85/84

89

BEGINNING OF YEAR

Idle Cash On Hand

965

987

1,000

1,000

1,000

SOURCES OF CASH

Cash Income

Matt's IRA

60,433

80,163

104,525

132,899

159,935

Tammy's IRA

0

64,078

84,038

107,805

131,565

Soc Security Inc

73,202

84,861

98,378

114,046

132,211

Interest+Dividends

1,027

1,081

1,147

1,227

1,324

Municipal Bonds

              405

              405

              405

              405

              405

135,067

230,588

288,492

356,382

425,440

Investments

BeachHouse

         69,527

         80,601

         93,439

       108,321

       125,574

69,527

80,601

93,439

108,321

125,574

Sale/Withdrawals

Excess Cash Fund

         47,386

           3,413

                 0

                 0

                 0

47,386

3,413

0

0

0

Total Cash Inflow

251,980

314,602

381,931

464,703

551,014

Tot Cash Available

252,945

315,589

382,931

465,703

552,014

USES OF CASH

Partly Deductible

Medicine & Drugs

9,270

10,747

12,459

14,443

16,743

Charity

           3,090

           3,582

           4,153

           4,814

           5,581

12,360

14,329

16,611

19,257

22,324

Not Tax Deductible

Food

23,176

26,867

31,146

36,107

41,858

Clothing

12,360

14,329

16,611

19,257

22,324

Entertainment

15,450

17,911

20,764

24,071

27,905

Vacations

15,450

17,911

20,764

24,071

27,905

Gas

9,270

10,747

12,459

14,443

16,743

Future Car Leases

15,527

18,001

20,868

24,191

28,044

Tammmy's VUL

900

900

900

900

900

Repair/Maintenance

6,180

7,165

8,306

9,629

11,162

Household Exp.

12,360

14,329

16,611

19,257

22,324

Utilities

         18,541

         21,494

         24,917

         28,886

         33,486

129,216

149,654

173,346

200,812

232,653

Taxes Paid

Fed Tax Paid

44,984

72,806

94,290

116,469

140,465

State Tax Paid

1,277

753

919

1,220

3,045

Real Estate Tax

         48,025

         58,430

         71,089

         86,491

       105,229

94,287

131,990

166,297

204,179

248,739


 

 

 

 

 

 

 

 

 

 

 

 

 

 

C A S H   F L O W   S T A T E M E N T (cont.)

Matthew Retires at age 62

 

 

 

 

 

 

 

 

 

 

 

Matthew & Tammy McCarthey

 

 

 

 

 

 

 

 

 

 

Sample Plan

2040

2045

2050

2055

2060

Age:

70/69

75/74

80/79

85/84

89

Purchase/Deposits

Excess Cash Fund

                 0

                 0

           4,047

         15,380

         18,230

0

0

4,047

15,380

18,230

Investments

BeachHouse

         16,094

         18,658

         21,629

         25,074

         29,068

16,094

18,658

21,629

25,074

29,068

Tot Cash Outflow

251,958

314,630

381,931

464,703

551,015

END OF YEAR

Cash Balance

988

959

1,000

1,000

1,000

 

                                 

Cash Flow Statement provides year by year projections for sources and uses of cash.

 

Next Graph Back to Reports Next Graph