Compute the financial ratios for both firms

Assignment Help Finance Basics
Reference no: EM131004870

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
Intangibles 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. 

Reference no: EM131004870

Questions Cloud

Use the watchdog in its default position : Use the watchdog in its default position (must be petted in less than 32 ms). Generate a 275 Hz, 50% duty cycle on P9.7. Use a timer with the SMCLK.
Construct a finite state machine m that accepts : Construct a finite state machine M that accepts these variables, constants, assignment operators and others, as well as all the reserved words for this primitive programming language that you are defined in Problem 1.
What recommendation would you make about purchasing : Based on the future value of the company that you calculated, and being mindful of the need to effectively balance portfolio risk with return, what recommendation would you make about purchasing the company as an investment at that price? Be sure to ..
Accounting for economic growth econ 311 : Accounting for Economic Growth, ECON 311 Assignment 3, Calculate the growth rates of real GDP per worker and capital per worker for each time period. What is the average growth rate and standard deviation for both?
Compute the financial ratios for both firms : 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:
Complete factorial analysis of variance in smart alex : Complete factorial analysis of variance in Smart Alex's Task #1 on p. 541, using the Fugazi.sav data set from the Field text. You can follow the steps outlined on pp. 520–525 as a guide.
Health care administration program : This is the Preparing for Dissertation final course in the PhD. in Health Care Administration Program.Strategies for Managing Resources
What you think and interpreting the results of your survey : You will be asking others what they think about a topic, and interpreting the results of your survey. Once you have completed the assignment, submit it on BlackBoard Learn in the appropriate place under the Assignments link (it will be submitted via ..
Find the tracking signal : After using your forecasting model for six months, you decide to test it using MAD and a tracking signal. Here are the forecast and actual demands for the six-month period: PERIOD FORECAST ACTUAL May 450 500 June 500 550 July 550 400 August 600 500 S..

Reviews

Write a Review

Finance Basics Questions & Answers

  The future of juvenile corrections

The Future of Juvenile Corrections

  Risk-free covered interest arbitrage

Critically discuss the transactions you would make to earn the risk-free covered interest arbitrage profits. How much profit would you expect to make?

  Demonstrate thoughtful consideration of the ideas

Support your paper with a minimum of three (3) resources, which may include your required text. In addition to these specified resources, other appropriate scholarly resources, including older articles, may be included.

  Explain decision making on fund management

Explain Decision making on fund management and what will be the outlook for such company

  Maximize the wealth of existing stockholders

Since managers are agents of stockholders, it is their professional obligation to make decisions to maximize the wealth of existing stockholders.

  Bethany opened a store credit card to purchase a tv for 589

bethany opened a store credit card to purchase a tv for 589. she put the entire purchase on the credit card. her apr is

  Estimate a second stage

Coca-Cola (KO) is the world's largest producer of soft-drink concentrates, syrups, and juices. Its soft-drink brands include Coke, Diet Coke, Cherry Coke, Sprite, Tab, Nestea, and Barq's.

  A discussion of the business strategy of the u.s.

Summarize the basic situation in the case including a discussion of the business strategy of the U.S. firm you identified.

  Has the after-tax cost gone up or down

Assume that the yield on the bonds goes up by 1 percentage point and that the tax rate is now 39%.

  The accounting manager of gateway inns has noted that every

the accounting manager of gateway inns has noted that every time the inns average occupancy rate increases by 5 percent

  Appel corporation is considering expanding it plans to

appel corporation is considering expanding. it plans to finance the expansion by issuing 4 million in preferred stock.

  Employee account diversification

Which of the following correctly describe Black, Inc.'s obligation to permit any of its employees to diversify his account?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd