Question

In: Finance

Consider the following data for X. Enterprise’s Accounts Payable: Year 1 2 3 Accounts Payable 78...

Consider the following data for X. Enterprise’s Accounts Payable:

Year

1

2

3

Accounts Payable

78

85

92

Holding all else is constant, how should you adjust X’s year 2 earnings to obtain Cash Flows?
Note: Use a positive number for any additions and a negative number for any subtractions

Accounts receivables:

Year

1

2

3

Accounts receivables

79

57

69

Holding all else is constant, how should you adjust X’s year 2 earnings to obtain Cash Flows?
Note: Use a positive number for any additions and a negative number for any subtractions

Inventory:

Year

1

2

3

Inventory

77

73

67

Holding all else is constant, how should you adjust X’s year 2 earnings to obtain Cash Flows?
Note: Use a positive number for any additions and a negative number for any subtractions

Solutions

Expert Solution

Account payable :

Accounts payable is part of current liabilities and increase in current liabilities implies that cash is coming in and it is increasing while decrease in the same implies cash is decreasing

Since Account payable increase in year 2, we will increase the cash flow by that amount

So increase in cash flow = 85 -78 = +7

Account receivables:

Accounts receivables is part of current assets and increase in current assets implies that cash is going out and it is decreasing while decrease in the same implies cash is increasing

Since Account receivables decrease in year 2, we will increase the cash flow by that amount

So increase in cash flow = 79-57 = +22

Inventory:

Inventory is also part of current assets and increase in current assets implies that cash is going out and it is decreasing while decrease in the same implies cash is increasing

Since Inventory decrease in year 2, we will increase the cash flow by that amount

So increase in cash flow = 77-73 = +4


Related Solutions

Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 3...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 3 4 4 2 3 5 6 3 5 7 7 6 6 8 Graph this data series (use the X-Y scatter/chart tool in Excel for this plot). What type of pattern(s) exists in the data? Does the graph suggest that these data exhibit seasonality? What is the length of the season in this particular case? Determine the seasonal factors for each quarter using METHOD...
2. Consider the following data: x= 1, 2, 3, 4, 5 y =3, 2, 4, 6,...
2. Consider the following data: x= 1, 2, 3, 4, 5 y =3, 2, 4, 6, 5 By hand, not using Matlab, and showing your work: (a) Compute the correlation coefficient. (b) Find the least-squares line. (c) Find the standard deviation around the least-squares line.
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 3 6...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 3 6 7 2 4 1 8 3 1 7 5 4 5 7 8 a. Which of the following is a time series plot? - Select your answer -time series plot #1time series plot #2time series plot #3Item 1 What type of pattern exists in the data? - Select your answer -upward linear trendnonlinear trend and a seasonal patternlinear trend and a seasonal patternslight curvaturedownward...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 3 6...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 3 6 8 2 2 4 8 3 4 7 9 4 6 9 11 . (a)  Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 4 5 2 4 5 8 3 1 3 4 4 7 9 10 (a) Choose the correct time series plot. (i) (ii) (iii) (iv) - Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1 What type of pattern exists in the data? - Select your answer -Positive trend pattern, no seasonalityHorizontal pattern, no seasonalityNegative trend pattern, no seasonalityPositive trend pattern, with seasonalityHorizontal pattern, with...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5 7 2 0 2 6 3 5 8 10 4 5 8 10 b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 2 5 7 2 0 2 6 3 5 8 10 4 5 8 10 (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your...
Consider the following data: Year 1 Year 2 Year 3 Year 4 Book Value of Equity...
Consider the following data: Year 1 Year 2 Year 3 Year 4 Book Value of Equity 25 ROE 22% 22% 30% 30% Payout 65% 65% 60% 60% Net Income Dividends Retained Earnings g - a) Complete the table. b) Check that in period 2 and period 4, the dividends grow according to the formula: g = ROE (1 - Payout) and explain. c) Determine the value of equity (E), taking into account that the dividend growth rate after the 4th...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 8...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 5 8 10 2 2 4 8 3 1 4 6 4 3 6 8 A.) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6...
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 0 1 4 3 3 5 6 4 5 7 8 (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT