The Following Investment Cash Flows Have Been Entered into Cells

question 119

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

---

Definitions:

Principles Of Operant Conditioning

Fundamental concepts in behavior theory that involve modifying behavior through reinforcement and punishment following specific actions.

Classical Conditioning

A learning process that occurs through associations between an environmental stimulus and a naturally occurring stimulus.

Language

A complex system of communication that uses symbols, sounds, and rules to convey information and express thoughts, emotions, and ideas.

Transformational Grammar

A linguistic theory that seeks to describe how the deep and surface structures of sentences are related by rules of transformation.