solve in excel with formulas

Consider the following simplified financial statements for the Wims Corporation (assuming no income taxes): The company has predicted a sales increase of 15 percent. Assume Wims pays out half of net income in the form of a cash dividend. Costs and assets vary with sales, but debt and equity do not. Prepare the pro forma statements. (Input all amounts as positive values. Do not round intermediate calculations.) Determine the external financing needed. (Do not round intermediate calculations, A negative answer should be indicated by a minus sign.)