Question

In: Finance

Johnson Transformers Inc. Following is the seven-year forecast for a new venture called Johnson Transformers: (all...

Johnson Transformers Inc.

Following is the seven-year forecast for a new venture called Johnson Transformers: (all amounts in $000)

	2020	2021	2022	2023	2024	2025	2026
EBIT	$(1000)	$(900)	$200	$1,200	$2,500	$3000	$3,050
Capital Expenditures	$550	$350	$200	$175	$175	$160	$150
Changes in Working Capital	$400	$300	$200	$100	$100	($100)	($100)
Depreciation	$40	$80	$125	$150	$150	$150	$150

Beginning after year 2026 the annual growth in EBIT is expected to be 1.5%, a rate that is projected to be constant over Johnson Transformers remaining life as an enterprise. Beginning in 2026 Johnson's Transformers capital expenditures and depreciation are expected to offset each other (capex - depreciation = 0) and year to year changes in working capital are expected to be zero (working capital levels remain constant year over year). For discounting purposes consider 2020 as year 1.

Assume a tax rate is 21% and a cost of capital of 7.75%

Question 1: Determine the NPV of Johnson Transformers Free Cash Flow for the years 2020 -2026. HINT: Remember to account for loss carry-forwards when determining income taxes. The answer to this question was determined in Excel. Your answer may deviate slightly depending upon differences in truncation and rounding. Answers below are in $000.

Answer: $2105

Calculate the fair market value (NPV) for Johnson Transformers. For this problem assume that the Net Present Value of Johnson Transformers free cash flow for the period 2020 - 2026 is $3000 (NOTE its not $3000 but make this assumption in case the answer you determined in the first question was incorrect. Assume no underlying changes to any of the data in the problem. DO NOT USE YOUR ANSWER FROM THE QUESTION ABOVE. All ANSWERS ARE IN $000

$26,206

$22,089

$24,536

$21,830

$34,476

Expert Solution

First, we calculate the net operating cash flow for each year

net operating cash flow = EBIT - capex - change in working capital + depreciation - tax outgo

In the first two years, the accumulated losses are 1000 + 900 = 1900. This is carried forward to the future years and set off against the EBIT of those years until the accumulated losses are completely set off. In year 3 and year 4, the EBIT is completely set off , and the tax outgo is zero. In year 5, the accumulated losses remaining are 1900 - 200 - 1200 = 500. In year 5 the EBIT is 2500. therefore tax outgo = (2500 - 500) * 21% = 420. In years 6 and 7 tax outgo = EBIT * 21%

Next we compute the Present value factor for each year using the 7.75% discount rate. PVF = 1 / (1 + 0.0775)^year

Present value of each cash flow = Net cash flow * PVF

The sum of these PVs is the NPV of the cash flows

NPV = 2,105

Next, we compute the value of Johnson Transformers at the end of 2026 using the constant growth formula.

Value of constant growth cash flow = (cashflow at end of next year) / (required rate of return - constant growth rate)

value at end of 2026 = (2510 + 1.5%) / 7.75% - 1.5%

value at end of 2026 = 40,754

now we discount this back to the present. present value = 40,754 / (1+ 7.5%)^7 = 24,169

Fair market value of Johnson Transformers = present value of cashflows + present value of value at end of 2026

Fair market value of Johnson Transformers = 2,105 + 24,169 = 26,274

jeff jeffy answered 1 year ago

Part 1 Johnson Transformers Inc. Following is the seven-year forecast for a new venture called Johnson...

Part 1 Johnson Transformers Inc. Following is the seven-year forecast for a new venture called Johnson Transformers: (all amounts in $000) 2020 2021 2022 2023 2024 2025 2026 EBIT $(1000) $(900) $200 $1,200 $2,500 $3000 $3,050 Capital Expenditures $550 $350 $200 $175 $175 $160 $150 Changes in Working Capital $400 $300 $200 $100 $100 ($100) ($100) Depreciation $40 $80 $125 $150 $150 $150 $150 Beginning after year 2026 the annual growth in EBIT is expected to be 1.5%, a rate...

Following is the seven-year forecast for a new venture called Johnson Transformers: (all amounts in $000)...

Following is the seven-year forecast for a new venture called Johnson Transformers: (all amounts in $000) 2020 2021 2022 2023 2024 2025 2026 EBIT $(1000) $(900) $200 $1,200 $2,500 $3000 $3,050 Capital Expenditures $550 $350 $200 $175 $175 $160 $150 Changes in Working Capital $400 $300 $200 $100 $100 ($100) ($100) Depreciation $40 $80 $125 $150 $150 $150 $150 Beginning after year 2026 the annual growth in EBIT is expected to be 1.5%, a rate that is projected to be...

JT Inc Following is the seven-year forecast for a new venture called JT Inc: (all amounts...

JT Inc Following is the seven-year forecast for a new venture called JT Inc: (all amounts in $000) 2020 2021 2022 2023 2024 2025 2026 EBIT $(1000) $(900) $200 $1,200 $2,500 $3000 $3,050 Capital Expenditures $550 $350 $200 $175 $175 $160 $150 Changes in Working Capital $400 $300 $200 $100 $100 ($100) ($100) Depreciation $40 $80 $125 $150 $150 $150 $150 Beginning after year 2026 the annual growth in EBIT is expected to be 1.5%, a rate that is projected...

Railback Battery Systems Following is the seven-year forecast for a new venture called Railback Battery Systems:...

Railback Battery Systems Following is the seven-year forecast for a new venture called Railback Battery Systems: Year 2020 2021 2022 2023 2024 2025 2026 EBIT ($1,000) ($900) $200 $1,200 $2,500 $3,000 $3,050 Capital Expenditures $550 $350 $200 $175 $175 $160 $150 Changes in Working Capital $400 $300 $200 $100 $100 ($100) ($100) Depreciation $40 $80 $125 $150 $150 $150 $150 Part 1: Beginning after year 2026 the annual growth in EBIT is expected to be 1.5%, a rate that is...

LG Following is the seven-year forecast for LG: (all amounts in $000) 2020 2021 2022 2023...

LG Following is the seven-year forecast for LG: (all amounts in $000) 2020 2021 2022 2023 2024 2025 2026 EBIT $(1000) $(900) $200 $1,200 $2,500 $3000 $3,050 Capital Expenditures $550 $350 $200 $175 $175 $160 $150 Changes in Working Capital $400 $300 $200 $100 $100 ($100) ($100) Depreciation $40 $80 $125 $150 $150 $150 $150 Beginning after year 2026 the annual growth in EBIT is expected to be 1.5%, a rate that is projected to be constant over LG remaining...

1) For the following situation, develop a seven-year forecast of net operating income for the St....

1) For the following situation, develop a seven-year forecast of net operating income for the St. George Apartments, incporating the following assumptions: a) Potential gross rent and misc. other income will grow at 2.5% per annum over the forecast period b) Vacancies in the market area will remain constant over the forecast period c) Operating expenses other than management fees and property taxes will growt at 2.5% per annum over the forecast period d) Management fees as a percent of...

