Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You will need to submit a report to present your analysis and recommendation to your manager. The report should not exceed 1,500 word (excluding references,
You will need to submit a report to present your analysis and recommendation to your manager. The report should not exceed 1,500 word (excluding references, table/figures and ratio worksheets). You are to submit two documents consisting of a word document and an excel spreadsheet. The report will be submitted as a word document and the calculations of the ratios and any other financial analysis will be submitted as an excel spreadsheet. The excel spreadsheet will not count towards the 1,500 word limit. 2 Assessment Task You are a newly recruited graduate for a company that provides financial advice and services in the Launceston Area. The name of your employer is "Finesse Financial Services". Your manager has given you an assignment. She has been approached by a couple who have recently retired and have opted to withdraw their entire superannuation monies. They are interested in investing $150,000 of their superannuation into the ASX and are particularly interested in a Tasmanian company called Tassal. The couple have come to Finesse Financial Services for advice on whether the company is a good investment especially during this time when there is so much uncertainty regarding COVID-19. Your manager sends you the following email: "Dear X, I trust you're settling in well with the new job. I have for you your first assignment. A couple who have just withdrawn their entire super are thinking of investing $150,000 into Tassal Ltd (ASX Code: TGR). They seem to be quite risk averse but they heard from some of their friends that this is the best time to buy shares as prices have never been so low. I think they've probably got a case of FOMO so they're coming to us for some financial advice. They're particularly worried about how the company will fare after COVID-19. I want you to perform a financial analysis of Tassal based on their two most recent annual reports (would be great if the 2020 report is available but I'm not sure if it's out). I don't want more than 16 ratios in your analysis so choose wisely. I also want you to compare with an industry benchmark. You can use an industry average or another company that you think is a useful comparison. Just use one benchmark and explain why you chose this benchmark and if there are any caveats in using this benchmark for comparisons. No benchmark is perfect, I'm more interested in understanding why you chose that benchmark and the shortcomings of that benchmark. If you do choose another company as the basis of your comparison you will have to perform the same set of financial statement analysis on that company and compare with Tassal Ltd. Also, I want you to make an assessment and this could be a qualitative one on your opinion of the impact of COVID-19 on Tassal in the future. This is a complicated question, and one that I myself am struggling with but I think we can't avoid thinking about COVID-19 even if there is still so much we don't know and can't quantify. Please support your assessment with relevant references to articles/reports/academic articles. After you've compiled the analysis based on financial data and your assessment of the impact of the COVID-19, I want you to prepare a recommendation for the couple based on their preferences. Remember they're a retired couple so they're looking for a safe investment and one that also provides them a healthy and stable return. And they've also picked Tassal because they are proud Tasmanians and want to invest in a Tasmanian company listed on the ASX. So if you can identify a better company that meets these requirements then please feel free to recommend it maybe it'll be good to use it as a benchmark then...just a thought). If you feel that right now is not the best time to invest in the stock market or there could be a better financial product then you can make that recommendation along with a few sentences to support your conclusion. Please prepare this in a report and submit your calculation on a separate excel spreadsheet and any other analysis so that I can check your calculations and working. I had a bad experience with a recent graduate who didn't know how to use excel properly and his numbers made no sense but I'm sure you won't disappoint me. You can also work on this assignment with the other two new graduates or with just one of them or if you can do it by yourself. We don't have much work at the moment and I think the most important thing is for you graduates to gain as much experience and to learn how to work together. But I understand that sometimes working in a group can be even more difficult. If you do work in a group please indicate who did what in the report. I'm interested to see how the work is shared and the strengths in the group. So I'm looking forward to reading your report and reviewing your analysis. Please keep the written report to a maximum of 1,500 words and use appropriate references. I encourage the use of headings to add structure to the report and also tables and graphs to aid in the analysis. Cheers, Manager Y Prepare a report in Microsoft Word based on the manager's expectations along with an excel spreadsheet for the working of any financial analysis that you perform. 3 Submission of Answers You will need to submit a report to present your analysis and recommendation to your manager. The report should not exceed 1,500 word (excluding references, table/figures and ratio worksheets). You are to submit two documents consisting of a word document and an excel spreadsheet. The report will be submitted as a word document and the calculations of the ratios and any other financial analysis will be submitted as an excel spreadsheet. The excel spreadsheet will not count towards the 1,500 word limit. 2 Assessment Task You are a newly recruited graduate for a company that provides financial advice and services in the Launceston Area. The name of your employer is "Finesse Financial Services". Your manager has given you an assignment. She has been approached by a couple who have recently retired and have opted to withdraw their entire superannuation monies. They are interested in investing $150,000 of their superannuation into the ASX and are particularly interested in a Tasmanian company called Tassal. The couple have come to Finesse Financial Services for advice on whether the company is a good investment especially during this time when there is so much uncertainty regarding COVID-19. Your manager sends you the following email: "Dear X, I trust you're settling in well with the new job. I have for you your first assignment. A couple who have just withdrawn their entire super are thinking of investing $150,000 into Tassal Ltd (ASX Code: TGR). They seem to be quite risk averse but they heard from some of their friends that this is the best time to buy shares as prices have never been so low. I think they've probably got a case of FOMO so they're coming to us for some financial advice. They're particularly worried about how the company will fare after COVID-19. I want you to perform a financial analysis of Tassal based on their two most recent annual reports (would be great if the 2020 report is available but I'm not sure if it's out). I don't want more than 16 ratios in your analysis so choose wisely. I also want you to compare with an industry benchmark. You can use an industry average or another company that you think is a useful comparison. Just use one benchmark and explain why you chose this benchmark and if there are any caveats in using this benchmark for comparisons. No benchmark is perfect, I'm more interested in understanding why you chose that benchmark and the shortcomings of that benchmark. If you do choose another company as the basis of your comparison you will have to perform the same set of financial statement analysis on that company and compare with Tassal Ltd. Also, I want you to make an assessment and this could be a qualitative one on your opinion of the impact of COVID-19 on Tassal in the future. This is a complicated question, and one that I myself am struggling with but I think we can't avoid thinking about COVID-19 even if there is still so much we don't know and can't quantify. Please support your assessment with relevant references to articles/reports/academic articles. After you've compiled the analysis based on financial data and your assessment of the impact of the COVID-19, I want you to prepare a recommendation for the couple based on their preferences. Remember they're a retired couple so they're looking for a safe investment and one that also provides them a healthy and stable return. And they've also picked Tassal because they are proud Tasmanians and want to invest in a Tasmanian company listed on the ASX. So if you can identify a better company that meets these requirements then please feel free to recommend it maybe it'll be good to use it as a benchmark then...just a thought). If you feel that right now is not the best time to invest in the stock market or there could be a better financial product then you can make that recommendation along with a few sentences to support your conclusion. Please prepare this in a report and submit your calculation on a separate excel spreadsheet and any other analysis so that I can check your calculations and working. I had a bad experience with a recent graduate who didn't know how to use excel properly and his numbers made no sense but I'm sure you won't disappoint me. You can also work on this assignment with the other two new graduates or with just one of them or if you can do it by yourself. We don't have much work at the moment and I think the most important thing is for you graduates to gain as much experience and to learn how to work together. But I understand that sometimes working in a group can be even more difficult. If you do work in a group please indicate who did what in the report. I'm interested to see how the work is shared and the strengths in the group. So I'm looking forward to reading your report and reviewing your analysis. Please keep the written report to a maximum of 1,500 words and use appropriate references. I encourage the use of headings to add structure to the report and also tables and graphs to aid in the analysis. Cheers, Manager Y Prepare a report in Microsoft Word based on the manager's expectations along with an excel spreadsheet for the working of any financial analysis that you perform. 3 Submission of Answers
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started