This topic contains a solution. Click here to go to the answer

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

kmcolvin

  • Full Member
  • ***
  • Posts: 140
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).


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by kmcolvin on Mar 29, 2022

xinyifff

  • Full Member
  • ***
  • Posts: 159
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




kmcolvin

  • Member
  • Posts: 140
Reply 2 on: Mar 29, 2022
Thanks for the timely response, appreciate it


hollysheppard095

  • Member
  • Posts: 339
Reply 3 on: Yesterday
Excellent

 

Did you know?

The top five reasons that children stay home from school are as follows: colds, stomach flu (gastroenteritis), ear infection (otitis media), pink eye (conjunctivitis), and sore throat.

Did you know?

All patients with hyperparathyroidism will develop osteoporosis. The parathyroid glands maintain blood calcium within the normal range. All patients with this disease will continue to lose calcium from their bones every day, and there is no way to prevent the development of osteoporosis as a result.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

There are major differences in the metabolism of morphine and the illegal drug heroin. Morphine mostly produces its CNS effects through m-receptors, and at k- and d-receptors. Heroin has a slight affinity for opiate receptors. Most of its actions are due to metabolism to active metabolites (6-acetylmorphine, morphine, and morphine-6-glucuronide).

Did you know?

Though the United States has largely rejected the metric system, it is used for currency, as in 100 pennies = 1 dollar. Previously, the British currency system was used, with measurements such as 12 pence to the shilling, and 20 shillings to the pound.

For a complete list of videos, visit our video library