After completing the Balance Sheet in the Excel Spreadsheet hyperlinked above, you should be able to...

 

  

Transcribed Image Text:

After completing the Balance Sheet in the Excel Spreadsheet hyperlinked above, you should be able to measure a company's capital structure. Based on your assessment of the firm's Balance Sheet, you are to report to senior management on these key components: a. What is the nature of this company's capital structure? Include percentages in your commentary? b. Compare this capitalization structure percent to an Industry Standard of 50%. What is the result? c. To what extent is this company leveraged? Balance Sheet Accounts and Amounts Cash & Equivalents Notes Payable/Short Term Debt Accounts Receivables, Net Accounts Payable Inventory Property/Plant/Equipment Long Term Note-Debt 2,000 Enter this data in the Balance Sheet below $ 15,000 $ 40,000 $ 65,000 $ 25,000 $ 120,000 $ 80,000 Ba yo CC Shareholders Equity will be calculated by student below In Use the data above to complete the Balance Sheet below pe As Asset subtotal enter account and amount here b. sta Asset subtotal enter account and amount here Asset subtotal enter account and amount here Asset subtotal enter account and amount here lev Total Assets to be calculated by student enter account and amount here Liability subtotal Liability subtotal Liability subtotal enter account and amount here enter account and amount here to be calculated by student Total Liabilities Shareholders Equity Total Liabilities and Shareholders Equity to be calculated by student to be calculated by student Income Statement tab part 2. Balance Sheet tab part 3. After completing the Balance Sheet in the Excel Spreadsheet hyperlinked above, you should be able to measure a company's capital structure. Based on your assessment of the firm's Balance Sheet, you are to report to senior management on these key components: a. What is the nature of this company's capital structure? Include percentages in your commentary? b. Compare this capitalization structure percent to an Industry Standard of 50%. What is the result? c. To what extent is this company leveraged? Balance Sheet Accounts and Amounts Cash & Equivalents Notes Payable/Short Term Debt Accounts Receivables, Net Accounts Payable Inventory Property/Plant/Equipment Long Term Note-Debt 2,000 Enter this data in the Balance Sheet below $ 15,000 $ 40,000 $ 65,000 $ 25,000 $ 120,000 $ 80,000 Ba yo CC Shareholders Equity will be calculated by student below In Use the data above to complete the Balance Sheet below pe As Asset subtotal enter account and amount here b. sta Asset subtotal enter account and amount here Asset subtotal enter account and amount here Asset subtotal enter account and amount here lev Total Assets to be calculated by student enter account and amount here Liability subtotal Liability subtotal Liability subtotal enter account and amount here enter account and amount here to be calculated by student Total Liabilities Shareholders Equity Total Liabilities and Shareholders Equity to be calculated by student to be calculated by student Income Statement tab part 2. Balance Sheet tab part 3.