Analysis Tasks on Financial Statements

Cash Flow Analysis: Calculate the cash flow from assets, the cash flow to creditors, and the cash flow to owners.

Growth of Net Income: Compute the historical average growth of net income.

Equity Valuation for $2024$: Project the value of the company's equity at the beginning of $2024.$ Assume that the net income for subsequent years will remain constant and equal to the product of the historical average growth of net income calculated and the net income for $2023.$

Dividend Analysis:

Calculate the annual dividend and the historical average growth of dividends.

Estimate the stock price at the start of $2024,$ assuming that the dividend will grow at a consistent rate equal to the calculated historical average growth of dividends.

Debt Financing:

If the company intends to increase its long$-$term debt by $50\%$ in $2024$ compared to $2023$ through the issuance of bonds with a $5\%$ coupon rate and a $20-$year maturity, determine how many bonds need to be issued.

Preferred Stock Issue:

Calculate the pricing for issuing an additional $1,000$ preferred stocks at the start of $2024,$ with a perpetual dividend of $$5$ per stock, assuming the stock will be held for seven years.

Financial Details and Submission Guidelines

Interest Rates: Long$-$term debts carry a $5\%$ interest, and short$-$term debts carry a $1\%$ interest.

Tax Rate: The applicable tax rate is $15\%.$

Required Rate of Return: The required return on investment is $7\%.$

Stock Information: There are $50,000$ outstanding common stocks and $10,000$ preferred stocks.

Bond Information: Bonds typically have a par value of $$1,000.$

$\backslash$table$[[$Group $4],[,2019,2020,2021,2022,2023],[,,,,,],[$Net Sales $($Revenue$),202,262,232,601,272,144,397,330,552,2,-20],[$Cost of goods sold,$62,701,81\mathrm{.}410,97,972,154,959,171,2],[$Selling & General costs,$40,452,67\mathrm{.}454,59,872,79466,160.],[$Administrative costs,$44498,46,520,68,036,119,199,],[$Depreciation$,2,311,4748,4,197,5,628,146],[$Interest$,575,1,119,594,2,071,6,8],[$taxes$,7,759,4,702,6,221,5,401,10],[,2019,2020,2021,2022,2023],[],[$Assets$],[$Cash$,1,89,5\mathrm{.}129,2,547,2,594,64],[$Short$-$term investments,$3,267,6,961,3,331,3,242,-10,8,5],[$Accounts receivable,$3,782,7,327,3,919,6,052,10,6],[$Inventory$,8,252,17,218,9,797,9,727,27\mathrm{.}74],[$Longrterm investments$],[$Properity$,$ plant and equipment,$28,883,59,348,52,464,70,356,183.],[$Goodwill and intangible assets,$9\mathrm{.}531,16486,14402,3\mathrm{.}404,32\mathrm{.}77],[$Accumulated depreciation,$2,311,4,748,4,197,5,628,14,6],[$Total Assets,$68,769,146,539,122,465,135,092,381,079],[$antagonists$,,,,,],[$Accounts payable$],[$Short$-$term debt,$1,702,4,110,1\mathrm{.}763,1\mathrm{.}751.,46],[$Other Current liabilities,$850,1,140,2,558,5,960,140],[$Longrterm debt$],[$Total Liabilities,$17,192,35,169,19,594,52,686,167,675],[$Common Stock$],[$Preferred Shares,$7\mathrm{.}125,17\mathrm{.}630,14889,12,538,35,677],[$Retained earnings,$11,992,7,662,9,813,8,651,15,200],[$Total Shareholders' Equity,$51,577,111,370,102,870,82,406,213,404],[$Total Liabilities and Equity,$769,146,539,122,465,135,092,381,079]]$