Question (a) only

On January 1, an investment account is worth $100,000. On April 1 the value declined to $90,000, and $42,000 is withdrawn. On November 1, the value declined again, this time to $80,000 and a new principal of $30,000 is deposited. On January 1 of the following year the investment account is worth $95,000. (a) Draw a table as the one given below for the transactions: Date Fund value before Cash flow Fund value after : : : : Note: do not paste any Excel screenshots. [5] (b) Compute the time-weighted rate of return (TWRR) and dollar-weighted rate of return (DWRR). Assume that each month is 1 of a year. [7]