Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Q1- Assuming that the net income of the following years starting from 2024 will be constant forever and equal to the historical average growth of
Q1- Assuming that the net income of the following years starting from 2024 will be constant forever and equal to the "historical average growth of net income" you calculated multiplied by the net income of 2023, what is the value of equity of the company at the start of 2024? if the required rate of return is 7%
4- Calculate the yearly dividend and the historical average growth of dividends.
\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Group 6} \\ \hline & 2019 & 2020 & 2021 & 2022 & 2023 \\ \hline \multicolumn{6}{|c|}{ } \\ \hline Net Sales (Revenue) & 207,875 & 199,560 & 247,454 & 324,165 & 317,682 \\ \hline Cost of goods sold & 76,914 & 79,824 & 76,711 & 100,491 & 117,542 \\ \hline Gross Profit & 130,961 & 119,736 & 170,744 & 223,674 & 200,140 \\ \hline Selling \& General costs & 43,654 & 51,886 & 51,965 & 74,558 & 79,420 \\ \hline Administrative costs & 58,205 & 51,886 & 66,813 & 64,833 & 88,951 \\ \hline Depreciation & 4,837 & 3,559 & 5,575 & 7,119 & 7,336 \\ \hline Operating Profit (EBIT) & 24,265 & 12,406 & 46,391 & 77,164 & 24,433 \\ \hline Interest & 1,216 & 1,897 & 2,226 & 3,636 & 3,801 \\ \hline Taxable Income & 23,049 & 10,509 & 44,165 & 73,528 & 20,631 \\ \hline taxes & 3,457 & 1,576 & 6,625 & 11,029 & 3,095 \\ \hline Net profit & 19,592 & 8,932 & 37,539 & 62.499 & 17,537 \\ \hline & 2019 & 2020 & 2021 & 2022 & 2023 \\ \hline \multicolumn{6}{|c|}{ } \\ \hline \multicolumn{6}{|l|}{ Assets } \\ \hline \multicolumn{6}{|l|}{ Current Assets: } \\ \hline Cash & 1,809 & 1,956 & 1,633 & 6,921 & 4,403 \\ \hline Short-term investments & 2,713 & 3,261 & 2,821 & 9,393 & 5,976 \\ \hline Accounts receivable & 5,064 & 5,380 & 3,415 & 12,359 & 11,008 \\ \hline Inventory & 8,500 & 5,706 & 6,978 & 20,763 & 10,064 \\ \hline Total Current Assets & 18,085 & 16,304 & 14,847 & 49,435 & 31,451 \\ \hline \multicolumn{6}{|l|}{ Fixed Assets: } \\ \hline Long-term investments & 30,745 & 23,632 & 32,664 & 47,458 & 42,982 \\ \hline Property, plant and equipment & 60,465 & 44,484 & 69,683 & 88,983 & 91,696 \\ \hline Goodwill and intangible assets & 11,273 & 1,390 & 6,533 & 11,864 & 8,596 \\ \hline Total Fixed Assets & 102,482 & 69,507 & 108,880 & 148,306 & 143,275 \\ \hline Total Assets & 120,568 & 85,811 & 123,727 & 197,741 & 174,725 \\ \hline \multicolumn{6}{|l|}{ antagonists } \\ \hline \multicolumn{6}{|l|}{ Current liabilities: } \\ \hline Accounts payable & 2,890 & 2,054 & 2,652 & 7,059 & 3,422 \\ \hline Short-term debt & 1,809 & 1,670 & 1,604 & 5,547 & 3,425 \\ \hline Other Current liabilities & 5,093 & 4,151 & 4,751 & 2,788 & 1,684 \\ \hline \multirow{3}{*}{\begin{tabular}{l} Total Current Liabilities \\ Long-term liabilities: \\ Long-term debt \\ \end{tabular}} & 9,791 & 7,875 & 9,006 & 15,394 & 8,530 \\ \hline & & & & & \\ \hline & 23,967 & 37,605 & 44,196 & 71,612 & 75,338 \\ \hline Total long-term liabilities & 23,967 & 37,605 & 44,196 & 71,612 & 75,338 \\ \hline Total Liabilities & 33,759 & 45,480 & 53,203 & 87,006 & 83,868 \\ \hline \multicolumn{6}{|l|}{ Equity: } \\ \hline Common Stock & 67,634 & 27,576 & 40,752 & 68,155 & 70,677 \\ \hline Preferred Shares & 7,515 & 6,894 & 8,347 & 7,573 & 9,638 \\ \hline Retained earnings & 11,660 & 5,860 & 21,426 & 35,007 & 10,542 \\ \hline Total Shareholders' Equity & 86,809 & 40,331 & 70,525 & 110,735 & 90,857 \\ \hline Total Liabilities and Equity & 120,568 & 85,811 & 123,727 & 197,741 & 174,725 \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started