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
Financial Accounting Intro Concepts Meth/Uses
14th Edition
ISBN:9781285595047
Author:Weil
Publisher:Weil
Chapter9: Working Capital
Section: Chapter Questions
Problem 21E
Related questions
Question
Calculate the
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
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning