25624 Financial Metrics for Decision Making

Individual Assignment

25624 Financial Metrics for Decision Making Autumn session 2022

General information and instructions

  • This individual assignment accounts for 40% of your final grade.
  • You must complete this assignment on an individual basis.
  • Deadline: Friday 13th May 2022, 11.59pm AEST (Sydney time)
  • You need to submit the Excel spreadsheet via Canvas:
    • Excel spreadsheet
      • .xlsx format only
      • The spreadsheet must contain all calculations you perform for the tasks.
      • Aim to structure and format your Excel solution in the most efficient way possible and use financial modelling best practices.
  • This task includes a milestone assessment component that evaluates academic English language proficiency. You may be guided to further language support after the completion of this subject if your results in this milestone task indicate you need more help with your language skills.
  • All assignment-related queries must be posted on the Canvas discussion board. E-mail queries related to the assignment will not be entertained.
  • It is possible that you run int o technical difficulties while uploading your assignment to Canvas. In this case (and only in this case), can you submit your work via e-mail to the subject coordinator. Note that submissions must still be received prior to the deadline.

From prior experience, technical difficulties often can be traced back to students trying to upload their work a few minutes prior to the deadline. Tip: do not wait until 11.55pm on 13th May to submit your work via Canvas. Late submissions will receive zero credit unless a special consideration with valid reasons and documentation is filed.

Grading

  • Both the Excel spreadsheet and the written component will be graded.
  • The Excel spreadsheet will be marked based on the efficiency and clarity with which solutions are produced.
  • Late submissions will receive zero credit unless a special consideration with valid rea- sons and documentation is filed.

Data

  • In the Assignment page on Canvas, you will find an Excel spreadsheet that contains the data you need to complete the assignment tasks.
  • There are 4 worksheets in the spreadsheet.
  • Perform your calculations based on the data in these spreadsheets.
  1. Refer to the “NationalExamInputs” worksheet.

You are given access to a data set that tracks student scores on the National Exam of a country. The National Exam is taken by students in their final year of high school, and has 4 components:

  1. Natural Sciences
  2. Social Sciences
  3. Languages
  4. Mathematics

The score students obtain is important in their application to universities. The data set also contains demographic details of students, as well as their individual circumstances. An overview of the different variables is provided below.

VariableDefinition
StudentIDStudent identifying code
ResidenceCodeCode identifying where the student lives
AgeStudent Age
GenderStudent Gender
BirthplaceCodeCode identifying where the student was born

FamilyNbrMembers

Number of members in the student’s immediate family (includes student). Numerical values range from 1-18.

FamilyNbrCars
Number of cars the student’s family has. Takes one of the values “1″, “2″, “3″, or “More than 3″

FamilyComputer
Equal to “Yes” if the student’s family has at least 1 computer. Equal to “No” if the student’s family has no computer.

FamilyInternet
Equal to “Yes” if the student’s family has access to the internet. Equal to “No” if the student’s family has no access to the internet.


FamilyIncome

Total monthly income of the student’s family (in local currency). Takes one of the values “Below 1000″, “Between 1000 and 2000″, or “Above 2000″.
ScoreNatSStudent’s score on the Natural Sciences component.
ScoreSocSStudent’s score on the Social Sciences component.
ScoreLangStudent’s score on the Languages component.
ScoreMathStudent’s score on the Mathematics component.

Perform the following tasks.

  1. [1 mark] Use Cell D4 of the NationalExamSolutions worksheet to calculate the number of students who are 20 year of age or under
  2. Use range D7:G9 of the NationalExamSolutions worksheet:
    • [2 marks] report the average score by component for the entire sample, the average score by component for students who are 20 year of age or under, and the % difference
    • [2 marks] Use Cell B1 of the Written Component worksheet to describe the exam components for which students 20 years of age or under have an advantage/disadvantage compared to the entire sample.
  3. [1 mark] Your colleague believes that gender is related to students’ language score component. More specifically, she thinks that female students perform better than male students. Write down the null and alternative hypotheses [Cells D13 and D14]. Do you need a 1-tail or two-tail t-test? [D15]
  4. Perform a hypothesis test of (c) using a 1% significance level.
    • [2 marks] Use Rows 19 to 22 to show your results
    • [2 marks] Use Cell B2 of the Written Component worksheet to answer:
      • Are you able to reject your null hypothesis? Explain why (not).
      • Provide an economic interpretation of your result.
  5. [1 mark] Another colleague believes that access to a computer and internet is related to students’ math score component. He thinks that students with access to both a computer and an internet connection (Yes on both variables) perform better than students with no access to computer or internet (No on both variables). Write down the null and alternative hypotheses [Cells D25 and D26]. Do you need a 1-tail or two-tail t-test? [D27]
  6. Perform a hypothesis test of (g) using a 1% significance level.
    • [2 marks] Use Rows 31 to 35 to show your results
    • [2 marks] Use Cell B3 of the Written Component worksheet to answer:
      • Are you able to reject your null hypothesis? Explain why (not).
      • Provide an economic interpretation of your result.
  7. [2 marks] You want to further understand the impact of gender on the scores of the Language component of the exam. To do this, you run the following regression analysis:

