cs 2

Data

Four Corners
Age	40
Current Salary	$85,000
Current Portfolio	$50,000
Annual Investment Rate	6.00%
Salary Growth Rate	5%
Portfolio Growth Rate	10%
Year	Beginning Balance	Salary	New Investment	Earnings	Ending Balance	Age
1	$50,000	$85,000	$5,100	$5,255	$60,355	41
2	$60,355	$89,250	$5,355	$6,303	$72,013	42
3	$72,013	$93,713	$5,623	$7,482	$85,118	43
4	$85,118	$98,398	$5,904	$8,807	$99,829	44
5	$99,829	$103,318	$6,199	$10,293	$116,321	45

FIGURE 13.18. FINANCIAL ANALYSIS SPREADSHEET FOR TOM GIFFORD