1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
PSYCHO15rus [73]
2 years ago
9

You have been asked to calculate the internal rate of return for an investment with the following cash flows, using the Excel IR

R function: The cost of the investment is $500,000. Cash flows in years 1 through 5 are $200,000; $160,000; $120,000; $80,000; and $40,000, respectively. There is no residual value to the investment. Using Excel's IRR function, what is the internal rate of return on the investment after 3 years
Business
1 answer:
agasfer [191]2 years ago
4 0

Answer:

9.92 %

Explanation:

Year 0 = ($500,000)

Year 1 = $200,000

Year 2 = $160,000

Year 3 = $120,000

Year 4 = $80,000

Year 5 = ($40,000 + $25,000) = $65,000

therefore,

the internal rate of return on the investment after 5 years is 9.92 %

You might be interested in
5. A man has $ 10,000 to invest. He invests $ 4000 at 5 % and $ 3500 at 4 %. In order to have a yearly income of $ 500, he must
Len [333]
6.4%

200 from the 5% of 4000
140 from 4% on 3500

160 on 6.4% on 2500
4 0
2 years ago
Read 2 more answers
Tanner is choosing between two​ mutually-exclusive investment options. These options have absolutely no​ risk, and Tanner can al
Reika [66]

Answer:

D) Tanner should be indifferent between the two investments, since both are equivalent to the same amount of cash today.

Explanation:

Here are the options to this question:

A) $531.40 later today, since $1 today is worth more than $1 in one year.

B) $550 in one year, since it is $50 more than he invested rather than $31.40 more than he invested.

C) Neither - both investments have a negative NPV.

D) Tanner should be indifferent between the two investments, since both are equivalent to the same amount of cash today.

Net present value is the present value of after tax cash flows from an investment less the amount invested.

NPV can be calculated using a financial calculator:

For the first option:

Cash flow in year 0 = $500

Cash flow in year 1 = $550

I = ​ 3.5%

NPV = $31.40

For the second option:

NPV = $631.40 - $600 = $31.40

The npv of both options are equal and postive. So, Tanner should be indifferent between the options.

To find the NPV using a financial calacutor:

1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.

2. After inputting all the cash flows, press the NPV button, input the value for I, press enter and the arrow facing a downward direction.

3. Press compute

I hope my answer helps you

5 0
4 years ago
The term _____ is defined as the activity, set of institutions, and processes for creating, communicating, delivering, and excha
Temka [501]

Answer:

American Marketing Association

Explanation:

American Marketing Association -

It refers to the association of many marketing professionals all together , is referred to as the American Marketing Association  .

In the year 2012 , there were 30,000 members , present in the United states .

Which consists of 250 collegiate chapters and 76 professional chapters .

Hence from the given scenario of the question ,

The correct option is American Marketing Association .

3 0
3 years ago
_____ involves marketing philosophies, policies, procedures, and actions whose primary objective is the enhancement of society.
Leto [7]

Social responsibility in marketing refers to marketing philosophies, strategies, practices, and actions whose main goal is to improve society and safeguard the environment by using environmentally friendly goods and methods.

SOCIAL RESPONSIBILITY: WHAT IS IT?

Sustainability can be attained through social responsibility. Any business or system can increase its chances of long-term sustainability and success by adopting fundamental social responsibility principles including accountability and transparency.

An organization's accountability for the effects of its choices and actions on people, the environment, and society through openness and moral behavior that: contributes to societal well-being and sustainable development, including health reflects an awareness of stakeholder expectations is in accordance with all current laws and international standards of conduct is incorporated across the business and used in partnerships.

to know more about social responsibility

brainly.com/question/12951431

#SPJ4

4 0
1 year ago
Prompt
Law Incorporation [45]

Answer:

Could you please be specific with your question?

Explanation:

8 0
3 years ago
Other questions:
  • According to the leadership grid developed by Blake and Mouton, which management style reflects moderate concern for production
    11·1 answer
  • This 18th century economist coined the term "invisible hand," a metaphor representing the natural forces that drive individuals
    7·1 answer
  • Which of the following are task roles? Select all that apply.
    13·2 answers
  • "A retail store owner offers a discount on product A and predicts that the customers would purchase products B and C in addition
    6·1 answer
  • Now, suppose the government were to decrease net taxes by $20 billion without changing the level of government purchases. This w
    8·1 answer
  • In the current year, many talented teachers have submitted their resignation notices in Sunnydale High School. The president of
    6·1 answer
  • A company budgeted unit sales of 204,000 units for January, 2017 and 240,000 units for February 2017. The company has a policy o
    8·1 answer
  • A $250,000 loan is to be amortized over 8 years, with annual end-of-year payments. Which of these statements is CORRECT? a. If t
    11·1 answer
  • The act of giving up one thing of value to gain another thing of value is called a/an
    8·2 answers
  • When a company creates overhead rates based on the actions it performs, it is employing an approach called.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!