1. Copy the Big Rock Candy Mountain Mining financial statements from Problem 1 in Chapter 2 into a new workbook.
a. Set up a ratio worksheet similar to the one in Exhibit 3-6, page 99, and calcu-late all of the ratios for the firm.
b. Identify areas of concern, if any, using the ratios. Identify areas that have shown improvement, if any.
c. In 2020 the ROE increased. Explain, in words, why this increase occurred using the DuPont method from equation (3-29). Now use the extended DuPont method from equation (3-33).
d. Big Rock Candy Mountain Mining has shown an accounting profit in each of the past two years. Calculate the economic profit for these years and compare it to net income. The WACC is 9%.
e. Using Altmans model for privately held firms, calculate the Z-score for Big Rock Candy Mountain Mining. Does it appear that the firm is in imminent danger of bankruptcy?
2. A computer problem at Mike Owjai Finance has resulted in incomplete financial statements. Management of the company has asked you to see if you can fill in the missing data.
a. Recreate the financial statements as shown using formulas with the ratios given below to fill in the cells with the word Ratio. Use the rOund function to round each of these answers to the nearest $1.
b. Complete the financial statements by using formulas that refer to existing data to fill in the remaining cells.





Recent Comments