Make an Excel and calculate out the cost of capital and compare two companies

Pick one company. Compute the cost of capital of the company using the methods discussed in the class. Then pick the company’s rival company, and compute its cost of capital. Finally, compare the two companies’ costs, and determine which company is better positioned.

The following document is the financial statement of TCEHY and BIDU. Please do the TCEHY as the main one and compare it with BIDU(competitor).There is also a powerpoint as the class method.

Sample Solution