Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please put in excel formulas and explain. really need help understanding EPS and the change in EPS% Fujita, Inc., has no debt outstanding and a

image text in transcribedimage text in transcribed

please put in excel formulas and explain. really need help understanding EPS and the change in EPS%

Fujita, Inc., has no debt outstanding and a total market value of $222,000. Earnings before interest and taxes, EBIT, are projected to be $18,000 if economic conditions are normal. If there is strong expansion in the economy, then EBIT will be 25 percent higher. If there is a recession, then EBIT will be 30 percent lower. The company is considering a $60,000 debt issue with an interest rate of 7 percent. The proceeds will be used to repurchase shares of stock. There are currently 7,400 shares outstanding. Assume the company has a tax rate of 21 percent, a market-to-book ratio of 1.0 , and the stock price remains constant. a. Calculate earnings per share (EPS) under each of the three economic scenarios before any debt is issued. Also calculate the percentage changes in EPS when the economy expands or enters a recession. b. Repeat part (a) assuming that the company goes through with recapitalization. \begin{tabular}{|c|c|c|c|c|c|} \hline 17 & Output Area: & & & & \\ \hline 18 & & & & & \\ \hline 19 & No debt with taxes & & Recession & Normal & Expansion \\ \hline 20 & EBIT & & $12,600 & $18,000 & $22,500 \\ \hline 21 & Taxes & & 2,646 & 3,780 & 4,725 \\ \hline 22 & NI & r & $9,954 & $14,2200 & 17,775 \\ \hline 23 & EPS & & $1.35 & $1.92 & $2.40 \\ \hline 24 & Change EPS % & r & & & \\ \hline 25 & With debt and taxes & & & & \\ \hline 26 & Share price & & $30.00 & & \\ \hline 27 & Shares repurchased & V & 2,000.00 & & \\ \hline 28 & & & Recession & Normal & Expansion \\ \hline 29 & EBIT & & $12,600 & $18,000VV & $22,500 \\ \hline 30 & Interest & V & 4,200 & 4,200 & 4,200 \\ \hline 31 & EBT & & $8,400 & $13,800 & $18,300 \\ \hline 32 & Taxes & & 1,764 & 2,898 & 3,843 \\ \hline 33 & NI & & 6,636 & 10,902 & 14,457 \\ \hline 34 & EPS & & $0.90 & $5.45 & \\ \hline 35 & Change EPS\% & r & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Entrepreneurial Finance

Authors: Rassoul Yazdipour

2011th Edition

148998190X, 978-1489981905

More Books

Students also viewed these Finance questions