Sheet 3- Time Comparison 1. At the bottom of the page, click on Sheet 3. If you're using Google Sheets, you can add a 3rd sheet. Rename it "Time Comparison". On this sheet, we're going to look at two individuals that are paying into annuities for their retirement fund. We want to pay close attention to when each of these men start paying into their annuity. 2. Type "Age - stats of saving" in cell A2. 3. Type "Payment Amount (P)" in cell A3. 4. Type "Rate (1)" in cell A4. 5. Type "Number of Payments per year (n)" in cell AS. 6. Type "Years to retire at 65 (t)" in cell A6. Again, find some reasonable values for payment amount, interest rate, and number of payments. 7. In cell B1, type "Tommy". Then enter his age, "45", in cell 82. 8. In cell C1, type "Sammy". Then enter his age, "25", in cell C2. a. NOTE: Pick whichever names you'd like. 9. Enter the amounts you chose for payment, rate, and frequency in cells 83 thru B5. These amounts should be the same for C3 thru CS. 10. For cells 86 and C6, we're going to calculate the time period of the annuity. To do this, input "65-82", and hit Enter for Tommy's time value. And, "65-C2" for Sammy's time value. Notice the difference in time period. Now, we will calculate the Future Value of each annuity. 11. Type "Future Value (FV)" in cell A8. 12. In cell 8, Input "aB3 (1+(84/85))^(85 86)-1)/(84/85)". Hit Enter. 13. Now input "C3 (1+(C4/CS))^CS C6)-1)/(C4/C5)" in cell C8 for Sammy's retirement amount. Hit Enter and compare the 2 retirement funds.
Sheet 3- Time Comparison 1. At the bottom of the page, click on Sheet 3. If you're using Google Sheets, you can add a 3rd sheet. Rename it "Time Comparison". On this sheet, we're going to look at two individuals that are paying into annuities for their retirement fund. We want to pay close attention to when each of these men start paying into their annuity. 2. Type "Age - stats of saving" in cell A2. 3. Type "Payment Amount (P)" in cell A3. 4. Type "Rate (1)" in cell A4. 5. Type "Number of Payments per year (n)" in cell AS. 6. Type "Years to retire at 65 (t)" in cell A6. Again, find some reasonable values for payment amount, interest rate, and number of payments. 7. In cell B1, type "Tommy". Then enter his age, "45", in cell 82. 8. In cell C1, type "Sammy". Then enter his age, "25", in cell C2. a. NOTE: Pick whichever names you'd like. 9. Enter the amounts you chose for payment, rate, and frequency in cells 83 thru B5. These amounts should be the same for C3 thru CS. 10. For cells 86 and C6, we're going to calculate the time period of the annuity. To do this, input "65-82", and hit Enter for Tommy's time value. And, "65-C2" for Sammy's time value. Notice the difference in time period. Now, we will calculate the Future Value of each annuity. 11. Type "Future Value (FV)" in cell A8. 12. In cell 8, Input "aB3 (1+(84/85))^(85 86)-1)/(84/85)". Hit Enter. 13. Now input "C3 (1+(C4/CS))^CS C6)-1)/(C4/C5)" in cell C8 for Sammy's retirement amount. Hit Enter and compare the 2 retirement funds.
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter27: Time Value Of Money (compound)
Section: Chapter Questions
Problem 2R
Related questions
Question
100%
![10:21
Exploring Annuities [DIR...
• Sheet 3- Time Comparison
1. At the bottom of the page, click on Sheet 3. If you're using Google Sheets, you can add a 3rd sheet.
Rename it "Time Comparison".
On this sheet, we're going to look at two individuals that are paying into annuities for their retirement fund. We want to
attention to when eac.
these
paying into their annuity.
2. Type "Age - stats of saving" in cell A2.
3. Type "Payment Amount (P)" in cell A3.
4. Type "Rate (i)" in cell A4.
5. Type "Number of Payments per year (n)" in cell A5.
6. Type "Years to retire at 65 (t)" in cell A6.
Again, find some reasonable values for payment amount, interest rate, and number of payments.
7. In cell B1, type "Tommy". Then enter his age, "45", in cell B2.
8. In cell C1, type "Sammy". Then enter his age, "25", in cell C2.
a. NOTE: Pick whichever names you'd like.
9. Enter the amounts you chose for payment, rate, and frequency in cells B3 thru B5. These amounts
should be the same for C3 thru CS.
10. For cells B6 and C6, we're going to calculate the time period of the annuity. To do this, input "=65-82",
and hit Enter for Tommy's time value. And, "=65-C2" for Sammy's time value.
Notice the difference in time period. Now, we will calculate the Future Value of each annuity.
11. Type "Future Value (FV)" in cell A8.
12. In cell B8, Input "=B3*(1+(84/B5)^(85* 86)-1)/(B4/B5)". Hit Enter.
13. Now input "C3* ((1+(C4/C5))^(C5*C6)-1)/(C4/C5)y" in cell C8 for Sammy's retirement amount. Hit Enter
and compare the 2 retirement funds.
Dashboard
Calendar
To Do
Notifications
Inbox](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0f725b05-6985-474e-a031-937034e54c0f%2F99cf235b-6bf7-45aa-863f-c47b35eb4fad%2Fwnc1un_processed.jpeg&w=3840&q=75)
Transcribed Image Text:10:21
Exploring Annuities [DIR...
• Sheet 3- Time Comparison
1. At the bottom of the page, click on Sheet 3. If you're using Google Sheets, you can add a 3rd sheet.
Rename it "Time Comparison".
On this sheet, we're going to look at two individuals that are paying into annuities for their retirement fund. We want to
attention to when eac.
these
paying into their annuity.
2. Type "Age - stats of saving" in cell A2.
3. Type "Payment Amount (P)" in cell A3.
4. Type "Rate (i)" in cell A4.
5. Type "Number of Payments per year (n)" in cell A5.
6. Type "Years to retire at 65 (t)" in cell A6.
Again, find some reasonable values for payment amount, interest rate, and number of payments.
7. In cell B1, type "Tommy". Then enter his age, "45", in cell B2.
8. In cell C1, type "Sammy". Then enter his age, "25", in cell C2.
a. NOTE: Pick whichever names you'd like.
9. Enter the amounts you chose for payment, rate, and frequency in cells B3 thru B5. These amounts
should be the same for C3 thru CS.
10. For cells B6 and C6, we're going to calculate the time period of the annuity. To do this, input "=65-82",
and hit Enter for Tommy's time value. And, "=65-C2" for Sammy's time value.
Notice the difference in time period. Now, we will calculate the Future Value of each annuity.
11. Type "Future Value (FV)" in cell A8.
12. In cell B8, Input "=B3*(1+(84/B5)^(85* 86)-1)/(B4/B5)". Hit Enter.
13. Now input "C3* ((1+(C4/C5))^(C5*C6)-1)/(C4/C5)y" in cell C8 for Sammy's retirement amount. Hit Enter
and compare the 2 retirement funds.
Dashboard
Calendar
To Do
Notifications
Inbox
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![PFIN (with PFIN Online, 1 term (6 months) Printed…](https://www.bartleby.com/isbn_cover_images/9781337117005/9781337117005_smallCoverImage.gif)
PFIN (with PFIN Online, 1 term (6 months) Printed…
Finance
ISBN:
9781337117005
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
![Pfin (with Mindtap, 1 Term Printed Access Card) (…](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![PFIN (with PFIN Online, 1 term (6 months) Printed…](https://www.bartleby.com/isbn_cover_images/9781337117005/9781337117005_smallCoverImage.gif)
PFIN (with PFIN Online, 1 term (6 months) Printed…
Finance
ISBN:
9781337117005
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning
![Pfin (with Mindtap, 1 Term Printed Access Card) (…](https://www.bartleby.com/isbn_cover_images/9780357033609/9780357033609_smallCoverImage.jpg)
Pfin (with Mindtap, 1 Term Printed Access Card) (…
Finance
ISBN:
9780357033609
Author:
Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk
Publisher:
Cengage Learning