Case Problem: Four Corners What will your investment portfolio be worth in 10 years? In 20 years? When you stop working? The Human Resources Department at Four Corners Corporation was asked to develop a nancial planning model that would help employees address these questions. Tom Gifford was asked to lead this effort and decided to begin by developing a financial plan for himself. Tom has a degree in business and, at the age of 40, is making $85,000 per year. Through contributions to his company's retirement program and the receipt of a small inheritance, Tom has accumulated a portfolio valued at $50,000. Tom plans to work 20 more years and hopes to accumulate a portfolio valued at $ 1,000,000. Can he do it? Tom began with a few assumptions about his future salary, his new investment contributions, and his portfolio growth rate. He assumed a 5% annual salary growth rate and plans to make new investment contributions at 6% of his salary. After some research on historical stock market performance, Tom decided that a 10% annual portfolio growth rate was reasonable. Using these assumptions, Tom developed the following Excel worksheet: 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% Beginning New Earning Ending Year Balance Salary Investment 5 Balance 1 $50,000 $85,000 $5,100 $5,255 $60,355 2 $60,355 $89,250 $5,355 $6,303 $72,013 3 $72,013 $93,713 $5,623 $7,482 $85,118 4 $85,118 $98,398 $5,904 $8,807 $99,829 $103,31 5 $99,829 8 $6,199 $10,293 $116,321 41 83 45