BIS. Calculating annuities - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Arial - 12 Paste BIU - Cells Editing A Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font > D18 X A B D E F G 1 2 3 You are planning to save for retirement over the next 30 years. To do this, you will invest $850 per month in a stock account and $350 per month in a bond account. The return of the stock account is expected to be 10 percent, and the bond account will pay 6 percent. When you retire, you will combine your money into an account with a return of 5 percent. How much can you withdraw each month from your account assuming a 25-year withdrawal period? 4 5 6 7 8 9 10 Monthly stock investment Monthly bond investment Stock return Bond return Years to save Retirement return Retirement years Months per year 850 350 10% 6% 30 5% 25 12 11 12 13 15 16 Complete the following analysis. Do not hard code values in your calculations. All Saved Arial M BIU Cells Editing 12 A A % 1.A Alignment Number Conditional Format as Cell Formatting Table Styles Styles fx Font X B D F G H 1 $ Monthly bond investment Stock return Bond return Years to save Retirement return Retirement years Months per year E 350 10% 6% 30 5% 25 12 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Stock account value at retirement Bond account value at retirement Total account value at retirement Monthly withdrawal Sheet1