StudyNotesExcelforInputToBrainscape Flashcards
Four methods of company valuation
Single Period Earnings, Multiple Period Earnings, PE Multiple, Relative Valuation
PE Multiple example
eg. $275 per share, with EPS of $10; = PE Multiple of 27.5; times SIMILAR company’s earnings = value of all shares
Multiple Period Earnings valuation in Excel
pv(.10, 500, 1000)
Single Period earning example in Excel
1000/.10
Retractable Bonds
Holder can sell these back to the company before maturity
Convertible bonds
Can be converted into common shares at pre-determined price
Extendible bonds
Can extend the maturity of the bond
Cash Flow - end of period consideration
Salvage value of assets should be considered
Find the implicit rate of lease in Excel
rate(30,-66000,1500000)
Other items to consider with positive NPV
Management needs, & financing needs
Which preferred shares are considered debt?
When they have redemption priveleges
NPV in excel is
NPV(.15, 200,200,200,200, 200)
Debt ot Equity is
Liabilities / Equity
Accounting treatment of convertible bonds
liability & equity components recorded separately
Current Ratio
current assets / current liabilities
Quick Ratio
Current assets less inventory / current liabilities
Inventory Turnover
COGS / avg inventory
Debt Ratio
Liabilities / Assets
Gross Profit Margin
(Sales - Gogs)/ Sales
Operating Margin
EBIT / Sales
Net profit Margin
Net profit / Sales
ROA (Return on Assets)
Net profit / Assets
ROI (Return on Investment)
Net profit / S. Equity
PE Ratio
Price per common share / Earnings per common share