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
algol [13]
3 years ago
14

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. The residual value of the investment is $25,000. Using Excel's IRR function, what is the internal rate of return on the investment after 5 years
Business
1 answer:
marusya05 [52]3 years ago
6 0

Answer:

9.92 %

Explanation:

The Summary of Cash flows to use in the calculation are as follows :

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
A corporate bond pays 6.25 percent interest. How much would a municipal bond have to pay to be equivalent to this on an after ta
garri49 [273]

Answer:

C) 4.50 percent

Explanation:

It is given that :

Interest a corporate bond pays = 6.25 percent

The marginal percent tax bracket is given as : 28 %

We have to find the amount that the municipality bond shall pay to be the equivalent to the amount after the tax basis :

We known that the municipal bond is tax exempted after the corporate tax bond should be equal to the municipal bond to be indifferent.

Thus, rate of return = rate of return after tax = rate x (1 - tax rate)

                                                                         = 6.25 % x (1 - 0.28)

                                                                         = 4.50 %

Therefore the answer is   = 4.50 %

5 0
3 years ago
NbADBGLKvb.ka Dvhb.wrkbvkrh.hbk.cS
elixir [45]

Answer:

It's A.

Explanation:

Can i please have brainlest.

3 0
3 years ago
Read 2 more answers
Lumeris Inc., an automobile manufacturer, has an inflexible work schedule and requires its workers to work nine hours a day and
jonny [76]

Answer:

The correct answer is letter "B": nonphysical constraints.

Explanation:

According to the Theory of Constraints (TOC) a constraint is a limiting factor that does not enable companies to perform their work at their maximum capacity for their goals' achievement. In the same sense, nonphysical constraints are not material factors negatively influencing employees' actions. Wages cuts, reduction of benefits, unclear lines of command are examples of that kind of constraint.

4 0
3 years ago
Which of the following best describes deflation?
choli [55]
I believe the answer is A) A decrease in the cost in the goods and services.
7 0
3 years ago
Read 2 more answers
In​ Keynes's analysis of the speculative demand for​ money, what will happen to money demand if people suddenly decide that the
Serggg [28]

Answer:

The correct answer is option C.

Explanation:

When the interest rate falls below the normal level, people expect the interest rates to rise in future and bond prices to fall. This causes investors to sell the bonds at present so that they can buy bonds when they are selling at lower prices in future as of result of an increase in interest rates. Money demand will, as a result, will decrease.

4 0
4 years ago
Other questions:
  • The following is the income statement for the period ending December 31, Year 1, for Manatee Construction Company:
    11·1 answer
  • In its role as money manager, the Federal Reserve has three primary goals: to maintain stable prices (control inflation), ensure
    9·1 answer
  • Which of the following is NOT an end goal of BOTH quality improvement programs and continuous process improvement? Select one: a
    9·1 answer
  • You read an article in a news magazine that explains how the economy expanded for several years, and then went into a period of
    10·1 answer
  • How can you make sure you use the appropriate etiquette while being aware of : the organizational structure, values within, meth
    5·1 answer
  • A soft drink bottler incurred the following factory utility cost: $3,711 for 1,250 cases bottled and $3,790 for 1,800 cases bott
    12·1 answer
  • An economy produces final goods and services with a market value of $10,000 billion in a given year, but only $8,500 billion wor
    7·1 answer
  • Jessica has been very reliable making payments on reasonable loans over the past decade. She has never been late on a payment an
    13·2 answers
  • For each of the annual inflation rates given in the following table, first determine the new price of a movie ticket, assuming i
    8·1 answer
  • Which of the following should NOT be used as a piece of personal protective equipment when using pesticides?
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!