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

Documentation Practice

Create Documentation Practice Daily Grade 8: More Documentation Practice Purpose: The main purpose of this assignment is to continue practicing documentation skills. Directions: Log on to Google Drive using your NSU credentials, and save a copy of this document there, renaming it DG8 JDoe *** (use your first initial and

Real Estate Articles (Week 3)

Participation will consist of locating, submitting and commenting on current articles related to real estate. Links to these articles are to be posted to Article Participation under the Discussion Board. Do not post the article itself, just its link. You are to read these articles and then post your comments/thoughts

Blue 6

SEE ATTACHED Teachers Creating an Equitable Classroom Climate: · Teachers acknowledge their own biases and inequitable actions · Teachers make an effort to learn about their students’ cultural backgrounds. · Teachers examine curriculum and learning materials for bias. · Teachers build caring, cooperative classroom environments. · Teachers build relationships with

P&L statement completed

I need the following P&L statement completed please see attached items. Need it completed by tonight 9/19 11 pm (CST)  this is for a business or no later than 5 am CST 9/20

Business Finance – Management Financial management assignment

I need to answer the attached file with professional teacher. FINANCIAL MANAGMENT SBS – MBA Assignment STUDENT ID UNIT TITLE: NAME (in Full): GENERAL INSTRUCTIONS • All assignments are to be submitted on 17th October 2024 on • Any Assignment submission extension request must come to Azra Fatima (Assistant Vice

Waiting in Line

   Describe a waiting line situation that you regularly face in your daily life. Explain how you would improve the structure of that system by applying waiting line analysis.

Solving Problems

   Describe a current problem facing your department (Training Department at Diesel Engine School), that would indicate the need for a simulation model. How best could this problem be solved by simulation versus the other modeling techniques covered in the course? 

Economic cost/Waiting line

   What are the economic costs of waiting in lines? How might these costs be measured? What decision criteria can be used to justify expanding services to reduce waiting times?

Optimal solution

    Create a simple 0, 1 integer model for a situation or problem you face in your life. Is there an optimal solution for your problem? What type of model would you use to create an optimal solution? Explain.

brenda

  Discussion #5 – Brenda Berkman – First Female Firefighter Brenda Berkman was the first female firefighter for the New York City Fire Department and to achieve that she single-handedly sued the City of New York for unfair labor practices and discrimination in not allowing women to become a  firefighter.

Moonstay Corporation

Please, answer questions #1 and #2 only. I attached the whole assignment but only need answer for question #1 and #2. I also attached the book so you can use it as reference (The Scheutze speech is at p. 226 of the text).

mgt2

Select one (only one) from the four categories of identity below and write a short essay (300 to 500 words) offering reasons and evidence for your choice. Start by asking yourself “Who am I?” 1. I am a person defined mostly by race, ethnic group, or country of origin. I

w3

i need some help! Business-process outsourcing (BPO) is a type of outsourcing that consists of contracting operations and responsibilities of a specific business process (e.g., human resources) to a third-party service provider. Such outsourcing generally began with manufacturing firms outsourcing their supply chain but has grown into a much wider

Blue 4

See attached Over the course of many years observing teachers in their classrooms, these experts report that teachers who use culturally responsive teaching practices, regardless of the content they are teaching, consistently demonstrate that they: • value students’ cultural and linguistic resources and view this knowledge as capital to build

Affordable Expertise for All Your Accounting Needs

MMBA Chartered Accountants & Registered Auditors established in 2009, is your trusted source for expert financial advice across the UK, with offices in Preston, Luton, Cambridge, and London.    Visit-> https://www.mmba.co.uk/  Call->  01772378020