Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Time Value of Money

Competency

Determine current values of cash streams utilizing discounted cash flow techniques.

Student Success Criteria

View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.

Scenario

You are currently a benefits analyst within Book Bliss Company, a small family-owned corporation that manufactures magnetic bookmarks. Currently, the members of management have been funding their own retirement plans, and it has begun to be costly and not commensurate with their salaries. Book Bliss management would like to provide a contributory pension plan for five current members of the management team.

Management believes they can afford to invest $10,000 per month for the next 10 years. They anticipate the rate of return will be 12%. At the end of the 10 years, they expect retiring employees to start withdrawing from this pension plan. The anticipated longevity after retirement is expected to be 20 years, and management believes the rate of return on the investment to continue through the 20 years of retirement payout.

Management is not knowledgeable about the time value of money and why it makes a difference if a dollar is invested today versus in 20 years. Management has requested your assistance in determining relevant pension plan values so they can finalize the components of the pension plan.

Instructions

Using the following Excel template, develop a spreadsheet that covers the following:

Module 5 Time Value of Money Template.xlsx

  • Explain the concept of the time value of money, including the present and future value of $1 and the present and future value of an annuity. Explain the difference between the annuity payment at the beginning and the end of the period.
  • Demonstrate the future value of the monthly cash investments for the next 10 years, given the investment earns the projected 12% annual return.
  • Calculate the total monthly payment that can be withdrawn from the investment over 20 years, given the anticipated 12% annual rate of return continues to be met through the 20 years of retirement. Provide management with the monthly payment amount that will be available to pay out in monthly pension amounts.
  • Assuming all five members of management will receive the same monthly annuity payment, provide management with the proposed monthly retirement payment that can be offered to these five members of management.
  • Use the built-in cash flow functions in Excel to perform all calculations, explaining the values you entered for the function in the adjacent cells.
Assessment Requirements/Submission Requirement:
  • Excel Template

A – 4 – Mastery

Accurate and robust explanation of Time Value Money. Highly accurate annuity payment calculation.

A – 4 – Mastery

Presentation accurately projects rate of return.

A – 4 – Mastery

Presentation accurately projects rate of payout for employees

A – 4 – Mastery

Presentation accurately projects rate of payout for management

A – 4 – Mastery

Accurate Excel calculations and clear and articulate explanations of values.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

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

Related Questions

question

Attached Use reference: David, F. R., David, F. R. & David, M.E. (2023). Strategic management: a competitive advantage approach, concepts and cases (18th ed.). Upper Saddle River: Pearson. HOMEWORK 1, 2 pages with atleast 2 references. Follow below SWOT and BCG examples. Overview Exercises 6A and 6C: You will begin

Workplace Hazards

Please respond to the following: What are the distinctive features of the workplace as a setting where exposure to chemical and physical hazards occurs? Be sure to respond to at least one of your classmates’ posts.

What Makes 3D Game Development a Smart Business Investment for Game Studios?

For studios and startups, 3D game development offers both creative flexibility and commercial advantages. High-quality visuals and realistic mechanics help attract modern players who expect console-level experiences across all devices. At the same time, 3D assets can be reused, scaled, and optimized for multiple platforms, making development more efficient in

Prof Double R

  Take a position. Do you agree or disagree that an emphasis on discipline and a zero tolerance approach in schools with a large minority or disadvantaged population creates a school-to-prison pipeline? First, title your initial post either “An emphasis on discipline / zero tolerance in schools with large minority

BUSINESS MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM, A+ WORK

Tutor Discussion and Assignment BUSN623 Week 6 Assignment Case Studies Selection The following three Case Studies are hypothetical simulations related to business tort situations. Choose ONE of these to complete your Week 6 Assignment. References to support your analysis and conclusion for recommendations should be drawn from your research using

Administrative Simulation

 Administrative Simulation   Download and complete the attached check sheet. When completed, upload a scan or image of the PDF here.   Discussion Topic 1.1   You get a call from an angry customer who tells you she had booked an adventure for her husband as a surprise for his 45th birthday only

Module Six Case Analysis BUS 206

