80.2K

Verified Solution

Link Copied!

Solve with excel

In cell B$19,$ input the net sales amount.

In cell B$20,$ input the cost of goods sold amount.

Note: The output of the expression or function you typed in this cell is expected as a positive number.

In cell B$21,$ calculate the gross profit.

In cell B$22,$ input the operating expenses.

Note: The output of the expression or function you typed in this cell is expected as a positive number.

In cell B$23,$ calculate the operating income.

In cell B$27,$ calculate the net income by adding the product of the dividend per share times the number of common stock outstanding and the increase in retained earnings.

In cell B$25,$ calculate the income before taxes amount by dividing the net income by $1$ minus the tax rate.

In cell B$24,$ calculate the interest expense amount by subtracting the income before taxes from the operating income.

Note: The output of the expression or function you typed in this cell is expected as a positive number.

In cell B$26,$ calculate the tax amount by subtracting the net income from the income before taxes.

Note: The output of the expression or function you typed in this cell is expected as a positive number.

In cell B$31,$ calculate the operating profit margin by dividing the operating income by the net sales.

Note: Refer to the appropriate cells from the Income Statement in your calculations.

In cell B$35,$ calculate the times interest earned by dividing the operating income by the interest expense.

Answer & Explanation Solved by verified expert

See Answer