EXCEL 5 | Sensitivity Analysis INTER YOUR NAME BELO\\ UTEID Investment Analysis Arif Harianawala ah53594 401(k) Flan Personal Account Salary Previous Year's Balance Mr. clark's Employer's Stock Market Previous Year Mr. Clark's Age Contribution 401K Plan Total Additional stock Market Contribution Earnings Balance SENVINES Earnings Account Total Yearly Total $175,000 General Assumptions Starting Salary $175.000 Salary Increase Rate 396 Stock Market Return Rate 401(k) Plan Assumption: Starting Balance of 401 (1) Plan $225.000 Mr. Clark's Contribution To 401(k) 696 Emplayer's Contribution to 401(k) Personal Account Assumptions Starting Personal Account Balance 385.000 Starting Additional Savings 310.000 Annual Increase in Additional Savings Sensitivity Analysis Increase in earnings Average Market Retum $5.720,012 436 596 69% 756 895 696 1096 1596