make an Excel spreadsheet to organize your answers to the following problem, and submit your Excel file as an attachment by clicking on the appropriate button on this page.

A company with 340,000 common shares outstanding had the following most recent income statement:

Sales$20,000,000- Cost of goods sold-12,000,000Gross profit8,000,000- Operating expenses6,000,000EBITDA2,000,000- Depreciation400,000EBIT1,600,000- Interest expense100,000- Taxes525,000Net Income975,000

In addition, the company had cash flow from operations of $1,200,000. If you were a financial analyst using the following five multipliers in your analysis, what value would you put on each share of common stock of the company in each of these five cases?

1. Earnings multiplier = 22
2. Cash flow from operations multiplier = 18
3. EBIT multiplier = 16
4. EBITDA multiplier = 13
5. Sales multiplier = 1.2