# Assignment

Computing Skills Assignment Help

### TFIN205 Financial Forecasting and Data Analysis

Rating:

TFIN205– Financial Forecasting and Data Analysis

Major Assignment 20%

Group Assignment Guidelines

2019, Semester 2

Dr.Omar Aziz

omar.aziz@top.edu.au

Due Date: Week 10 at the day of the lecture at 3 pm.

Assessment Value: 20%

Topic: Financial performance analysis and forecasting.

Length: 1000 words maximum

Information about obtaining the data needed for the assessment

The students will be allocated in a group of 1 or 2 students in week 6 of teaching. In week 6, financial statements will be given to each group.

Required

This group assignment requires the analysis of the financial position and performance of your assigned company for the previous three financial years (2016, 2017 and 2018). The assignment also requires forecasting 2020 income statement. This involves answering the following questions in your own words (i.e. do not simply “cut and paste” information from the Annual Report or any other source). You must apply critical thinking when you are answering the questions, not only write the numbers without discussion about its indication, use references to support your answers.

Based on the information obtained from your assigned company, answer the following questions:

QUESTION 1:

Analyse the liquidity position of your company in 2019 compared to 2018 and 2017. Calculate the values for two liquidity ratio. Ensure that you analyse in this question, not just describe the ratio values. Create a X Y Scatter chart with straight lines and markers in Excel for your results with clear indication on axis’ titles.

(maximum 100 words)

QUESTION 2:

Analyse the efficiency position of your company in 2019 compared to 2018 and 2017. Use two efficiency ratios, the inventory turnover and average collection period. Ensure that you analyse in this question, not just describe the ratio values. Create a X Y Scatter chart with straight lines and markers in Excel for your results with clear indication on axis’ titles.(maximum 100 words)

QUESTION 3:

Analyse your company’s leverage ratio in 2019 compared to 2018 and 2017. Use two leverage ratios to support your answer which are total debt ratio and long-term debt ratio. Ensure that you analyse in this question, not just describe the ratio values. Create a X Y Scatter chart with straight lines and markers in Excel for your results with clear indication on axis’ titles.(maximum 100 words)

QUESTION 4:

Analyse your company’s profitability in 2019 compared to 2018 and 2017. Use two profitability ratios to support your answer which are gross profit margin and return on total assets. Ensure that you analyse in this question, not just describe the ratio values. Create a X Y Scatter chart with straight lines and markers in Excel for your results with clear indication on axis’ titles.(maximum 100 words)

QUESTION 5:

Depending on the above questions’ results, using Excel application only, make a table summarizing all the financial ratios’ groups that you have calculated and create Sparkline charts next to each ratio, then put and show these tables and charts in the word file where you are writing your assignment. Write your final report about your company performance during these years. What do you think? Was it good or bad? Why?(maximum 400 words)

QUESTION 6:

Now,  using only  2019  and  2018  years  of  your  company information,  forecast  the income

#### Details

• Number of views:
307
• PRICE :
AU\$ 150.00

BROWSE

### Our Top Experts

Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...

55 - Completed Orders

Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...

52 - Completed Orders

Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...

102 - Completed Orders

To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...

109 - Completed Orders

JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...

202 - Completed Orders

Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...

20 - Completed Orders

Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...

100 - Completed Orders

Personal Profile Dedicated and highly experienced private chauffeur. High energy, hardworking, punctua...

200 - Completed Orders