Calculate the present value of the cash flow stream

Assignment Help Financial Management

Reference no: EM13873712

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

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

Reference no: EM13873712

Questions Cloud

Find the present value of this annuity : A three-year continuous annuity pays a total of $100 during the first year, $400 during the second year, and $1,000 during the third year. Within each year, the payments are made continuously and evenly throughout the year. The effective annual inter..

Specific entropy increase in the actual turbine : A turbine receives air at 1500 K, 1000 kPa and expands it to 100 kPa. The turbine has an isentropic efficiency of 85%. Find the actual turbine exit air temperature and the specific entropy increase in the actual turbine.

Using the historical data as guide construct pro forma : Using the historical data as a guide construct a pro forma ( forecasted) profit and loss statement for the clinic's average day for all of 2013 assuming the status quo. With no change in volume (utilization), is the clinic projected to make profit?

How to use social media to improve patient safety : Search for a skill related to healthcare quality management that can increase your chance in finding an internship or a job in the current job market. For example, how to use social media to improve patient safety

Calculate the present value of the cash flow stream : Calculate the future value of $100,000 ten years from now based on the following annual interest rates: Calculate the present value of a stream of cash flows based on a discount rate of 8%. Annual cash flow is as follows: Calculate the present value ..

What strategies would you use as a project manager : What strategies would you use as a project manager to ensure that your team members identify project risks - what motivation strategies would you use and what challenges do you foresee and what strategies would you utilize to overcome these challenge..

Magnitudes of the pressures on the top : A tiny steel cube is suspended in water by a string. If the lengths of the sides of the cube are very small, how would you compare the magnitudes of the pressures on the top, bottom, and side surfaces of the cube?

Dividend reinvestment plan : Pam owns 50 shares of Floor Mart Inc. The firm has a semi annual dividend policy of $0.75 per share or the option to reinvest the cash dividends into additional shares of company stock. If the stock is selling for $25.00 per share ex-dividend, how ma..

Calculate heat transfer from water : A test cylinder with constant volume of 0.1 L contains water at the critical point. It now cools down to room temperature of 20°C. Calculate the heat transfer from the water.

User Account

All Pages