Saturday, 30 April 2011
mgt201 formulas 1~22
pter_1-22
MGT201
Formulas Chapter 1-22
PVIF = 1 - (1+i)^-n = (1-(1+i)^-n)/i (to use
in Excel worksheet)
i
FVIF = (1+i)^n - 1 = (1+i)^(n) -1 )/i
i
FV = PV*(1+i)^n
PV = FV/(1+i)^n
i = (Future Payment/Present Value)^
1/n
- 1
1. Fundamental Accounting Equation and Double Entry Principle.
• Assets +Expense = Liabilities + Shareholders’ Equity + Revenue
Liabilities = Equity = Net Worth
Revenue – Expense = Income
1. Statement of Retained Earnings or Shareholders’ Equity
Statement
Total Equity = Common Par Stock Issued + Paid In Capital + Retained
Earnings
1. Current Ratio:
= Current Assets / Current Liabilities
1. Quick/Acid Test ratio:= (Current Assets – Inventory) / Current Liabilities
1. Average Collection Period:
= Average Accounts Receivable /(Annual Sales/360)
1. PROFITABILITY RATIOS:
Profit Margin (on sales):
= [Net Income / Sales] X 100
Return on Assets:
= [Net Income / Total Assets] X 100
Return on equity:
= [Net Income/Common Equity]
6. ASSET MANAGEMENT RATIOS
Inventory Turnover:
= Sales / inventories
Total Assets Turnover:
= Sales / Total Assets
1. DEBT (OR CAPITAL STRUCTURE) RATIOS:
2. http://groups.google.com/group/vuZs
Debt-Assets:
= Total Debt / Total Assets
Debt-Equity:
= Total Debt / Total Equity
Times-Interest-Earned:
= EBIT / Interest Charges
1. Market Value Ratios:
Price Earning Ratio:
= Market Price per share / *Earnings per share
Market /Book Ratio:
= Market Price per share / Book Value per share
*Earning Per Share (EPS):
= Net Income / Average Number of Common Shares Outstanding1. M.V.A (Market Value Added):
MVA (Rupees) = Market Value of Equity – Book Value of Equity Capital
1. E.V.A (Economic Value Added):
EVA (Rupees) = EBIT (or Operating Profit) – Cost of Total Capital
1. Interest Theory:
• Economic Theory:
i = iRF + g + DR + MR + LP + SR
– i is the nominal interest rate generally quoted in papers. The “real”
interest rate = i – g
Here i = market interest rate
g = rate of inflation
DR = Default risk premium
MR = Maturity risk premium
LP = Liquidity preference
SR = Sovereign Risk
The explanation of these determinants of interest rates is given as under:
1. Market Segmentation:
• Simple Interest (or Straight Line):
F V = PV + (PV x i x n)
• Discrete Compound Interest:
Annual (yearly) compounding:
F V = PV x (1 + i) n
Monthly compounding:F V = PV x (1 + (i / m) m x n
• Continuous (or Exponential) Compound Interest:
• F V (Continuous compounding) = PV x e i x n
1. Estimated current assets for the next year
= [Current assets for the current year/Current sales] x Estimated sales for
the next year
1. Expected Estimated retained earnings
= estimated sales x profit margin x plowback ratio
1. Estimated discretionary financing
= estimated total assets – estimated total liabilities –estimated total equity
1. G (Desired Growth Rate)
= return on equity x (1- pay out ratio)CASH FLOW STATEMENT
Net Income
Add Depreciation Expense
http://groups.google.com/group/vuZs
Subtract Increase in Current Assets:
Increase in Cash
Increase in Inventory
Add Increase in Current Liabilities:
Increase in A/c Payable
Cash Flow from Operations
Cash Flow from Investments
Cash Flow from Financing
Net Cash Flow from All Activities
1. Interest Rates for Discounting Calculations
• Nominal (or APR) Interest Rate = i nom
• Periodic Interest Rate = i per
It is defined as
iper = ( i nominal Interest rate) / m
Where
m = no. of times compounding takes place in 1 year i.e.
If semi-annual compounding then m = 2
• Effective Interest Rate = i eff
i eff = [1 + ( i nom / m )]m – 11. Calculating the NPV of the Café Business for 1st Year:
NPV = Net Present Value (taking Investment outflows into account)
NPV = −Initial Investment + Sum of Net Cash Flows from Each Future
Year.
NPV = − Io +PV (CF1) + PV (CF2) + PV (CF3) + PV (CF4) + ...+ ∞
1. Annual Compounding (at end of every year):
FV = CCF (1 + i) n – 1
Annual Compounding (at end of every year)
PV =FV / (1 + i ) n . n = life of Annuity in number of years
1. Multiple Compounding:
Future Value of annuity =CCF (constant cash flow)*(1+ (i/m) m*n-1/i/n
Multiple Compounding:
PV =FV / [1 + (i/m)] mxn
1. Future value of perpetuity:
=constant cash flow/interest rate
1. Future value by using annuity formula
FV =CCF [(1+i) n - 1]/ i
1. Return on Investments:
ROI= (ΣCF/n)/ IO1. Net Present Value (NPV):
NPV= -IO+ΣCFt/ (1+i) t
Detail
NPV = -Io + CFt / (1+i)t = -Io + CF1/(1+i) + CF2/(1+i) ^2 + CF` /
(1+i)^3 +..
-IO= Initial cash outflow
i=discount /interest rate
t=year in which the cash flow takes place
1. Probability Index:
PI = [Σ CFt / (1+ i) t ]/ IO
1. Internal Rate Of Return(IRR) Equation:
NPV= -IO +CF1/ (1+IRR) + CF2/ (1+IRR) ^2......
1. Internal Rate of Return or IRR:
The formula is similar to NPV
NPV = 0 = -Io + CFt / (1+IRR)t = -Io + CF1/(1+IRR) + CF2/(1+IRR) ^2 + ..
1. Modified IRR (MIRR):
(1+MIRR) n = Future Value of All Cash Inflows….
Present Value of All Cash Outflows
(1+MIRR) n = CF in * (1+k) n-t
CF out / (1+k) t1. Equivalent Annual Annuity Approach:
EAA FACTOR = (1+ i)^ n / [(1+i)^ n -1]
Where n = life of project & i=discount rate
BONDS’ VALUATION
The relationship between present value and net present value
1. NPV = -Io + PV
1. Present Value formula for the bond:
n
PV= Σ CFt / (1+rD)t =CF1/(1+rD)+CFn/(1+rD)2 +..+CFn/
(1+rD) n +PAR/ (1+rD) ^n
t =1
In this formula
PV = Intrinsic Value of Bond or Fair Price (in rupees) paid to invest in the
bond. It is the Expected or Theoretical Price and NOT the actual Market
Price.
rD = it is very important term which you should understand it care fully. It
is Bondholder’s (or
Investor’s) Required Rate of Return for investing in Bond (Debt).As
conservative you can choose
minimum interest rate. It is derived from Macroeconomic or Market Interest
Rate. Different from the Coupon Rate!
Recall Macroeconomic or Market Interest Theory: i = iRF + g + DR +
MR + LP + SR
CF = cash flow = Coupon Receipt Value (in Rupees) = Coupon Interest Rate
x Par Value. Represents cash receipts (or in-flow) for Bondholder (Investor).
Often times an ANNUITY pattern Coupon Rate derived from
Macroeconomic or Market Interest Rate. The Future Cash Flows from a
bond are simply the regular Coupon Receipt cash in-flows over the life of the
Bond. But, at Maturity Date there are 2 Cash In-flows: (1) the Coupon
Receipt and (2) the Recovered Par or Face Value (or Principal)n = Maturity or Life of Bond (in years)
In the next lectures, you would study that how the required rate of return is
related to market rate of return
1. Calculate the PV of Coupons from the FV Formula for
Annuities (with multiple compounding within 1 year):
FV = CCF (1 + rD/m )nxm - 1/rD/m
http://groups.google.com/group/vuZs
Use Monthly Basis for this example. n = 1 year m = 12 months
CCF = Constant Cash Flow = Rs 1,000 = Monthly Coupon
rD = Annual Nominal Required Rate of Return for investment in Bond
(Debt) = 10% pa.
Periodic Monthly Required Rate of Return is rD/m = 10/12 = 0.833 % =
0.00833 p.m.
m = 12 months
1. YTM =Total or Overall Yield:
= Interest Yield + Capital Gains Yield
1. Interest Yield or Current Yield:
= Coupon / Market Price
1. Capital Gains Yield:
= YTM - Interest Yield
1. FV=CCF[(1+rD/m)n*m-1]/rD/m
N=1 year ,m= no. of intervals in a year =12
CCF=constant cash flow
n = Maturity or Life of Bond (in years)1. Call:
=par value +I, year copoun receipts
Another thing to keep in mind is that YTM has two components first is
1. YTM:
=interest yield on bond +capital gain yield on bond
1. INTEREST YIELD =annual copoun interest /market price
2. CAPITAL YIELD =YTM –INTEREST YIELD
1. Perpetual Investment in Preferred Stock
– PV = DIV 1 / r PE
1. Perpetual Investment in Common Stock:
PV = DIV1/(1+rCE) +DIV2/(1+rCE)2 +…..+ DIVn/(1+rCE)n + Pn/
(1+rCE)n
PV = Po* = Expected or Fair Price = Present Value of Share, DIV1=
Forecasted Future Dividend at end of Year 1, DIV 2 = Expected Future
Dividend at end of Year 2, …, Pn = Expected Future Selling Price, rCE =
Minimum Required Rate of Return for Investment in the Common Stock for
you (the investor). Note that Dividends are uncertain and n = infinity
1. PV (Share Price) = Dividend Value + Capital Gain.
Dividend Value is derived from Dividend Cash Stream and Capital Gain /
Loss from Difference
between Buying & Selling Price.1. Simplified Formula (Pn term removed from the equation for large
investment durations i.e. n =
infinity):
PV = DIV1/ (1+rE) + DIV2/ (1+rE) 2 + … DIVn/(1+rE)n
= DIVt / (1+ rE) t. t = year. Sum from t =1 to n
1. Fair Value. Dynamic Equilibrium.
If Market Price > Fair Value then Stock is Over Valued
Share Price Valuation -Perpetual Investment in Common Stock:
1. Zero Growth Dividends Model:
DIV1 = DIV 2 = DIV3
1. The Formula for common stock
PV = Po*= DIV1 / (1+ rCE) + DIV1 / (1+ rCE) 2 + DIV1 / (1+ rCE) 3 + ...
...+
= DIV 1 / rCE
1. Dividends Cash Flow Stream grows according to the Discrete
Compound Growth Formula
DIVt+1 = DIVt x (1 + g) t.
t = time in years.
1. Zero Growth Model Pricing
PV = Po* = DIV1 / rCE1. Constant Growth Model Pricing
PV = Po* = DIV1 / (rCE -g)
http://groups.google.com/group/vuZs
1. Dividends Pricing Models:
Zero Growth: Po*=DIV1 / rCE (Po* is being estimated)
1. rCE*= DIV1 / Po (rCE* is being estimated)
Similarly,
1. Constant Growth: Po*= DI V1/ (rCE -g)
rCE*= ( DIV 1 / Po) + g
use this formula to calculate the required rate of return.
1. Gordon’s Formula:
rCE*= (DIV 1 / Po) + g
In this the first part
(DIV 1 / Po) is the dividend yield
g is the Capital gain yield.
1. Earning per Share (EPS) Approach:
PV = Po* = EPS 1 / rCE + PVGO
Po = Estimated Present Fair Price,
EPS 1 = Forecasted Earnings per Share in the next year (i.e. Year 1),
rCE = Required Rate of Return on Investment in Common Stock Equity.
PVGO = Present Value of Growth Opportunities. It means the Present
Value of PotentialGrowth in Business from Reinvestments in New Positive NPV Projects and
Investments PVGO is perpetuity formula.
The formula is
PVGO = NPV 1 / (rCE - g) = [-Io + (C/rCE)] / (rCE -g)
In this PVGO Model: Constant Growth “g”. It is the growth in NPV of new
Reinvestment Projects (or Investment).g= plowback x ROE
Perpetual Net Cash Flows (C) from each Project (or reinvestment).
Io = Value of Reinvestment (Not paid to share holders)
= Pb x EPS
Where Pb= Plough back = 1 – Payout ratio
Payout ration = (DIV/EPS) and
1. EPS Earnings per Share= (NI - DIV) / # Shares of Common Stock
Outstanding
Where NI = Net Income from P/L Statement and DIV = Dividend, RE1=
REo+ NI1+ DIV1
ROE = Net income /# Shares of Common Stock Outstanding.
1. NPV 1 = [-Io + (C/rCE)] / (rCE -g)
If we compare it with the traditional NPV formula
-Io = Value of initial investment
(C/rCE) = present value formula for perpetuities where you assume that you
are generating the net cash
inflow of C every year.
C = Forecasted Net Cash Inflow from Reinvestment = Io x ROE
Where ROE = Return on Equity = NI / Book Equity of Common Stock
Outstanding
1. Range of Possible Outcomes, Expected Return:
Overall Return on Stock = Dividend Yield + Capital Gains Yield (Gordon’s
Formula)1. Expected ROR = < r > = pi ri
Where pi represents the Probability of Outcome “i” taking place and ri
represents the Rate of Return (ROR) if Outcome “i” takes place. The
Probability gives weight age to the return. The Expected or Most Likely
ROR is the SUM of the weighted returns for ALL possible Outcomes.
1. Stand Alone Risk of Single Stock Investment:
Risk = Std Dev = ( r i - < r i > )2 p i . = Summed over each possible outcome
“ i ” with return “r i ” and probability of occurrence “p i .” < r I > is the
Expected (or weighted average) Return
1. Possible Outcomes Example Continued:
Measuring Stand Alone Risk for Single Stock Investment
Std Dev = δ = √ Σ (r i - < r i >) 2 p i.
1. Coefficient of Variation (CV):
= Standard Deviation / Expected Return.
CV = σ/ < r >.
< r > = Exp or Weighted Avg ROR = pi ri
1. Risk Basics
Risk = Std Dev = σ = √ ( r i - < r i > )2 p i . = “Sigma”1. Types of Risks for a Stock:
Types of Stock-related Risks which cause Uncertainty in future possible
Returns & Cash Flows:
Total Stock Risk = Diversifiable Risk + Market Risk
http://groups.google.com/group/vuZs
1. Portfolio Rate of Return
Portfolio Expected ROR Formula:
rP * = r1 x1 + r2 x2 + r3 x3 + … + rn xn .
1. Stock (Investment) Portfolio Risk Formula:
p = √ XA2 σ A 2 +XB2 σ B 2 + 2 (XA XB σ A σ B AB)
1. Efficient Portfolios:
rP * = xA rA + xB rB + xC rC
solved math302 mid term 2010 papers
MIDTERM EXAMINATION
Spring 2010
MTH302- Business Mathematics & Statistics
Ref No: 1504952
Time: 60 min
Marks: 40
| Student Info | ||
| Student ID: | | |
| Center: | | |
| Exam Date: | | |
| For Teacher's Use Only | |||||||||
| Q No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | Total |
| Marks | | | | | | | | | |
| Q No. | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | |
| Marks | | | | | | | | | |
| Q No. | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | |
| Marks | | | | | | | | | |
| Q No. | 25 | 26 | | | | | | | |
| Marks | | | | | | | | | |
hird
Question No: 1 ( Marks: 1 ) - Please choose one
Sale price is the selling price less the ________
► Markdown
► Revenue
► Cost
► Profit
Question No: 2 ( Marks: 1 ) - Please choose one
A reduction of the amount due on an invoice is called a _______ .
http://vustudents.ning.com
► Trade discount
► Net discount
► Cash discount
► Unearned discount
Question No: 3 ( Marks: 1 ) - Please choose one
Find A in the formula A = LW if L = 4 and W = 2.5.
► 6.5
► 2.9
► 10
► 1.0
Question No: 4 ( Marks: 1 ) - Please choose one
Let’s assume that you are receiving 1000 Rs. every year, and you invested each payment at 5%. The amount you would have at the end of five years period is referred as
► Final Value
► Cumulative interest
► Accumulated value
► Principal value
Question No: 5 ( Marks: 1 ) - Please choose one
Ali has bought his new motorcycle on installments. He will pay Rs. 2000 for 30 months. If the bike currently cost Rs. 54000 what percent of current cost he will pay more after 30 months. http://vustudents.ning.com
► 6%
► 15%
► 11.2%
► 10%
Question No: 6 ( Marks: 1 ) - Please choose one
0.20% = ------------
► 0.2
► 0.02
► 0.002
► 0.0002
Question No: 7 ( Marks: 1 ) - Please choose one
If 25 is decreased to 12,then percentage decrease will be
► 50
► 51
► 52
► None of these
Question No: 8 ( Marks: 1 ) - Please choose one
Contribution Margin is the Rs. amount that is equal to ----------------------
► S – VC
► VC – S
► FC – VC
► VC – FC
Question No: 9 ( Marks: 1 ) - Please choose one
http://vustudents.ning.com
This example returns the depreciation for an asset that costs Rs. 10,000, with a salvage value of $8,000. The useful life of the asset is 5 years. The depreciation is being calculated for the third year, and there are 10 months in the first year.
► =DB (10000, 5, 8000, 3, 10)
► =DB (10000, 8000, 5, 10, 3)
► =DB (10000, 8000, 5, 3, 10)
► =DB (10000, 8000, 10, 3, 5)
Question No: 10 ( Marks: 1 ) - Please choose one
Weighted average is one type of http://vustudents.ning.com
► arithmetic mean .
► DSUM function
► SUMIF function
► all given above choices.
Question No: 11 ( Marks: 1 ) - Please choose one
To find average of numbers given in figure ,one can apply the excel formula
► =AVERAGE(E12:E13)
► =AVERAGE(E5:E12)
► =SUMIF(E5:E12)
► =DSUM(E5:E12)
Question No: 12 ( Marks: 1 ) - Please choose one
SLN returns the straight-line depreciation of an asset for http://vustudents.ning.com
► Zero period
► One period
► Two periods
► Three periods
Question No: 13 ( Marks: 1 ) - Please choose one
If matrix A is given in excel as follows
Then which is the correct formula to find the inverse of A
► =MINVERSE(B4:E7)
► =MINVERSE(B4;E7)
► =MINVERSE(B2;E7)
► =MINVERSE(B2,E7)
Question No: 14 ( Marks: 1 ) - Please choose one
You purchase equipment for $42,000, minus trade discount of 30% ,20% ,15%. Trade discount will be
► $19,992
► $22,008
► $23,520
► $29,400
Question No: 15 ( Marks: 1 ) - Please choose one
http://vustudents.ning.com
Given Old Sale price = $1.95 , Markdown rate =13.6% ,then $Mark down will be
► $ 0.27
► $ 0.72
► $ 0.66
► $ 0.92
Question No: 16 ( Marks: 1 ) - Please choose one
Which function calculates depreciation at the same amount each year over an asset’s useful life?
► DB
► SLN
► DDB
► All of above
Question No: 17 ( Marks: 1 ) - Please choose one
which of the following is linear equation
► 2x-3y=-6
► x+x+x
► 520x²y²
► y^2 -3=0
Question No: 18 ( Marks: 1 ) - Please choose one
…………..are periods for the buyers to pay invoices within specified times. http://vustudents.ning.com
► discount periods
► credit periods
► initial period
► none of these
Question No: 19 ( Marks: 1 ) - Please choose one
If you want to multiply a number 7 to matrix 
then the result is
then the result is ► 
► 
► 
► Number cannot be multiply to matrix
Question No: 20 ( Marks: 1 ) - Please choose one
If the price of a shirt is Rs 250 and discount on its price is Rs 30, what is the percentage of discount?
► 10 %
► 11%
► 12%
► 15%
Question No: 21 ( Marks: 2 )
http://vustudents.ning.com
Find the unknown ‘x’ in x: 8 = 99: 44
x/8 =99/44
x * 44 = 99*8
x44=792
x=792/44
18
Question No: 22 ( Marks: 2 )
What is Salvage?
Retail store chains need an outlet for their merchandise that they can't sell in their store- so instead of trying to sell it retail, some sell it out to wholesale dealers as salvage. Salvage merchandise is merchandise that has been exchanged, returned, or shelf-pulled for any reason. It is sold "as is" and loads could consist of:
New Merchandise
Clearanced Merchandise
Returned Merchandise
Shelf Pull Merchandise
Question No: 23 ( Marks: 3 )
On a poster, a calculator that is actually 7 cm wide is shown as 0.5 m
wide. If the calculator is actually 15.4 cm long, how long is it on the poster?
Question No: 24 ( Marks: 3 )
The equations 5x + 2y = 48 and 3x + 2y = 32 represent the money collected from school concert tickets sales during two class periods. If x represents the cost for each adult ticket and y represents the cost for each student ticket, what is the cost for each adult ticket?
5x+2y=48
3x+2y=32
.
Multiply both sides of the second equation by -1
5x+2y = 48
-3x-2y =-32
.
adding two equations together:
5x+2y = 48
-3x-2y =-32
--------------
2x = 16
dividing both sides by 2
x = $8 (adult ticket cost)
Question No: 25 ( Marks: 5 )
A retailer used a markup rate of 18% on cost. Find the selling price of an item that costs the retailer $60.
Selling price = cost price + %markup on cast
= 60 + 60(18/100)
= 60 +10.8
Selling price =70.8
Question No: 26 ( Marks: 5 )
Find
a) The fourth proportional to 4 , 9 , 12;
http://vustudents.ning.com
/9 = 12/x
or x = (12 * 9)/4
x = 108/4
x = 27
b) The t proportional to 16 and 36.
Subscribe to:
Posts (Atom)