I would like to see how it is done in excell! Thank you (:

(40 points) Provided the below information regarding Barbie Wonderland Inc., using the DCF approach, what is the value of its equity? - It expects to make earnings before interest and taxes (EBIT) of $295,000,$271,000, and $234,000 for the next three years. - Depreciation is estimated to be $55,000,$68,000, and $65,000 for the next three years. - Capital expenditures are estimated to be $68,000,$91,000, and $80,000 for the next three years. - Increases in working capital are estimated to be $50,000,$35,000, and $10,000 for the next three years. - Free cash flows beyond year three are estimated to grow at an annual rate of 3.6%. - The firm's WACC is 9.2%. - The firm's statutory tax rate is 21%, effective corporate tax rate is 37.5%, and marginal tax rate is 27%. - The market value of its debt is $600,000