Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Geographical presence: Production in the UK and sales across Europe; UK and Germany main markets (90%) Additional notes: The company has sold non-core assets during



Geographical presence: Production in the UK and sales across Europe; UK and Germany main markets (90%)


Additional notes:

The company has sold non-core assets during 2022, generating a profit of 15,622.

The company has performed a department restructuring during 2022, incurring in cost of 323,900.

The manager's daughter is receiving a salary of 16,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).

Profit and loss Data 2021A 2022A 2023B 2024F 2025F 2026F 2027F
Net Sales(+) 17,439,530 18,137,111 18,862,596 19,617,100 20,401,784 21,217,855 22,066,569
COGS(-) -13,254,043 -13,784,205 -14,335,573 -14,908,996 -15,505,355 -16,125,570 -16,770,592
Operating Expenses(-) -2,092,744 -2,161,329 -2,178,220 -2,222,537 -2,320,277 -2,380,742 -2,400,366
Other results(+/-) 0 -323,900 0 0 0 0 0
Impairment and gains or losses on disposals of fixed assets(+/-) 26,728 15,622 0 0 0 0 0
Depreciation & Amortization(-) -109,070 -116,503 -123,531 -126,245 -135,555 -144,509 -144,840
Financial income(+) 10,567 10,814 11,592 11,676 11,742 12,703 13,613
Financial expense(-) -144,528 -150,782 -160,441 -162,519 -164,366 -170,424 -172,647








EBT 1,876,440 1,626,829 2,076,423 2,208,479 2,287,972 2,409,313 2,591,737
Corporate taxes (25%) -469,110 -406,707 -519,106 -552,120 -571,993 -602,328 -647,934








Net Income 1,407,330 1,220,122 1,557,317 1,656,359 1,715,979 1,806,985 1,943,802
% Net income margin 8.07% 6.73% 8.26% 8.44% 8.41% 8.52% 8.81%
















Balance Sheet Data 2021A 2022A 2023B 2024F 2025F 2026F 2027F
Fixed Assets 2,181,410 2,334,108 2,497,495 2,672,321 2,859,383 3,059,540 3,273,708
Inventories 2,576,627 2,705,458 2,840,731 2,982,767 3,131,906 3,288,501 3,452,926
Trade Receivables 2,628,595 2,760,025 2,898,026 3,042,927 3,195,074 3,354,827 3,522,569
Short-term financial investments 507,911 533,307 559,972 587,970 617,369 648,237 680,649
Cash 1,062,908 1,144,381 1,599,513 2,065,188 2,541,290 3,027,660 3,524,094
Equity 1,154,396 1,419,346 1,934,909 2,467,303 3,016,957 3,584,298 4,169,754
Financial Debt 2,705,470 2,705,470 2,8.407.44 2,982,781 3,131,920 3,288,516 3,452,942
Trade Payables 5,097,583 5,352,462 5,620,085 5,901,090 6,196,144 6,505,951 6,831,249








FCFF






EBITDA 1,985,510 1,743,332 2,199,954 2,334,724 2,423,527 2,553,822 2,736,577


1. Calculate the Weighted Average Cost of Capital (WACC)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Weighted Average Cost of Capital WACC is the average rate of return required by the companys investo... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business To Business Marketing

Authors: Ross Brennan , Louise Canning , Raymond McDowell

5th Edition

1526494396, 1529726174, 9781526494399, 9781529726176

More Books

Students also viewed these Finance questions

Question

What does surplus energy mean to civilizations?

Answered: 1 week ago