When the genesis and sensible essential teams held their

Assignment Help Finance Basics

Reference no: EM13388311

When the Genesis and Sensible Essential teams held their weekly meeting, the time value of money and its applicability yielded an extremely stimulating discussion. However, most of the team members from Genesis were very perplexed. Sensible Essentials decided the most expedient way to demonstrate how interest rates as well as time impact the value of money was to use examples. You have been asked to prepare a report analyzing your findings of the three example calculations listed below.

In this assignment, you will do the following:

    Calculate the future value of $100,000 ten years from now based on the following annual interest rates:
        2%
        5%
        8%
        10%

    Calculate the present value of a stream of cash flows based on a discount rate of 8%. Annual cash flow is as follows:
        Year 1 = $100,000
        Year 2 = $150,000
        Year 3 = $200,000
        Year 4 = $200,000
        Year 5 = $150,000
        Years 6-10 = $100,000

    Calculate the present value of the cash flow stream in problem 2 with the following interest rates:
        Year 1 = 8%
        Year 2 = 6%
        Year 3 = 10%
        Year 4 = 4%
        Year 5 = 6%
        Years 6-10 = 4

Perform your calculations in an Excel spreadsheet. Copy the calculations in a Word document. In addition, write a 2- to 3-page executive summary in Word format. Your summary should reflect a proper analysis of your findings, including a comparison and contrast of data. Apply APA standards to citation of sources. Use the following file naming convention

Reference no: EM13388311

Questions Cloud

For the three most recent years calculate the du pont : for the three most recent years calculate the du pont identity for your chosen company. how has roe changed over this

Write down risks advantages and disadvantages to the : how would entering into the global arena affect your business your region and the country as a whole? what are the

After reading your report as well as comments by others on : after reading your report as well as comments by others on the teams the genesis team began to understand the

Identify a brand about which you are passionateexplain a : write a 750- to 1000-word paper in which you identify your favorite brand apple michael kors and explain why it is your

When the genesis and sensible essential teams held their : when the genesis and sensible essential teams held their weekly meeting the time value of money and its applicability

Describe the role of interpersonal communication both as a : give a comprehensive research review of the significant principles of management communications used to successfully

Why is it necessary to monitor and control strategic plans : b1.nbsp why is it necessary to monitor and control strategic plans? who should be responsible for monitoring and

Illustrate the difference between leading and coaching give : 1. what is meant by the statement leadership is a process not a position? give examples of how jesus modeled this in

How can two partners each with a 50 interest in a : how can two partners each with a 50 interest in a partnership have different amounts of outside basis at the formation

User Account

All Pages