perform a regression analysis to predict which factors can impact the level of firm financial distress (i.e. Altman Z-score) by answering the following questions1. When it comes to forecasting a company’s financial distress, which variable(s) has (have) significant impact(s)? 2. Are the errors of the regression independent? 3. Is the regression model useful? A copy of Excel workings is requiredA copy of draft of the presentation is required

Business Analytics and Data Visualization Presentation – Trimester 2A, 2023 When a company cannot generate enough revenue to cover its financial obligations, especially loan payments to creditors, it is in a state of financial distress. This situation can ultimately lead to bankruptcy if it is severe and prolonged. As a market analyst, you are curious about the elements that can lead to a company’s financial difficulties. To conduct the investigation, you obtain the following data for the financial year 2022 from Capital IQ database for US companies in the S&P500 Index. • Altman Z-score: This score, developed by Professor Edward Altman1 in 1968, measures a company’s level of financial distress. It takes into account factors such as profitability, leverage, liquidity, and insolvency. debt ratio). This ratio indicates the proportion of a company’s assets which is financed through debt. revenue minus all expenses, including cost of goods sold, operating expenses, taxes, and more. to its total assets. It is calculated as net income divided by total assets.Use the above data, you are required to perform a regression analysis to predict which factors can impact the level of firm financial distress (i.e. Altman Z-score) by answering the following questions1. When it comes to forecasting a company’s financial distress, which variable(s) has (have) significant impact(s)? 2. Are the errors of the regression independent? 3. Is the regression model useful? A copy of Excel workings is requiredA copy of draft of the presentation is required