For the year ended December 31, 2017, Transformers Inc. reported the following: Net Income $305068 Preferred...

For the year ended December 31, 2017, Transformers Inc. reported the following: Net Income $305068 Preferred dividends paid 54210 Common dividends paid 9619 Unrealized holding loss, net of tax 3543 Retained Earnings, beginning balance 389503 Common Stock 177628 Accumulated Other Comprehensive Income, beginning balance 22896 What would Transformers report as the ending balance of Retained Earnings?

Provide a forecast on a new product that you will be developing. Often managers are called...

Provide a forecast on a new product that you will be developing. Often managers are called upon to make forecasts for these new products when they don't have historical sales data inside the company. What secondary sources of data might you find? Who specifically would provide it (e.g.: the US Census, US Dept of Commerce, ComScore, Nelsen, . . .)? How would this data be used to support your forecast?

Elakin Inc., a calendar year taxpayer, paid $1,339,000 for new machinery (seven-year recovery property) placed in...

Elakin Inc., a calendar year taxpayer, paid $1,339,000 for new machinery (seven-year recovery property) placed in service on August 29, 2017. The machinery was Elakin’s only asset purchase during 2017, and Elakin’s taxable income before any Section 179 deduction was $14 million. Compute Elakin’s 2017 cost recovery deduction with respect to the machinery. How would your answer change if the cost of the machinery was $2,150,000 instead of $1,339,000? How would your answer to a. change if Elakin’s taxable income...

Throughout the year, Johnson Inc. had the following shares outstanding. There were no shares issued or...

Throughout the year, Johnson Inc. had the following shares outstanding. There were no shares issued or repurchased during the year. Preferred shares, $3.00, unlimited number authorized,60,000 issued and outstanding $12,000,000 Common shares, unlimited number authorized, 420,000 issued and outstanding . 24,000,000 Total contributed capital $36,000,000 Net income for the year was $ 1,590,000. Loss from discontinued operations (net of tax)of $-159,000was included in net income for the year. Required: Prepare the basic EPS presentation for the company assuming: 1.The preferred...