Please post in EXCEL format or from an EXCEL spreadsheet. Thank you.

22. [EXCEL] Income statement: Sosa Corporation recently reported an EBITDA of $31.3 million and net income of $9.7 million. The company had $6.8 million in interest expense, and it's average corporate tax rate was 35 percent. What was its depreciation and amortization expense?

23. [EXCEL] Income statement: Fraser Corporation has announced that its net income for the year ended June 30, 2017, was $1,353,412. The company had EBITDA of $4,967,855 and its depreciation and amortization expense was equal to $1,112,685. The company's average tax rate is 34 percent. What was its interest expense?

24. [EXCEL] Income Statement: For its most recent fiscal year, Carmichael Hobby Shop recorded EBITDA of $512,725.20, EBIT of $362,450.20, zero interest expense, and cash flow to investors from operating activity of $348,461.25. Assuming there are no non-cash revenues recorded on the income statement, what is the firm's net income after taxes?

25. [EXCEL] Retained earnings: Columbia Construction Company earned $451,888 during the year ended June 30, 2017. After paying out $225,794 in dividends, the balance went into retained earnings. If the firm's total retained earnings were $846,972 at the end of fiscal year 2017, what were the retained earnings on its balance sheet on July 1, 2016?

27. [EXCEL] Tax: Mount Hebron Electrical Company's financial statements indicated that the company had earnings before interest and taxes of $718,323. The interest rate on its $850,000 debt was 8.95 percent. Calculate the taxes the company is likely to owe. What are the marginal and average tax rates for this company?