Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Water Audits And Loss Control Programs

Authors: American Water Works Association

4th Edition

1625761007, 978-1625761002

More Books

Students also viewed these Accounting questions