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

MATH120

SEE ATTACHMENT  Conditional Probability: What affect does a condition have on the probability?  Let’s compare and find out. Example:   Let’s look at a standard deck of 52 playing cards. No replacement:  What is the probability of getting 2 kings assuming that the first one is not replaced?  (Note:  There are

MGMT496

SEE ATTCHMENT 250-300 WORDS ANSWERING THE FOLLOWING QUESTION This week explain who the potential audience for your e-portfolio will be.  How will you ensure that your e-portfolio is well received by the audience?  What acronyms do you use in your workplace that can cause confusion?  If you are including a

Government and Politics

Details attached.   The role of government in the economy is often debated by economists and businesspeople. 

HRM 6302 Unit V DBR

2 Employment Law HRM 6302 Unit V DB Reply 1 Posts to others should be a minimum of 150 words and use at least one supporting reference. You can use the text for this course as one of the reference sources. Reply to student post below Part I Under the Federal

Fin 6301 Unit VI PPP

2 Corporate Finance ECO 6301 Unit VI PowerPoint Presentation This assignment measures your mastery of ULOs 5.1, 5.2, and 5.3. The purpose of this PowerPoint Presentation is to analyze fundamental aspects of corporate finance management in multinational corporations. You will research a multinational corporation to focus on for the assignment,

gender

 In this summarize, Gallant writes mostly about gender and sex work. How might her ideas be expanded to consider gender in other areas of life?  

Real Estate Evaluation| Neighborhood Analysis

Identify and evaluate the neighborhood within which you live? Create a neighborhood profile using internet links and personal information that will provide some specific data. Draw some inference from this evaluation. Be sure to understand the term neighborhood and what makes this neighborhood different. Is it close to jobs? How

week 3 dicussion Organizational Behavior

 What are the factors that influence our perception? What is the link between perception and decision making? How do individual differences and organizational constraints influence decision making? 

FIN 6301 Unit V DB R1

2 Corporate Finance ECO 6301 Unit V DB Reply 1 • Your response post to class classmate should be at least 150 words in length. • Your response post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or

FIN 6301 Unit V DB R2

2 Corporate Finance ECO 6301 Unit V DB Reply 2 • Your response post to class classmate should be at least 150 words in length. • Your response post should include at least one APA-formatted scholarly, professional, or textbook reference with accompanying in-text citation to support any paraphrased, summarized, or

BUSINESS (NO PLAGARISM A+ WORK, ON TIME)

discussion and assignment ASSIGNMENT Brand Extension Assignment For this assignment, you are asked to choose an  existing brand and create a  brand extension for that brand. This is not connected to your final paper topic, so you can use any brand, including your final paper topic for this deliverable. Your goal is

Cash Budget

See attached Please complete Excel template provided The goal of this assignment is to demonstrate the process of construction and utilization of a cash budget for a company. The assignment is closely related to Course Objectives #02. For this assignment we consider the monthly cash budget for six months (January

Final Project: Present a Business Plan

   Final Project: Present a Business Plan WHO: You are the entrepreneur, and your job is to present a business plan for your entrepreneurial venture (I was thinking of a truck parking stop).

Deliverable 7 – Strategic Implementation of Quality Initiatives

  Competencies Analyze the history of healthcare quality improvement and how it shapes current and future quality initiatives. Evaluate patient care clinical outcomes using quality improvement principles. Evaluate healthcare quality measures and their use in diverse populations and settings. Apply models of quality improvement to institutional challenges within the healthcare

Week 4 Discussion Response- Account for Managment Decision Making

Account for Management Decision Making Week 4 Learning Resources Costs There are many different types of costs that impact a manager’s decision making. Therefore, it is imperative that managers understand what each type is as well as the ones relevant to a specific decision. In these resources, you will examine

Marketing Strategy

Marketing Strategy is already completed but need to make improvements based on feedback. I will share the document i have prepared thus far with the feedback, referrences.

Unit VIII FP

see attached Unit VIII A Case Analysis of AMC Assignment objective: AMC is the largest movie theater operator in the world. AMC recently became a popular meme stock. Take a few minutes to learn more about AMC Theaters . Length: Your submission is required to be at least 5 pages

Unit VII J

see attached Unit VII Journal Journal objective: Auctions can be an important tool for selling/buying goods and gathering information. Auctions are used in multiple venues including agriculture, eBay, and distressed asset sales. The seller does not have to worry about estimating demand and setting a price because the demanders will