Document Type


Publication Date



This case illustrates the impact of various business transactions on a firm’s financial statements. The case objective is to highlight how business transactions affect financial statements and to illustrate the links between financial statements and key ratios. The case was developed and piloted as a final project in an introductory accounting class and as an accounting review in a corporate finance course. In each part of the case, students are asked to show the impact of a business transaction on the firm’s balance sheet and income statement. The cash flow statement and financial ratios calculate automatically. Part 1 of the case focuses on the transactions involved in establishing the company. Part 2 illustrates basic operating transactions. Part 3 considers the impact of growth and leverage.


Originally published:

Boyer, Benoit, and Bridget Lyons. "Rivera Custom Cabinetry: Financial Statement Analysis Using Excel." Journal Of The Academy Of Business Education 12 (2011): 156-162.



To view the content in your browser, please download Adobe Reader or, alternately,
you may Download the file to your hard drive.

NOTE: The latest versions of Adobe Reader do not support viewing PDF files within Firefox on Mac OS and if you are using a modern (Intel) Mac, there is no official plugin for viewing PDF files within the browser window.