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: Price of stock at year end =$53
Explanation:
we first compute the Expected rate of return using the CAPM FORMULAE that
Expected return =risk-free rate + Beta ( Market return - risk free rate)
Expected return=6% + 1.2 ( 16%-6%)
Expected return= 0.06 + 1.2 (10%)
Expected return=0.06+ 0.12
Expected return=0.18
Using the formulae Po= D1 / R-g to find the growth rate
Where Po= current price of stock at $50
D1= Dividend at $6 at end of year
R = Expected return = 0.18
50= 6/ 0.18-g
50(0.18-g) =6
9-50g=6
50g=9-6
g= 3/50
g=0.06 = 6%
Now that we have gotten the growth rate and expected return, we can now determine the price the investors are expected to sell the stock at the end of year.
Price of stock = D( 1-g) / R-g
= 6( 1+0.06)/ 0.18 -0.06
=6+0.36/0.12
=6.36/0.12= $53
Answer: $1,900
Explanation:
Theft loss deduction is calculated by adjusting the fair market value of the asset for a theft loss floor limitation of $100 and 10% of the person's AGI.
Theft loss deduction is:
= Fair value -Theft floor limitation - 10% of AGI
= 7,000 - 100 - (10% * 50,000)
= $1,900
Answer:
Authorities can be assigned, but never delegated obligations. Subordinates are responsible for "results" and managers are responsible for their subordinates ' actions. You can't be held responsible for a mission if you have little competence.
Explanation:
The delegation lets you pass the power to professional team members to work on more urgent matters. But you are still responsible for doing these in the right way. It is therefore necessary to periodically track the status or interact with the team member
Let us recognize some of the fundamental principles to be observed in delegating: 1. The delegated authority to subordinates should be adequate to achieve the desired performance.
2. The power may be delegated but never assigned responsibility. Subordinate accountability is "efficiency" and managers are "responsible for their subordinates ' activities."
3. A duty can not be held accountable if it only has limited authority. A balance between authority and responsibility must be created.
4. A single superior's presence brings to mind the subordinate more personally responsible.
Answer:
15.4%
Explanation:
Calculation to determine your best guess for the rate of return on the stock
The revised estimate on the rate of return on
the stock would be:
Before
14% = α +[4%*1] + [6%*0.4]
α = 14% - 6.4%
α = 7.6%
With the changes:
7.6% + [5%*1] + [7%*0.4]
= 7.6% + 5% + 2.8%
= 15.4%
Therefore your best guess for the rate of return on the stock will be 15.4%
