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

Assignment 1 689

Webinars are an effective way to obtain on-demand information regarding issues and challenges that leaders face. This assignment is designed to help students learn about various resources available for professional development, as well as engage in the thoughtful examination of pertinent leadership topics. After you have listened to your chosen

Response 1689

Write a 100 word response Due 1/18/2026 Mendes Based on the challenges identified in Week 1 discussion, it is clear that the need for stronger communication, reliability and flexibility in my work environment is the focus. A transformational leadership model appears most suitable for addressing current societal and organization issues.

Response 2689

Write a 100 word response Due 1/18/2026 Bradford Reflecting on a previously identified challenge related to change fatigue and ongoing organizational strain, a leadership model that is well suited to address current societal and organizational issues is transformational leadership. This approach emphasizes purpose, communication, and shared commitment, which are essential

Business

Perry Part 1 Your statement must be well-written and include all the elements listed.  Do NOT use AI to write your statement for you.  Personal Statement (Use the Department of Social Services as a Job) 1. Research the organization, the organization’s overall objectives, and who is eligible for the opportunity

Discussion 2

Write a 300-word response. 2 references with in-text citations Due 1/16/2026 · Thinking about the challenges and aspects that you identified in your response to the Week 1 discussion, what leadership style of model would you consider appropriate to address some of the current societal and organizational issues? (Week 1

Unit 2 670

See attached Prepare an individual strategy report ( 800–1000words) that demonstrates your ability to apply strategic analysis to your organization. Integrate your personal/professional experience and cite specific company reports, which may also include original SWOT tables. Your report must address the following questions: · Business Model – What business model does

EXP A1

Please read directions and rubric thoroughly  Student Name: firstName lastName [A1 – Assignment 1] Research the products and services of Fintech companies and write about three Fintech products and services. Learning objective: to describe the application of Fintech products and services. [Instructions: Use “A1 Template” for this assignment. The template

week 2

 synthesizing findings from research on organizational development models and theories 

BUS 206 MODULE 2

ATTACHED Project One Guidelines and Rubric.html BUS 206 Project One Guidelines and Rubric Competency In this project, you will demonstrate your mastery of the following competency: Describe the foundational elements of the U.S. legal system and the relationships among them Scenario You are a successful small business owner and have

Week 9 Discussion- Delivery of Healthcare

   Continuum Of Care Scenario: Team B- Discussion 3 In this Discussion, you will continue to analyze your continuum of care scenario using the value-based care model, the IOM Aims, and a country comparison. You will continue to work with Team B and share your suggestions for improvements. Then, you

BUSN100_Assign.

see attached Instructions Assignment Instruction You are the Information Security Director for a medium-sized company. You recently experienced a ransomware attack that cost the company $500,000.00. After the attack, your CEO held a meeting and informed you and the other IT professionals that it “WILL” not happen again. Write a

Unit VII

see attached Assignment Instructions You will use the multinational corporation (MNC) you researched in Unit VI for this assignment. The purpose of this scholarly activity is to continue to analyze fundamental aspects of corporate finance management in multinational corporations. You will examine supply chains and working capital management and make

Discussion 1

Write a 350 word response with 1 reference Due 1/6/2026 Discussion Question One: In this course, you will have an opportunity to explore ways to address topics of your interest that may represent challenges or areas in need of improvement or growth facing the organization.  · Considering your position, what

Business Finance – Management MBA 511 Week One Assignment. Powerpoint Presentation 7-8 slides

Week One Assignment Instructions Assignment 1: Assess Emotional Intelligence Top of Form Bottom of Form Instructions Competent leadership drives organizational success. Research shows that self-awareness, a central aspect of Emotional Intelligence, is more crucial for effective leadership than IQ or technical skills (Showry & Manasa, 2014). Self-awareness underpins managerial capability

sdddjsjs

Personal Reaction Paper Instructions: The purpose of the assignment is to reflect on the concepts gleaned from reading chapters 1 – 3 of the required textbook ( Human Resource Management). The objective of the paper is to analyze how human resource concepts apply to employees and the organizations they are

7-1 Discussion: What Would You Do Differently?

 For this discussion, describe a persuasive message that your workplace leader sent to an audience who resisted the idea, product, or service. Imagine yourself as a member of the audience. What would you recommend to the leader to better construct the message to get the intended results? Identify at least