𝑆𝑐𝑜𝑟𝑒𝐿𝑎𝑛𝑔 = 𝛽0 + 𝛽1𝐴𝑔𝑒 + 𝛽2𝐹𝑒𝑚𝑎𝑙𝑒 + 𝛽3𝐶𝑜𝑚𝑝𝑢𝑡𝑒𝑟 + 𝛽4𝐼𝑛𝑡𝑒𝑟𝑛𝑒𝑡

Report the regression outputs starting in Cell D37 of the NationalExamSolutions worksheet

  1. [3 marks] Use Cell B4 of the Written Component worksheet to discuss your main results: coefficients statistical and economic significance, model goodness of fit.

Make sure you relate these findings to those in questions 1.c and 1.d.

  1. The “Modelling” worksheet contains assumptions to build an Income Statement forecast for

Chalten Ltd for the 2022 – 2026 period. Using the assumptions provided, please:

  1. [2 marks] Build the Economic scenarios section [Rows 16 -33], including a scenario selector
  2. [2 marks] Build the Revenue forecast [Rows 42 -58]
  3. [2 marks] Build the Cost of Sales forecast [Rows 68 -78]
  4. [2 marks] Build the Income Statement forecast [Rows 88 -96]
  5. [6 marks] After analysing the company’s forecasts, Chalten’s CFO believes the sales volume growth is too high. The company aims to having an implied operating rate that does not exceed 80%. Given that the sales growth rate is the same every year, what should that rate be to make sure Chalten followsthe 80% rule?
  6. [6 marks] The model is also assessed for consistency and use of best practices
Universal Assignment (September 25, 2022) 25624 Financial Metrics for Decision Making. Retrieved from https://universalassignment.com/25624-financial-metrics-for-decision-making/.
"25624 Financial Metrics for Decision Making." Universal Assignment - September 25, 2022, https://universalassignment.com/25624-financial-metrics-for-decision-making/
Universal Assignment June 2, 2022 25624 Financial Metrics for Decision Making., viewed September 25, 2022,<https://universalassignment.com/25624-financial-metrics-for-decision-making/>
Universal Assignment - 25624 Financial Metrics for Decision Making. [Internet]. [Accessed September 25, 2022]. Available from: https://universalassignment.com/25624-financial-metrics-for-decision-making/
"25624 Financial Metrics for Decision Making." Universal Assignment - Accessed September 25, 2022. https://universalassignment.com/25624-financial-metrics-for-decision-making/
"25624 Financial Metrics for Decision Making." Universal Assignment [Online]. Available: https://universalassignment.com/25624-financial-metrics-for-decision-making/. [Accessed: September 25, 2022]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Get 45%* OFF on Assignment Help

Popular Assignments

Find the Greatest Ancient History Assignment Help Instantly

Ancient History Assignment Help Benefits Student Performance! Ancient History assignment help uplifts student understanding and interest in the area. Ancient history can often become confusing for students because it involves understanding events that are hardly relatable to us in the present generation! Universal Assignment is the perfect platform for the

Read More »

Australia’s Best Aboriginal Studies Assignment Help Online

Upgrade your knowledge with the best Experts:  Quick Aboriginal Studies Assignment Help The world’s most rich research on Aboriginal studies takes place at the top educational institutions in Australia. This field involves rich socio-historical research on the Aboriginal indigenous community of Australia. Aboriginal Studies assignment help online can help students

Read More »

Physical Education Assignment Help: Expert Guidance to Boost your Career

