首页 > 其他分享 >ACCT3003: Accounting Modelling and Data

ACCT3003: Accounting Modelling and Data

时间:2024-09-13 17:55:42浏览次数:10  
标签:Please Assignment Excel two Modelling machine Accounting Data your

ACCT3003: Accounting Modelling and Data Visualisation

Folio Assignment Guide, Semester 2, 2024

Due Date for Submission: Sunday 15/9/2024 at 5.00 PM

Please note that the Practical Assignment for ACCT3003 Accounting Modelling and Data Visualisation is an individual assessment task worth 40% of your total marks in the unit. Please refer to the online marking rubric for an explanation of how individual marks will be allocated for this assessment task. The assignment is to be submitted online through the Blackboard “Assessment” folder.

High standards of academic integrity are expected. You are referred to the URL link provided in the ACCT3003 Unit Outline (see: Academic Integrity Website) for further information on Academic Integrity and originality.

No Turnitin submission is required for the Practical Assignment file because it is not a written submission, but an original Microsoft Office 365 / Excel Assignment.

 

VIVAS

To detect any academic misconduct, we will conduct vivas (i.e. short interviews with some students) on the assignment. Students will be randomly selected.

Interviews will be held face to face or using Blackboard Collaborate.

Required:

Question 1: Interactive Dashboard / Financial Statement Analysis                             (20 marks)

(a)     Using the Curtin University library link to: DatAnalysis Premium (Morningstar) Database. Download the 10-year comparative Ratio Analysis (see Financials folder) for any two (2) Australian listed company that you have been allocated. Please see the attached list of allocated companiesand ASX codes.

Save the original downloaded ratio analysis data for each company in the first worksheet in your Excel workbook. No marks are allocated for this task.

(b)    Using Microsoft Office 365 / Excel, 代 写ACCT3003: Accounting Modelling and Dataprepare a single interactive dashboard of the key ratios that you feel would help an analyst to evaluate the financial performance of the two companies.

The dashboard should be based on the 10-year comparative ratio analysis workbook (where possible) that you have downloaded in Part (a) above.

Please select any four ratios from the following categories: Liquidity, Asset Management, Leverage / Debt Management, Profitability, Cash Flow and Market Based Ratios.

In addition, to the four ratios selected, students are also required to calculate the Altman Z score for the two companies allocated.

The single Dashboard should contain, at a minimum: 1) two different chart types; 2) images of company brand and other graphical images related to each company’s business; 3) filters for data in your charts to engage user interaction with your Dashboard; and 4) Title and text boxes to explain the charts and diagrams in your Dashboard. (15marks).

(c) Using Microsoft Office / Excel 365 STOCKHISTORY and FORECASTING functions available, prepare a line graph of the weekly share price history (from 1/7/2022 to

30/6/2024) for any two (2) listed companies that you have been allocated (separate graphs).  Forecast the share price for the next 6 months (i.e., 31/ 12/2024).  Please note, graphs should also include a trendline and formula. Predicted weekly share price figures should be shown using the FORECAST SHEET function or FORECAST formula function available. (5 marks).

Question 2: Capital Evaluation (8 marks)

Ingenious Devices, Inc. is considering a replacement for its damaged old cutting machine with a

new laser cutting machine. Repairing this machine would cost $5,700. Management has requested information about two new machines from two different vendors. The old machine has no salvage value. The estimated after-tax cash flow associated with the old machine for the next year is $2,000 and the firm expects that this cash flow will grow at a rate of 12% per year over the next four years. The first model of the new laser cutting machine has a price of $8,000 and the firm expects to generate after-tax cash flows of $3,000 with this machine for the next four years. These cash flows will grow at an annual rate of 15% over the next four years. Finally, the second model of the new laser cutting machine has a selling price of $9,000 and the firm expects to produce after-tax cash flows of $3,500 for the next year. This cash flow will grow at a rate of 5% per year over the next four years. If the firm’s WACC is 14% and its reinvestment rate is 10%, determine the following:

Required:

a)   Create an after-tax cash flow statement for the first model, second model and to repair the old machine. Compare the alternatives.

b)  Calculate the payback, discounted payback, NPV, PI, IRR, and MIRR of the replacement project. Compare old machine with first and second models?

Question 3: Excel Case Study: APAC Data Model (12 marks)

Case study detail: – imagine you are a recently appointed graduate accountant in APAC International Limited and your manager has asked you to investigate the overall sales and profitability for the company and to identify key areas for improvement and present your findings to the board. Using Microsoft Office 365 / Excel and the APAC Data Model provided (see Assessment folder), prepare a two-page interactive dashboard ofyour findings and recommendations. Your analysis should include all areas: customers, products and regions (i.e. locations). Please note, remember to select data model when creating and inserting pivot tables.

The visualisations should contain, at a minimum: 1) two interactive dashboards; 2) different chart types, and tables; 3) calculated fields; 4) filters for data in your visualisations to engage user interaction with visualisation; and 5) Title and text boxes to explain the charts and diagrams in your visualisations.

Format Requirements and marking note:

The Foliol Assignment task must be submitted online as one MS Excel workbook file with a separate cover page. Please note, the following submission format requirements:

