Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Show Full Process/Details with Formula on Excel.
Calculate (1) Horizon Value (HV) or Terminal Value (TV) and (2) Value of Operations
![Company Financial Statements (Mllions, Except for Per Share Data)
INCOME STATEMENTS
BALANCE SHEETS
2018
5,000
2019 Assets
2018
2019
Net sales
4,760
3.560
Cash
ST Investments
Accounts receivable
Inventories
Total CA
Net PP&E
60
50
COGS (excl. depr.)
3,800
40
Depreciation
Other operating expenses
170
200
380
500
1,000
480
1550
500
820
EBIT
500
1,300
1,550
Interest expense
120
1,700
2,000
100
Pre-tax earnings
450
380
Total assets
3,000
3,550
Taxes (40%)
180
152
NI before pref. div.
Preferred div.
Liabilities and equity
Асcounts payable
Accruals
Notes payable
Total CL
$50 Long-term bonds
S170 Total liabilities
40% Preferred stock
270
8
228
8
190
200
Net income
262
220
280
300
130
280
Other Data
600
780
Common dividends
$48
1,000
1,200
Addition to RE
$214
1,600
1,980
Tax rate
40%
100
100
Shares of common stock
50
50 Common stock
500
500
970
Earnings per share
Dividends per share
$4.40 Retained earnings
$1.00 Total common equity
$27.00 Total liabs. & equity
$5.24
800
$0.96
1,300
1,470
Price per share
$40.00
3,000
3,550
Actual
Forecast
Sales Revenues
2019
2020
2021
2022
2023
2024
Net sales
5000
5500
5940
6355.8
6673.59 7007.27
Operating Assets and Operating Liabilities
Cash
50
55
59.4
63,558
66,74
70.07
Accounts receivable
500
550
594
635.58
667.36
700.73
Inventories
1000
1100
1188
1271.16
1334.72
1401.45
Net PP&E
2000
2200
2376
2542.32
2669.44
2802.91
Accounts payable
200
220
237.6
254.232
266.94
280.29
Accruals
300
330
356.4
381.348
400.42
420,44
Operating Income
COGS (excl. depr.)
3800
4180
4514.4
4830.408
5071.93
5325.52
200
220
237.6
254.232
266.94
Depreciation
Other operating expenses
280.29
500
550
594
635.58
667.36
700.73
EBIT
500
550
594
635.58
667.36
700.73
Net operating profit after taxes
300
330
356.4
381.348
400.42
420.44
Free Cash Flows
1247.4
1471.53
Net operating working capital
Total operating capital
FCF = NOPAT - A op capital
1050
1155
1334.718
1401,45
3623.4
4070.89
206,56
3050
3355
3877.038
4274.43
-260
88
127.71
216.89
Target WACC
10.97%
10.97%
10.97%
10.97%
10.97%
Growth rates in FCF
252.00%
45.12%
61.74%
5.00%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9717c547-8e97-45c0-ac91-4dd858ed1b92%2F37b0d75a-eca4-494a-9891-a7c2d0521697%2Fc6ng8xk_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Company Financial Statements (Mllions, Except for Per Share Data)
INCOME STATEMENTS
BALANCE SHEETS
2018
5,000
2019 Assets
2018
2019
Net sales
4,760
3.560
Cash
ST Investments
Accounts receivable
Inventories
Total CA
Net PP&E
60
50
COGS (excl. depr.)
3,800
40
Depreciation
Other operating expenses
170
200
380
500
1,000
480
1550
500
820
EBIT
500
1,300
1,550
Interest expense
120
1,700
2,000
100
Pre-tax earnings
450
380
Total assets
3,000
3,550
Taxes (40%)
180
152
NI before pref. div.
Preferred div.
Liabilities and equity
Асcounts payable
Accruals
Notes payable
Total CL
$50 Long-term bonds
S170 Total liabilities
40% Preferred stock
270
8
228
8
190
200
Net income
262
220
280
300
130
280
Other Data
600
780
Common dividends
$48
1,000
1,200
Addition to RE
$214
1,600
1,980
Tax rate
40%
100
100
Shares of common stock
50
50 Common stock
500
500
970
Earnings per share
Dividends per share
$4.40 Retained earnings
$1.00 Total common equity
$27.00 Total liabs. & equity
$5.24
800
$0.96
1,300
1,470
Price per share
$40.00
3,000
3,550
Actual
Forecast
Sales Revenues
2019
2020
2021
2022
2023
2024
Net sales
5000
5500
5940
6355.8
6673.59 7007.27
Operating Assets and Operating Liabilities
Cash
50
55
59.4
63,558
66,74
70.07
Accounts receivable
500
550
594
635.58
667.36
700.73
Inventories
1000
1100
1188
1271.16
1334.72
1401.45
Net PP&E
2000
2200
2376
2542.32
2669.44
2802.91
Accounts payable
200
220
237.6
254.232
266.94
280.29
Accruals
300
330
356.4
381.348
400.42
420,44
Operating Income
COGS (excl. depr.)
3800
4180
4514.4
4830.408
5071.93
5325.52
200
220
237.6
254.232
266.94
Depreciation
Other operating expenses
280.29
500
550
594
635.58
667.36
700.73
EBIT
500
550
594
635.58
667.36
700.73
Net operating profit after taxes
300
330
356.4
381.348
400.42
420.44
Free Cash Flows
1247.4
1471.53
Net operating working capital
Total operating capital
FCF = NOPAT - A op capital
1050
1155
1334.718
1401,45
3623.4
4070.89
206,56
3050
3355
3877.038
4274.43
-260
88
127.71
216.89
Target WACC
10.97%
10.97%
10.97%
10.97%
10.97%
Growth rates in FCF
252.00%
45.12%
61.74%
5.00%
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education