Question

In: Accounting

Please create a monthly (or semester) cash flow budget that would seem appropriate for a college...

Please create a monthly (or semester) cash flow budget that would seem appropriate for a college student.

Solutions

Expert Solution

A cash budget is basically a plan of estimated cash inflows and outflows during a specific period. It is a very useful planning tool, so that one can know his financial position for specifit time in future. I am uploading both image format and table format for youe convenience.

Student Name
Cash Budget
For the Four Months Ending December 31
September October November December
Estimated cash receipts from:
Part-time job $     800.00 $   800.00 $   800.00 $            800.00
Rent Deposit $            400.00
Pocket Money - Parents $     200.00 $   200.00 $   200.00 $            200.00
Scholarship $3,000.00
Total cash receipts $ 1,000.00 $1,000.00 $4,000.00 $         1,400.00
Less estimated cash payments for:
Season football tickets $       90.00
Additional entertainment $     220.00 $   220.00 $   220.00 $            220.00
Tution $ 3,500.00
Rent $     310.00 $   310.00 $   310.00 $            310.00
Food $     180.00 $   180.00 $   180.00 $            180.00
Rent Deposit $     400.00
Library $     150.00 $   150.00 $   150.00 $            150.00
Books $     120.00 $      90.00
Total cash payments $ 4,970.00 $   860.00 $   950.00 $            860.00
Cash increase (decrease) $-3,970.00 $   140.00 $3,050.00 $            540.00
Plus cash balance at beginning of month $ 6,470.00 $2,500.00 $2,640.00 $         5,690.00
Cash balance at end of month $ 2,500.00 $2,640.00 $5,690.00 $         6,230.00

Related Solutions

Question 3: Please create a statement of cash flow with indirect method- Please provide answers to...
Question 3: Please create a statement of cash flow with indirect method- Please provide answers to each category and a one paragraph analysis of the cash flow using the indirect method. Statement of Cash Flow with Indirect method 2011 2010 Difference Operating Investing Financing ASSETS: Current Assets Cash and equivalents $ 2,291.1 $ 2,133.9 Short-term investments    1,164.2       642.2 Account receivable    2,883.9    2,795.3 Inventory    2,357.0    2,438.4 Prepaid expenses and other assets       765.6       602.3...
Uneven Cash Flow Stream Find the present values of the following cash flow streams. The appropriate...
Uneven Cash Flow Stream Find the present values of the following cash flow streams. The appropriate interest rate is 10%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that,...
Uneven Cash Flow Stream Find the present values of the following cash flow streams. The appropriate...
Uneven Cash Flow Stream Find the present values of the following cash flow streams. The appropriate interest rate is 6%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that,...
Uneven Cash Flow Stream Find the present values of the following cash flow streams. The appropriate...
Uneven Cash Flow Stream Find the present values of the following cash flow streams. The appropriate interest rate is 6%. Round your answers to the nearest cent. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $119,000 $151,000 $190,000 Manufacturing costs 50,000 65,000 68,000 Selling and administrative expenses 42,000 45,000 72,000 Capital expenditures _ _ 46,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $129,000 $164,000 $213,000 Manufacturing costs 54,000 71,000 77,000 Selling and administrative expenses 37,000 44,000 47,000 Capital expenditures _ _ 51,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the...
Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget...
Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: January February March Sales $89,000 $105,000 $144,000 Manufacturing costs 37,000 45,000 52,000 Selling and administrative expenses 26,000 28,000 32,000 Capital expenditures _ _ 35,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 70% are expected to be collected in full in the month...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: March April May Sales $130,000 $155,000 $205,000 Manufacturing costs 55,000 67,000 74,000 Selling and administrative expenses 38,000 42,000 45,000 Capital expenditures _ _ 49,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $126,000 $160,000 $205,000 Manufacturing costs 53,000 69,000 74,000 Selling and administrative expenses 37,000 43,000 45,000 Capital expenditures _ _ 49,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $120,000 $146,000 $197,000 Manufacturing costs 50,000 63,000 71,000 Selling and administrative expenses 35,000 39,000 43,000 Capital expenditures _ _ 47,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 65% are expected to be collected in the month following the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT