Explain fully, with examples, what dollar cost averaging is. What will happen (1) if the price of an investment trends down overtime; (2) trends up; (3) trends down then up; and (4) in real life? Use excel to model and graph the result. Hint: There are 3 cases. First, a lump sum investment divided into equal amounts of investments spread over time. Second, what happens when you invest a fixed amount of capital in a diversified investment at a regular frequency (e.g., monthly) over a long period of time. Third, what happens when you withdraw a fixed amount of capital from a diversified investment at regular frequency over a long period of time