Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Finance questions