Competitive and Ratio Analysis Flashcards
What is the formula to calculate return on investment (ROI)?
Net Income/Total Assets
Given the following variables, how do you calculate ROI (Return on investment)? Sales - $311,000 Variable cost - $250,000 Traceable fixed costs - $50,000 Avg. Invested Capital - $40,000 Interest rate = 10%
Return on investment = Division Income/Avg. Invested Capital
Income = Sales - Variable costs = Contribution Margin - Fixed costs
Average Invested Capital = $40,000
($311,000 - $250,000 - $50,000)/$40,000 = .275
When you are given a target capital % of debt, preferred equity, and common equity as well rates for each one of these, how do you calculate weighted average cost of capital? You also need to take into account tax rate.
Sum the totals for each group.
Debt = % of debt x % interest rate x (1 - tax rate)
Common stock = % common stock x % cost of common stock
Preferred stock = % preferred stock x % yield preferred stock
Tax rate only applies to debt
What is the formula to calculate residual income? Given the variables provided below.
Operating income = $400
Total assets = $1,600
Required rate of return = 10%
Residual income = Operating income - Required return on invested capital (required rate of return x invested capital)
or
$400 - (.10 x $1,600) = $240
You are trying to determine cost of capital. You are given the rates for debt and equity. .8% rate for debt and 10% rate for equity. You are not given weighted for each capital structure, however, you are given debt ratio of 40%. How do you determine weighting for both stocks and debt as well as determine cost of capital?
Debt ratio = 40%; means 40% is debt while 60% is equity.
Stock: .60 x .10
Debt: .40 x .08
What is the formula to calculate DuPont ROI?
DuPont ROI = Return on Sales/Asset Turnover
How do you calculate Return on Sales? Formula.
Return on Sales = Net Income/Sales
How do you calculate Asset Turnover? Formula.
Asset turnover = Sales/Total Assets
How do you solve for residual income given the following variables listed below? Sales = $750,000 Asset Turnover = 1.5 Return on Sales = 8% Interest rate = 12%
Residual Income Formula
RI = Operating Income - (required rate of return x invested capital)
Step 1: Solve for total assets (invested capita) using asset turnover formula
Asset Turnover = Sales/Total Assets
Step 2: Solve for operating income using Return on Sales formula
Return on Sales = Net Income/Sales
Variables are given for these formulas. Just need to solve for total assets and operating income to use in formula
Step 3: Solve for RI using operating income - (assets x interest rate)
What is the formula to calculate economic value added (EVA)?
EVA = Net Profit After Tax - (WACC % x Invested Capital)
_______ is equal to net operating profit after taxes plus noncash expenses less capital expenditures and the change in working capital requirements.
Free cash flow
_______ is equal to the market value of the firm minus the original investment.
Market value-added
______ is equal to net operating profit after taxes minus the cost of capital. It represents the residual income that remains after the cost of all capital, including equity capital, has been deducted.
Economic value-added (EVA)
Divisional revenues, $1,000,000; divisional expenses, $500,000; divisional assets, $2,000,000; and the required rate of return is 15%. How would you calculate residual income?
Residual Income = Operating Income - (Assets x required rate of return)
Income = Revenues - expenses
RI = (Revenues - expenses) - (Assets x required rate of return)
A divisional manager receives a bonus based on 20% of the residual income from the division. How do you calculate bonus when you have calculated or are given residual income?
RI x Bonus % = Amount of bonus
What is the primary disadvantage of using return on investment (ROI) rather than residual income (RI) to evaluate the performance of investment center managers?
ROI may lead to rejecting projects that yield positive cash flows. The company may not want to undertake a project with a lower ROI than its current average even though the project has positive RI.
What is the formula to calculate free cash flows? Give the following variables
- Net Operating Income After Tax
- Depreciation expense
- Change in net working capital
- Capital expenditures
- Invested capital
- WACC %
Free cash flow = Net operating income (After tax) + Depreciation expense - Change in net working capital - capital expenditures
WACC and Invested capital excluded
What are the two ratios that can be used to calculate ROI?
Return on sales and asset turnover
You are trying to calculate sales off of asset turnover ratio (sales/total assets). You are given asset turnover of 2.5. Also, you are beg. book value of asset on January 1st of 22 million and ending book value of asset on December 31st of 18 million. How do you solve for sales and how do you determine what to use for assets?
Asset Turnover = Sales/Total Assets or AVERAGE ASSETS
Asset turnover given of 2.5
Calculate Asset denominator by finding the average asset value. 18 million + 22 million/2.
EVA = Net Profit After Tax - (WACC x Invested Capital). You are already given invested capital of 1.2 million in problem and you’re solving for EVA. How do you calculate Net Profit After tax and WACC with the variables given below?
- Pretax profit = 300 million
- Tax rate =40%
- Capital used to generate profits 50% debt, 50% equity
- Cost of debt = 5%
- Cost of equity = 15%
- Net profit after tax = Pretax profit - (Tax rate x pretax profit)
300 million - (.40 x 300 million)
- WACC = (.50 x .05) Debt + (.50 x .15) Equity
ROI highly related to stock price and ____ value.
shareholder value
- ROI could cause managers to postpone critical expenditures.
- ROI could cause managers to not accept projects that would be advantageous to the firm.
- ROI could be affected arbitrarily by allocation of indirect costs.
These are all limitations or advantages of ROI?
Limitations
What is the formula to calculate selling price given gross margin % and cost per unit?
CPU = $89
Gross margin = 40%
SP = CPU/(1 - gross margin)
$89/(1-.40) = $148.33
- Focusing on creating shareholder value
- Not promoting acceptance of unprofitable projects
- Encouraging cutting costs
These are all advantages of what?
EVA (Economic Value added)
What is a major disadvantage of EVA?
It fails to reflect all of the ways that value may be created.
_____ analysis involves comparisons of results and ratios for the same firm over time.
Horizontal analysis
______ analysis involves comparisons of relationships in a firm’s financial statements for a single year.
Vertical analysis
_____ analysis involves comparing results and ratios to those of other firms in the same industry. Implies benchmarking.
Cross-sectional analysis
Inventory Turnover, Average accounts receivable collection period, and fixed asset turnover are all examples of asset ______ ratios.
Asset utilization ratio
Debt to total assets is an example of debt ____ or financial ____ ratios
Debt utilization or financial leverage
Aba Caterers quotes a price of $30 per person for a dinner party. This price includes the 6% sales tax and the 15% service charge. Sales tax is computed on the food plus the service charge. The service charge is computed on the food only. How do you go about solving this equation?
F +.15F + .06 (F + .15F) = $30.00 Solve algebraically 1.219F = $30
How do you calculate Contribution Margin and Gross Margin?
CM = Sales - Variable costs GM = Sales - COGS
Which one of the following factors should NOT be considered a limitation in using quick ratio to evaluate credit worthiness?
A. Accounts Receivable
B. Marketable Securities
C. Inventories
C. Inventories
Inventories are excluded in quick ratio. AR and marketable securities are included*
How do you calculate ROI with these four variables?
- Sales
- Operating expenses
- Operating assets beg. of year
- Operating assets end of year
ROI = Net Income/Average assets
NI = Sales - Operating expenses
Average assets = (perating assets beg. of year - operating assets end of year/2)
Formula for Inventory Turnover is COGS/Average Inventory. You are trying to determine COGS and Average inventory given the following data. How do you calculate both of these? Inventory Turnover for current year! Current year Sales Gross Profit % Current Yr Prior year Sales Gross profit % Prior Yr BG FG Inv % Prior Yr END FG Inv % Current Yr
COGS = Current year sales x (1 - Gross Profit % current Yr)
Avg. Inv. = (Beg FG Inv % prior yr x prior year sales) + End FG Inv % Current yr x current year sales)/2