Downloads & Links
I ran into a problem with a spreadsheet I wrote and made available for people to download. It was listed in a number of posts on the site and therefore required updating at every link when a new version came out. I am overcoming that by setting up a standard page for any downloads I make available.
Financial Ratios & Time Value Formulae
V0.08 8th October 2022
This Excel spreadsheet will calculate and do the following:-
- Present Values
- Future Values
- Net Present Values
- Current Ratio
- Quick Ratio
- Internal Rate of Return
- Profitability Index
- Payback Period – Simple
- Payback Period – Discounted
- Accept or Reject Determination based on Calculations
- Break Even Analysis – Accounting
- Break Even Analysis – Cash Flow
- Profitability – Accounting
- Profitability – Cash Flow
- Accounts Receivable Days
- Accounts Payable Days
- Operating Cycle Days
- Cash Conversion Days
- Debt Ratio
- Debt to Equity Ratio
- Interest Cover
- Return on Equity
- Macros written to clear all data and start a new calculation
- Instructions for use in the spreadsheet.
You can download now on Gumroad at Financial Ratios & Time Values.
If the spreadsheet is useful to you, your support is appreciated and there’s a link to 
. No obligation of course, I love the feedback. I always look forward to comments, feedback and suggestions for improvements.