Question

In: Finance

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 to be constant over JT Inc remaining life as an enterprise.   Beginning in 2026 JT Inc 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%

Determine the NPV of JT Inc Free Cash Flow for the years 2020 -2026. HINT: Remember to account for loss carry-forwards when determining income taxes.

Solutions

Expert Solution

All amounts mentioned are in $000

First, we calculate the free cash flows from years 2020 to 2026:

Losses in 2020 and 2021 are $1000 + $900, which is $1900. This loss is carried forward, and set off against EBIT of future years. The EBIT of 2022 and 2023 ($1,400) is entirely set off against the carried forward losses. In 2024, the remaining carried forward loss of $500 is set off against EBIT of $2500. The tax payment in 2024 is ($2,500 - $500) * 21%. In 2025 and 2026, tax payment = EBIT * 21%

Free cash flow = EBIT - tax + deprecation - increase in working capital - capital expenditure

Each of these free cash flows are discounted back to the present using the discount rate of 7.75%

Present value of free cash flow of year X = free cash flow / (1 + 7.75%)^X

Sum of these free cash flows = $2,105

Next, we calculate the value of the future cash flows after 2026:

EBIT in 2027 = $3,050 + 1.5% ==> $3,095.75

Free cash flow in 2027 = EBIT(1 - tax rate) ==> $3,095.75 (1 - 0.79) ==> $2,445.64

As the 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, no other adjustments to EBIT are required

Terminal value of free cash flows (in 2026) = Free cash flow in 2027 / (cost of capital - constant growth rate)

Terminal value in 2026 = $2,445.64 / (0.0775 - 0.015) ==> $39,130.24

Present value of Terminal value = $39,130.24 / (1 + 0.0775)^7 ==> $23,206

NPV = sum of PV of free cash flows + PV of terminal value

NPV = $2,105 + $23,206

NPV = $25,311


Related Solutions

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...
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...
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...
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...
Riley Incorporated reports the following amounts at the end of the year (all amounts in $000):...
Riley Incorporated reports the following amounts at the end of the year (all amounts in $000): Cash $16,140 Product Revenues $112,500 Depreciation Expense 3,210 Mortgage Payable 38,000 Taxes Payable 1,020 Treasury Stock 650 Buildings 79,000 Salaries 62,800 Land 40,000 Accumulated Depreciation 21,730 Current Portion - Notes and Mortgage Payable 2,200 Accounts Payable 18,500 Equipment 42,000 Net Accounts Receivable 23,500 Income Tax Expense 3,650 Discounts on Notes Payable 7,950 Interest Expense 4,000 Inventory 6,400 Notes Payable 25,650 Costs of Goods Sold...
Riley Incorporated reports the following amounts at the end of the year (all amounts in $000):...
Riley Incorporated reports the following amounts at the end of the year (all amounts in $000): Cash Depreciation Expense Taxes Payable $ 16,140 3,210 1,020 Product Revenues Mortgage Payable Treasury Stock $ 112,500 38,000 650 Buildings Land Current Portion of Notes and Mortgages Payable 79,000 40,000 2,200 Salaries Accumulated Depreciation 62,800 21,730 Accounts Payable Net Accounts Receivable 18,500 23,500 Equipment Income Tax Expense Discount on Notes Payable 42,000 3,650 7,950 Interest Expense Notes Payable Utilities 4,000 25,650 350 Inventory Costs...
Riley Incorporated reports the following amounts at the end of the year (all amounts in $000):...
Riley Incorporated reports the following amounts at the end of the year (all amounts in $000): Cash Depreciation Expense Taxes Payable $ 16,140 3,210 1,020 Product Revenues Mortgage Payable Treasury Stock $ 112,500 38,000 650 Buildings Land Current Portion of Notes and Mortgages Payable 79,000 40,000 2,200 Salaries Accumulated Depreciation 62,800 21,730 Accounts Payable Net Accounts Receivable 18,500 23,500 Equipment Income Tax Expense Discount on Notes Payable 42,000 3,650 7,950 Interest Expense Notes Payable Utilities 4,000 25,650 350 Inventory Costs...
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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT