Use the following information to complete the balance sheet below. (Enter your a
ID: 2647184 • Letter: U
Question
Use the following information to complete the balance sheet below. (Enter your answer in millions of dollars rounded to the nearest whole dollar amount (for example 1.5 not 1,500,000). Omit the "$" sign in your response.)
2. The table below shows your stock positions at the beginning of the year, the dividends that each stock paid during the year, and the stock prices at the end of the year.
Beginning of
Year Price
What is your portfolio dollar return and percentage return?
Current Ratio 2.20 times Profit Margin 9 % Sales $ 2,150 m. ROE 15 % Long-term Debt to Long-term Debt and Equity 55 %Explanation / Answer
Answer:
1. Current Ratio = Current Assets / Current Liabilities
Hence, 2.20 = Current Assets / 375,000,000 , Current Assets = 2.20*375,000,000
Therefore, Current Assets = $ 825,000,000
2. Profit Margin = Net Income / Sales
Hence , 9% = Net Income / 2,150,000,000, Net Income = 2,150,000,000 * 9%
Therefore, Net Income = $ 193,500,000
3. ROE = Net Income / Stockholders Equity
Hence , 15 % = 193,500,000 / Stockholders Equity, Stockholders Equity = 193,500,000/15%
Therefore, Stockholders Equity = $ 1,290,000,000
4. Long-term Debt to Long-term Debt and Equity = Long Term Debt / Long term+ Debt Equity
Here , Let Long term debt = y
Hence, 55% =y/ (y + 1290000000)
Therefore, y (Long term Debt) = $ 1,576,666,666.67
Therefore,
Current Assets$ 825m Current Liabilities$375 m. Fixed Assets 2416.67m (Bal Fig) Long-term Debt 1576.67m Stockholders' Equity 1290m Total Assets$ 3241.67m Total Liabilities & Equity$ 3241.67m
Calculation Shwowing Portfolio Return and percentage Return:
Portfolio Return
100 * (End Value - Beginning Value) / Beginning Value
Percentage Return
(End Value - Beginning Value) / Beginning Value
Name of the CompanyPortfolio Return
100 * (End Value - Beginning Value) / Beginning Value
Percentage Return
(End Value - Beginning Value) / Beginning Value
Johson Controls 16.83 % 0.1683 Medtronic (-6.92) % (-0.0692) Direct TV (-2.11%) (-0.0211) Qualcomm (--9.41%) (-0.0941)Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.