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

Tourism Presentation & Report

Create a PowerPoint presentation including all the data from the attachments. Use visuals and easy-to-read charts. Add a more detailed recommendation section to the report. 

Business & Finance HOMEWORK

Required Course Textbook(s) · Introduction to Information Systems, 5th Edition By: Wallace, Patricia ISBN: 978-0-13-791844-7

W5

Course Project: Source Selection Criteria Instructions This week, you are required to produce your Source Selection Criteria deliverable. The Source Selection Criteria is a required deliverable to define how the evaluation of each response will be executed. Typically, evaluations are executed following multiple considerations, including (1) demonstrated competence, (2) compliance,

week 4 pj

 U.S. manufacturing over the last half century  Course Objectives: Students will apply international business theories and concepts to a various multinational organization. Questions: 1. Reflect on the changes in U.S. manufacturing over the last half century. Why did the United States lose so many jobs? 2. What impact did that job loss

MBA510 Week One Discussion Post 2. Please answer the discussion post in 250 min

Instructions How might companies incorporate AI into their value chain to improve operating efficiencies? Length: 250-400 words  Contributions must display original thinking and good knowledge of the subject matter, including links and references to sources to support your arguments. Additionally, make sure you cite sources you reference in-text and under a

MBA510 Week One Discussion Post 1. Please answer the discussion post in 250 min

Instructions · How do you think business structures might change in a world with AI? Length: 250-400 words  Contributions must display original thinking and good knowledge of the subject matter, including links and references to sources to support your arguments. Additionally, make sure you cite sources you reference in-text and under

Business

BUSI 301 Discussion Assignment Instructions Overview Discussions bring dialogue and communication into our learning experience. Unlike so much of the unsubstantiated opinion we see in the public square and social media, these discussions provide a space for in-depth analysis and application of the topics in our Learn readings and presentations.

HRM 6303 VIII

2 Training and Development HRM 6303 Unit VIII Reflection Paper Consider that you want to report to the executive team on how this course could help shape training and development program for leadership and career planning. Be sure to consider major training-related theories. Reflect on the course and thoroughly explain

ACC 5301 VII

1 5 Title of the Paper Goes Here Student Name Institution ACC 5301 Management Applications of Accounting Instructor Date Abstract The abstract is an overview of the paper, written after completion. Other researchers use the abstract to determine if your work will be useful to them. The abstract should include

Prof Double R

DISCUSSION 1 In a conversation with a family member, you are told: “Bad people do bad things. Some people are just bad eggs.” For this discussion, you will incorporate what you have learned about antisocial behavior and its implications for promoting diversity, equity, and inclusion. For your initial post, review

Case Study

answering the case by applying all the digital transformation tools  Chapter 1: The Five Domains of Digital Transformation: Customers, Competition, Data, Innovation, Value This chapter introduces the five domains of digital transformation: customers, competition, data, innovation, and value. It explains how digital technologies are changing strategic assumptions in each domain,

Group project

Background UNLO Kuwait Group Company is currently exploring new business opportunities by identifying and targeting untapped market segments. As part of this initiative, students will engage in a strategic consulting assignment focused on discovering feasible and sustainable market expansion options for the company. Student teams will work on real-world business

Business Finance – Management 2-2 Assignment: Communications Plan Template

  MGT 550 Module Two Assignment Guidelines and Rubric Overview Using the Communications Template, linked in the What to Submit section, identify two overall issues that are present in the final project case study that can be addressed using internal and external communications. For each issue, note the red flags

Calculate the economic value added assuming its cost of capital

At the end of 2011 Home Depot’s total capitalization amounted to $29,031 million. In 2012 debt investors received interest income of $648 million. Net income to shareholders was $4,487 million. (Assume a tax rate of 35%.) Calculate the economic value added assuming its cost of capital is 10%. (Do not

Econ 13

Instructions attached Please answer the following questions 1. Please research ‘forced arbitration” and tell us what you find out about it. What is it and do you think it is a good or a bad thing? Explain. To what extent is forced arbitration legal in California and federally. 2. How

leasing

   Lewis Securities Inc. has decided to acquire a new market data and quotation system for its Richmond home office. The system receives current market prices and other information from several online data services and then either displays the information on a screen or stores it for later retrieval by

HRM 6303 VII SA

2 Training and Development HRM 6303 Unit VII SA For this assignment, you will write a report that details the components of an executive leadership development program for a fictitious company. The fictitious company can be within an organization and industry of your choice. Do not use the name of

ACC 5301 VI

2 Management Applications of Accounting ACC 5301 Unit VI Assignment This assignment measures your mastery of ULOs 2.5, 4.1, 5.2, and 6.1. You have been hired at ABC Manufacturing, and you have been asked to work on the budget for the upcoming year regarding labor costs and the number of