25624-Financial Metrics for Decision Making Report Writing - Finance Assignment Help

Assignment Task

Task

Perform the following tasks.

1).

a. Use Cell D4 of the NationalExamSolutions worksheet to calculate the number of students who are 20 year of age or under

b. Use range D7:G9 of the NationalExamSolutions worksheet:

• 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
• 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. 

c. 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]

d. Perform a hypothesis test of (c) using a 1% significance level.

• Use Rows 19 to 22 to show your results
• Use Cell B2 of the Written Component worksheet to answer:

i). Are you able to reject your null hypothesis? Explain why (not).
ii). Provide an economic interpretation of your result.

e. 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]

f. Perform a hypothesis test of (g) using a 1% significance level.

• Use Rows 31 to 35 to show your results
• Use Cell B3 of the Written Component worksheet to answer:

i). Are you able to reject your null hypothesis? Explain why (not).
ii). Provide an economic interpretation of your result.

2. The “Modelling” worksheet contains assumptions to build an Income Statement forecast for Chalten Ltd for the 2022 – 2026 period. Using the assumptions provided, please:

a. Build the Economic scenarios section [Rows 16 -33], including a scenario selector

b. Build the Revenue forecast [Rows 42 -58]

c. Build the Cost of Sales forecast [Rows 68 -78]

d. Build the Income Statement forecast [Rows 88 -96]

e. 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 follows the 80% rule?

f. The model is also assessed for consistency and use of best practices

This 25624-Finance  Assignment has been solved by our Finance Expert at Exam Question Bank. 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 Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.