Please start the Assessment Test only after you have completed the previous modelling exercise.
0 of 3 Questions completed
Questions:
You have already completed the assessment test before. Hence you can not start it again.
Assessment Test is loading…
You must sign in or sign up to start the assessment test.
You must first complete the following:
0 of 3 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
There are only three questions, but you need to get all of them correct, to ensure that you have built the model correctly!! Please try again.
Well done! Please continue with the course.
Q1: What is the value of the Year 3 Cumulated Profit (cell G21), to the nearest decimal place, in the case that: Sales Growth (cell C5) is set to 1%, Fixed Cost Growth (cell C8) is set to 2%, and Variable Cost is set to 18% of Sales Revenue?
Q2: What is the value of the Year 3 Cumulated Profit (cell G21), to the nearest decimal place, in the case that: Sales Growth (cell C5) is set to 6%, Fixed Cost Growth (cell C8) is set to 4%, and Variable Cost is set to 22% of Sales Revenue?
Q3: What is the value of the Year 3 Cumulated Profit (cell G21), to the nearest decimal place, in the case that: Sales Growth (cell C5) is set to 5%, Fixed Cost Growth (cell C8) is set to 5%, and Variable Cost is set to 15% of Sales Revenue?