Determine of the discount rate or hurdle rate

Assignment Help Financial Management
Reference no: EM13766932

Company selected is Amazon.

Select a company in which you have an interest. For that company, describe a capital budgeting project (i.e., an investment in fixed assets) that might be undertaken by the company. Make sure that the project has an initial investment in Year 0, followed by a series of annual cash flows for at least seven (7) years.

1. Determine (make estimate) of the discount rate, or hurdle rate, that is appropriate for this project and explain the determination of that rate?

2. Develop your own Excel spreadsheet model that can be used to determine the Net Present Value (NPV), Internal Rate of Return (IRR), Modified Internal Rate of Return (MIRR), and Profitability Index (PI)? The Excel spreadsheet that you develop must use Excel’s automated financial functions for determining the NPV, IRR and MIRR. What is the NPV, IRR, MIRR, and PI for the project?

3. Using results of the spreadsheet analysis, explain whether, or not, the project should be implemented? Also, discuss what the various indicators (i.e., NPV, IRR, MIRR and PI) mean?

Reference no: EM13766932

Questions Cloud

Different capital structures-equity plan and levered plan : Rise Against Corporation is comparing two different capital structures: an all-equity plan (Plan I) and a levered plan (Plan II). Under Plan I, the company would have 170,000 shares of stock outstanding. Under Plan II, there would be 120,000 shares o..
Explain how poor, neglected operations : Explain how poor, neglected "operations" is in fact the ugly duckling that can mature into a swan. How can companies that neglect their operations find themselves in serious trouble
Calculate the beta portfolio : You hold a portfolio with the following securities: Security Percent of portfolio Beta. Calculate the beta portfolio
Debt capital is lower than the cost of equity capital : In general the cost of debt capital is lower than the cost of equity capital. It might be expected that firms with high debt ratios would have a lower weighted average cost of capital. Explain at least one reason why this is not the case.
Determine of the discount rate or hurdle rate : Select a company in which you have an interest. For that company, describe a capital budgeting project (i.e., an investment in fixed assets) that might be undertaken by the company. Determine (make estimate) of the discount rate, or hurdle rate, that..
Compute the squares of the numbers in the array : Write a java program to find the number in the given list. Write a java program to find the location of an element in the list.
Did your life become just a bit easier : Naturally, left-handed people have adapted to the right-handed world to the extent that most are ambidextrous.Lefties, what did you get from this? Did your life become just a bit easier?
The correlation between chronic conditions and optimum healt : Can a person with a chronic condition also experience optimum health? Why or why not - provide rationale.
A columnist for a metropolitan newspaper : Research Problem 2. Stuart is a columnist for a metropolitan newspaper. He holds a degree in journalism from a major midwestern university. For the past 10 years, Stuart has prepared his own income tax returns. He finds doing so to be challenging and..

Reviews

Write a Review

Financial Management Questions & Answers

  What do you suggest as a cost-effective approach

What do you suggest as a cost-effective approach to capital budgeting analysis when a project contains real options

  Mistakenly made public the personal information

Spotlight on AOL— Common Law. AOL, LLC, mistakenly made public the personal information of 650,000 of its members. The members filed a suit, alleging violations of California law. AOL asked the court to dismiss the suit on the basis of a “forum- sele..

  Give in one paragraph your reasoning why someone should

select 3 outcomesconcepts you learned in this class. explain why there are important for you and how will you use what

  What actions can it take to be in compliance

If the Friendly National Bank experiences a required reserves deficit, what actions can it take to be in compliance with the existing required reserves ratio?

  1 calculate the audjpy cross rate when the following fx

1 calculate the audjpy cross rate when the following fx spot rates are quoted bullaudusd0.6066bullusdjpy115.90 give

  Annual pretax cost savings

Purple Haze Machine Shop is considering a four-year project to improve its production efficiency. Buying a new machine press for $540,000 is estimated to result in $225,000 in annual pretax cost savings. The press falls in the MACRS five-year class, ..

  What is the present value of the perpetuity

What is present value of perpetuity of $100 per year with first payment started 5 years from today if appropriate discount rate is 5%? If discount rate is increased to 15% what is the present value of the perpetuity?

  Garnett jackson the founder and ceo of tech tune-ups stared

garnett jackson the founder and ceo of tech tune-ups stared out the window as he finished his customary peanut butter

  The caraway seed company sells specialty gardening seeds

the caraway seed company sells specialty gardening seeds and products primarily to mail-order and internet customers.

  What is the after tax cash flow from the sale of this asset

Consider an asset that costs $635,000 and is depreciated straight-line to zero over its eight-year tax life. The asset is to be used in a five-year project; at the end of the project, the asset can be sold for $125,000. If the relevant tax rate is 35..

  Equal to the present value of the redemption amount

A bond with face and redemption amount of $3000 with annual coupons is selling at an effective annual yield rate equal to twice the coupon rate. The present value of the coupons is equal to the present value of the redemption amount. What is the sell..

  The correlation coefficient between two stocks

The correlation coefficient between two stocks

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