Question: how to create a cash flow analysis for the year 1 9 9 5 ? Using the information given. Exhibit 3 Cash Flow Analysis of

how to create a cash flow analysis for the year 1995? Using the information given.
Exhibit 3
Cash Flow Analysis of Helping Hand: 1993-1995($000s)
Net Income
Depreciation
Cash flow operations
Change adjusted working capital
Capital Spending
Dividends
Cash flow
Accounts Receivable
Inventory
Accounts Payable
Accruals
Adjusted working capital Change adjusted working capital
\table[[0,0,0],[0,0,0]]
Total liabilities and equityRetained earningsS6,256.53224.2$6489.,2Common stock3,545.5$7471.7Term loansCurrent liabilities543.03,969.0543.0633.5950.3582.2561.6Calculated as (Receivables/(Sales/360)]1.25 percent had a current ratio above 3.1. By implication, 50 percent of these ratios fell between 1.5 and 3.1.cutoff for the top 25 percent. For example, 25 percent of the industry firms had a current ratio below 1.5, andbThe left or lower number shows the cutoff for the bottom 25 percent. The right or higher number shows theAccruals1,855.81818.5832.6L.990.8Accounts payable767.6ratio above 2.1 and half had a current ratio below 2.1.aThe median is the middle value of the industry statistic. For example, half the industry firms had a current958.0Liabilities and EquityShort-term bank loans6974743.2$325.8652.7$307.7Net profit margin1.70.7/2.6$380.13.0Total assetsNet fixed assets1.7/3.6S6,256.5S6.489.25.10.7/73694.0$7471.7assets705.911.9725.81.7/18.25,5625Total asset turnoverReturn on equity (%)Return on total assets (%)Inventory turnover (CGS)Average collection periodInventory5,783.32.91.8/3.94649.06,745.94,875.7Accounts receivable1810/345518.5S624.5289.0Times interest earned2.6AssetsCash1.1/5.5387.9766.0Debt (%)57S519.738/74$461.4QuickCurrent2.10.3/1.015/3.1199319941995MedianLower/UpperHelping Hands Balance Sheets: 1993--1995($000s)EXHIBIT 2Selected Ratios for Hardware Storesa: 1993-1995EXHIBIT 4Net incomeS413.4Taxes$321.3S423.5275.6Earnings befone taxes214.2282.4$203.7S344.8689.1Change adjusted working capitalAdjusted working capital535.6705.9Interest3,204.43,408.13,752.9108.8105.7107.0-AccrualsEarning befone interest and taxes (EBI)832.6767.6797.8641.3Depreciation812.9-Accounts payable697.4743.21388Operating expeses141.2145.24,649.0InventoryAccounts receivable4,875.85,932.65,986.26.846.5Gross mangin$289.1S387.9Cost of goods sold6,86936768.77,804.5199219931994Sales13,946.8S20,816.114.383.7$21,152415562.2$23,366.7Adjusted Working CapitalCash flow199319941995-Dividends-Capital spending$189.1Helping Hand's Income Statements: 1993-1995(S000s)(S35.3)159.5153.0EXHIBIT 1-Change
TotalRetained earningsS6,256.5$6,A89.2Common stock3,224.2$7A71.73,545.5Term loans543.0543.0Current633.53,969.0950.3582.2Calculated as (Receivables/(Sales/360)].25 percent had a current ratio above 3.1. By imnplication, 50 percent of these ratios fell betweern 1.5 and 3.1.cutoff for the top 25 percent. For example, 25 percent of the industry firms had a current ratio below L.5, andThe left or lower number shows the cutoff for the bottom 25 percent. The right or higher number shows theAccrualsAccounts payable1,855.8561.61,818.5832.61.990.8767.6ratio above 2.1 and half had a current ratio below 2.1.aThe median is the middle value of the industry statistic. For example, half the industry firms had a currentLiabilities and EquityShort-term bank loans697A958.0743.2S325.8652.7S307.7Net profit1.70.7/2.6s380.130Total assets1.7/3.6S6,256.5Net fixed assetsS6,489.26.10.7/7.3694.0$7471.7Total asset turnoverReturn on equity (%)Return on total assets (%)Inventory turnover (CGS)Current assets11.91.7/18.2705.95562.5725.8Inventory5,783.32.91.8/3.94,649.06,745.94,875.7Average collection periodAccounts1810/34S624.5289.05518.5Times interest earned2.6CashAssets1.1/5.5387.9766.0Debt (%)57S519.738/74$461.4QuickCurrent0.52.10.3/1.01.5/3.1199319941995MedianLower/Upper QruartilesHelpingEXHIBIT 2Selected Ratios for Hardware Storesa: 1993-1995EXHIBIT 4Net incomeTaxesS4134275.6S321.3S423.5214.2Earmings befone taxes252.4Change adjusted working capital$203.7S344.8689.1535.6Adjusted working capital705.93,204.4Interest3408.13,752.9108.8105.7Earnings befone interest and taxes107.0-Accruals832.6767.6797.86413Depreciation812.9-Accounts payable697.4743.213881412InventoryOperating expees145.24,649.0875.85.93265,986.26846.5Accounts receivableGross$289.1S387.968693Cost of goods sold6.768.77,804.5199219931994SalesS20,816.I13,946.814.383.7S21,152.415,562.2S23,366.7Adjusted Working CapitalCash flow199319941995S189.1(S353)-DividendsHelping Hand's Income Statements: 1993-1995($O00s)-Capital spending159.5153.0-Change adjusted working capitalEXHIBIT I203.6344.8Cash flow operations552.24

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!