. All the calculations must be made in Excel (NOT on calculator or manually) using formulas and references, so that if the original data is changed your Excel template will make all the necessary adjustments automatically. When solving problems in a spreadsheet, make sure to format the output very carefully to ensure that it is legible and presentable. In case you want to explain, please explain on the Excel worksheet. Do not use a separate Word Document (Remember that the work you turn in reflects you. Even if your work is correct, if it looks unprofessional it is unlikely to get the full attention of its intended audience).

ABC Technologies has been growing quite rapidly in recent years, with earnings and dividends increasing at a rate of 30% per annum. This has been achieved by a relatively high level of retention in conjunction with high rates of return on investment. Retentions have been kept at a level of 60%. The company plans to continue with retentions at this level for another year, and then allow retentions to fall to 40% and 25% in the subsequent two years as good investment opportunities become more difficult to find. Earnings for the next year are expected to be $8,000,000. The expected rate of return on the investment to be undertaken next year is 30% and this is expected to fall to 25% the following year, and to 20% - which is the shareholders required rate of return the year after that. a. Provide an estimate of the firms value today. b. Determine the rate of return the firm must have been earning to grow at 30% given the level of its retentions.