Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due

Business Analytics and Data Visualisation (ECOM5005)

Video Presentation – Singapore Trimester 2, 2024

Return on assets (ROA) is a financial metric commonly used to assess a company's profitability relative to its asset base or how efficiently the company leverages its assets to generate profit. It is determined by dividing the company's net income by its total assets. The ROA value provides management, analysts, and investors with insights into the effectiveness of the company's resource utilization.

As a market analyst, you aim to explore the factors that could influence a company's ROA. To conduct this analysis, you have gathered data from the Capital IQ database for U.S. companies listed in the S&P 500 Index. The data, covering the financial year ending June 2024, is provided in the accompanying Excel file“VP_data_2024_Tri2A.xlxs”.

• ROA: Return on Assets (ROA) reflects a company’s profitability relative to its total assets. It is computed by dividing net income by total assets.

• Total Revenue: The total revenue a company generates from selling its products and services.

• Total Operating Expenses: The overall costs a business incurs during its regular operations, such as marketing, rent, payroll, insurance, inventory expenses, and funds allocated to research and development (R&D).

• Cash and Equivalents: refers to items on the balance sheet that represent the value of a company's assets that are either in cash form or can be quickly converted to cash. Examples include bank accounts and marketable securities, such as commercial paper and short-term government bonds with maturities of less than 90 days.

• Total Liabilities/ Total Assets %: this ratio, also known as the debt ratio, measures the proportion of a company’s assets that are financed through debt.

You are required to perform a regression analysis to predict which factors (i.e., total revenue, total operating expenses, total cash and equivalents, and the ratio of total liabilities over total assets) can predict return on assets (i.e. ROA) by answering the following questions:

1. Which of the variable(s) is (are) significant in predicting a company’s ROA?

2. Is the regression model useful?

3. Are the errors, i.e. the residuals of the regression analysis, independent?

Note: You should consider to transform the variables if they are not in the same scales (i.e. one variable is too big compared to others).

DUE DATE

Your video presentation is due on Friday 20th September 2024 at 5pm.

• You should upload the video presentation to Echo360 and submit its public website link via Blackboard. Please see the following file for details.

“ECOM5005_Instructions_upload_video_Echo360_and_BBsubmission.pdf”

• A copy of your Excel workings is required to submit with the Echo360 link of your video presentation.

o When submit to Blackboard, the name of your Excel file should be

“YourStudentID_LastName_Excel.xlxs”

If your video presentation is not submitted by the due date,

• a deduction of 5% of the total marks allocated for the video presentation (i.e. 1.25 marks) will be deducted from the assessment mark if they are submitted within the first 24 hours of the due date,

• for each additional 24-hour period, an additional penalty of 10% of the total marks allocated (i.e. 2.5 marks) will be deducted from the assessment mark, and

• zero mark will be recorded after seven (7) days from the due date.

Mark allocation of the video presentation:

• The total mark for the video presentation is 30 (account for 30% of final marks)

o 15 marks are for the video content

 Derive to final sample (after removing observations without data)

 How to obtain the regression results in Excel

 Correct answer for 3 questions

 Correct Excel outputs

o 15 marks are fore the video presentation.

 Presentation with the structure outlined in the requirement document

• Logical structure of the presentation and maintain interest

• Expect to have a combination of

o Excel screen

o Results on powerpoint slides

• Student’s face must be in the video at all times

 Video editing technique

 Timing