FIN3704 Assignment 02 Exam (elaborations) FIN3704 - Applied Financial Management (FIN3704) Financial Analysis with Microsoft Excel 2016, 8E, ISBN: 9781337298049

3/28/23, 9:53 AM Assessment 2: Attempt review

tarted on Tuesday, 28 March 2023, 9:32 AM
State Finished
Completed on Tuesday, 28 March 2023, 9:52 AM
Time taken 19 mins 41 secs
Marks 15.00/15.00
Grade 100.00 out of 100.00

Question 1
Correct
Mark 1.00 out of 1.00




Using the data presented below to answer the following question, Choose the best option from the given answers to answer each question.




Which one of the following formulas is correct when calculating Sibusiso's Products International 2021 EBIT in B11 using an excel worksheet?



a.
=B7-SUM(B6:B10)


b. =B7-SUM(B7:B10)


c. =B7-SUM(B8:B10)


d. =B7-SUM(B9:B10)




Your answer is correct.
The correct answer is:

=B7-SUM(B8:B10)




https://mymodules.dtls.unisa.ac.za/mod/quiz/review.php?attempt=8501442&cmid=592494 1/14

, 3/28/23, 9:53 AM Assessment 2: Attempt review

Question 2
Correct
Mark 1.00 out of 1.00




Using the data presented below to answer the question. Choose the best option from the given answers to answer each question.




The formula for the change in accounts receivable (in B6) from the above balance sheet to be included in the cash flow statement should be =?
(Assuming the worksheet is named "Balance Sheet")




a. = 'Balance sheet'! C5 + 'Balance sheet'! B5


b. = 'Balance sheet'! C5 – 'Balance sheet'! B5


c. = 'Balance sheet'! C6 + 'Balance sheet'! B6


d.
= 'Balance sheet'! C6 – 'Balance sheet'! B6




Your answer is correct.
The correct answer is:
= 'Balance sheet'! C6 – 'Balance sheet'! B6




https://mymodules.dtls.unisa.ac.za/mod/quiz/review.php?attempt=8501442&cmid=592494 2/14