Close window

Formulas included in the Finance Spreadsheet

Equivalent Pre-Tax Yield On Taxable Investment
Inflation Premium
Nominal Interest Rate
Risk Free Rate Of Interest
Average Sales Per Day
Cash Flow Coverage Financial Ratio
Current Financial Ratio
Days Sales Outstanding
Debt Financial Ratio
Earnings Per Share
Fixed Assets Turnover Financial Ratio
Inventory Turnover Financial Ratio
Market / Book Financial Ratio
Price / Earnings Financial Ratio
Profit Margin On Sales
Quick Financial Ratio Or Acid Test Financial Ratio
Return On Common Equity
Return On Total Assets
Times-Interest-Earned Financial Ratio
Total Assets Turnover Financial Ratio
Break Even Quantity
Break Even Sales
Cash Operating Break Even Quantity
Contribution Margin
Degree Of Financial Leverage
Degree Of Financial Leverage - If NO Preferred Stock Exists
Degree Of Financial Leverage - If Preferred Stock Exists
Degree Of Operating Leverage
Degree Of Operating Leverage - At A Particular Operating Level
Degree Of Operating Leverage - At A Particular Sales Level
Degree Of Total Leverage
Degree Of Total Leverage - If NO Preferred Stock Exists
Degree Of Total Leverage - If Preferred Stock Exists
Earnings Before Interest And Taxes
Earnings Before Interest And Taxes - Financial Break Even Point
Full Capacity Sales
Gross Profit Margin
Total Cost
Beta Coefficient Of A Portfolio
Coefficient Of Variation
Expected Rate Of Return
Expected Rate Of Return On A Portfolio
Market Risk Premium
Security Market Line
Standard Deviation
Variance
Effective Annual Rate
Future Value
Future Value Of An Annuity
Future Value Of An Annuity Due
Future Value Of An Uneven Cash Flow Stream
Future Value With Frequent Compounding
Periodic Interest Rate
Present Value
Present Value Of A Perpetuity
Present Value Of An Uneven Cash Flow Stream
Simple, Quoted Interest Rate Per Period
Time Value Of Money Calculator
Intrinsic (Theoretical) Value Of A Stock - (The Present Value Of Future Dividends)
Preferred Stock Valuation
Value Of A Stock Based On Constant Growth
Approximate Yield To Maturity
Asset Value

Bond Present Worth
Bond Valuation (Annual Compounding)
Bond Valuation (Semi-Annual Compounding)
Conversion Price
Price Of Callable Bond
Value Of Long-Term And Short-Term Annual Coupon Bonds At Different Market Interest Rates
Yield To Maturity
Optimal Amount Of Cash Raised By Selling Marketable Securities Or By Borrowing
Baumol Model
Annual Savings
Average Sales Per Day
Cost Of Carrying Receivables
Credit Score
Days Sales Outstanding
Total Cost Of Cash Balances
Average Inventory
Economic Order Quantity
Inventory Management
Reorder Point
Total Carrying Cost
Total Inventory Cost
Total Ordering Cost
Annual Percentage Rate
Approximate Cost Of Foregoing A Cash Discount
Compensating Balance Requirement
Effective Annual Rate
Periodic Rate
Periodic Rate (Discount)
Required Loan Amount
Usable Funds
Capital Budgeting Evaluation
Coefficient Of Variation
Comparison Of Multiple Projects
Expected Net Present Value
Incremental Operating Cash Flow
Net Cash Flow
Net Present Value
Payback
Required Rate Of Return For A Project
Standard Deviation Of The Net Present Value
After Tax Component Cost Of Debt
Bond Yield + Risk Premium Approach To Stock Valuation
Break Point
Capital Asset Pricing Model
Component Cost Of Preferred Stock
Constant Growth Rate Approach To Stock Valuation
Cost Of New Common Equity
Discounted Cash Flow Approach To Stock Valuation
Marginal Cost Of Capital Schedule
Required Rate Of Return
Required Rate Of Return
Weighted Average Cost Of Capital
Weighted Average Cost Of Capital
Degree Of Financial Leverage
Degree Of Financial Leverage - If NO Preferred Stock Exists
Degree Of Financial Leverage - If Preferred Stock Exists
Degree Of Operating Leverage
Degree Of Operating Leverage - At A Particular Operating Level
Degree Of Operating Leverage - At A Particular Sales Level
Degree Of Total Leverage
Degree Of Total Leverage - If NO Preferred Stock Exists
Degree Of Total Leverage - If Preferred Stock Exists
Earnings Per Share (Eps)
New Earnings Per Share Based On Increased Sales (EPS1)
Currency Conversion Cross Rate

Here is a sample image of what a portion of the Finance Spreadsheet looks like:

Click to close this window