The Morris Corporation has $800,000 of debt outstanding, and it pays an interest rate of 10%...

50.1K

Verified Solution

Question

Finance

The Morris Corporation has $800,000 of debt outstanding, and itpays an interest rate of 10% annually. Morris's annual sales are $4million, its average tax rate is 30%, and its net profit margin onsales is 3%. If the company does not maintain a TIE ratio of atleast 5 to 1, its bank will refuse to renew the loan and bankruptcywill result. What is Morris's TIE ratio? Do not round intermediatecalculations. Round your answer to two decimal places.

Balance Sheet Analysis

Complete the balance sheet and sales information in the tablethat follows for J. White Industries using the following financialdata:

Total assets turnover: 2
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =24%
Total liabilities-to-assets ratio: 55%
Quick ratio: 0.75
Days sales outstanding (based on 365-day year): 36.5 days
Inventory turnover ratio: 5.0

Do not round intermediate calculations. Round your answers tothe nearest whole dollar.

Partial IncomeStatement
Information
Sales$  
Cost of goods sold$  

Balance Sheet

Cash$  Accounts payable$  
Accounts receivable  Long-term debt  50,000
Inventories  Common stock  
Fixed assets  Retained earnings  100,000
Total assets$  400,000Total liabilities and equity$  

Analysis of Financial Statements: Tying the RatiosTogether

The DuPont equation shows the relationships among assetmanagement, debt management, and-Select-liquiditymarketprofitabilityCorrect 1 of Item 1 ratios.Management can use the DuPont equation to analyze ways of improvingthe firm's performance. Its equation is:

Ratio analysis is important to understand and interpretfinancial statements; however, sound financial analysis involvesmore than just calculating and interpreting numbers.-Select-QuantitativeQualitativeForeignCorrect 2 of Item 1 factorsalso need to be considered.

Quantitative Problem: Rosnan Industries' 2018and 2017 balance sheets and income statements are shown below.

Balance Sheets:
20182017
Cash and equivalents$60  $45  
Accounts receivable275  300  
Inventories375  350  
      Total current assets$710  $695  
Net plant and equipment2,000  1,490  
Total assets$2,710  $2,185  
Accounts payable$150  $85  
Accruals75  50  
Notes payable110  135  
      Total currentliabilities$335  $270  
Long-term debt450  290  
Common stock1,225  1,225  
Retained earnings700  400  
Total liabilities and equity$2,710  $2,185  


Income Statements:
20182017
Sales$2,000  $1,500  
Operating costs excluding depreciation1,250  1,000  
EBITDA$750  $500  
Depreciation and amortization100  75  
EBIT$650  $425  
Interest62  45  
EBT$588  $380  
Taxes (40%)235  152  
Net income$353  $228  
Dividends paid$53  $48  
Addition to retained earnings$300  $180  
Shares outstanding100  100  
Price$25.00  $22.50  
WACC10.00%    

What is the firm’s 2018 current ratio? Round your answer to twodecimal places.

If the industry average debt-to-total-assets ratio is 30%, thenRosnan’s creditors have a -Select-smallerbiggerCorrect 1 of Item 3cushion than indicated by the industry average.

What is the firm’s 2018 net profit margin? Round your answer tofour decimal places.
%

If the industry average profit margin is 12%, then Rosnan’slower than average debt-to-total-assets ratio might be one reasonfor its high profit margin.
-Select-TrueFalseCorrect 1 of Item 4

What is the firm’s 2018 price/earnings ratio? Round your answerto two decimal places.

Using the DuPont equation, what is the firm’s 2018 ROE? Roundyour answer to two decimal places.
%

Answer & Explanation Solved by verified expert
4.2 Ratings (604 Votes)
1 Debt 800000 interest rate 10 annually Annual Sales 4000000 tax rate 30 Net profit margin 3 on sales Net profit margin 3 4000000 Net profit 4120000 interest 80000 tax30 36000 EBIT 236000 TIE Ratio EBIT Interest expense TIE Ratio 236000    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

The Morris Corporation has $800,000 of debt outstanding, and itpays an interest rate of 10% annually. Morris's annual sales are $4million, its average tax rate is 30%, and its net profit margin onsales is 3%. If the company does not maintain a TIE ratio of atleast 5 to 1, its bank will refuse to renew the loan and bankruptcywill result. What is Morris's TIE ratio? Do not round intermediatecalculations. Round your answer to two decimal places.Balance Sheet AnalysisComplete the balance sheet and sales information in the tablethat follows for J. White Industries using the following financialdata:Total assets turnover: 2Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =24%Total liabilities-to-assets ratio: 55%Quick ratio: 0.75Days sales outstanding (based on 365-day year): 36.5 daysInventory turnover ratio: 5.0Do not round intermediate calculations. Round your answers tothe nearest whole dollar.Partial IncomeStatementInformationSales$  Cost of goods sold$  Balance SheetCash$  Accounts payable$  Accounts receivable  Long-term debt  50,000Inventories  Common stock  Fixed assets  Retained earnings  100,000Total assets$  400,000Total liabilities and equity$  Analysis of Financial Statements: Tying the RatiosTogetherThe DuPont equation shows the relationships among assetmanagement, debt management, and-Select-liquiditymarketprofitabilityCorrect 1 of Item 1 ratios.Management can use the DuPont equation to analyze ways of improvingthe firm's performance. Its equation is:Ratio analysis is important to understand and interpretfinancial statements; however, sound financial analysis involvesmore than just calculating and interpreting numbers.-Select-QuantitativeQualitativeForeignCorrect 2 of Item 1 factorsalso need to be considered.Quantitative Problem: Rosnan Industries' 2018and 2017 balance sheets and income statements are shown below.Balance Sheets:20182017Cash and equivalents$60  $45  Accounts receivable275  300  Inventories375  350        Total current assets$710  $695  Net plant and equipment2,000  1,490  Total assets$2,710  $2,185  Accounts payable$150  $85  Accruals75  50  Notes payable110  135        Total currentliabilities$335  $270  Long-term debt450  290  Common stock1,225  1,225  Retained earnings700  400  Total liabilities and equity$2,710  $2,185  Income Statements:20182017Sales$2,000  $1,500  Operating costs excluding depreciation1,250  1,000  EBITDA$750  $500  Depreciation and amortization100  75  EBIT$650  $425  Interest62  45  EBT$588  $380  Taxes (40%)235  152  Net income$353  $228  Dividends paid$53  $48  Addition to retained earnings$300  $180  Shares outstanding100  100  Price$25.00  $22.50  WACC10.00%    What is the firm’s 2018 current ratio? Round your answer to twodecimal places.If the industry average debt-to-total-assets ratio is 30%, thenRosnan’s creditors have a -Select-smallerbiggerCorrect 1 of Item 3cushion than indicated by the industry average.What is the firm’s 2018 net profit margin? Round your answer tofour decimal places.%If the industry average profit margin is 12%, then Rosnan’slower than average debt-to-total-assets ratio might be one reasonfor its high profit margin.-Select-TrueFalseCorrect 1 of Item 4What is the firm’s 2018 price/earnings ratio? Round your answerto two decimal places.Using the DuPont equation, what is the firm’s 2018 ROE? Roundyour answer to two decimal places.%

Other questions asked by students