Lulus Lemons Ltd. sells vehicles. The company is planning its cash needs for the month of January, 2015. In the past, Lulus has had to borrow money during the post-Christmas season to offset a significant decline in sales. The following information has been assembled to assist in preparing a cash flow forecast for January.

January 2015 income statement:

Sales $500,000

Cost of goods sold 350,000

Gross profit 150,000

Variable selling expenses $25,000

Fixed administrative expenses 30,000 55,000

Forecast net operating income $95,000

Sales are 100% on credit.

Credit sales are collected over a three-month period: 30% is collected in the following month, 20% in the second month following sale, and 40% in the third month following sale. 10% of sales revenue is never collected. October 2014 sales totaled $600,000. November sales totaled $600,000 and December sales totaled $700,000.

100% of a months inventory purchases are paid in the following month. Accounts payable relate solely to inventory purchases. At December 31, accounts payable totaled $422,500.

The company maintains its ending inventory levels at 150% of the cost of the merchandise to be sold in the following month. The merchandise inventory at December 31, 2014 was $525,000. February 2015 sales are budgeted at $400,000. Gross profit is expected to decline from the usual 30% to 25%.

The company pays $10,000 cash dividends to shareholders each month.

The cash balance at December 31 was $30,000; the company must maintain a cash balance of at least this amount at the end of each month.

The company can borrow and repay its operating loan in increments of $10,000 at the end of each month, up to a total loan balance of $500,000. The interest rate on this loan is 1/2% per month. The operating loan balance at December 31 is $50,000.

Required: Prepare a cash flow forecast for Lulus for January 2015, formatted as in chapter 10 of the managerial accounting text. Include appropriate supporting schedules.