Financial Mthematics and Working Capital Management - 1
Financial Mthematics and Working Capital Management - 1
Financial Mthematics and Working Capital Management - 1
b. market risk, which reflects the risk of a general stock market decline and
cannot be eliminated by diversification (hence, does concern investors) Only
market risk is relevant to rational investors because diversifiable risk can and
will be eliminated.
A stock with high market risk must offer a relatively high expected rate of
return to attract investors. Investors are in general are averse to risk, so they
will not buy risky assets unless they are compensated with high expected
returns.
B. TIME VALUE OF MONEY
This explains how the time value of money works and discuss why it is such
an important concept in finance; calculate the present value and future value
of lump sums; identify the different types of annuities, calculate the present
and future value of both an ordinary annuity and an annuity due, and
calculate the relevant annuity payments; calculate the present and future
value of uneven cash flow stream.
TIME VALUE OF MONEY (cont’d)
Set Up Time Line – an important tool used in time value analysis; it is a
graphical representation used to show the timing of cash flows. Time line is
presented in the following Diagram:
1. Step By Step Approach
To find the Future Value of P100 compounded for 3 years at 5% is:
Periods 0 5% 1 2 3
1. Formula approach
In this approach we use the equation FVN = PV(1+1)ⁿ
FVN = PV (1+I)ᴺ = P100(1.05)ᵌ = P115.76
3. Excel Approach
In your spreadsheet, use FV function
FVN = FV(rate,nper,pmt,pv,type)
FVN = FV(0.05,3,0,-100) = 115.76
In excel formula, the terms are entered in this sequence: interest, periods, 0 to
indicate no intermediate cash flows, and then the PV
Present Values
To find the Present Value, using Formula Approach the formula is:
PV = FVN (1+1)ᴺ
Excel Approach PV = PV(rate,nper,pmt,fv,type)
PV(0.05,3,0,115.76) = P100
TIME VALUE OF MONEY (cont’d)
Finding Interest Rates
In finding interest rates, you can use equation using the existing Formula
approach and use Calculator approach.
Using excel approach - RATE = RATE(nper,pmt,pv,(fv),(type),(guess))
Thus for example – given bond has a cost of P100 and that it will return P150
after 10 years so we know PV, the N and the FV:
=RATE(10,0,-100,150) = 4.14%
Finding Number of Years in excel
=NPER(rate,pmt,pv,(fv),(type))
=NPER(0.0414,0,-100,150) =9.9990 or 10 years
C. BOND AND STOCK VALUATION
CONCEPT
What is a Bond? Who issues Bond?
A Bond is a long term contract under which a borrower agrees to make
payments of interest and principal on a specific dates to the holders of the
bond. Bonds are issued by the corporations and Government Agencies
that are looking for a long-term debt capital. Bonds may either be:
Treasury Bonds –referred to as government bonds; Corporate Bonds - bonds
issued by a corporation; Foreign Bonds – bonds issued by foreign
government.
Key Characteristics of Bonds:
Par Value Coupon Interest Rate Maturity Date
Call Provisions Sinking Funds Original Maturity Fixed-Rate
Bonds Zero Coupon Bonds Floating-Rate Bonds
C. BOND AND STOCK VALUATION
CONCEPT
Other Features of Bonds
•Convertible Bonds – bonds convertible to common stock
•Warrants – giving the holder the right to buy a security at a particular price
•Putable bonds – provides the holder to force the issuer to redeem the b4 maturity
•Income Bond – only the face value of the bond is promised to be paid by the holder
•Callable Bond – can be redeemed by the issuer before maturity
•Indexed (Purchasing Power) Bond – interest payments is based on P-index
•The following general equation can be solved to find the value of any bond:
Bond’s Value = Bν = INT + INT + INT + INT
(1+rd)1 (1+rd)2 (1+rd)n (1+rd)n
= N + INT + N (1+rd)t
(1+rd)n
Where: VB = Value of the bond
INT = Interest
Rd = Coupon rate
M = Maturity
BOND AND STOCK VALUATION CONCEPT (cont’d)
Using Excel’s PV function you can calculate the present value of the Bond
Example: A friend of yours invested in an outstanding Bond with 5% annual
coupon and a remaining 10 maturity years and annual coupon payment of
P50. The par value of the bond is P1,000 and the market interest rate is
currently 7%. How much did your friend pay for the bond? Is it a discount
bond or premium bond?
Solution: = PV(0.07,10,50,1000) = P859.53 = A discount bond
Note: A discount bond is a bond that sells below its par value A
premium bond is a bond that sells above its par value
Yield to Maturity
Supposed you were offered a 14-year, 10% annual coupon, P1,000 par value
bond at a price of P1,494.93. What rate of interest would you earn on your
investment if you bought the bond, held it to maturity, and received the promised
interest and maturity payments? This rate is called Yield to Maturity (YTM). You
need to solve it through equation but using the Excel’s RATE function it would go
like this:
=RATE(14,100,-1494.93,1000) = 5%
Note: to find PMT of P100: =PMT(0.05,14,-1494.93,1000) = P100
Now assume that this bond is callable in 7 years at a price of P1,075, what is the
bond’s Yield to Call (YTC)?
= RATE(7,100,-1494.93,1075) = 3%
where: PMT =PMT(.03,7,-1494.93,1075)=P100
BOND AND STOCK VALUATION CONCEPT (cont’d)
Stocks
Generally, Stocks is an ownership in a corporation. Stocks represent
partial ownership, or equity, in a company. When you buy stock, you’re
actually purchasing a tiny slice of the company — one or more "shares."
And the more shares you buy, the more of the company you own.
Preferred Stock
A main difference from common stock is that preferred stock comes with
no voting rights. So when it comes time for a company to elect a board of
directors or vote on any form of corporate policy, preferred shareholders have
no voice in the future of the company. In fact, preferred stock functions
similarly to bonds since with preferred shares, investors are usually
guaranteed a fixed dividend in perpetuity.
BOND AND STOCK VALUATION CONCEPT (cont’d)
Common stock
Common Stock represents shares of ownership in a corporation
and the type of stock in which most people invest. Common
shares represent a claim on profits (dividends) and confer voting
rights. Investors most often get one vote per share- owned to elect
board members who oversee the major decisions made by
management. Stockholders thus have the ability to exercise control
over corporate policy and management issues compared to
preferred shareholders.
BOND AND STOCK VALUATION CONCEPT (cont’d)
2. Current Assets Financing Policy – the manner in which current assets are
financed which are categorized by the following approaches:
Maturity Matching or Self-Liquidating Approach – a financing policy
that matches the maturities of assets and liabilities. This is a moderate
policy. For example fixed assets and fixed current assets are financed by a
long term capital while temporary assets are financed by long term debt.
WORKING CAPITAL MANAGEMENT (cont’d)
Cash Budget – a table that shows cash receipts, disbursements, and balances
over some period.
If firm needs additional cash, most likely it needs to forecast cash flows and
should line up funds well in advance. The monthly cash budget begins with
sales forecast for each month and a projection of when actual collections will
occur. Then it follows with forecasted purchases, followed by forecasted
payments. The difference between cash receipts and disbursements will be
either gain or loss. Management should take into account beginning cash
balance to arrive at the target cash balance. Usually, the target cash balance is
the desired cash balance that a firm plans to maintain in order to conduct a
business.
WORKING CAPITAL MANAGEMENT (cont’d)
Demand Deposits - are checking account deposits used for transactions such
as paying for raw materials, labor and other regular purchase transactions.
These earn no interest so firms minimize their holdings. Most common
nowadays are bank debit or transfer of funds to another bank of suppliers to
ensure prompt cash payments.
WORKING CAPITAL MANAGEMENT (cont’d)
Credit Period – the length of time customers have to pay for purchases.
A long credit period lengthen the cash conversion cycle and the higher the
probability of the customer to default and that will end up to bad debts. CFO
should also determine background of customers who avail of credit account
by creating credit standards.
Discounts – price reductions for early payments.
Offering discounts to customers may sometimes lower the price. The benefits
and cost of discounts must be balanced when credit policy is being
established.
WORKING CAPITAL MANAGEMENT (cont’d)
Credit standards – the financial strength customers must exhibit to qualify
for credit.
This includes verifying customer’s credit history thru credit rating agencies
with their credit score card. Tighter credit standards should be balanced
through its costs and benefits.
Collection Policy – degree of toughness in enforcing credit terms.
Sometimes excessive collection pressures to customers would lead to
strangling them. Valued customers may take their business elsewhere thus,
balance must be struck between costs and benefits of different collection
policies.
Credit Scores – numerical scores that indicate the likelihood that people or
business will pay on time.
WORKING CAPITAL MANAGEMENT (cont’d)
Trade Credit - Debt arising from credit sales and recorded as an account
receivable by the seller and as accounts payable to the buyer.
Line of credit – an arrangement in which a bank agrees to lend up to a
specified maximum amount of funds during a designated period. It is an
agreement between a bank and a borrower indicating the maximum amount of
credit the bank will extend to the borrower.
WORKING CAPITAL MANAGEMENT (cont’d)
Cash management deals with all aspects of working capital management and
involves many different tasks. The roles and responsibilities of this
department include:
•Forecasting the cash requirements of the business and preparing budgets.
•Establishing necessary banking relationships and providing working capital
finance security.
•Managing the credit collection.
•Ensuring that shortfalls are avoided or minimised and that the business can
always meet its financial obligations.
•Releasing trapped cash
•Extracting liquidity from working capital
•Releasing working capital
F. MANAGEMENT OF SHORT-TERM INVESTMENTS
Setting Objectives
The first step in setting any investment strategy is to understand the three core
objectives and the interrelationships between them. The three core objectives
are to preserve the invested principal (also known as security or safety), to
maintain access to the invested funds (liquidity), and to maximize the return
on the invested funds (yield).
G. ACCOUNTS RECEIVABLE MANAGEMENT
Collecting cash
Obviously, if cash is to be collected, then the customer must be invoiced. It is
essential that the invoice is sent out quickly and accurately. The receipt of
your invoice is the first indication a company gets of the efficiency of your
debt collection system. If the invoice takes a long time to arrive and is not
accurate, then your accounts receivable department will be viewed as
inefficient and customers may seek to exploit this perceived weakness and
delay payment.
ACCOUNTS RECEIVABLE MANAGEMENT (cont’d)
Having sent out the invoice quickly and accurately, the methods a
company could use to ensure customers pay in a timely fashion include:
1. monthly statements – these can be produced quickly and easily by any
computerised sales ledger system and sent to customers. Exactly how much
impact they have is however debatable
2. chasing letters – these should be directed to a specific person preferably at
a reasonably senior level. However, preparing and sending these letters has a
cost and, like the monthly statements, their impact is often limited
ACCOUNTS RECEIVABLE MANAGEMENT (cont’d)
3. chasing phone calls – these can often have a great impact as all businesses
have to answer the telephone and, hence, they have a nuisance value which
can generate results. A credit controller who regularly contacts a suitably
senior person at their customers with overdue amounts and politely, but
firmly, demands payment can often achieve good results
4. personal approach – a personal approach from a senior person in the
company to a senior person at the customer can often yield results. This is
quite common in trades where the personal relationship with clients is
important. For instance, this often occurs in professional accountancy and
legal firms
ACCOUNTS RECEIVABLE MANAGEMENT (cont’d)
5. stopping supplies – this is a cash collection tool that must be used with
care. If the product being sold is built specifically to the customers design,
and you are the only supplier who currently makes the product, then it is a
powerful tool as, in the short term, you are the only supplier and, hence,
payment is likely to be forthcoming. However, in the longer term it is always
possible for the customer to train up an alternative supplier to make the
product. If the product is a generic product that could be purchased from
many suppliers, then quite obviously this is a weak tool that is simply likely
to lead to the loss of the customer
6. legal action – this is costly and is likely to lead to the customer being lost
ACCOUNTS RECEIVABLE MANAGEMENT (cont’d)
. external debt collection agency – as with legal action this is costly and is
likely to lead to the loss of the customer.
Invoice discounting
Invoice discounting is another method a company can use to speed up the
receipt of cash from its receivables. If a company is short of cash, it can
approach an invoice discounter who will lend cash against the security of one
or a few invoices that customers have still to pay.
H. INVENTORY MANAGEMENT
Landed costs - These are the costs of shipping, storing, import fees, duties,
taxes and other expenses associated with transporting and buying inventory.
The time it takes a supplier to deliver goods after an order is placed along
with the timeframe for a business’ reordering needs.
The complete lifecycle of an order from the point of sale to pick-and-pack to
shipping to customer delivery.
a supplier and a buyer that outlines types, quantities, and agreed prices for
products or services.
INVENTORY MANAGEMENT (cont’d)
(iv) Purchase or discounting of bills - Bills receivable arise out of credit sales
transaction, where the seller of goods draws the bill on the buyer. The bill may be
documentary or clean bill. Once the bill is accepted by the buyer, then the drawer
(seller) of the bill can go to the bank for bill discounting or sale.
(v) Letter of Credit - There are two non-fund based sources of working capital, viz.,
letter of credit (L/Cs) and Bank Guarantees (B/Gs). These are also known as quasi-
document issued by the Buyer’s Banker (BB) at the request of the Buyer’s, in favour
of the seller, where the Buyer’s Banker gives an undertaking to the seller, that the bank
pay the obligations of its customer up to a specified amount, if the customer fails to
pay the value of goods purchased. Letter of credit facility is available from banks only
for the companies that are financially sound and bank charges the customer for
providing this facility.
SHORT-TERM FINANCING SOURCES (cont’d)