Are there any excel templates that calculate financial ratios?
I need a program or add-in that will say, directly calculate the current ratio when i enter the current liabilities and current assets.
I need a program or add-in that will say, directly calculate the current ratio when i enter the current liabilities and current assets.
bluesman3df
Favorite Answer
I got one from microsoft.com office excel financial templates, please use this address.
Anonymous
This Site Might Help You.
RE:
Are there any excel templates that calculate financial ratios?
I need a program or add-in that will say, directly calculate the current ratio when i enter the current liabilities and current assets.
GoddessofCoughSyrup
You can do this yourself.
A B
Current Assets 200
Current Liabilities50
Current Ratio 4
Have your CA & CL in your spreadsheet. Then for Current Ratio type in the cell reference. =B1/B2
Whatever you type in the CA & CL cells will automatically update in the CR cell.
You can click and drag for multiple problems if this is homework.