Financial forecasting and short term financing
Download
1 / 41

Financial Forecasting and Short-term Financing - PowerPoint PPT Presentation


  • 1533 Views
  • Updated On :

Financial Forecasting and Short-term Financing Forecasting and Pro Forma Analysis Timing of financial needs Amount of financial needs Flow of funds Check the covenants Pro forma Income Statement Pro forma Balance Sheet Plug Figure Financing Options Depreciation

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Financial Forecasting and Short-term Financing' - emily


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Forecasting and pro forma analysis l.jpg
Forecasting and Pro Forma Analysis

  • Timing of financial needs

  • Amount of financial needs

  • Flow of funds

  • Check the covenants


Slide3 l.jpg

Pro forma Income Statement

Pro forma Balance Sheet

Plug Figure

Financing Options

Depreciation

Change in Net Plant & Equipment

Capital Expenditures

Short-Term Debt

Long-Term Debt

Working Capital Accounts

Sales

Forecast

External

Financing

Required

Net Income

Change in Retained Earnings

Dividend Policy


Steps in financial forecasting l.jpg
Steps in Financial Forecasting

  • Forecast sales

  • Project the assets needed to support sales

  • Project internally generated funds

  • Project outside funds needed

  • Decide how to raise funds

  • See effects of plan on ratios and stock price


Sales forecast l.jpg
Sales Forecast

  • Seasonal changes

  • Business cycle

    • Recession

    • Expansion

  • Market segment

    • High growth

    • Contraction

  • Inflation




Afn additional funds needed l.jpg
AFN (Additional Funds Needed)

Key Assumptions

  • Operating at full capacity in 2001.

  • Each type of asset grows proportionally with sales.

  • Payables and accruals grow proportionally with sales.

  • 2001 profit margin (2.52%) and payout (30%) will be maintained.

  • Sales are expected to increase by $500 million. (%ΔS = 25%)


Afn additional funds needed9 l.jpg
AFN (Additional Funds Needed)

  • AFN= (A*/S0) ΔS - (L*/S0) ΔS - M(S1)(1 - d)

    = ($1,000/$2,000)($500) - ($100/$2,000)($500) - 0.0252($2,500)(1 - 0.3)

    = $180.9 million.


Projecting pro forma statements with the percent of sales method l.jpg
Projecting Pro Forma Statements with the Percent of Sales Method:

  • Project sales based on forecasted growth rate in sales

  • Forecast some items as a percent of the forecasted sales

    • Costs

    • Cash

    • Accounts receivable

  • Items as percent of sales

    • Inventories

    • Net fixed assets

    • Accounts payable and accruals

  • Choose other items

    • Debt (which determines interest)

    • Dividends (which determines retained earnings)

  • Common stock



Other inputs l.jpg
Other Inputs Method:



2002 1st pass balance sheet assets forecasted assets are a percent of sales l.jpg
2002 1st Pass Balance Sheet (Assets) Method:Forecasted assets are a percent of sales.



What are the additional funds needed afn l.jpg
What are the additional funds needed (AFN)? Method:

  • Forecasted total assets = $1,250

  • Forecasted total claims = $1,071

  • Forecast AFN = $ 179

  • NWC must have the assets to make forecasted sales. The balance sheets must balance. So, we must raise $179 externally


How will the afn be financed l.jpg
How will the AFN be financed? Method:

  • Additional notes payable= 0.5 ($179) = $89.50  $90.

  • Additional L-T debt= 0.5 ($179) = $89.50  $89.

  • But this financing will add 0.08($179) = $14.32 to interest expense, which will lower NI and retained earnings.





Results after the second pass l.jpg
Results After the Second Pass Method:

  • Forecasted assets= $1,250 (no change)

  • Forecasted claims= $1,244 (higher)

  • 2nd pass AFN = $ 6 (short)

  • Cumulative AFN= $179 + $6 = $185.

  • The $6 shortfall came from the $6 reduction in retained earnings. Additional passes could be made until assets exactly equal claims.



Full capacity l.jpg
Full Capacity Method:

  • The equation used to calculate EFN when fixed assets are being utilized at full capacity is given below.


Slide25 l.jpg

  • S Method:0 = Current Sales,

  • S1 = Forecasted Sales = S0(1 + g),

  • g = the forecasted growth rate is Sales,

  • A*0 = Assets (at time 0) which vary directly with Sales,

  • L*0 = Liabilities (at time 0) which vary directly with Sales,

  • PM = Profit Margin = (Net Income)/(Sales), and

  • b = Retention Ratio = (Addition to Retained Earnings)/(Net Income).


Full capacity example l.jpg
Full Capacity Example Method:

  • Given that Fixed Assets are being utilized at full capacity and the forecasted growth rate in Sales is 25%.

  • Forecasted Sales: S1 = 1200(1 + .25) = $1500


Excess capacity l.jpg
Excess Capacity Method:

  • If the firm has excess capacity in its Fixed Assets then the Fixed Assets may not have to increase in order to support the forecasted sales level. Moreover, if the Fixed Assets do need to increase in order to support the forecasted sales level, then they will not have to increase by as much as would be required if they were being used at full capacity.

  • If Forecasted Sales are less than Full Capacity Sales, then fixed assets do not need to increase to support the forecasted sales level. On the other hand, if Forecasted Sales are greater than Full Capacity Sales, then Fixed Assets will have to increase.