see attachment Module Six Case Analysis Guidelines and Rubric.html BUS 206 Module Six Case Analysis Guidelines and Rubric Overview In the case of Lucy v. Zehmer, Zehmer spent the night drinking with his friend Lucy. During the evening, a piece of paper was signed whereby Zehmer agreed to sell his

Simulation Email 4

 You are working at First in My Family Education as an executive assistant to Mariam Raza, the President.  Mariam has sent you the following request:  I’ve drafted an email to Anne Vaccaro, the Social Media Manager at First in My Family Education, regarding a marketing plan and budget request. Please

BUSINESS MANAGEMENT GREAT WORK, ON TIME, NO PLAGARISM, A+ Work

Tutor discussion Hypothetical Case Simulation You are the CEO of business (in an industry you will select) that is considering a new AI application called Dublin-10, to automate a system and bring efficiency to operations. An ROI study has convinced you this innovation will enable the business to eventually save costs

Business Finance – Management HOMEWORK

attached. Reference: David, F. R., David, F. R. & David, M.E. (2023). Strategic management: a competitive advantage approach, concepts and cases (18th ed.). Upper Saddle River: Pearson. Homework 1: PHASE 2… 5 pages (additional/continuation to the phase 1) HOMEWORK 2: 1 page with 2 references: Overview In this exercise, compare

HRM 6304 VIII J

2 Labor Relations and Collective Bargaining HRM 6304 Unit VIII Journal You have been asked to make a short speech to the executive team on how this course could help shape labor relations within the organization, including the history of the American labor movement, dispute resolutions, avoidance, models, strategies, and

ITC 5301 VIII J

2 Management Information Systems ITC 5301 Unit VIII Journal This journal measures your mastery of ULOs 2.3, 3.3, 3.7, and 5.5. Reflect on how you can apply the concepts learned in this course in your future professional, personal, or academic pursuits. Given the ubiquity of global corporations in the current

Tesla

  Step 1 Review the Strategic Management: A Competitive Advantage Approach, Concepts, and Cases textbook and find and study the case information about your selected company. List the firm’s strengths, weaknesses, opportunities, and threats. Consider both internal and external factors when compiling your list. Go to that firm’s website and

Logistics Discussion 3

BUSI 615 Discussion Assignment Instructions You will complete 4 Discussions over the duration of this course. These Discussions will cover the following topics: · Manufacturing Resource Planning · Enterprise Resource Planning · Logistics Information Systems · Implementation of a Logistics System Each will be completed over a period of 2

EXP A3

A2 is a completed assignment. A2 has to be reviewed in order to complete A3.  Student Name: firstName lastName [A3 – Assignment 3] Create Personas and User Stories based on your interview. This is another application of the Empathize step in the Design Thinking framework. Here, you restate or depict

Business Finance – Accounting Week Two Assignment 3. See Instructions

Top of Form Assignment 3: Dissect Bonds and Stocks BOOK LINK: Corporate Finance: A Focused Approach Michael C. Ehrhardt; Eugene F. Brigham https://bookshelf.vitalsource.com/reader/books/9798214584249/epubcfi/6/2[%3Bvnd.vst.idref%3Dcover-page]!/4/2[cover-page]/6[EYBS9QXYGD16YZT2E049]/2%4051:2 I will message the username and password for access to the book. Top of Form Hide Assignment Information Instructions Instructions · Textbook Chapter 5: Question 5-1 (p. 226),

Business Finance – Accounting Week Two Assignment 4. See Instructions

Top of Form Assignment 4: Define Capital Budgeting BOOK LINK: Corporate Finance: A Focused Approach Michael C. Ehrhardt; Eugene F. Brigham https://bookshelf.vitalsource.com/reader/books/9798214584249/epubcfi/6/2[%3Bvnd.vst.idref%3Dcover-page]!/4/2[cover-page]/6[EYBS9QXYGD16YZT2E049]/2%4051:2 I will message the username and password for access to the book. Instructions Chapter 9: Mini-case a. through l. only (p. 404 – 405).  Complete the above textbook

HRM 6304 VII E

2 Labor Relations and Collective Bargaining HRM 6304 Unit VII Essay As the corporate labor relations lawyer for a European car manufacturer, building a new facility in Middle Valley, Tennessee, you have been asked by corporate management to draft a position paper regarding the labor relations process at the new