Time Value of Money Activity For this activity, read the

 

Time Value of Money Activity

For this activity, read the scenario and then use the provided Week 6 Time Value of Money Excel Template [XLSX] and Week 6 Time Value of Money Template [DOC] templates to complete your activity before uploading them to the submission area.

Note: There are locked cells in the Excel template. The cells have been locked to prevent the formulas from being disturbed. The cells that you will need to use to complete this assignment are not locked. You may create your own templates, however, it is recommended that you use the templates provided. 

Note: Watch the Excel tutorial videos linked in this week to learn how to use Excel before attempting the assignment. You can use the template provided or you may create your own template based on the one provided.

Scenario

Larry and Beth are both married, working adults. They both plan for retirement and consider the $6,000 annual contribution a must.First, consider Beth’s savings. She began working at age 20 and began making an annual contribution to her IRA of $6,000 each year until age 32 (12 contributions). She then left full-time work to have children and be a stay-at-home mom. She left her IRA invested and plans to begin drawing from her IRA when she is 65.Larry started contributing to his IRA at age 32. In the first 12 years of his working career, he used his discretionary income to buy a home, upgrade the family cars, take vacations, and pursue his golfing hobby. At age 32, he made his first $6,000 contribution to an IRA and contributed $6,000 every year up until age 65 (33 contributions). He plans to retire at age 65 and make withdrawals from his IRA.Both IRA accounts grow at an 8 percent annual rate. Do not consider taxes or inflation.

Instructions

  • Create a chart summarizing the details of the investment for both Larry and Beth.
  • Write a one-paragraph summary in which you explain the results in terms of the time value of money for both Larry and Beth. (Hint: discuss why one person was able to save a great deal more than the other.)

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Instructions Include the following in your presentation. Use the titles

Instructions Include the following in your presentation. Use the titles below  for the headings of each section. The number of slides indicated for  each section are suggestions. Introduction (1 slide).       Provide a brief overview of the presentation. Intervention Strategies (1 slide).       Explain the intervention strategies that will be

Activity: SWOT Analysis PowerPoint Due Week 2 and worth 200 points Physicians and patients have been affected by development and implementation of Health Information Technology (HIT). There are many o Nursing Assignment Help

Activity: SWOT Analysis PowerPointDue Week 2 and worth 200 points Physicians and patients have been affected by development and implementation of Health Information Technology (HIT). There are many other healthcare professionals and venues affected by significant complexities and characteristics that make HIT implementation challenging. For example, standardized data formats are

Organizational Risk Management Interview

Select a health care organization in your community to conduct an interview with an appropriate risk management employee. The organization can be your current employer, or a different health care facility in your community. Acute care, urgent care, large multi-provider private medical clinics, assisted living facilities, and community/public health clinical

TASK For the web application that you have identified in

 TASK For the web application that you have identified in section b., what web application security mechanisms are used for authentication and why? What access control model(s) are used and why? What security controls do you plan to use to protect your organization’s data (files, databases, etc.)? What security mechanisms

Reply to: Chomsky’s theories, such as the Minimalist Program and

Reply to:   Chomsky’s theories, such as the Minimalist Program and Universal Grammar, argue that language is made up of small units (like words or phrases) that people combine or “merge” to create larger language structures. This is a hierarchical process that builds upon itself. This means unit A and

Op-Ed : health policy

 The goal of this op-ed assignment is for you to write and state your opinions about an aspect of health policy and what should be done about it. pick a CURRENT health policy (proposal or already enacted) at the federal, state, or local level that affects one or more of

There are many different types of memory retrieval problems. Do

 There are many different types of memory retrieval problems. Do you think that the criminal justice system should still rely on first person testimonies during court cases. If yes, please state why. If no, please state why. Also be sure to include and describe vocabulary terms that support your stance. 

Follow the directions below for the completion of the Research

Follow the directions below for the completion of the Research Proposal assignment for Unit III. If you have questions, please email your professor for assistance. Purpose: The purpose of the research proposal is to help you to understand your project, to gain direction and feedback on your project, and to

Explain how the Montgomery bus impacted the civil rights movement

 Explain how the Montgomery bus impacted the civil rights movement on a local, state, and national level. How did Dr. King’s role in the Montgomery movement impact his role on a local and national level.  think about how what happened in Montgomery captures there role of women in the movement.

1. Write Cornell notes after reading materials, Cornell Notes are

1. Write Cornell notes after reading materials, Cornell Notes are designed to engage critical thinking, analysis, and synthesis. Use uploaded ‘Cornell Notes Template.doc’ to write. Reading from Chapter 2: pg 96 to 118 2. No less than 350 words. 3. All WRITING, IDEAS, and INFORMATION used in your assignments that

Developing a Long Term Growth Strategy

 Respond to the following: What can you learn from the financial statements of competitors that determine the relative cost position of your company? What are some of the ways in which you can secure a sustainable cost advantage over the competition? How does maintaining a strong understanding of relative costs

Claims Processing and Reimbursement Discussion Nursing Assignment Help

In your post, compare the characteristics and claims filing processes of private and public payers. What type of ethical issues could arise with personnel during the claims filing processes? Discussion offers you the opportunity to express your own thoughts, ask questions for clarification, and gain insight from your classmates’ responses

Inner Office Memo Assignment Write a memo To: new office

  Inner Office Memo Assignment Write a memo To:  new office hires From:  your name Date:  due date Subject:    Importance of good communication skills and the amount of time spent in all forms of  communication The contents of this document is to be a discussion about the average amount of

Please submit a paper giving me some feedback about the

Please submit a paper giving me some feedback about the class, group work, and any other thoughts you have. I know you have a course eval, but I would love some specific thoughts you have on ways this class could be improved going forward. Also, this is a chance for

First and foremost, it is important to understand the purpose

  First and foremost, it is important to understand the purpose of the Army Maintenance Program. The objective of AMP is to ensure that Army materials are in the best working conditions for effective performance purposes. Keeping up to date with AMP keeps the Army ready for missions with a

Reflect on the video , “America’s greatest speeches ,” Write

  Reflect on the video , “America’s greatest speeches ,” Write a brief Political Science summary , be sure to include the following questions: (123) Greatest Recorded Speeches in American History (1933-2008)    Why political scientists argue that public speaking, speeches could be powerful to influence society as a whole?