Question: FINANCIAL MODELLING IN EXCEL (100 points) You worked as a general accountant at Treasure Corporation, which operates in Australia. Your immediate supervisor asked you to

FINANCIAL MODELLING IN EXCEL (100 points) You worked as a general accountant at Treasure Corporation, which operates in Australia. Your immediate supervisor asked you to prepare a presentation of your company's performance in each state for the financial year 2015/16 to 2017/2018. The management of your company wanted to know which states have the highest and lowest sales for the said years. To effectively convey the operation's financial status, you were asked to create a visualization of the data. Procedures: 1. Open 08 Task Performance 1 Template.xlsx. 2. Study the data given. Afterward, create at least two (2) charts that would present the needed information of the management. 3. Title your charts as "Sales per State". 4. If all things are set, save your file output as "SURNAME_FMDTPW1718 and place it on the network drive

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

FINANCIAL MODELLING IN EXCEL (100 points) You worked as a general accountant at Treasure Corporation, which operates in Australia. Your immediate supervisor asked you to prepare a presentation of...

CAN YOU PLEASE HELP ME SOLVE THE QUESTION REFERENCING THE ANNUAL REPORT OF BILLABOG 2015 AND 2016. THANKS FEDERATION BUSINESS SCHOOL BUACC1508 ACCOUNTING AND FINANCE ASSESSMENT TASK 2: GROUP...

Case study introduction: Michael (49) and Sue (48) are married. Michael works as a Construction Manager earning $140,000 per annum plus Super Guarantee (SG) contribution. Sue is a part-time Brand...

It was 3 a.m. when the wake-up call startled Steve McKenzie out of deep sleep. McKenzie, a management consultant from New Jersey, was glad to be finally leaving the Bon Star Hotel, a three-star hotel...

AF 304 SEMESTER 2 - 2019 MAJOR ASSIGNMENT (15%) Due date: Friday 11th October 2019 @ 3.30pm with School of Accounting Secretary Audit Cases - A Practical Approach to Auditing 1.0 Introduction Audit...

Needing ANSWERS ASAP! Starting at pg 34 - Labeled Graded Project 06155200: Graded Project Instructions & Worksheets 1 Lesson 1: Business, Accounting, and You PROJECT GOAL The goal of this graded...

ATC 14-1 (Pg. 686) 1.(Follow the cash) In a narrative format, answer the questions posed in the case. 2.What is meant by "presentation of financial statement information in common-size amounts rather...

Financial Statement Analysis Part 1 As described in the project overview, Appendix A of your textbook describes several ratios, as well as vertical analysis and horizontal analysis of financial...

Please read the attachment chapters and answer the following questions with at least 50 words. Depreciation discussion What are the various methods of determining depreciation and amortization...

Prepare a statement of cash flows for Nosker Company using the direct method: NOSKER COMPANY Comparative Balance Sheets December 31 Assets 2020 2019 Cash $37,300 $19,100 Accounts receivable 32,700...

How does the preparation of a contribution margin income statement enhance cost behavior understanding and comparisons?

The credit for the elderly or disabled is intended to provide financial assistance to elderly or disabled individuals with modest incomes. Question 2 3 options: TrueFalse

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....