Question: Would someone be able to explain how they got the numbers for the answers in this question? The question is in the link sent below

Would someone be able to explain how they got the numbers for the answers in this question?

The question is in the link sent below

http://www.chegg.com/homework-help/questions-and-answers/chapter-3-problem-14-using-information-provided-construct-monthly-cash-budget-october-dece-q4395584

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?
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?
Does the December 31, 2011, estimated external financing equal your cash surplus (deficit) for this date from your cash budget?
Based on your answers above, construct a cash flow forecast for Noble for the period October through December 2011.
Sales (20 percent for cash, the rest on 30-day credit terms):
2011 Actual 2011Projected
July August September October November December
76,000 88,000 266,000 125,000 51,000 53,000
Purchases (all on 60-day terms):
2011 Actual 2011 Projected
July August September October November December
116,000 122,000 257,000 62,000 27,000 26,000
20,000
25,700
9,000
15,000
19,000
4,000
35,000
15,000
Noble
Annual Income Statement
Fiscal Year ended September 30, 2011 ($ 000)
1,581.6
1,098.0
483.6
240.0
18.0
16.0
209.6
69.2
140.4
Noble
Balance Sheet
September 30, 2011 ($ 000)
34.0
212.8
425.0
671.8
135.0
52.0
83.0
754.8
0.0
379.0
55.0
25.7
56.0
515.7
120.0
119.1
754.8
Would someone be able to explain how they got the numbers for

the answers in this question? The question is in the link sent

below http://www.chegg.com/homework-help/questions-and-answers/chapter-3-problem-14-using-information-provided-construct-monthly-cash-budget-october-dece-q4395584 Using the information provided, construct a monthly cash budget for

October through December 2011. Based on your analysis, will Noble enjoy a

a your analysis, will Noble enjoy a surfeit of cash, or require external financing? Cash Budget October November December 4 opening Balance 35,000.00 130,800.00 15,000.00 6 Cash Collection Cash sales 25,000.00 10, 200.00 10,600.00 7 Credit Sales 212,800.00 100,000.00 40,800.00 8 10 Cash Disbursement 122,000.00 257,000.00 62,000.00 11 Purchase 12 Salaries payable 20,000.00 20,000.00 20,000.00 13 Principal Payment 25,700.00 14 Interest Payment 9,000.00 15 Dividend payable 15,000.00 16 Taxes Payable 19,000.00 17 18 Net surplus 130,800.00 55,000.00 65,300.000 19 Minimum Desired Cash Balance 15,000.00 15,000.00 15,000.00 20 Repayment of Financing 21 External Financing 70,000.00 80,300.00 22 23 Closing Balance 130,800.00 15,000.00 15,000.00

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 Finance Questions!