Cover-page is to be submitted with full student name, student ID and student signature. Please note that this cover sheet is to be submitted separately to your Folio Assignment MS Excel workbook.

When naming your Cover Page in MS Word, please use the following file name protocol: Student ID_Surname_Folio Assignment_Cover Sheet.docx.

Practical Assignment task is to be submitted with full student name and student ID. Please note your MS Excel workbook files are to be submitted separately to your cover page.

When naming your MS Excel files, please use the following file name protocol:

Student ID_Folio Assignment_Q1_Q2.xlsx

Student ID_Folio Assignment_Q3.xlsx

 

标签:Please,Assignment,Excel,two,Modelling,machine,Accounting,Data,your
From: https://www.cnblogs.com/qq---99515681/p/18412619

相关文章

  • UDS 诊断 - TransferData(传输数据)(0x36)服务
    UDS诊断服务系列文章目录诊断和通信管理功能单元UDS诊断-DiagnosticSessionControl(诊断会话控制)(0x10)服务UDS诊断-ECUReset(ECU重置)(0x11)服务UDS诊断-SecurityAccess(安全访问)(0x27)服务UDS诊断-CommunicationControl(通信控制)(0x28)服务UDS诊断-TesterPresent......
  • 2024 医疗 Datathon 又叕来啦~!“理-工-医-信”跨学科联合科研,以数据驱动医疗实践
    由解放军总医院和中国生物医学工程学会临床医学工程分会共同举办的第五届“解放军总医院—麻省理工学院医疗大数据学术交流及Datathon活动”预计将于2024年11月在北京举行,旨在通过引进国际先进理念与模式,促进医疗大数据与人工智能领域的跨学科合作,特别是“理-工-医-信”四大......
  • 火山引擎VeDI核心产品DataTester再进化,A/B大模型应用评测功能上线
    更多技术交流、求职机会,欢迎关注字节跳动数据平台微信公众号,回复【1】进入官方交流群近日,火山引擎A/B测试产品DataTester上线了A/B大模型应用评测功能。此次升级不仅强化了模型上线前的基础能力评测,还新增了针对线上使用场景的全面、系统检测与评估机制,为企业在模型应用的全周期管......
  • Google 发布 DataGemma 技术减少 AI 生成错误信息 (即幻觉)
    Google推出了DataGemma,这是基于真实世界数据的两个新Gemma模型版本,旨在减少AI生成中的“幻觉”问题。DataGemma通过利用GoogleDataCommons中超过2400亿个来自可信来源的统计数据,显著提高了模型在处理数值和统计数据时的准确性。DataGemma采用了两种关键技术:检索......
  • 如何在删除ibdata1和ib_logfile的情况下恢复MySQL数据库
    昨天,有个朋友对公司内部使用的一个MySQL实例开启binlog,但是在启动的过程中失败了(他也没提,为何会失败),在启动失败后,他删除了ibdata1和ib_logfile,后来,能正常启动了,但所有的表通过showtables能看到,但是select的过程中却报“Tabledoesn'texist”。于是,建议他试试可传输表空间。同......
  • datastructure与算法 orderedPair
    /**  Aninterfacethatdescribestheoperationsofasetofobjects.  @authorCharlesHoot,FrankM.Carrano  @version4.0*/publicinterfaceSetInterface<T>{  /**Getsthecurrentnumberofentriesinthisset.    @return Theintegernum......
  • DataGrip或者intellijIDEA 远程链接数据库的时候下载驱动失败 出现错误:https://downlo
    一、问题本人使用DataGrip版本:2023.1在链接数据库的时候出现这个错误,无法完全加载驱动,是因为这里的maven仓库下载驱动失败,这时候需要自己手动下载驱动二、怎么解决需要手动更改下载的镜像网址,改成阿里云的镜像网址仓库服务(aliyun.com)这三个仓库地址,可以选择其中一个......
  • DataGrip 2021.2.2如何导出.sql文件
     目录Blue留声机: 导出文件:1、点击要导出的table,选择Exportwith'mysqldump'2、选择一下数据库备份数据的路径,选择导出sql文件存放的位置导入文件: 概览:1.第一步,进入运维管理端,通过命令行进入数据库2.第二步,切换数据库3.第三步,导入sql文件source无法导入sql文件......
  • 使用WM_COPYDATA实现进程间通信
    发送端LRESULTcopyData;//copyDataResulthasvaluereturnedbyotherappCWnd*pOtherWnd=CWnd::FindWindow(NULL,_T("窗体名"));CStringstrData;strData.Format(L"%.1lf",tickdata);if(pOtherWnd){ COPYDATASTRUCTcpd;//上面提到的结构体 cpd.......
  • mysql 5.7 删除ibdata1 、ib_logfile 文件的数据恢复
    简介:本文记录删除ibdata1、ib_logfile文件被意外删除且无法还原或损坏的解决方案,当删除后没有重启mysql可以查询进程号,找到删除的文件可以还原回来。参考其他文章。本文介绍ibdata1、ib_logfile文件无法找到或异常没有备份的情况处理。 新安装一台mysql用作从库......