I need it in simple form- I not good with spread sheet. See example: Assets 2007 2008
Cash & equivalents 26956 14066 -12890
Accounts receivables 9659 7711 -1948
Inventories 14939 13042 -1897
Other current assets 8849 6505 -2344
Total current assets 60403 41324 -19079
Gross plant, property & equipment 97319 86919 -10400
Accumulated depreciation 47590 45042 -2548
Net plant, property & equipment 49729 41877 -7852
Investments 0 0 0
Intangibles 0 0 0
Other assets 38751 7846 -30905
Total assets 148883 91047
Recent Financial Data for GM vs. Toyota
For the Mini Case on KMP p. 116, use Market Watch website for General Motors and Toyota financial statements, ratios, etc. https://www.marketwatch.com/investing/stock/GM/financials
Notice that the fiscal year for Toyota ends on March 31, so the most recent annual data is dated March 31, 2015. GM's fiscal year ends December 31.
a. Compute the financial ratios for both firms for the most recent year, and evaluate the relative performance of the two firms in the following areas:
1. Liquidity
2. Operating profitability
3. Financing practices
4. Return on the shareholders' investment
a. What is each firm's price/earning ratio and market/book ratio? What do these ratios tell you?
b. Assume that the cost of capital (investors' required rate of return) is 8 percent for both companies.. Calculate the EVA for each company. Interpret your findings.
Need excel sheet with formulas type out for me.