Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Start with the partial model in the file Ch 1 5 P 1 3 Build a Model.xlsx . J . Clark Inc. ( JCI )

Start with the partial model in the file Ch15 P13 Build a Model.xlsx. J. Clark Inc. (JCI), a manufacturer and distributor of sports equipment, has grown until it has become a stable, mature company. Now JCI is planning its first distribution to shareholders. (See the file for the most recent year's financial statements and projections for the next year, 2022; JCI's fiscal year ends on June 30.) JCI plans to liquidate and distribute $800 million of its short-term securities on July 1,2022, the first day of the next fiscal year, but it has not yet decided whether to distribute with dividends or with stock repurchases.
The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Use a minus sign to enter a negative value, if any.
Download spreadsheet Ch15 P13 Build a Model-7e091a.xlsx
Assume first that JCI distributes the $800 million as dividends. Fill in the missing values in the file's balance sheet column for July 1,2022, which is labeled "Distribute as Dividends." (Hint: Be sure that the balance sheets balance after you fill in the missing items.) Assume that JCI did not have to establish an account for dividends payable prior to the distribution. Enter your answers in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answers to two decimal places.
Distribute as Dividend
7/1/2022
Short-term investments $ fill in the blank 2
million
Treasury stock $ fill in the blank 3
million
Retained earnings $ fill in the blank 4
million
Now assume that JCI distributes the $800 million through stock repurchases. Fill in the missing values in the file's balance sheet column for July 1,2022, which is labeled "Distribute as Repurchase." (Hint: Be sure that the balance sheets balance after you fill in the missing items.) Enter your answers in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answers to two decimal places.
Distribute as Repurchase
7/1/2022
Short-term investments $ fill in the blank 5
million
Treasury stock $ fill in the blank 6
million
Retained earnings $ fill in the blank 7
million
Calculate JCI's projected free cash flow; the tax rate is 25%. Enter your answer in millions. For example, an answer of $1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places.
$ fill in the blank 8
million
What is JCI's current intrinsic stock price (the price on 6/30/2021)? What is the projected intrinsic stock price for 6/30/2022? FCF is expected to grow at a constant rate of 6%, and JCI's WACC is 10%. The firm has 800 million shares outstanding. Round your answers to the nearest cent.
Intrinsic stock price on 6/30/2021: $ fill in the blank 9
Intrinsic stock price on 6/30/2022: $ fill in the blank 10
What is the projected intrinsic stock price on 7/1/2022 if JCI distributes the cash as dividends? Round your answer to the nearest cent.
$ fill in the blank 11
What is the projected intrinsic stock price on 7/1/2022 if JCI distributes the cash through stock repurchases? Round your answer to the nearest cent.
$ fill in the blank 12
How many shares will remain outstanding after the repurchase? Enter your answer in millions. For example, an answer of 1.23 million should be entered as 1.23, not 1,230,000. Round your answer to two decimal places.
fill in the blank 13
million
image text in transcribed

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

Step: 3

blur-text-image

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

Mutual Fund Industry Handbook

Authors: Gremillion

1st Edition

0471736244, 978-0471736240

More Books

Students also viewed these Finance questions

Question

Summarize what happened in the Salomon Brothers manipulation.

Answered: 1 week ago

Question

Identify the two factors in the two-factor theory of emotion.

Answered: 1 week ago

Question

Identify cultural barriers to communication.

Answered: 1 week ago