Question: SOLVE USING EXCEL Makers Corp. had additions to retained earnings for the year just ended of $395,000. The firm paid out $195,000 in cash dividends,

SOLVE USING EXCEL Makers Corp. had additions to retained earnings for the year just ended of $395,000. The firm paid out $195,000 in

SOLVE USING EXCEL

Makers Corp. had additions to retained earnings for the year just ended of $395,000. The firm paid out $195,000 in cash dividends, and it has ending total equity of $5.3 million. If the company currently has 170,000 shares of common stock outstanding, what are earnings per share? Dividends per share? Book value per share? If the stock currently sells for $64 per share, what is the market-to-book ratio? The price-earnings ratio? If the company had sales of $5.15 million, what is the price-sales ratio? Addition to retained earnings Cash dividends Total equity Common shares outstanding Share price Sales $ 395,000 $ 195,000 $ 5,300,000 170,000 $ 64 $ 5,150,000 Complete the following analysis. Do not hard code values in your calculations. Net income Earnings per share Dividends per share Book value per share Market-to-book ratio Price-earnings ratio Sales per share Price-sales ratio

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

2. Aerotron Radio Inc. has $250,000 available and its engineering staff has proposed the following indivisible investments. With each, Aerotron can exit at the end of its planning horizon of 5 years...

Martinez Corporation had additions to retained earnings for the year just ended of $ The firm paid out $ in cash dividends, and it has ending total equity of $ 5 . 7 million. The company currently...

Ford Corp. had additions to retained earnings for the year just ended of $248,00 firm paid out S187,000 in cash dividends, and it has ending total equity of $5.42 The company currently has 150,000...

Makers Corp. had additions to retained earnings for the year just ended of $553,000. The firm paid out $191,000 in cash dividends, and it has ending total equity of $4.96 million. The company...

XL Calculating market value ratios - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial 12 AA % Ee Paste BIU. A- Alignment Number Cells Editing Conditional Format as Cell...

ANSWER MUST BE IN EXCEL FORMULA FORMAT H 3 Makers Corp. had additions to retained earnings for the year just ended of $395,000. The firm paid out $195,000 in cash dividends, and it has ending total...

Makers Corp. had additions to retained earnings for the year just ended of $268, 000. The firm paid out $188, 000 in cash dividends, and it has ending total equity of $4.93 million. The company...

Makers Corp. had additions to retained earnings for the year just ended of $230, 000. The firm paid out $186,000 in cash dividends, and it has ending total equity of $4.91 million. The company...

Makers Corp. had additions to retained earnings for the year just ended of $395,000. The firm paid out $195,000 in cash dividends, and it has ending total equity of $5.3 million. If the company...

All answers must be entered as formulas (using cell names) AB Makers Corp. had additions to retained earnings for the year just ended of $395,000. The firm paid out $195,000 in cash dividends, and it...

a) 95 | x 3 -R subspora of IR 3. b) 9s subspare

Go to the IRS Web site (tvww.irs.gov) and locate Publication 501: Exemptions, Standard Deduction, and Filing Information. What documentation is necessary for a taxpayer with impaired vision to...

Company X , which is an oil and gas producer, sells crude oil in the spot market on a monthly schedule. A crude oil swap is quoted by the dealer at $ 7 5 . Which of the following statements is...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...