Question: Chapter 3 Problem 14 a Using the information provided, construct a monthly cash budget for October through December 2011. Based on your analysis, will Noble
| Chapter 3 Problem 14 | ||||||||
| a | Using the information provided, construct a monthly cash budget for October through December 2011. Based on your analysis, will Noble enjoy a surfeit of cash, or require external financing? | |||||||
| b | Construct a pro forma income statement for the first fiscal quarter of 2012 and a pro forma balance sheet as of December 31, 2011. What is your estimated external financing required for December 31? | |||||||
| c | Does the December 31, 2011, estimated external financing equal your cash surplus (deficit) for this date from your cash budget? | |||||||
| d | Based on your answers above, construct a cash flow forecast for Noble for the period October through December 2011. | |||||||
| Noble Selected Information and Financial Statements | ||||||||
| Sales (20 percent for cash, the rest on 30-day credit terms): | ||||||||
| 2011 Actual | 2011Projected | |||||||
| July | August | September | October | November | ||||
| 76,000 | 88,000 | 266,000 | 125,000 | 51,000 | ||||
| Purchases (all on 60-day terms): | ||||||||
| 2011 Actual | 2011 Projected | |||||||
| July | August | September | October | November | ||||
| 116,000 | 122,000 | 257,000 | 62,000 | 27,000 | ||||
| Salaries payable monthly | 20,000 | |||||||
| Principal payment on debt due in December | 25,700 | |||||||
| Interest due in December | 9,000 | |||||||
| Dividend payable in December | 15,000 | |||||||
| Taxes payable in November | 19,000 | |||||||
| Addition to accumulated depreciation in December | 4,000 | |||||||
| Cash balance on October 1, 2011 | 35,000 | |||||||
| Minimum desired cash balance | 15,000 | |||||||
| Noble | ||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
