The Following Investment Cash Flows Have Been Entered into Cells

question 95

Multiple Choice

The following investment cash flows have been entered into cells B5 through B9 of an EXCEL spreadsheet. B5 $(5,200 ) , B6 $2,100, B7 $1,300, B8 $1,800, B9 $1,200, where $(5,200) is the cost of the investment and the following amounts are cash flows at the end of years one through four. The correct function for computing the yield on this investment is

• A) =irr(B6:B9)+B5.
• B) =irr(B5:B9).
• C) =rate(4,0,-5200, 1200).
• D) =ytm(B5, B6:B9).

---

Definitions:

Problem Orientation

A mindset focused on identifying, analyzing, and finding solutions for difficulties and challenges.

Solution Implementation

The process of executing a plan or strategy to solve a problem or address an issue effectively.

Decision Making

The cognitive process of selecting a course of action among several alternatives.

Alternatives Generation

The process of creating or identifying different options or strategies to achieve a particular goal or solve a problem.