Calculate the Terminal Value using the Perpetual growth Method Cost of Capital using WACC = 11.02% Terminal growth rate = 3%

Financial Accounting Intro Concepts Meth/Uses
14th Edition
ISBN:9781285595047
Author:Weil
Publisher:Weil
Chapter9: Working Capital
Section: Chapter Questions
Problem 21E
icon
Related questions
Question

Calculate the Terminal Value using the Perpetual growth Method

Cost of Capital using WACC = 11.02%

Terminal growth rate = 3%

Analyst 3: MOUNTIER Ltd.
Industry: Manufacturing - Household products (Manufacturer of furniture, appliances
such as a microwave or toaster oven, electronic equipment such as TVs and computers).
Geographical presence: Production in the UK and sales across Europe; Spain, France
and Italy main markets (90%).
Additional notes:
Profit and loss Data
Net Sales
COGS
Operating Expenses
Other results
Corporate taxes (25%)
Net Income
% Net income margin
Cash
Equity
Financial Debt
Trade Payables
Impairment and gains or losses on disposals of fixed assets
Depreciation & Amortization
Financial income
Financial expense
EBT
Balance Sheet Data
Fixed Assets
The company has performed a department restructuring during 2022, incurring
in cost of £457,058.
The manager's daughter is receiving a salary of £21,000 annually from the
company but she is not performing any task in the company. This person will no
longer receive this compensation.
All results are reinvested in the company (no divided forecasted for the next 5
years).
Inventories
Trade Receivables
Short-term financial investments
2026F
2021A
2022A
2023B
2024F
2025F
17,532,511 17,926,614 18,849,738 19,648,151 19,970,643 20,173,807
-13,324,708 -13,624,227 -14,325,801 -14,932,595 -15,177,689 -15,332,093
-3,313,511 -3,339,195 -3,414,061 -3,430,758 -3,435,733 -3,516,965
-457,058
0
-112,850
10,440
-148,317
255,407
-63,852
191,555
1.07%
0
26,728
-109,070
9,451
-144,804
676,596
-169,149
507,447
2.89%
2021A
2,181,410
2,576,627
2,628,595
507,911
1,062,908
1,154,396
2,705,470
5,097,583
2022A
2,334,108
2,705,458
2,760,025
533,307
2,864,517
3,139,482
2,705,470
5,352,462
0
0
-114,570
11,263
-156,213
850,356
-212,589
637,767
3.38%
0
0
-121,472
11,695
-159,905
1,015,116
-253,779
761,337
3.87%
2023 B
2,497,496
2,840,731
2,898,026
559,972
5,300,222
5,635,617
2,840,744
5,620,085
0
0
2024F
-130,015
12,664
-163,885
1,075,986
-268,996
806,989
4.04%
0
0
-135,977
12,745
-165,306
1,036,210
-259,052
777,157
3.85%
2027F
20,215,389
-15,363,695
-3,560,131
0
0
-142,774
13,613
-172,647
989,754
-247,439
742,316
3.67%
2025F
2026F
2027F
2,672,321 2,859,383
3,059,540
3,273,708
2,982,767 3,131,906 3,288,501
3,452,926
3,522,569
3,042,927 3,195,074 3,354,827
587,970 617,369
648,237 680,649
7,825,692 10,443,981 13,158,226 15,971,649
8,227,807 10,919,648 13,714,864 16,617,310
2,982,781 3,131,920 3,288,516 3,452,942
5,901,090 6,196,144 6,505,951 6,831,249
Transcribed Image Text:Analyst 3: MOUNTIER Ltd. Industry: Manufacturing - Household products (Manufacturer of furniture, appliances such as a microwave or toaster oven, electronic equipment such as TVs and computers). Geographical presence: Production in the UK and sales across Europe; Spain, France and Italy main markets (90%). Additional notes: Profit and loss Data Net Sales COGS Operating Expenses Other results Corporate taxes (25%) Net Income % Net income margin Cash Equity Financial Debt Trade Payables Impairment and gains or losses on disposals of fixed assets Depreciation & Amortization Financial income Financial expense EBT Balance Sheet Data Fixed Assets The company has performed a department restructuring during 2022, incurring in cost of £457,058. The manager's daughter is receiving a salary of £21,000 annually from the company but she is not performing any task in the company. This person will no longer receive this compensation. All results are reinvested in the company (no divided forecasted for the next 5 years). Inventories Trade Receivables Short-term financial investments 2026F 2021A 2022A 2023B 2024F 2025F 17,532,511 17,926,614 18,849,738 19,648,151 19,970,643 20,173,807 -13,324,708 -13,624,227 -14,325,801 -14,932,595 -15,177,689 -15,332,093 -3,313,511 -3,339,195 -3,414,061 -3,430,758 -3,435,733 -3,516,965 -457,058 0 -112,850 10,440 -148,317 255,407 -63,852 191,555 1.07% 0 26,728 -109,070 9,451 -144,804 676,596 -169,149 507,447 2.89% 2021A 2,181,410 2,576,627 2,628,595 507,911 1,062,908 1,154,396 2,705,470 5,097,583 2022A 2,334,108 2,705,458 2,760,025 533,307 2,864,517 3,139,482 2,705,470 5,352,462 0 0 -114,570 11,263 -156,213 850,356 -212,589 637,767 3.38% 0 0 -121,472 11,695 -159,905 1,015,116 -253,779 761,337 3.87% 2023 B 2,497,496 2,840,731 2,898,026 559,972 5,300,222 5,635,617 2,840,744 5,620,085 0 0 2024F -130,015 12,664 -163,885 1,075,986 -268,996 806,989 4.04% 0 0 -135,977 12,745 -165,306 1,036,210 -259,052 777,157 3.85% 2027F 20,215,389 -15,363,695 -3,560,131 0 0 -142,774 13,613 -172,647 989,754 -247,439 742,316 3.67% 2025F 2026F 2027F 2,672,321 2,859,383 3,059,540 3,273,708 2,982,767 3,131,906 3,288,501 3,452,926 3,522,569 3,042,927 3,195,074 3,354,827 587,970 617,369 648,237 680,649 7,825,692 10,443,981 13,158,226 15,971,649 8,227,807 10,919,648 13,714,864 16,617,310 2,982,781 3,131,920 3,288,516 3,452,942 5,901,090 6,196,144 6,505,951 6,831,249
Expert Solution
steps

Step by step

Solved in 5 steps with 2 images

Blurred answer
Knowledge Booster
Classification and Prediction of Corporate Financial Distress
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Accounting Intro Concepts Meth/Uses
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:
9781285595047
Author:
Weil
Publisher:
Cengage
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning