Please show me how to calculate the interest coverage. step by step or in excel

1 National Beverage Corp. 2 Annual Reports Income Statement 4 5 6 {Amounts in thousands except per share data} 1 6 Fiscal Year Ended 41311121116 512121115 513121114 4121121113 9 Net sales 5 194,165 5 645,625 5 641,135 5 662,991 19 Cost of sales 463,346 426,665 423,461} 444,151 11 Gross prot 241,431 219,149 211,655 211,251} 12 13 Expenses: 14 Selling, general and administrative 146,364 145,151 153,229 146,223 15 Other operating expense [incomeJnet 145 {1,1111} 666 113 16 Interest expense 2113 311 6611 4113 11 Total Expenses 146,132 144,421 154,546 146,199 16 Income before income taxes 92,1115 14,113 63,1119 111,451 19 Provision for income taxes 31,5111 25,4112 19,414 23,531 211 Net inoome 5 61.1941 5 49,311 5 43,636 5 46.9211 21 22 Basic EPS 51.31 51.116 511.93 51.111 23 Diluted EPS 51.31 51.115 511.92 51.111 24 Dividends Per Share 511.1111 511.1111 511.1111 52.5 25 213 Common Stock Dividends Paid 116,139 21 {also assume no dividends will be paid to preferred stockholders} 26 Weighted Average Common Shares Outstanding 46,3111 29 Weighted Average Common Shares Outstanding (dutedj 46,462