Docstoc

UNCLE

Document Sample
UNCLE Powered By Docstoc
					Scenario Summary
                                                   LOAF-IN        LOAF-OUT      DELAY-IN
Changing Cells:
RETIRE OR WORK, 2008                   $C$10          R               R            W
RETIRE OR WORK, 2009                   $D$10          R               R            W
RETIRE OR WORK, 2010                   $E$10          R               R            W
RETIRE OR WORK, 2011                   $F$10          R               R            R
RETIRE OR WORK, 2012                   $G$10          R               R            R
RETIRE OR WORK, 2013                   $H$10          R               R            R
IN CLUB, 2008-2013?                    $C$11           Y              N            Y
Result Cells:
END-OF-THE-YEAR CASH ON HAND $H$14                    -$68,400        $15,195       $8,389
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
DELAY-OUT

   W
   W
   W
   R
   R
   R
   N

    $83,689
                  A                  B        C         D         E         F         G
 1   YOUR UNCLE'S EARLY RETIREMENT DECISION
 2   CONSTANTS                      2007     2008      2009      2010      2011      2012
 3   SALARY INCREASE FACTOR          NA         0.03      0.03      0.02      0.02      0.01
 4   PART TIME WAGES EXPECTED        NA       10000     10200     10500     10800     11400
 5   BUY OUT AMOUNT                  NA       30000     25000     20000     15000      5000
 6   COST OF LIVING (NOT RETIRED)    NA       41000     42000     43000     44000     45000
 7   COUNTRY CLUB DUES               NA       12000     13000     14000     15000     16000
 8
 9   INPUTS                         2007     2008      2009      2010      2011      2012
10   RETIRED [R] or WORKING [W]      NA       W         W         W         R         R
11   STAY IN CLUB? [Y] OR [N]        NA       Y         NA        NA        NA        NA
12
13 SUMMARY OF KEY RESULTS           2006     2007      2008      2009      2010      2011
   END-OF-THE-YEAR
14 CASH ON HAND                     NA        50580     71490     92189     73989     44389
15
16 CALCULATIONS                     2007     2008      2009      2010      2011      2012
17 TAX RATE                          NA          0.3       0.3       0.3      0.15      0.15
18 COST OF LIVING                    NA       41000     42000     43000     29000     30000
19 YEARLY SALARY OR WAGES            80000    82400     84872     86569     10800     11400
20 COUNTRY CLUB DUES PAID            NA       12000     13000     14000     15000     16000
21
   INCOME STATEMENT AND
22 CASH FLOW STATEMENT              2007     2008      2009      2010      2011      2012
   BEGINNING-OF-THE-YEAR
23 CASH ON HAND                     NA        30000     50580     71490     92189     73989
24
25 SALARY OR WAGES                  NA        82400     84872     86569     10800     11400
26 BUY OUT INCOME                   NA            0         0         0     15000      5000
27 TOTAL CASH INFLOW                NA        82400     84872     86569     25800     16400
28 COUNTRY CLUB DUES PAID           NA        12000     13000     14000     15000     16000
29 COST OF LIVING                   NA        41000     42000     43000     29000     30000
30 TOTAL COSTS                      NA        53000     55000     57000     44000     46000
31 INCOME BEFORE TAXES              NA        29400     29872     29569    -18200    -29600
32 INCOME TAX EXPENSE               NA         8820      8962      8871         0         0
33 NET INCOME AFTER TAXES           NA        20580     20910     20699    -18200    -29600
34
   END-OF-THE-YEAR CASH ON
   HAND (BEGINNING-OF-THE-
   YEAR CASH, PLUS NET
35 INCOME AFTER TAXES)               30000    50580     71490     92189     73989     44389
      H
 1
 2   2013
 3      0.01
 4    12000
 5         0
 6    46000
 7    17000
 8
 9   2013
10    R
11    NA
12
13   2012

14     8389
15
16   2013
17      0.15
18    31000
19    12000
20    17000
21

22   2013

23    44389
24
25    12000
26        0
27    12000
28    17000
29    31000
30    48000
31   -36000
32        0
33   -36000
34



35     8389

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:12
posted:11/24/2012
language:Unknown
pages:4