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
Company, Customers, Competitors, Collaborators, and Climate.
Answer:
Note: <em>The complete question is attached as picture below</em>
1a. The one year spot rate can be calculated using the one year zero bond.
PV * (1 + S1) = FV
1 + S1 = 1000 / 900
S1 = 1.1111 - 1
S1 = 0.1111
S1 = 11.11%
1b. PV of the 2 year bond = $950
Annual coupon = 1000 * 5% = $50
950 = 50 / (1 + S1) + (50 + 1000) / (1 + S2)^2
950 = 50 / 1.1111 + 1,050 / (1 + S2)^2
1,050/ (1 + S2)^2 = 950 - 45 = 905
(1 + S2)^2 = 1050 / 905
1 + S2 = 1.160221/2
S2 = 7.714%
1c. Price of the 2 year zero bond = 1,000 / (1 + 0.07714)^2
Price of the 2 year zero bond = 1,000 / 1.1602
Price of the 2 year zero bond = 861.9203586
Price of the 2 year zero bond = $861.92
Answer: steering
Explanation:
Steering is an illegal practice whereby people that are looking for homes are channeled towards particular areas based on their social status or race.
In such scenarios, the choice of the person looking for a home is being influenced by the person's gender, color, race, status, religion, disability, or national origin.
