Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please show the way of solving too begin{tabular}{|c|c|c|c|c|c|} hline multicolumn{6}{|c|}{ Group 9} hline & 2019 & 2020 & 2021 & 2022 & 2023
Please show the way of solving too
\begin{tabular}{|c|c|c|c|c|c|} \hline \multicolumn{6}{|c|}{ Group 9} \\ \hline & 2019 & 2020 & 2021 & 2022 & 2023 \\ \hline \multicolumn{6}{|c|}{ } \\ \hline Net Sales (Revenue) & 238,229 & 233,464 & 235,799 & 228,725 & 217,289 \\ \hline Cost of goods sold & 85,762 & 72,374 & 80,172 & 84,628 & 78,224 \\ \hline Gross Profit & 152,467 & 161,090 & 155,627 & 144,097 & 139,065 \\ \hline Selling \& General costs & 69,086 & 49,028 & 61,308 & 59,469 & 49,976 \\ \hline Administrative costs & 57,175 & 56,031 & 58,950 & 61,756 & 43,458 \\ \hline Depreciation & 4,232 & 2,823 & 5,298 & 3,990 & 4,372 \\ \hline Operating Profit (EBIT) & 21,974 & 53,208 & 30,071 & 18,882 & 41,259 \\ \hline Interest & 3,107 & -67 & 3,691 & 1,734 & 2,914 \\ \hline Taxable Income & 18,867 & 53,141 & 26,380 & 17,148 & 38,345 \\ \hline taxes & 2,830 & 7,971 & 3,957 & 2,572 & 5,752 \\ \hline Net profit & 16,037 & 45,170 & 22,423 & 14,576 & 32,593 \\ \hline & 2019 & 2020 & 2021 & 2022 & 2023 \\ \hline \multicolumn{6}{|c|}{ } \\ \hline \multicolumn{6}{|l|}{ Assets } \\ \hline \multicolumn{6}{|l|}{ Current Assets: } \\ \hline Cash & 5,232 & 2,352 & 2,971 & 2,795 & 4,957 \\ \hline Short-term investments & 6,539 & 2,895 & 3,565 & 3,655 & 6,864 \\ \hline Accounts receivable & 12,643 & 4,704 & 5,942 & 7,310 & 9,915 \\ \hline Inventory & 19,182 & 8,142 & 7,329 & 7,740 & 16,398 \\ \hline Total Current Assets & 43,596 & 18,093 & 19,807 & 21,500 & 38,134 \\ \hline \multicolumn{6}{|l|}{ Fixed Assets: } \\ \hline Long-term investments & 30,517 & 17,913 & 39,284 & 28,380 & 30,931 \\ \hline Property, plant and equipment & 52,896 & 35,282 & 66,222 & 49,880 & 54,645 \\ \hline \multirow{2}{*}{\begin{tabular}{l} Goodwill and intangible assets \\ Total Fixed Assets \end{tabular}} & 18,310 & 1,086 & 6,734 & 7,740 & 17,528 \\ \hline & 101,724 & 54,280 & 112,240 & 86,001 & 103,104 \\ \hline Total Assets & 145,320 & 72,374 & 132,047 & 107,501 & 141,238 \\ \hline \multicolumn{6}{|l|}{ antagonists } \\ \hline \multicolumn{6}{|l|}{ Current liabilities: } \\ \hline Accounts payable & 6,522 & 2,931 & 2,272 & 3,096 & 5,575 \\ \hline Short-term debt & 3,884 & 1,574 & 2,418 & 2,322 & 4,374 \\ \hline Other Current liabilities & 3,788 & 3,152 & 1,203 & 1,212 & 4,672 \\ \hline \multirow{3}{*}{\begin{tabular}{l} Total Current Liabilities \\ Long-term liabilities: \\ Long-term debt \\ \end{tabular}} & 14,194 & 7,657 & 5,893 & 6,630 & 14,621 \\ \hline & & & & & \\ \hline & 61,372 & 1,028 & 73,336 & 34,220 & 57,410 \\ \hline Total long-term liabilities & 61,372 & 1,028 & 73,336 & 34,220 & 57,410 \\ \hline Total Liabilities & 75,566 & 8,685 & 79,228 & 40,850 & 72,031 \\ \hline \multicolumn{6}{|l|}{ Equity: } \\ \hline Common Stock & 48,623 & 33,919 & 34,071 & 46,753 & 44,920 \\ \hline Preferred Shares & 11,405 & 4,192 & 5,546 & 10,967 & 5,552 \\ \hline Retained earnings & 9,726 & 25,578 & 13,201 & 8,931 & 18,734 \\ \hline Total Shareholders' Equity & 69,753 & 63,689 & 52,819 & 66,650 & 69,206 \\ \hline Total Liabilities and Equity & 145,320 & 72,374 & 132,047 & 107,501 & 141,238 \\ \hline \end{tabular} What you are required to do with the financial statements attached to you are as follows: 1- Construct a cash flow statement. 2- Calculate the historical average growth of net income. 3- 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. 5- Assuming that the dividend of the following years starting from 2024 will grow at a constant growth rate forever equal to the "historical average growth of dividends" you calculated, what is the price of 1 stock of the company at the start of 2024? if the required rate of return is 7% and the number of outstanding stock is 10000 . Note: 75% of the remaining net income "after paying the dues of the preferred shares" is distributed to the holders of common sharesholders. "Make sure you calculate the dividend correctly" 6- If the company wants to raise its long-term debt by 50% in 2024 in comparison to its long-term debt in 2023 by issuing bonds that pay a 5% coupon rate and have a maturity of 20 years, how many bonds must the company sell to achieve such a goal? 7- Assuming that the company wants to issue a 1000 preferred stock at the start of 2024 and has announced that it will pay a constant amount of 5$ as a constant dividend for these stocks, How much will these stocks sell for if the required rate of return is 7% ? Note: In regard to the historical financial statements: 1- Interest on long-term debts is 5% and on short-term debts is 1%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