Highlights
Please read the scenarios below and answer the questions or complete the activities that follow. Should you have any questions please do not hesitate to contact to your trainer. Financial Modelling
Scenario 1:
You work for Australian Super, one of Australia’s largest super funds. This Superannuation Fund is committed to passing on all good things that size has to offer. The vision of this organization is:” Every Australian should have a solid financial future, so our purpose is to help achieve better retirement outcomes for all”.
Australian Super is committed to providing quality service by employing managers and specialist staff in- house and complements their expertise with external service providers. Your manager has asked you to prepare a comprehensive financial model for the purpose of determining where $100 million dollars will be invested. The Strategic Plan for Australian Super over the next 3 years is the achieve 10% return on investment. Your task is to choose 2 ASX listed companies from the list below. Using Microsoft Excel prepare a financial model to determine the value and ongoing viability of both companies for a period of 3 years. Make your recommendations as to your preferred organization and explain your reasons.
1. Develop an asset pricing model to determine the required or expected rate of return on the assets
2. Determine the value in relation to the capital structure of both companies.
3. Determine in the theoretically appropriate rate of return will be 10% over the 5 years’ period from the purchase of shares in the organization.
4. The model should take into account the asset’s sensitivity to non- diversifiable risk, as well as the expected return of the market and the expected return of a theoretical risk- free asset.
5. Detailed market analysis and other information to the support projected numbers
6. Consider how the economic and political climate might relate to the financial industry when undertaking financial modeling. ASX Listed companies include:
Woolworths Ltd
Lend Lease Group
Toll Holdings
Goodman Groups
Qantas Airway
This FNS60217: Accounting Assessment has been solved by our Accounting experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.