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

discussion replies

reply to the 2 prompts INDS 491 Discussion Assignment Instructions The discussions in this course are meant to be collaborative learning experiences that foster a spirit of community and collegiality, but you must also view these as academic assignments with formal requirements. For these discussions, you are required to submit

current event ethics

BUSI 301 Paper: Current Events Ethics Assignment Instructions Overview Our study of ethics in business can sometimes seem esoteric and removed from day-to-day management responsibilities, but media are filled with real-life examples of unethical business behavior that harms the businesses involved, as well as their shareholders, customers, employees, and other

Deliverable 4 – Creating Alternative Revenue Streams

Deliverable 4 – Creating Alternative Revenue Streams Scenario Health organizations continue to face challenges relative to costs and revenue. Changes in reimbursement structure is most often cited as one of the biggest challenges for providers. As a result, leaders are developing new approaches aimed at creating additional revenue streams. Traditionally,

DEFM200

see attached Instructions Assignment Directions Create a five-page essay that elaborates on the key ethical issues in federal government contracting and the differences between legislative and executive branch regulations in ethical behavior. Include the degree to which commercial contractors are bound by federal regulations. Remember, the two branches operate independently

Unit VII GSM

See attached 2 Teameco Broughton Institution: Columbia Southern University BUS 6320: Global Strategic Management Instructor: Professor: Robin Shah Date: 3/4/2026 Figure 1: Infographic on Johnson & Johnson Strategic Expansion References Johnson & Johnson. (2026, January 26). Johnson & Johnson named a 2026 Fortune World’s most admired company. Rothaermel, F. T.

Why Are Custom Candle Boxes Essential for Modern Candle Brands?

  What Are Custom Candle Boxes? Custom candle boxes are specially designed packaging solutions created to fit candles perfectly. But are they only about size and shape, or do they offer more than basic protection? Why Do Candles Need Custom Packaging? Candles are delicate—so how do you protect them from

Drinking Water Quality

Please respond to the following: Using the Internet or Strayer Library, research the work of U.S. government agencies to ensure the safety of your community’s water supply. Also, locate a current Consumer Confidence Report or City or Town water quality report to assess your community’s drinking water’s quality. Summarize your

Excel Questions Business Analysis

Answer the following questions excel. Assignment 6: Analyzing Distribution Types and Trend Lines in Excel Scenario: You are a data analyst for a small retail company, and your manager has asked you to analyze customer purchasing trends over the past year. You have been provided with sales data from different

SCMG201

see attached Discussion Prompt: Find an operations-based company you are familiar with and research its use of suppliers. First, take a look at what companies have already been reported on and try not to duplicate what someone else has analyzed.  Company: WALGREENS – Nationwide pharmacy and retail operations Discussion Points:

Climate Change Efforts

Please respond to the following: Consider what you learned about how COVID-19 shutdowns affected air quality. What can these events teach us about efforts to control global climate change? What do you think are fair and realistic expectations of the world’s more-developed and less-developed countries in this effort? Be sure

Prof Double R

 In response to your peers, consider their argument. Do you agree? Disagree? Are there parts of their argument that you agree with? If so, which ones? If not, which parts do you specifically disagree with? Is there something that your peer said that made you reevaluate your position a bit? 

Mgmt 338 RP

I’ll post question to you  Assignment Expectations Week 1: Country Selection Students are required to select a country to research for the final paper. The selected country must be claimed in the ‘Country Selection’ discussion topic located in the open forum. Students must review classmates’ selections to ensure their chosen

Business Finance – Management Homework

MBA 599 – Strategic Management Case Project This capstone course requires each student to construct a detailed and well-thought-out analysis of a business employing all the relevant strategic analysis tools studied in the course. This project will take the full term to complete. It is our sincere hope that you

Mapping the Customer Experience Journey to Improve Customer Experience

Mapping the Customer Experience Journey to Improve Customer Experience In today’s competitive market, businesses must focus on delivering meaningful and seamless interactions at every stage of engagement. This is why mapping the customer experience journey has become an essential strategy for growth. By understanding how customers interact with a brand

Generative AI

   Discuss whether and how generative AI will play a role in strategic planning? How might you use it to assist in strategy formulation and implementation?

BCG and IE

   Are there key differences between BCG and IE portfolio matrices in both early-stage and established companies? If so, what are those key differences, and if not, why not? Provide insights in your responses based on the industry in which you have worked, are working in, or would like to

Event Software LLC

Reliable virtual event software is essential for online gatherings, and Eventsoftware.com offers seamless integrations, engagement features, and stable performance for global audiences.