Please complete the excel file attached.Please cite all sources used. If a question asks which process/way is better, both ways should be calculated to determine the answer. Do not just answer which way is better without showing the work. Use formulas with variables in separate cells. That means no numbers should be hard coded. Each formula should link to other cells so the variables can be changed and the results will calculate automatically.Thank you for your help.

The balance sheet of Roop Industries is shown below. The 12/31/2010 value of operations is $651 million, and there are 10 million shares of common equity. What is the intrinsic price per share?

The financial statements of Lioi Steel Fabricators are shown below-- both the actual results for 2010 and the projections for 2011. Free cash flow is expected to grow at a 6% rate after 2011. The weighted average cost of capital is 11%.

Name: Chapter: Questions: 9 13 9,10 The balance sheet of Roop Industries is shown below. The 12/31/2010 value of operations is $651 million, and there are 10 million shares of common equity. What is the intrinsic price per share? Assets Cash Marketable Securities Accounts receivable Inventories Total current assets Net plant and equipment Total assets 10 Roop Industries Balance Sheet December 31, 2010 Liabilities and Equity $20 Accounts payable 47 Notes payable 100 Accruals 200 Total current liabilities $367 Long-term bonds 279 Preferred stock Common stock (par plus PIC) Retained earnings Common equity $646 Total liabilities and equity $19 65 51 $135 131 33 160 187 $347 $646 The financial statements of Lioi Steel Fabricators are shown below-- both the actual results for 2010 and the projections for 2011. Free cash flow is expected to grow at a 6% rate after 2011. The weighted average cost of capital is 11%. a If operating capital as of 12/31/2010 is $502.2 million, what is the free cash flow for 12/31/2011? b What is the horizon value as of 12/31/2011? c What is the value of operations as of 12/31/2010? 1 d What is the total value of the company as of 12/31/2010? e What is the intrinsic price per share for 12/31/2010? 2