Write your own analysis program to calculate a common size income statement and the ratios introduced in this chapter. To keep the exercise reasonably simple, just provide for one year of ratios and one common size statement.

Construct an input area in your spreadsheet in the form of an income statement and a balance sheet. Input the accounts and have the program calculate all totals and subtotals. Define your common size income statement alongside the input income statement by dividing each input line item by revenue. Define your ratios in another area drawing the numerators and denominators from the input statements.