Order Physical Education Assignment Help Instantly! Are you a Physical Education student, struggling to submit assignments on time? Universal Assignment Help Service is the perfect place for all your solutions. With expert guidance available from the best professionals, all your assignments will be top-quality. Physical Education involves a strict and

Read More »

Assignment Help in South Africa

5 Ways to Make Your Assignments Error-Free Assignments are a crucial part of every student’s life as they help them to enhance knowledge about the subjects and also improve academic grades, writing skills, time management skills, research skills, etc. Usually, due to internships, part-time jobs, and other co-curricular activities, students

Read More »

Instant Engineering Assignment Help in Ukraine

Engineering is a vast field of study that consists of several branches. While studying various branches of engineering in the best Ukraine universities, students are required to compose several types of assignments to improve their academic scores. There are many different reasons due to why students seek engineering assignment help

Read More »

[SOLVED] AHS205: The Australian Healthcare System within a Global Context

AHS205: The Australian Healthcare System within a Global Context Part A 1. Healthcare professionals include registered nurses, physicians, dentists, physician assistants, and veterinarians. Registered nurse: The key function which the nurses play in treating the patient with depression include monitoring the clinical progress, improving the compliances of treatment, assessment for

Read More »

[SOLVED] Assignment: Pressure ulcer in ICU in UK

1- Critique different types of evidence ( the area I’ve chosen is pressure ulcer in ICU)2- Analyse what constitutes Best Evidence for practice in the UK3- Critically reflect on the BENEFITS and LIMITATIONS of evidence based practice (EBP) within nursing practice. Using Randomised Controlled Trial (RCT)Student will critique a qualitative

Read More »

[SOLVED] Assignment The lasting negative impact of Colonialism within contemporary Indian Economy and Industry

The lasting negative impact of Colonialism within contemporary Indian Economy and Industry Famine in India and colonialism During the period of colonialism, root causes of famine within India include government policies, population imbalance, crop failure, inflation and war. Increased mortality, epidemic, starvation and regional malnutrition follow and accompany famine within

Read More »

[SOLVED] OSQs: The Psychology of Competition: A Social Comparison Perspective

The Psychology of Competition: A Social Comparison Perspective OSQs Outlines Competitiveness and Social Comparison – The passage is all about reducing differences in the society and developing factors to do social comparison – Situational and individual factors have been highlighted to increase competitiveness The framework highlighting situational and individual factors

Read More »

 [SOLVED] Letter of advice 5126LAW: ASSESSMENT ITEM 3

Law Letter of Advice 25 January 2022 Ms. Amelia Hart 4 Cornet Street, Yeronga Re: Domestic Violence and parenting matter- Hart & Hart Dear Amelia, We do confirm that we have been asked to provide you with advice regarding the parenting and domestic violence matter during the appointment on 24

Read More »

5126LAW: ASSESSMENT ITEM 3  Letter of Advice Problem

5126LAW: ASSESSMENT ITEM 3  Information about this assignment:  This assessment piece requires you to prepare:  1. An initial letter of advice;  2. A draft Application for a Protection Order (Form DV1); and  3. Draft Written Submissions.  Initial letter of advice  Ensure that the initial letter of advice is addressed to

Read More »

HC1021 INTERPERSONAL AND E-COMMUNICATION Assignment T3 [SOLVED]

Student Number: (enter on the line below) Student Name: (enter on the line below) HC1021INTERPERSONAL AND E-COMMUniCATION final assessmeNt Trimester 3, 2021 Assessment Weight: 50 total marks Instructions: All questions must be answered by using the answer boxes provided in this paper. Completed answers must be submitted to Blackboard by

Read More »

COMM1001 Communication in Organisations

Assessment 4 – Written report (1200 Words) 50% Due Week 14 – By 5pm Friday Sept 27th Your full recorded interview from Assessment 3, becomes the basis of your report for Assessment 4 Drawing on the content from your interview and the academic literature related to the three communication topics

Read More »

MBA703 – The Economic Environment – Trimester 2 2022 Assessment Task 2

