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]
2 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]2 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
Kate purchased 500 shares of Fast Deliveries stock on Wednesday, July 7th. Ted purchased 100 shares of Fast Deliveries stock on
Nataly_w [17]

Answer:

d. Both Ted and Kate are entitled to the dividend.

Explanation:

There are 3 important dates when a corporation declares a dividend:

  1. The declaration date: in this case June 20th. It is the date when the corporation declares that it will pay a certain cash dividend.
  2. The date of record: the date of record is one day after the ex-dividend date, which means that the stockholders that the stock until the ex-dividend date will be entitled to receive the dividend. The stockholders that purchase the stock on the record date or any date after the ex-dividend date, will not be entitled to receive the dividend. In this case, the ex-dividend date was July 11th, and both Ted and Kate purchased the stocks before that date.
  3. The date of payment: the actual date when the dividends are distributed, in this case, August 1st.
5 0
2 years ago
Computer Consultants Inc. is considering a project that has the following cash flow and cost of capital (r) data. What is the pr
Korolek [52]

Answer:

e. 14.20%

Explanation:

We use the formula:

A=P(1+r/100)^n

where

A=future value

P=present value

r=rate of interest

n=time period.

Hence

A=$450(1.1)^2+$450(1.1)^1+$450

=$450[(1.1)^2+(1.1)+1]

=$1489.50

Hence

MIRR=[Future value of inflows/Present value of outflows]^(1/time period)-1

=[1489.5/1000]^(1/3)-1

=14.20%(Approx)

4 0
3 years ago
Suppose that you invest $100 today in a risk-free investment and let the 6 percent annual interest rate compound. What will be t
Kipish [7]

Solution :

It is given that :

Amount of investment or the principle amount , P = $ 100

Time of investment , t = 6 years

Rate of interest compounded annually r = 6 %

Therefore the future amount of this investment in a 6 year time is given by,

$FV=P(1+\frac{r}{100})^t

$FV=100(1+\frac{6}{100})^6

$FV=100(1+0.06)^6

$FV= 100 (1.4185)$

$FV=141$

Therefore, after 6 years the investment of $ 100 will give an amount of $ 141.

3 0
3 years ago
What happens to the price of a three-year annual coupon paying bond with an 8% coupon when interest rates change from 8% to 6.85
ruslelena [56]

Face Value of bond = $1000

Annual Coupon Payment = $1000*8%

= $80

No of years to maturity(n) = 3 years

When the Market Interest rate was 8%, the Price of the bond will be the same as the Par value which is $1000 because when the Coupon rate and Market Interest rate are the same the Bond sells at par Value.

So, At an 8% Interest rate price is $1000

- Interest rate(YTM) changed to 8.86%

Calculating the Price of Bond:-

Price = \frac{CouponPayment}{(1+YTM)^{1}}+\frac{CouponPayment}{(1+YTM)^{2}}+...+\frac{CouponPayment}{(1+YTM)^{n}}+\frac{FaceValue}{(1+YTM)^{n}}

Price = \frac{80}{(1+0.0886)^{1}}+\frac{80}{(1+0.0886)^{2}}+\frac{80}{(1+0.0886)^{3}}+\frac{1000}{(1+0.0886)^{3}}

Price =$203.008 + $775.166

Price = $978.17

So, when the Interest rate changed to 8.86% the price falls to $978.17

Change in Price due to increase in Interest rate = $978.17 - $1000

= -$21.83

Hence, the price decreased by $21.83

Learn more about interest here

brainly.com/question/2294792

#SPJ1

7 0
2 years ago
What peripherals would you need to host a video conference?
Leto [7]
The answer would be C. Webcam, Speakers, and microphone.
5 0
2 years ago
Read 2 more answers
Other questions:
  • A company currently pays a dividend of $3.4 per share (D0 = $3.4). It is estimated that the company's dividend will grow at a ra
    10·1 answer
  • Furnaces & Filters Inc. is a public company whose shares are traded in the public securities markets. Under the Sarbanes-Oxl
    6·1 answer
  • When the price of candy bars decreased from $0.55 to $0.45, the quantity demanded changed from 19,000 per day to 21,000 per day.
    6·1 answer
  • من الامثلة على الازمات المادية الملموسة في المنظمات​
    6·1 answer
  • When Karin’s supervisor asks about her work load she says it is fine. In actuality, she spends much of her time on personal call
    7·2 answers
  • when demand does not change much after a price change, demand is: a. variable b. static c. elastic d. inelastic
    8·2 answers
  • Explain how opportunity cost is different for economic goods and free goods
    15·1 answer
  • 2019 balance sheet showed net fixed assets of $5.2 million, and the 2020 balance sheet showed net fixed assets of $5.8 million.
    7·1 answer
  • Define option price. Explain why the option price of a policy might differ from the expected surplus generated by the policy.
    13·1 answer
  • What is the first thing a lender might do if a borrower is late with a payment?
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!