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).
Answer: B
You might also like to view...
The economic resources of a company that are expected to benefit the company's future operations are called:
a. Liabilities. b. Assets. c. Stockholders' equity. d. Contributed capital.
In six years' time, you are scheduled to receive money from a trust established by your grandparents. When the trust matures there will be $100,000 in the account. If the account earns 5.75% compounded continuously, how much is in the account today?
A. $82,153.56 B. $69,405.59 C. $61,615.17 D. $70,822.04 E. $59,490.51
If a company has $50,000 of assets, which of the following could be true?
A. It has ?$50,000 in stockholders' equity and $100,000 in liabilities. B. The company has fewer assets than it does liabilities. C. It has $30,000 in liabilities and $80,000 in owners' equity. D. The company has more owners' equity than assets. E. It has $23,000 in owners' equity and $27,000 in liabilities.
In companies that adopt the ________ model of organizational structure, functions are centralized where it makes sense to do so, but a great deal of decision making also takes place at the local level.
A. international B. multinational C. global D. intranational E. transnational