DUE DATE AND TIME:                        Friday, 23 September 2022, by 8:00pm (AEST) PERCENTAGE OF FINAL GRADE:                                                            40% WORD COUNT:                                   2000 words Description This assignment is based on an article published in the AFR titled “Australia must have a new macroeconomic framework”. Please read the article and answer the following questions (using

Read More »

IT510 Systems Analysis and Design Module Preview

This guide contains a preview of the materials for all module courses in this series: IT510M1: Systems Planning, Analysis, and Logic Processes IT510M2: Data Organization Process IT510M3: System Physical Attributes IT510M4: Written Proposals for System Analysis and Design Be sure to follow the detailed directions found within the actual module

Read More »

BULAW5915 Assignment

Information about the Assignment:   Due date   Sunday, 23:59, 18 September 2022 (Week 9) How to submit   The assignment must be submitted in word format through the submission link on Moodle.   Topics covered by Assignment Topic 4   Maximum word limit   2500 words   Total marks

Read More »

Biomedical Physiology and Engineering assignment

Stent grafts for coronary arteries were first used in the mid 1980’s.  I want you to review the developments in stent graft technology since that time and discuss the natural response of the body to angioplasty and stent placement and how biomedical engineers have responded to the adverse events encountered

Read More »

NRSG374 Assessment Task 1, 2022

ASSESSMENT TASK 1 Professional Development Resource: Narrated PowerPoint Due date: Thursday 15th September 2022 at 4pm Weighting: 50% Length and/or format: Narrated PowerPoint equivalent to 1500 Words +/- 10%8-10 Slides Including Title Page and ReferencesDiagrams and images can be used please include references as per APA7No longer than 8 mins

Read More »

2110AFE – PROBLEM-SOLVING ASSIGNMENT (T 2, 2022)

WEIGHT:          This assessment is worth 30% of the total marks for this course. WORD LIMIT: Your answer to Question 1 (Hypothetical ILAC Question) must be no longer than 1000 words. Your answer to Question 2 & 3 must be no longer than 1000 words. INSTRUCTIONS TO STUDENTS: Students may refer

Read More »

HRM 4801 Managing and Developing People

The following table provides an example of the overview of the assessment requirements. Assessment 1 : Individual reflexive review The following table provides an overview of the assessment requirements. Assignment brief : Individual reflexive review Module code HRM 4801 Module title Managing and Developing People Submission date, time 01.12.2020 :

Read More »

BUS4023 BUSINESS ETHICS

Course/ Module: BUSINESS ETHICS SEGI Course Code: BUS4023 UCLAN Module Code: (if applicable) Lecturer name: William Tan Coursework Submission Date:                         Individual Assessment 1: Week 7 Individual Assessment 2: Week 9 ASSESSMENT METHODS Number of Assessments Form of Assessment     % weighting Size of Assessment/Duration/ Word count Category of

Read More »

Human Subjects Case Studies

Case Study 1 – Research involving adults with terminal illness Dr. Abbott, an oncologist at a major teaching hospital, has been asked to put forward a number of her patients for participation in a clinical trial of a new cancer treatment. Mr. Day is a terminally ill patient with a

Read More »

BA Stage 3 Level 7 Special Education and Differentiation

Assignment Brief and Marking Scheme Programme: Module: Semester: Date of Title Issue: Assignment Deadline: Assignment Submission Details:   Module Credits: Weighting for this Assignment: BA Stage 3 Level 7 Special Education and Differentiation 1 05/10/20 26/11/20 Submit both the essay and the completed IEP in electronic format (PDF) to Moodle.

Read More »

PART II: Media Analysis and Reflection Submission

Students are also required to submit a Media Analysis and Reflection in relation to the media segment (see below) for the Media Discussion Forum. In approximately 350 to 500 words, please expand the synopsis you have provided as a Leader on the Discussion Forum. In this expanded version, you should

Read More »

Philosophy227 Take Home Essay Questions

Philosophy227 Take Home Essay Questions Carel argues that one can be happy – that one’s life can be meaningful – even if one is terminally ill. What is her argument? Do you agree? Is death harmful? Articulate a reason for thinking that death is harmful. Identity an argument against the

Read More »

General Psychology Assignment

Question Mark Travers in his article posted by Psychology Today dated 8th Sept, 2020 posed a question; “Are dating apps a breeding ground for dark personality?” in which new research suggests that the answer is likely yes (Johannes Kepler University). Dark personality triad comprises personality traits of Narcissism, Machiavellianism and

Read More »

Portfolio Planning Tool

Planning for a Target Position: Use this sheet to identify your Key Skill Areas. Add more Key Skill Areas or additional rows if needed.  Within each key skill area, indicate your skills, knowledge, and abilities along with the work samples/evidence you have to prove it, the skill type, source and

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?