I'm pretty sure i know how to solve this but it can't hurt to be sure (answers in excel format please).

1/Rawhajpoutalah Intl., an Indian tobacco company, has two divisions, A and B, for which the figures are as follows: Division A Division B Capital employed 1000 1000 Expected return 15% 15% Net operating income 50 300 (a) What are the values for divisions A and B if you assume, for calculation purposes, that operating income is constant to perpetuity? (b) The company pays out 50 and so finances its investments for 300. The company invests everything in division B at the same return on capital employed (30%) . How much value is created? (c) Same question if the 300 is invested in division A at the average rate of return of A (5%). (d) Same question if the 300 is divided equally between A and B. (e) What are your conclusions