|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
...
CC: Finance 510 Class Members
From: Lance E. Schultz
Date: 9/18/2003
Subject: Comparative Ratio Analysis Using Data from Robert Morris Associates website: http://help. ... net/help/Excel/Comparative%20Ratio%20Analysis. ... Second, a financial manager can use Excel formulas to compare actual data to RMA ratios and show variances. They can use Goal Seek to experiment with changes to the actual needed to bring data in line with RMA averages. Third, a financial manager can utilize the information available in the comparative analysis to establish the financial stability of customers, partners and suppliers critical to the supply-chain. ...
The resource selected is the Comparative Ratio Analysis website offered by Robert Morris & Associates (RMA) which is referenced at the conclusion of this memorandum. When you are finished you will be able to identify the SIC code for your specific industry and have the knowledge and skill to enter and interpret individual data for your area of responsibility and financial period selected. ... Imagine the look on your banker’s face the next time your commercial line of credit comes up for renegotiation and you have already performed a comprehensive ratio analysis. ... ”
The RMA comparative ratios are available in the reference section of most business libraries. ... You can use Excel formulas to compare actual data to RMA ratios and show variances. Use Goal Seek to experiment with changes to the actual needed to bring data in line with RMA averages.
Approximate Word count = 1106
Approximate Pages = 4.4
(250 words per page double spaced)
|
|
|
|
|
|