IRR function for this problem is 7. 7% and invest in the project
<h3>What is
IRR function?</h3>
The Excel IRR function returns the internal rate of return (IRR) for a sequence of cash flows that occur at regular intervals. Determine the internal rate of return. Return was calculated as a percentage. =IRR (values, [guess])
IRR is the interest rate at which the sum of all cash flows equals zero, thus it is useful for comparing one investment to another. In the preceding example, if we substitute 8% with 13.92%, the NPV becomes 0, and your IRR becomes zero. As a result, IRR is defined as the discount rate at which a project's NPV becomes zero.
To know more about IRR function follow the link:
brainly.com/question/24301559
#SPJ4
Answer:
less desirable to other investors
Explanation:
<u>Given</u>: Current fixed coupon rate 5%
Market rate of interest 5%
New Market Rate of Interest 6%
Value of a bond is inversely related to economy interest rate or the yield to maturity (YTM). Value of a bond is expressed by the following equation:
wherein, C = Coupon rate of interest
YTM = Market Rate of Interest or interest rate in the economy or investor's expectation
n= Years to maturity
RV = Redemption value
In the given case, C = YTM i.e par value bond. When ytm rises to 6%, the value of the bond shall fall making such a bond less attractive since it represents lower coupon payments than investor expectations.
Thus, now the bond would be less desirable to other investors.
Answer:
The firm's cost of preferred stock is 9.10%
Explanation:
The cost of preferred stock with the flotation of 5% would be the dividend payable by the preferred stock divided by the adjusted current market price(adjusted for flotation cost)
The dividend per year is $8
The adjusted price of the stock=$92.50*(1-f)
where f is the flotation cost in percentage terms i.e 5%
adjusted price of the stock is =$92.50*(1-5%)=$ 87.88
Cost of preferred stock=$8/$87.88*100 = 9.10%
Answer:
$21,000
Explanation:
initial investment $25,000
we need to determine the expected value of every possibility:
- $15,000 loss ⇒ 20% x $10,000 = $2,000
- $29,000 loss ⇒ 15% x $5,000 = $750
- $40,000 gain ⇒ 5% x $65,000 = $3,250
- break even ⇒ 60% x $25,000 = $15,000
total expected value = $21,000
Answer:
Check the explanation
Explanation:
Alternative A
Let the break even point be X, then
Total Revenue = Total Expense
60*X = (300000 + 25*X)
35*X = 300000
X = 8571.43 Units
Alternative B
Let the break even point be Y, then
60*Y = (250000 + 30*Y)
30*Y = 250000
Y = 8333.33 Units
