The Following Investment Cash Flows Have Been Entered into Cells

question 4

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) =rate(4,0,- 5200, 1200).
• C) =irr(B6:B9).
• D) =ytm(B5, B6:B9).

---

Definitions:

Dihydrotestosterone

A potent androgen hormone that is derived from testosterone and plays a key role in the development of male characteristics and reproductive tissues.

Androgen Insensitivity Syndrome

A situation where an individual with male genes exhibits a resistance to male hormones, known as androgens, resulting in the manifestation of feminine physical characteristics despite having a male genetic structure.

5-alpha Reductase Deficiency

A genetic condition that affects the metabolism of testosterone, potentially influencing sexual development.