Pick a company of your choice from a Technology industry. Briefly describe what the company does and what its products are and then look for information (financial statements, stock price etc.) on finance.yahoo.com and complete the yellow cells in the excel template below. Mainly you need to calculate both the market and book value of short-tern debt, long-term debt and shareholder's equity. (remember that for the debt items use the same value for book and market). Then describe the company's capital structure and add any comments you might have.

Chosen tech company = Sony

****Please use cell references****

Sony Book Value of: Short-term Debt Long Term Debt Shareholders Equity Total Capital $0 Debt/Equity Ratio % STD % LTD % Equity Market Value of: Short-term Debt $0 Long Term Debt Shareholders Equity Total Capital $0 Debt/Equity Ratio % STD % LTD \% Equity Y+ Get access to 40+ years of historical data with Yahoo Finance Plus Essential. Le Balance Sheet Currency in JPY. All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Plus Essential. Learn more Sony Book Value of: Short-term Debt Long Term Debt Shareholders Equity Total Capital $0 Debt/Equity Ratio % STD % LTD % Equity Market Value of: Short-term Debt $0 Long Term Debt Shareholders Equity Total Capital $0 Debt/Equity Ratio % STD % LTD \% Equity Y+ Get access to 40+ years of historical data with Yahoo Finance Plus Essential. Le Balance Sheet Currency in JPY. All numbers in thousands Get access to 40+ years of historical data with Yahoo Finance Plus Essential. Learn more