Details of this Paper

? Pick 7 financial ratios (see Chapter 14 of your...

Description

Solution


Question

? 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,? 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

 

Paper#12927 | Written in 18-Jul-2015

Price : $25
SiteLock