Question 3 Today is 1 January 2016. Sumsang company will start to deposit part of its after-tax profit to launch a new phone project in 3 years' time. The project launch date is i January 2019 and the required capital amount is 5 million dollars. Sumsang is planning to make 3 annual deposits into an investment fund. The assumed invest- ment fund return rates of 2016-2018 are shown in table 1 (B6:B8). The first deposit will be made today (1 January 2016) and the last one will be made on 1 January 2018. Sumsang's current before-tax profit is 4 million dollars and it believes that its before-tax profit will increase by 4% every year. The company tax rate is 30%. The deposit amount is r% of Sumsang's after-tax profit. Table 1: Excel spreadsheet D E 30% 4% 2 A Tax rate Profit growth rate p.a. r% 3 4 5 Year 6 7 8 9 2016 2017 2018 2019 52.53% Sumsang project plan Investment Before-tax After-tax return rates profit profit 4.0% $4,000,000 $2,800,000 4.7% $4,160,000 $2.912,000 4.3% $4,326,400 $3,028,480 Total Accu- mulated value Deposit amount $1,470,799 $1,529,631 $1,590,816 $5,000,000 a. Describe the steps we need to take to create a line chart to plot the investment fund return rates from 2016-2018. b. Give the Excel cell formula you would use to calculate the value of cell C8. c. Give the Excel cell formula you would use to calculate the value of cell D8