cash budgetCash BudgetCash BudgetCash Budgetcash budgetCash BudgetCash Budgetcash budgetcash budgetCASH BUDGETCash budgetcash budgetcash budgetCash BudgetCash budgetCash BudgetCash Budgetcash budgetcash budget

The Pots Company has obtained the following sales forecast data:January; cash $80,000, credit $240,000February; cash $70,000, credit $220,000March; cash $50,000, credit $180,000April; cash $60,000, credit $200,000The regular pattern of collection of credit sales is 20% in the month of the sale, 70%

The president of the retailer Prime Products has just approached the companys bank with a request for a $30,000, 90- day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan o

The treasurer of Systems Company has accumulated the following budget information for the first two months of the coming year:March AprilSales. $450,000 $520,000Manufacturing costs 290,000 350,000Selling and administrative expenses 41,400 46,400Capital additions 250,000 The company expects to sel

Required: Prepare a schedule of cash receipts for August and September.

Which in not a source of working capital?a. sale of non-current asset b. sale of current asset c. sale of additional shares of capital stock d.long-term borrowingplease do not guess

Use the following information to prepare the July cash budget for Anker Co. It should show expectedcash receipts and cash disbursements for the month and the cash balance expected on July 3l.a. Beginning cash balance on July 1: $63,000.b. Cash receipts from sales: 30% is collected in the month of sa

The controller of Santa Fe Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information:August September OctoberSales 630,000 715,000 845,000Manufacturing Cost 350,000 360,000 410,000Selling/Admin expenses. 170,000

it has to done with excel no hand calculation

The Sharpe Corporation: Detailed cash flow budget for the first seven months of 2004

The Sharpe Corporations projected sales for the first eight months of 2004 are as follows:January $90,000February &

Piano Man, Inc., has a 50-day average collection period and wants to maintain a minimum cash balance of $40 million, which is what the company
currently has on hand. The company currently has a receivables balance of $198 million and has developed the following sales and cash
disbursement budgets in millions:

Q1

Q2

Q3

Q4

Sales

$

459

$

531

$

612

$

576

Total cash disbursement

302

466

720

477

Required:

Complete the following cash budget for the company. (Do not include the dollar signs ($). Negative amounts should be
indicated by a minus sign. Enter your answers in millions of dollars. Round your answers to the nearest whole dollar amount (e.g.,
32).)

PIANO MAN, INC.
Cash Budget
(in millions)

Q1

Q2

Q3

Q4

Beginning receivables

$

$

$

$

Sales

459

531

612

576

Cash collections

Ending receivables

$

$

$

$

Total cash collections

$

$

$

$

Total cash disbursements

302

466

720

477

Net cash inflow

$

$

$

$

Beginning cash balance

$

$

$

$

Net cash inflow

Ending cash balance

$

$

$

$

Minimum cash balance

$

$

$

$

Cumulative surplus (deficit)

$

$

$

$

You may use any of the Additional Resources listed in the drop-down menu above to help you complete this activity, but you are not required to do so. To access each resource, click on its name in the drop-down menu above.The controller of Sedona Housewares Inc. instructs you to prepare a monthly cas

The use of working capital would:a. increase current assets or increase current liabilites. b.increase assets or decrease liabilities. c.decrease current assets or increase current liabilities. d. decrease assets or decrease liabilities.please do not guess

If sales of Pear Corporation totaled $500,000 for the current year (50,000 units at $10 each) and planned sales were $405,000 (45,000 units at $9 each), the affect of the unit price factor on sales is:a.$50,000 increase. b. $45,000 decrease. c. $45,000 increase.d. $50,000 decrease.please show work

QUESTION 1
The income statement and balance sheets for the year ended December 31, 2010 for Pineapple Valley, Inc. are given below. The company would like to apply term loan from your bank. As a financial analyst, you are required to review the financial ratios of the firm. Calculated below ratios for the company and compare it to the industry average ratios as below:
Current Ratio 1.72 times Acid Test Ratio 0.70 times Net working capital $60,400.00 Inventory Turnover 5.59 times Total Asset Turnover 1.

a. Prepare a cash budget for October, November and December, and state if the firm will be able to purchase the new equipment.

Johnson company is preparing a cash budget for June. The company has $12,000 cash at the beginning of June and anticipates $30,000 in cash receipts and $34,500 in cash disbursements during June. Johnson company has an agreement with its bank to maintain a cash balance of at least $10,000. As of May

Please use the Excel spreadsheet I have uploaded. Thank you!

If management is interested in utilizing its cash efficiently, it is considering a proposal which will incorporate seasonal cash balances. during heavy production months when needs are greatest, May company would have more cash on hand. conversely, in slower months the balance would be lowered. H

The Outturn Company, a merchandising firm, has budgeted its activity for July according to the following information: Sales at $550,000, all cash Inventory on June 30 was $300,000 July depreciation is budgeted for $35,000 Cash at July 1 was $25,000 selling and admin. expenses for July are budge