Paste La 3 BIU hili B Conditional Forma Formatting as Tabl D F 1 D29 xv fx 1 INDIVIDUAL RETIREMENT ACCOUNT ACCUMULATION 2 3 30 7.00% $3,000 Annual Annudy Ordinwy Anuty Annuity Due Compound Valve Compound Value 5 Number of Years: 6 Projeded annual rate of retum 7 Annual annuity contribution 8 9 10 11 Your 12 1 13 2 14 3 15 16 5 17 6 18 7 19 20 9 21 10 22 11 23 12 24 13 25 16 26 15 27 se 17 20 18 30 19 31 20 32 25 33 22 34 23 35 28 36 25 37 26 38 27 30 28 40 29 41 30 Sheet1 Sheet2 Sheets 32 33 34 35 36 37 38 39 40 21 22 23 24 25 26 27 28 29 41 30 42 43 44 45 Sensitivity Analysis Matrix 46 47 48 Ordinary Annuity Compound Value 49 Annuity Due Compound Value 50 Ordinary Annuity Compound Value 51 Annuity Due Compound Value 52 Projected Annual Rate of Retum 5% 9% Number of Years 25 25 40 40 53 54 55 56 57 58 59 Sheet1 Sheet2 Sheet3 + Recently Delet Assign ssignn PRINCIPLES OF FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Future Value of Annuities HW Atta Sub Is. 1. Retrieve the file IRA2P.XLS. . 2. Copy cell B7 to cell B12 and then copy cell B12 into cells B13 through B41, being mindful of the issue of absolute versus relative cell addresses. 3. Copy cell B12 to cell c12. Create an equation in cell c13 that solves for the future value of the ordinary annuity after two years. Adapt the equation in cell C13 to cells C14 through C41. 4. Create an equation in cell 012 that solves for the future value of the annuity due after one year. Adapt the equation in cell D12 to cells D13 through 141. 5. Enter the appropriate financial function command in cell B48 that solves for the future value of an ordinary annuity assuming a five percent rate of return, compounded annually, for twenty five years. 6. Enter the appropriate financial function command in cells B49, B50, 351, 248, 249, 250, and C51 that solves for the respective future values in the Sensitivity Analysis Matrix. 7. Print the worksheet. New Folder Page 1 of 1 189 words 118% 30 dtv 1. Retrieve the file IRA2P.XLS. 2. Copy cell B7 to cell B12 and then copy cell B12 into cells B13 through B41, being mindful of the issue of absolute versus relative cell addresses. 3. Copy cell B12 to cell c12. Create an equation in cell c13 that solves for the future value of the ordinary annuity after two years. Adapt the equation in cell C13 to cells C14 through C41. 4. Create an equation in cell 012 that solves for the future value of the annuity due after tone year. Adapt the equation in cell D12 to cells D13 through 141. 5. Enter the appropriate financial function command in cell B48 that solves for the future value of an ordinary annuity assuming a five percent rate of return, compounded annually, for twenty five years. 6. Enter the appropriate financial function command in cells B49, B50, 351, C48, 249, 250, and C51 that solves for the respective future values in the Sensitivity Analysis Matrix. A B E D F 1 INDIVIDUAL RETIREMENT ACCOUNT ACCUMULATION 2 3 30 7.00% $3,000 Annual Annuity Ordinary Annuity Compound Value Annuity Due Compound Value 5 Number of Years: 6 Projected annual rate of retum: 7 Annual annuity contribution: 8 9 10 11 Year 12 1 13 2 14 3 15 4 16 5 17 6 18 7 19 8 20 9 21 10 22 11 23 12 24 13 25 14 26 15 27 16 28 17 29 18 30 19 31 20 32 21 33 22 34 23 35 24 36 25 25 26 15 27 16 28 17 29 18 30 19 31 20 32 21 33 22 34 23 35 24 36 25 37 26 38 27 39 28 40 29 30 42 43 44 45 Sensitivity Analysis Matrix 46 47 48 Ordinary Annuity Compound Value 49 Annuity Due Compound Value 50 Ordinary Annuity Compound Value 51 Annuity Due Compound Value 52 53 54 55 56 57 Projected Annual Rate of Retum 5% 9% Number of Years 25 25 40 40 Paste La 3 BIU hili B Conditional Forma Formatting as Tabl D F 1 D29 xv fx 1 INDIVIDUAL RETIREMENT ACCOUNT ACCUMULATION 2 3 30 7.00% $3,000 Annual Annudy Ordinwy Anuty Annuity Due Compound Valve Compound Value 5 Number of Years: 6 Projeded annual rate of retum 7 Annual annuity contribution 8 9 10 11 Your 12 1 13 2 14 3 15 16 5 17 6 18 7 19 20 9 21 10 22 11 23 12 24 13 25 16 26 15 27 se 17 20 18 30 19 31 20 32 25 33 22 34 23 35 28 36 25 37 26 38 27 30 28 40 29 41 30 Sheet1 Sheet2 Sheets 32 33 34 35 36 37 38 39 40 21 22 23 24 25 26 27 28 29 41 30 42 43 44 45 Sensitivity Analysis Matrix 46 47 48 Ordinary Annuity Compound Value 49 Annuity Due Compound Value 50 Ordinary Annuity Compound Value 51 Annuity Due Compound Value 52 Projected Annual Rate of Retum 5% 9% Number of Years 25 25 40 40 53 54 55 56 57 58 59 Sheet1 Sheet2 Sheet3 + Recently Delet Assign ssignn PRINCIPLES OF FINANCIAL ANALYSIS SPREADSHEET ASSIGNMENT: Future Value of Annuities HW Atta Sub Is. 1. Retrieve the file IRA2P.XLS. . 2. Copy cell B7 to cell B12 and then copy cell B12 into cells B13 through B41, being mindful of the issue of absolute versus relative cell addresses. 3. Copy cell B12 to cell c12. Create an equation in cell c13 that solves for the future value of the ordinary annuity after two years. Adapt the equation in cell C13 to cells C14 through C41. 4. Create an equation in cell 012 that solves for the future value of the annuity due after one year. Adapt the equation in cell D12 to cells D13 through 141. 5. Enter the appropriate financial function command in cell B48 that solves for the future value of an ordinary annuity assuming a five percent rate of return, compounded annually, for twenty five years. 6. Enter the appropriate financial function command in cells B49, B50, 351, 248, 249, 250, and C51 that solves for the respective future values in the Sensitivity Analysis Matrix. 7. Print the worksheet. New Folder Page 1 of 1 189 words 118% 30 dtv 1. Retrieve the file IRA2P.XLS. 2. Copy cell B7 to cell B12 and then copy cell B12 into cells B13 through B41, being mindful of the issue of absolute versus relative cell addresses. 3. Copy cell B12 to cell c12. Create an equation in cell c13 that solves for the future value of the ordinary annuity after two years. Adapt the equation in cell C13 to cells C14 through C41. 4. Create an equation in cell 012 that solves for the future value of the annuity due after tone year. Adapt the equation in cell D12 to cells D13 through 141. 5. Enter the appropriate financial function command in cell B48 that solves for the future value of an ordinary annuity assuming a five percent rate of return, compounded annually, for twenty five years. 6. Enter the appropriate financial function command in cells B49, B50, 351, C48, 249, 250, and C51 that solves for the respective future values in the Sensitivity Analysis Matrix. A B E D F 1 INDIVIDUAL RETIREMENT ACCOUNT ACCUMULATION 2 3 30 7.00% $3,000 Annual Annuity Ordinary Annuity Compound Value Annuity Due Compound Value 5 Number of Years: 6 Projected annual rate of retum: 7 Annual annuity contribution: 8 9 10 11 Year 12 1 13 2 14 3 15 4 16 5 17 6 18 7 19 8 20 9 21 10 22 11 23 12 24 13 25 14 26 15 27 16 28 17 29 18 30 19 31 20 32 21 33 22 34 23 35 24 36 25 25 26 15 27 16 28 17 29 18 30 19 31 20 32 21 33 22 34 23 35 24 36 25 37 26 38 27 39 28 40 29 30 42 43 44 45 Sensitivity Analysis Matrix 46 47 48 Ordinary Annuity Compound Value 49 Annuity Due Compound Value 50 Ordinary Annuity Compound Value 51 Annuity Due Compound Value 52 53 54 55 56 57 Projected Annual Rate of Retum 5% 9% Number of Years 25 25 40 40