Problem 1 (15 marks) a

Problem 1 (15 marks)

a.           Complete the 2020 Cash Flow Statement for Moncton Electronics. (5 marks)

b.           Complete the 2020 Sources and Uses Statement for Moncton Electronics. (5 marks)

c.           Complete the 2020 Cash Flow Identity Statement for Moncton Electronics.

(5 marks)

Problem 2 (14 marks)

Using the following excel spreadsheet (the spreadsheet is incorporated in the word document) complete the ratios for Moncton Electronics Inc. Show your work! Each ratio is worth a ½ each and the cash flow from asses is worth 1 mark)

Problem 3 – 17 marks

1. Complete a common size statement for Dapper Dawg Industries for all three years using an excel spreadsheet. (5 marks)
2. Use the Dupont ratio to calculate the ROE and which ratio should the firm try to improve? ( Show your work! 4 marks)
3. Using the ratios template for the forecast, complete the ratios (½ mark each) (show your work). Do you observe any weakness or concerns in the firm’s forecast (2 marks)? (9 marks)