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 Financial income Financial expense EBT Cash Equity Financial Debt Trade Payables ■ Impairment and gains or losses on disposals of fixed assets Depreciation & Amortization Corporate taxes (25%) Net Income % Net income margin 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). Balance Sheet Data Fixed Assets Inventories Trade Receivables Short-term financial investments 2021A 2022A 2023B 2024F 2025F 2026F 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 -130,015 12,664 -163,885 1,075,986 -268,996 806,989 4.04% 2024F 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 3,273,708 2,672,321 2,859,383 3,059,540 2,982,767 3,131,906 3,288,501 3,452,926 3,042,927 3,195,074 3,354,827 3,522,569 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 3,452,942 6,831,249 2,982,781 3,131,920 3,288,516 5,901,090 6,196,144 6,505,951
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 Financial income Financial expense EBT Cash Equity Financial Debt Trade Payables ■ Impairment and gains or losses on disposals of fixed assets Depreciation & Amortization Corporate taxes (25%) Net Income % Net income margin 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). Balance Sheet Data Fixed Assets Inventories Trade Receivables Short-term financial investments 2021A 2022A 2023B 2024F 2025F 2026F 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 -130,015 12,664 -163,885 1,075,986 -268,996 806,989 4.04% 2024F 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 3,273,708 2,672,321 2,859,383 3,059,540 2,982,767 3,131,906 3,288,501 3,452,926 3,042,927 3,195,074 3,354,827 3,522,569 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 3,452,942 6,831,249 2,982,781 3,131,920 3,288,516 5,901,090 6,196,144 6,505,951
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
Calculate the
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 2 images
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
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
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…
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