Please form an excel spreadsheets of your own for each of the following questions and answer the questions accordingly. By using the financial statements of raytheon technologies company for the last three years (2017, 2018, and 2019):

a) Make the financial planning and forecast the financial statements (balance sheet, income statement, cash flow statement) for the next three years by using the percentage of sales method and by making the necessary assumptions (for interest rates on loans; growth rates, tax rates etc).

b) Find the external funds needed.

c) Estimate how sensitive the external funds needed to changes in your growth rate assumption.