Company: IBM

*You may find data from investing.com or yahoo finance.

Q1) By using the financial statements of company which is assigned to you for the last three years (2018, 2019, 2020 and 2021)

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). (IN EXCEL)

b) Find the external funds needed. (IN EXCEL)

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

d) For this part use financial ratios to describe and investigate your company. In a separate sheet in atextboxwrite downyour comments(in your own words)about thecompany financials and the industryto which your company belongs. You may elaborate your findings considering economic conditions and expectations. (Providing reference is highly encouraged.)