analyse financial and business performance information: Using formulas Practice: Calculates basic financial ratios using sample data Discuss: Reporting periods for different entities (research ATO website) 6-7 Accessing and managing financial services information Accessing financial product and services information Interpreting documentation Methods of presenting financial data Understanding principles of financial reporting Using Excel to process financial information Key Excel Formulas and Functions:
SIT50116 | SITXFIN002 Interpret Financial Information Learner’s Guide| V 2.0 | Apr 2018 Macquarie Education Group Australia Pty Ltd t/a MEGA | RTO Code 91305 | CRICOS Code 02657J Approved by: CEO | Next Review: Dec 2018 Page 14of 46Using excel formulas AutoSum Financial Logical: AND, IF, NOT, OR, TRUE, FALSE Analysing financial information using Excel Examples and demonstration Excel practice: Create and format worksheets using various menu options Review complex excel spreadsheet examples Search and sort data values Determining and confirming reliability and accuracy of financial data Determining organisational procedures, statutory requirements and standard financial reporting principles in preparing financial statements Analysing revenues and costs using a range of techniques use of financial information and reports in monitoring overall business performance Understanding standard financial analysis techniques Evaluating profitability, efficiency and financial stability: Key ratio analyses Assessing financial potential of the business, future funding requirements and statutory obligations Research: Research online and find a policy document relevant to financial document preparation: Share and compare within your group 10 Review and revision Student Q&A Assessment feedback and follow up
SIT50116 | SITXFIN002 Interpret Financial Information Learner’s Guide| V 2.0 | Apr 2018 Macquarie Education Group Australia Pty Ltd t/a MEGA | RTO Code 91305 | CRICOS Code 02657J Approved by: CEO | Next Review: Dec 2018 Page 15of 46Suggested Learner Resources Elliott B., 2017, Financial Accounting and Reporting, Pearson CPA Australia, 2015, Accounting Handbook 2015, Pearson Other Resources Titman S. et al, 2017, Financial Management, Global Edition, Pearson Euan S., 2013, Computer Accounting: A Systematic Approach Using MYOB®, Pearson Frye C., Microsoft Excel 2016 Step by Step, Pearson Uniware: Microsoft Dynamics NAV: Sage MyBusiness: Australian Accounting Standards Board: Changes in Australian accounting standards: -accounting-standards Accounting Principles: CPA Australia: Misc. Videos and Online Channels Khan Academy Channel #Education
You've reached the end of your free preview.
Want to read all 46 pages?
- One '17
- ........., Formative assessment, Summative assessment, Macquarie Education Group Australia Pty Ltd