Q6: Consider the Industrial supply company example again.Assume that the company plans to maintain its dividend payment at the same level in 2014 as in 2013. Also assume that all of the additional financing needed is in the short-term notes payable. Work the pro forma analysis for 2014 under each of the following conditions. 1. Determine the amount of additional financing need 2. Work out pro forma financial statements (that is, balance sheet, income statement) case b change forecasting case a change in sales as 3,750.00 3,000.00 change in expense AExp 3,750.00 2,800.00 This is an extension to the class example. Please follow the explanation in the textbook. I have also included the template for you to work. You can to first replicate my results for case a, and apply the same logic to case b. In the worksheet, the numbers have been rounded into thousands. You can attach the excel worksheet for your Q6: Consider the Industrial supply company example again.Assume that the company plans to maintain its dividend payment at the same level in 2014 as in 2013. Also assume that all of the additional financing needed is in the short-term notes payable. Work the pro forma analysis for 2014 under each of the following conditions. 1. Determine the amount of additional financing need 2. Work out pro forma financial statements (that is, balance sheet, income statement) case b change forecasting case a change in sales as 3,750.00 3,000.00 change in expense AExp 3,750.00 2,800.00 This is an extension to the class example. Please follow the explanation in the textbook. I have also included the template for you to work. You can to first replicate my results for case a, and apply the same logic to case b. In the worksheet, the numbers have been rounded into thousands. You can attach the excel worksheet for your