Bridge Water Pumps and Filters requires $500,000 for a plant expansion. Some of this funding will come from operations (the equity owners contribution from the addition to retained earnings), some from changes in the companys current assets and current liabilities, and the remainder through debt via a bank loan. The lending bank wants the current balance sheet and a pro forma balance sheet for the coming year as part of the documents for the loan application. Prepare the pro forma balance sheet with the following assumptions and targets, and determine the needed increase in long-term debt for the coming year.