Please show your work step by step in order to receive a thumbs up. You can use Excel for calculations if you wish, but the solutions must be copied and pasted in a Word text.

1. A firm has total interest charges of $12,000 per year, sales of $1 million, a tax rate of 40 percent, and a net profit margin of 6 percent. What is the firm's times-interest-earned ratio?