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:

Cortisol

A steroid hormone released by the adrenal glands in response to stress or low blood-glucose concentration; it plays a key role in the body's stress response.

Proactive Coping

A form of coping where individuals anticipate potential stressors and take action in advance to prevent or mitigate their impact.

Defensive Coping

Strategies used to protect oneself from psychological harm.

American Children

Young individuals who are citizens or residents of the United States, encompassing a diverse background of cultural, social, and economic backgrounds.