Hi, Can you please answer this question and please attatch the excel file to this or if not possible can you email it to maybejames2411 at outlook dot com

I will make sure to leave a postive feedback for you

10. The actual sales and purchases for White Inc. for September and October 2006, along with its forecast sales and purchases for the November 2006 through April 2007, follow.

The firm makes 30 percent of all sales for cash and collects 35 percent of its sales in each of the two months following the sale. Other cash inflows are expected to be $22,000 in September and April, $25,000 in January and March, and $37,000 in February. The firm pays cash for 20 percent of its purchases. It pays for 40 percent of its purchases in the following month and for 40 percent of its purchases two months later. Wages and salaries amount to 15 percent of the preceding months sales. Lease expenses of $30,000 per month must be paid. Interest payments of $20,000 are due in January and April. A principal payment of $50,000 is also due in April. The firm pays cash dividend of $30,000 in January and April. Taxes of $120,000 are due in April. The firm also intends to make a $55,000 cash purchase of fixed assets in December. Assuming that the firm has a cash balance of $25,000 at the beginning of November and its desired minimum cash balance is $25,000, prepare a cash budget for November through April and determine the cash surplus/deficit for each month.

Year Month Sales Purchases 2006 September $310,000 $220,000 250,000 240,000 200,000 180,000 210,000 200,000 190,000 2006 October 350,000 2006 November 270,000 2006 December 260,000 240,000 00 300,000 350,000 2007 January 2007 February 280,0 2007 March 2007 April