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

  Withdraws the entire amount and puts it in a mutual fund

At the end of each quarter, a 30-year-old woman puts $2000 in a retirement account that pays 6% interest compounded quarterly. When she reaches 55, she withdraws the entire amount and puts it in a mutual fund that pays 8.7% interest compounded monthl..

  Question 1assume a manufacturer incurs 2000000 hours of

question 1assume a manufacturer incurs 2000000 hours of direct productive labor in a year at a total direct labor cost

  Compute the prospective rate of return before tax

A project has an initial cost of $140,000 and an estimated salvage value after 16years of$80000. Estimated average annual recipts are $26,000. Estimated average annual disbursement are $16,000. Assuming that annual receipts and disbursement will be u..

  Equity account on the balance sheet and earnings

What is the relationship between the equity account on the Balance Sheet and Earnings (Net Income) reported on the Income Statement?

  Source of systematic risk

Which of the following is not a source of systematic risk?

  Consumers awareness and concerns

Collecting and using personal data: consumers' awareness and concerns

  Incremental cost of going outside versus conducting survey

Each year, Sunshine Motos surveys 7,500 former and prospective customers regarding satisfaction and brand awareness. For the current year, the company is considering outsourcing the survey to Global Associates, who have offered to conduct the survey ..

  Provide an example of a health care capital expenditure why

provide an example of a health care capital expenditure. why is the capital expenditure budgeting process important?

  Consider the following data for abc enterprises all numbers

consider the following data for abc enterprises all numbers in euro today is january 1 2013 income statement for 2012

  What is the price of maxwells stock today

What is the price of Maxwell's stock today and what is the expected payout ratio if Martha Stewart's uses the residual distribution model to determine next year's distribution and makes all distributions in the form of dividends?

  How much cash flow before tax and interest is necessary

How much cash flow before tax and interest is necessary to support a project that requires $4 million annually for equity investors and $2 million annually in interest payments if the firm's tax rate is 35%?

  Calculate the companys return on equity

Company B has a total asset turnover of 6.91 and a net profit margin of 14.29 percent. The total asset to equity ratio for the firm is 2.0. Calculate the company’s return on equity.

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