Please see attached spreadsheet:

John and Jane are 50 years old. Each earns $100,000 working for a university. Each deposit 4% of pay into a 403(b)-defined contribution account; the university provides a 4% match. Each has $600,000 accumulated in their 403(b) defined contribution plans. Each deposit $5,000 annually into a taxable brokerage account at Schwab with a present balance of $100,000. Each intends to retire at age 67. Each intends to maintain a retirement life-style equivalent to their pre-retirement life style. (A) Perform the requisite analysis to determine if they are on track to reach their retirement goal. (B) Recommend an asset allocation for their 403(b)-defined contribution plan. Assume any additional information, if needed.