The companye decided the most expedient way to demonstrate

Assignment Help Finance Basics
Reference no: EM13497365

The companye 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.



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 page executive summary in Word format. Your summary should reflect a proper analysis of your findings, including a comparison and contrast of data.

Reference no: EM13497365

Questions Cloud

How much work does the elevator do on you : You are moving into an apartment and take the elevator to the 6th floor. How much work does the elevator do on you alone (without belongings) on the downward trip, which is also made at a constant velocity
Do you agree or disagree with collison and why : If ‘profit' maximization is biased towards maximising the interest of only one stakeholders group, would you expect that over time there will be less emphasis on profits and more emphasis on other performance indicators?
Explain the structure of biphenyl and the numbering scheme : The structure of biphenyl and the numbering scheme used in naming its derivatives are indicated below. What is the major product obtained on dinitration of biphenyl (HNO3, H2SO4)
Which method provides the most useful information to users : Which method provides the most useful information to users? Under what circumstances would the other methods provide more useful information?
The companye decided the most expedient way to demonstrate : The companye decided the most expedient way to demonstrate
Find the speed at which the water leaves the hole : A large storage tank, open to the atmosphere at the top and filled with water, develops a small hole in its side at a point17.6m below the water level. Determine the speed at which the water leaves the hole
Determine the acceleration of the bucket : A bucket of water with a mass of 2.0 kg is attached to a rope that is wound around a cylinder. What is the acceleration of the bucket
Explain what is the repeatability of a measurement : what is the repeatability of a measurement and the extent to which repeated measurements agree among themselves
Compute the normalization constant for the wave function : What are the possible value for of n and m if a) l = 1, b) l = 4, and c) l = 0 ? Compute the minimum possible energy for each case. compute the normalization constant for the wave function

Reviews

Write a Review

Finance Basics Questions & Answers

  How the bank control the loan extended to the borrowers

Explain how the bank control the loan extended to the borrowers

  What will be the projected eps next year

If Zybeck issues common stock this year, what will be the projected EPS next year?

  Compute rate of return on the investment

Suppose you decide to sell short 200 shares of XCorp stock at a price of $75. Your margin deposit is 65%. Commission on the sale is 1.25 percent. While you are short, the stock pays a $1.75 per share dividend.

  Compute rate of earnings to grow

Canyon Recreational Products has earnings of $1.60 per share and plans to pay a $0.64 dividend. In past Canyon Recreational Products has earned a return of 25 percent on its investments,

  In each case identify on the blank line whether the item is

the following items and amounts were taken from linus inc.s 2012 income statement and balance sheet.cash84700accounts

  Compute the present value of this stream of income

Now compute the present value of the income stream from the gold mine at a discount rate of 6%, and at a discount rate of 4%.

  Improving the efficiency of logistics

Falling prices for core computing components, rapid advancement in speech recognition technology and head-worn display products are fueling a phenomenal growth in the wearable computer market.

  If 10 percent is the appropriate discount rate what is

the state lotterys million-dollar payout provides for 1 million to be paid over 19 years in 20 payments of 50000.the

  Risky portfolio and the risk-free asset

Suppose you have $500,000 available to invest. The risk-free rate is 8 percent, and there is a fund in which you could invest that has an expected return of 16 percent.

  Calculate the certainty equivalent cash flow

A project has an expected risky cash flow of $300, in year 3. The risk-free rate is 5%, the market risk premium is 8% and the project's beta is 1.25. Calculate the certainty equivalent cash flow for year 3.

  What is the expected return of each asset

what is the expected return of a portfolio with 9% in asset J, 51% in asset K, and 40% in asset L?

  Explaining statement of cash flows

Describe the content and layout of a statement of cash flows, including it three sections. List at least three transactions classified as investing activities in a statement of cash flows.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd