Please use the cells of Excel and provide the process, thanks a lot! Using Excel to Calculate Shareholders' Equity Ratios

PROBLEM

RIngtone Inc. has the following selected financial data:

Net income

Total assets

Preferred shares, cumulative

Common shares

Retained earnings

Accumulated other comprehensive income

Total shareholders' equity

Cash dividends paid in the year

Market price of common shares

Weighted average number of common shares

Dividend rate on preferred shares

There were no preferred dividends in arrears.

There were no preferred dividends in arrears.

$|$

Student Work Area

Required: Provide input into cells shaded in yellow in this template. Use

mathematical formulas with cell references to the Problem or work areas as

indicated.

$($a$)$ Calculate the following ratios for $2023.$

$(1)$ Rate of return on common shareholders' equity

Average common shareholders' equity

Preferred dividends

Rate of return on common shareholders' equity

$(2)$ Payout ratio

Payout ratio

$(3)$ Price earnings ratio

Earnings per share

Price earnings ratio

$(3)$ Book value

Book value per share

$(4)$ Rate of return on total assets

Rate of return on total assets

$($b$)$ Is Khalid Inc. trading on the equity?

Because Khalid's

exceeds its

the company is