How to calculate the cost of debt based on what the company is currently paying for its debt? Considering the fact I want to value a firm's value as of 1st January 2023.
How to calculate the cost of debt based on what the company is currently paying for its debt? Considering the fact I want to value a firm's value as of 1st January 2023.
How to calculate the cost of debt based on what the company is currently paying for its debt? Considering the fact I want to value a firm's value as of 1st January 2023.
How to calculate the cost of debt based on what the company is currently paying for its debt? Considering the fact I want to value a firm's value as of 1st January 2023.
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.
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.
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
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