The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 402 Weeks Ago, 4 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Pick 7 financial ratios (see Chapter 14 of your textbook) on which to compare the two companies. Create a simple chart that shows your results. To support your results you must highlight within Excel the numbers that you used to calculate each ratio. A sample project has been provided on Blackboard so that you can understand how to reference the cells. You have to actually compute the ratios – you are not to rely on ratios that you might find published on other sources such as Yahoo Finance. Your boss must be able to recalculate the numbers that you have arrived at using the numbers that you have highlighted in the tabs of your spreadsheet. On your chart you must indicate for each ratio which Company’s ratio is better. For example, if you decide to use Inventory Turnover as one of your ratios to analyze you would include something that looks like the following: Company A Company B Company with better ratio Ratio is acceptable Inventory Turnover 6.2 8.3 Company B Yes You also need to indicate, to the best of your ability, if the Ratio is acceptable. For example, see the following: ` Company A Company B Company with better ratio Ratio is acceptable Debt Ratio 1.2 1.8 Company A No
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll