《CASH BUDGET (FORECAST).ppt》由会员分享，可在线阅读，更多相关《CASH BUDGET (FORECAST).ppt（25页珍藏版）》请在三一办公上搜索。
1、CASH BUDGET(FORECAST),a plan for the cash inflows and outflows over a certain period of time.,THE CASH BUDGET IS A TOOL FOR FINANCIAL PLANNING,The cash budget helps the firm to plan for the actual receipt and disbursement of cash.,PREPARING THE CASH BUDGET,1.The company estimates the sales for each
2、period during the planning period,MonthSales for 2005 Projected Sales for 2006,January25142706February36283788March50595410April59986492May94529654June1065711241July34523652August41484620September20032050October 18761930November16401750December15731582Total5200054875Monthly Distribution of sales for
3、 Happiness Plc.(thousands of Euros),.,2.When will the sales actually generate cash?(Sales made for credit do not produce immediate cash inflows,and the cash budget must take these delays into account.)Customers payment habits tend to remain in the same over time.,Payment MonthPercentage Paid,Month o
4、f sale15%Month after sale 35%Second month after sale50%,MonthCollectedCashAmount,November 2005 15%246000December 2005 35%574000January 2006 50%820000Cash Receipts for November 2005(Sales were 1640000),3.The company use the projected sales and payment pattern to prepare the cash inflows for 2006.,.,P
5、rojected cash inflows of sales from 2006 for Happiness plc.*The Cash budget must reflect all cash inflows.These items should also inlcude cash receipts for rent,interest,dividends.,4.The firm makes a schedule of disbursements,.,Projected Cash Disbursements for Happiness plc.2006(thousand of euros),5
6、.Finally we prepare the cash budget,the projected cash inflows and disbursements will be brought together with the cash available at the beginning of the period.,.,CASH BUDGET FOR HAPPINESS PLC.,(thousand of euros),Short explanations,The first line shows the beginning cash.For January is simply from
7、 the balance sheet for 2005.The second line shows the cash inflows the company expects in each month.Line 3 is the sum of the first and the second line,the available cash.Line 4 is for the projected cash disbursementsTo get line 5 we have to subtract from the available cash the cash disbursements.So
8、 will we get the amount of cash the company expects to have at the end of the month.(This ending cash figure would be carried forward as the beginning amount of cash for the next month.),In the line 6 we have the minimum cash balance that the company like to have as a precaution against planning err
9、ors or to be sure not run out of cashLine 7 shows any excess or shortfall of cash.A positive number(excess cash)indicates the company can invest it to a return.A negative number(needed cash)indicates the companyy must acquire money to pay its debts and to maintain its minimum cash balance.,SOME CASH
10、FLOW RATIOS:Cashflow from Operating Activities(CFOA),1.Cashflow Interest Coverage=CFOA+Interest Paid+Taxes Paid Interest Paid,CFIC 1 means the company cannot cover its interest cost through operating cashflows.This condition can lead to insolvency.,2.CashFlow Return-on Investments=CFOA+Interest Tota
11、l Assets-on Assests,CFROI/CFROA The higher the ratio the better the company position is.CFROI 1 means the firm earns less than 1 percent on equity and this performance will not attract any new investment capital.,3.Cash Collection Ratio=Cash received from Costumers Sales,Cash received from Costumers
12、=Accounts Receivable+Sales Begining Balance-Accounts Receivable Ending BalanceCCR would be considered 100%,but this is very rarely happens due to different reasons.(Some credit sales are never collected.),Kite Products makes 35 percent its sales for cash,collects 40 percent of its sales the followin
13、g month,and the final 25 percent the next month.The sales figures in Kite Products for the past year:,January120000July660000February150000August520000March200000September380000April400000October210000May500000November100000June460000December 50000,Show the cash inflows generated by the sales presen
14、ted above.In planning for next year,the company expects sales to be 8 percents above last years level.Calculate the forecasted sales on a month-by-month basis for the next year.If Kite Products collects 5 percent of its sales in cash,15 percent the following month;and the final 80 percent the next m
15、onth,calculate the companys projected cash receipts for the next year.,Exercise:,2.Follow on making a cash budget for Happiness plc.for the rest of the year 2006.,Projected Cash Disbursement for Happiness plc.2006.(thousand of euros),Exercise for Appendix(2),Balance Sheet Sun HolidayFor the Year End
16、ed 31 December 2005 2004 2005ASSETSInvested Assets Intangibles 500 400 Tangibles 10000 9500 10500 9500Current Assets Inventories 880 720 Accounts Receivable 220 190 Marketable Securities 130 0 Cash 160 80 1390 990Total ASSESTS 11890 10890,LIABILITIES(SOURCES)20042005Shareholders Equity Issued Capita
17、l 50005000 Capital Reserve 1500 1400 Other Reservers 3200 2600Provisions 100 50Long-Term Liabilities 500 1000 Current Liabilities Accounts Payable590 340 Taxes Payable 400 200 Notes Payable 600 300TOTAL LIABILITIES 11890 10890,Income StatementSun HolidaysFor the Year Ended 31 December 2005(thousand
18、of euros),Revenue 18000Cost of goods sold(12560)Depreciation and Amortization(3200)Financial Expenses(180)_ Earnings before taxes 2060Taxes _(2000)_Earnings after taxes 60Dividends(1800)_Loss(1740)Cumulated income(O)7000Cumulated income(E)5260,Additional information,Increase in Tangible Assets 2.700.000Amortization 600.000Expenses include the 6 percent interest of Bonds Make a Cashflow Statement for Sun Holidays using the indirect method.,
