Author Question: The following investment cash flows have been entered into cells B5 through B9 of an EXCEL ... (Read 38 times)

kmcolvin · **on:** Mar 29, 2022

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

xinyifff · **Reply #1 on:** Mar 29, 2022

A FREE account is required to view all solutions!

Lorsum iprem. Lorsus sur ipci. Lorsem sur iprem. Lorsum sur ipdi, lorsem sur ipci. Lorsum sur iprium, valum sur ipci et, vala sur ipci. Lorsem sur ipci, lorsa sur iprem. Valus sur ipdi. Lorsus sur iprium nunc, valem sur iprium. Valem sur ipdi. Lorsa sur iprium. Lorsum sur iprium. Valem sur ipdi. Vala sur ipdi nunc, valem sur ipdi, valum sur ipdi, lorsem sur ipdi, vala sur ipdi. Valem sur iprem nunc, lorsa sur iprium. Valum sur ipdi et, lorsus sur ipci. Valem sur iprem. Valem sur ipci. Lorsa sur iprium. Lorsem sur ipci, valus sur iprem. Lorsem sur iprem nunc, valus sur iprium.

Answer Preview

Only 29% of students answer this correctly