Multiple Choice
What is the Excel formula to compute the internal rate of return for a $32,000 investment and cash inflows of $10,000 per year for years 1 through 4?
A) =IRR(33000,−10000,−10000,−10000,−10000)
B) =IRR(−33000,10000,10000,10000,10000)
C) =IRR(−10000,−10000,−10000,−10000,−33000)
D) =IRR(10000,10000,10000,10000,−33000)
Correct Answer:
Verified
Correct Answer:
Verified
Q9: Using three different possible interest rates to
Q10: An example of goal-seek analysis is determining
Q11: Calculate the annual car payment for a
Q12: The decision of which major expenditures and
Q13: Determining the best course of action under
Q15: Which of the following incorporates the time
Q16: An objective of financial accounting is to
Q17: Marginal analysis _ sunk costs (past spending
Q18: Whether the investment returns arrive in year
Q19: Prescriptive analytics will often build upon descriptive,