There will be information and income statement of a company

There will be information and income statement of a company provided, and thenPrepare: (Detailed in attached documents)1. An estimated income statement showing the effects of the expected transactions for the second quarter and the third quarter.2. Forecasts of collections from accounts receivable by months and of disbursements by months.3. A summary cash statement, showing the amount of bank loans and the repayment of them; this statement should also show the expected cash balance at September 30.4. An estimated balance sheet showing the expected financial position of the company.5. Upon completion, make a complete comparative financial analysis.The sheets are required in both a Word Document and an Excel Document.The financial analysis is required in Word.