MPI Incorporated has $5 billion in assets, and its tax rate is 35%. Its basic earning power (BEP) ratio is 12%, and its return on assets (ROA) is 3%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet What is MPI's times - interest - earned (TIE) ratio? Round your answer to two decimal places.

Excel Online Structured Activity: TIE ratio MPI Incorporated has $6 billion in assets, and its tax rate is 35%. Its basic earning power (BEP) ratio is 10%, and its return on assets (ROA) is 4%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet What is MPI's times-interest-earned (TIE) ratio? Round your answer to two decimal places. X

Archware Systems has total assets of $35.594billion, total debt of $9.678 billion, and net sales of $22.200 billion. Theirnet profit margin for the year was 0.17, while the operating profitmargin was 30 percent. What is Archware’s net income? (Answer needs to be stated in billions. For example: 2.83) Round to two decimal places.

(This is what is in between the 1st and 2nd screenshot)   Using these data, determine the following: Earnings per share. Round your answer to two decimal places. Price-to-earnings ratio. Round your answer to two decimal places. Book value per share. Round your answer to two decimal places. Market-to-book ratio. Round your answer to two decimal places. EV-EBITDA multiple. Assume the cost of sales includes $14 million in depreciation expenses. Assume there are no amortization expenses. Round your answer to two decimal places. How much of the retained earnings total was added during Year 1? Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to two decimal places.$  million Show Eastland’s new balance sheet after the company sells 1 million new common shares in early Year 2 to net $28 a share. Part of the proceeds, $12 million, is used to reduce current liabilities, and the remainder is temporarily…

For fiscal year 2018, Walmart Inc. (WMT) had total revenues of $500.34 billion, net income of $9.86 billion, total assets of $204.52 billion, and total shareholders' equity of $77.87 billion. a. Calculate Walmart's ROE directly, and using the DuPont Identity. b. Comparing with the data for Costco, use the DuPont Identity to understand the difference between the two firms' ROES. Data table For fiscal year 2018, Costco Wholesale Corporation (COST) had a net profit margin of 2.08%, asset turnover of 3.55, and a book equity multiplier of 3.37. Costco's ROE (DuPont) is 24.88%.

Firm C has net income of $136,000, turnover of 1.91, and ROI of 23.90%. Calculate the firm's margin, sales, and average total assets. (Round "Margin" answer to 1 decimal place and use the rounded answer for the subsequent computations.)

Use the information provided from Sapphire Ltd to calculate the ratios for 2022 (expressed to two decimal places) that would reflect each of the following:1. The profit of the company relative to sales after deducting the cost of sales.2. The ability of the company to profitably utilize its capital, which includes both debt and equity.3. The proportion of the total assets that are financed by total debt.4. The ability of the company to repay its short-term debts under distress conditions, on the assumption that inventories would have no value at all.5. The portion of the company's profit that is allocated to each outstanding ordinary share.6. An indication of the percentage of profit that has been put back into the company.

For the year ended December 31, 2022, Settles Incorporated earned an ROI of 8.8 %. Sales for the year were $9 million, and average asset turnover was 2.2. Average stockholders' equity was $2.9 million. Required: a. Calculate Settles Incorporated's margin and net income. Note: Round "Margin" answer to 1 decimal place. Enter the net income answer in dollars, i.e., $5 million should be entered as 5,000,000. b. Calculate Settles Incorporated's return on equity. Note: Round your answer to 1 decimal place. a. Margin a. Net income % b. Return on equity %

The Rossdale Company has a ratio of long-term debt to long-term debt plus equity of .34 and a current ratio of 1.29. Current liabilities are $1,450, sales are $7,380, profit margin is 8.1 percent, and ROE is 14.3 percent. What is the amount of the firm’s net fixed assets? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)

Southern Style Realty has total assets of $485,390, net fixed assets of $250,000, current liabilities of $23,456, and long-term liabilities of $148,000. What is the total debt ratio? Can you provide the formula?