Case 1 s 1 less than s fc l.jpg
Case 1: S Method:1 Less Than SFC

  • Given that Fixed Assets are currently being utilized at 60% of capacity and the forecasted growth rate in Sales is 25%.

  • S1 = 1200(1 + .25) = $1500

  • SFC = 1200/.60 = $2000

  • Forecasted Sales are less than Full Capacity Sales the EFN can be found in one step. Here A*0 is equal to Total Current Assets which equals $1200.


Case 2 s 1 greater than s fc l.jpg
Case 2: S Method:1 Greater Than SFC

  • When the Forecasted Sales are greater than Full Capacity Sales, EFN can be determined in two steps. The first step, EFN1, finds the EFN needed to get to Full Capacity Sales. The second step, EFN2, finds the additional EFN to get from Full Capacity Sales to the Forecasted Sales.

  • The total EFN is simply EFN1 plus EFN2.


Excess capacity example s 1 s fc l.jpg
Excess Capacity Example: S Method:1 > SFC

  • Given that Fixed Assets are currently being utilized at 90% of capacity and the forecasted growth rate in Sales is 25%.

  • S1 = 1200(1 + .25) = $1500

  • SFC = 1200/.90 = $1333.33


Tracing cash and net working capital l.jpg
Tracing Cash and Net Working Capital Method:

  • Current Assets are cash and other assets that are expected to be converted to cash with the year.

    • Cash

    • Marketable securities

    • Accounts receivable

    • Inventory

  • Current Liabilities are obligations that are expected to require cash payment within the year.

    • Accounts payable

    • Accrued wages

    • Taxes


The operating cycle and the cash cycle l.jpg

Raw material purchased Method:

Order Placed

Stock Arrives

Inventory period

Accounts receivable period

Cash cycle

The Operating Cycle and the Cash Cycle

Cash received

Finished goods sold

Time

Accounts payable period

Firm receives invoice

Cash paid for materials

Operating cycle


Operating cycle inventory turnover and a r turnover l.jpg
Operating Cycle, Inventory turnover, and A/R turnover Method:

  • Inventory turnover = Sales / Average Inventory, or COGS / Average Inventory

    • [Inventory Conversion = 365 / Inventory turnover]

  • Accounts Receivable turnover = Sales / AR

    • [Days A/R outstanding = 360 / Accounts Receivable turnover]

  • Payable turnover = Purchase (or COGS) / AP

    • [Days A/P outstanding = 360 / Payable turnover]

  • Operating Cycle = Inventory Conversion + Days A/R outstanding


The operating cycle and the cash cycle34 l.jpg

Accounts payable period Method:

Cash cycle

=

Operating cycle

The Operating Cycle and the Cash Cycle

  • In practice, the inventory period, the accounts receivable period, and the accounts payable period are measured by days in inventory, days in receivables and days in payables.


Dell s working capital policy l.jpg
Dell’s Working Capital Policy Method:

  • Dell’s daily sales was about $20M per day. Dell was able to reduce the need of short term financing $800M. Assuming a 6% short term cost of capital, Dell was able to created $48M more pre tax earnings.


Slide36 l.jpg
You find the following information from a firm’s financial statements, please calculate its cash (conversion) period?

  • Beginning Inventory $ 400,000

  • Purchase $2,600,000

  • Ending Inventory $ 600,000

  • Accounts Receivable $ 800,000

  • Sales $3,600,000

  • Accounts Payable $ 600,000


Slide38 l.jpg

Operating Cycle = Inventory Conversion + A/R Days statements, please calculate its cash (conversion) period?

Cash Cycle = Operating cycle – A/P days

Operating Cycle = 75 + 80 = 155 days

Cash Cycle = 155 days – 83 days = 72 days


Short term financing l.jpg
Short term financing: statements, please calculate its cash (conversion) period?

  • Advantages:

    • Could be obtained quicker.

    • The amount raised can be flexible.

    • Usually cheaper. (comparing with long-term finance)

  • Disadvantages

    • High solvency risk: need to be repaid in a short period.

    • High refinance risk: face highly volatile short-term interest rates.


Short term financing strategies l.jpg
Short-term financing strategies statements, please calculate its cash (conversion) period?

  • Moderate Approach: matching maturities. Finance long term assets and permanent current assets with long term financing; finance transitory current assets with short term.

  • Aggressive Approach: Finance part of permanent assets and all transitory assets with short term financing.

  • Conservative Approach: Finance part of transitory current assets with long-term financing.


The short term financial plan l.jpg
The Short-Term Financial Plan statements, please calculate its cash (conversion) period?

  • The most common way to finance a temporary cash deficit to arrange a short-term loan.

  • Unsecured Loans

    • Line of credit down at the bank

  • Secured Loans

    • Accounts receivable financing can be either assigned or factored.

    • Inventory loans use inventory as collateral.

  • Other Sources

    • Banker’s acceptances

    • Commercial paper.


ad