Question

In: Accounting

I/S Analysis:  The following ratios have been calculated for the SolarMolar Company. Note that SolarMolar has NO...

  1. I/S Analysis:  The following ratios have been calculated for the SolarMolar Company. Note that SolarMolar has NO DEBT.  Given this information and nothing else, analyze the income statement data and provide your thoughts regarding TWO changes you may encourage SolarMolar to consider.                                                                                                                                  (5 pts)

                                                                                                            2018                2017                2016

Gross profit margin                                                    41.9%              42.5%              42.1%

Operating profit margin                                              15.7%              21.7%              21.5%

Net profit margin                                                        11.8%              13.0%              12.9%

  1. B/S Analysis:  You are reviewing the balance sheet of DGD Inc., (a durable goods manufacturer) and you notice a sizeable amount of “Deferred Taxes Payable” in the long-term liabilities section of the balance sheet.                                                                                                             (6 pts)
  1. Explain how this liability was created
  1. Is this a liability that you expect to be repaid in the next five years?  Explain.
  1. SOCF Analysis:  Your are reviewing the statement of cash flows for DGD Inc., (a durable goods manufacturer) and you notice that CFFO is meaningfully positive and growing.  However, you also notice that FCF last year was negative.  Given that a firm’s purpose in life is to generate cash flow, would you expect this durable goods company to be in peril?                                      (4 pts)
  1. B/S:  Johnny Jim Corporation’s 2019 balance sheet has no funded, long-term debt on the balance sheet.  However, there are operating leases payments that must be made in the future as follows:  

         2018                 47,116

            2019                 43,449

            2020                 41,315

            2021                 37,383

      2022                 32,168

            Thereafter       87,582  (assume this is 30,000/30,000/27,582 in 2023/2024/2025)

  1. Calculate an adjustment you would make (assuming a 5% interest rate) to reflect the amount of balance sheet debt these operating leases represent.                          (6 pts)

Solutions

Expert Solution

Answert to

IS analysis -

Gross margin high in 2017 as compared to 2016 and 2018, so the company should consider in reducing non value added cost while manufacturing goods or providing services to enhance its gross profit margin.

Operating profit margin in 2018 is significantly low in 2018 aas compared to 2017 and 2016, Company should identify where the cost has increased in terms of its indirect costs - salary, rent, communication, IT expenses & any other administrative cost and reduce its avoidable cost to return to its operating profit margin trend.   

a) How Deferred tax paybale was created

Deferred tax liabilities are recognized due to the taxable temporary differences, i.e., when the profit as per book is more than the profit as per tax law.

b) Is this liability that you expect to be repaid in the next five years? Explain

DTL is revered in the future period, once the accounting profit will be more than the taxable profit. Usually the deferred tax is expected to be repaid in the next five years.

SOCF analysis -

Operating cah flow is the main input to determine the prerformance of the Company as it is the cash floww from the business activity of the Company. Financila cahs flow is mainly the raising of funds thorugh different sources and payments towards it. FCF does not affect the performance is it is negative, it could also means that the Compnay has reduced its debts and obligations. So, the Company is not going to peril.

Answer to 2nd part a)

Year 2018 2019 2020 2021 2022 2023 2024 2025
Operating lease payments 47116 43449 41315 37383 32168 30000 30000 27582
PV factor@5% 0.95238 0.90703 0.86384 0.82270 0.78353 0.74622 0.71068 0.67684
PV of operating lease payments 44,872 39,410 35,689 30,755 25,204 22,386 21,320 18,669
Present value 238306
Amount of Balance Sheet debt these operating lease represents 238306

Related Solutions

The following ratios have been calculated for the Solar Tech Company. Analyze the profitability of Solar...
The following ratios have been calculated for the Solar Tech Company. Analyze the profitability of Solar Tech Company.                                                                    2015           2014 Gross profit margin                                    37.0%         42.5% Operating profit margin                             4.7%         21.7% Net profit margin                                       1.3%           17.2% Cash flow margin                                       20.4%         25.9%
The following ratios have been calculated for MORT Oil and Gas Company for two years 2019-2018....
The following ratios have been calculated for MORT Oil and Gas Company for two years 2019-2018. Financial ratios 2019 2018 Leverage Debt ratio (%) 70.2 68.1 Long-term debt to total capital (%) 60.0 67.5 Debt to equity (times) 3.2 3.1 Times interest earned (times) 2.5 0.9 Cash interest coverage (times) 3.9 2.7 Fixed charge coverage (times) 1.0 0.7 Cash flow adequacy (times) 0.4 1.1 Profitability Gross profit margin (%) 14.2 11.1 Operating profit margin (%) 2.3 0.8 Net profit margin...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June 2008:                                        Actual results Budgeted results Previous year Industry average current ratio 1.97 1.92 1.87 1.92 Quick asset ratio 1.06 1.06 1.06 1.11 Inventory turnover 4.21 4.91 4.86 4.76 Net profit ratio 0.05 0.03 0.03 0.03 Gross margin 0.65 0.59 0.61 0.61 Required: Provide four (4) possible explanations for the results for the various ratios for Nova Ltd and outline their implications...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June 2008: Ratio Actual results Budgeted results Previous year Industry Average Current ratio 1.97 1.92 1.87 1.92 Quick asset ratio 1.06 1.06 1.06 1.11 Inventory turnover 4.21 4.91 4.86 4.76 Net profit ratio 0.05 0.03 0.03 0.03 Gross margin 0.65 0.59 0.61 0.61 Required: Provide four (4) possible explanations for the results of the various ratios for Nova Ltd and explain their implications for the...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June 2008:                         Actual results      Budgeted results    Previous year      Industry average current ratio 1.97                    1.92                       1.87 1.92 quickasset ratio 1.06                    1.06                        1.06 1.11 Inventory turnover    4.21    4.91                       4.86    4.76 Net profit ratio 0.05    0.03                       0.03                      0.03 Gross margin           0.65                    0.59                       0.61                       0.61 Required: Provide four (4) possible explanations for the results for the various ratios for Nova Ltd and outline...
The following ratios have been calculated from the most recent financial statements for Goodman Enterprises and...
The following ratios have been calculated from the most recent financial statements for Goodman Enterprises and Kwiksave Limited. Both businesses operate in the retail industry. Goodman Enterprises Kwiksave Limited Average collection period 55 days 22 days Gross profit margin 39% 13% Average days in inventory 46 days 23 days Net profit margin 9.9% 9.9% REQUIRED: Compare and contrast the profitability and liquidity of Goodman Enterprises and Kwiksave Limited on the basis of the ratios above. (word limit: 300 words) Explain...
Discuss the possible causes and effects of changes in the ratios that have been calculated below:...
Discuss the possible causes and effects of changes in the ratios that have been calculated below: UNITED UTILITIES GROUP PLC (UU.) Profitability Ratio Calculation 2015-03 2016-03 2017-03 Profit before Tax and Interest 639 557 582 Equity 2434 2706 2822 Long term borrowing 6067 6509 7058 Return on Capital employed 7.52% 6.04% 5.89% Profit after Tax 271 398 434 Equity 2434 2706 2822 Return on Equity 11.13% 14.71% 15.38% Operating Profit before Interest and Taxes 639 557 582 Revenue 1720 1730...
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June 2008
The following financial ratios have been calculated for Nova Ltd for the year ended 30 June 2008: Ratio Actual results Budgeted results Previous year Industry Average Current ratio 1.97 1.92 1.87 1.92 Quick asset ratio 1.06 1.06 1.06 1.11 Inventory turnover 4.21 4.91 4.86 4.76 Net profit ratio 0.05 0.03 0.03 0.03 Gross margin 0.65 0.59 0.61 0.61 Required: Provide four (4) possible explanations for the results of the various ratios for Nova Ltd and explain their implications for the...
QUESTION FOUR The following ratios have been calculated from the most recent financial statements for Goodman...
QUESTION FOUR The following ratios have been calculated from the most recent financial statements for Goodman Enterprises and Kwiksave Limited. Both businesses operate in the retail industry. Goodman Enterprises       Kwiksave Limited Average collection period    55 days 22 days Gross profit margin 39% 13% Average days in inventory 46 days 23 days Net profit margin    9.9% 9.9% REQUIRED: (a)   Compare and contrast the profitability and liquidity of Goodman Enterprises and Kwiksave Limited on the basis of the ratios...
You’ve been monitoring Bletchley Park Corporation and have calculated the following information. The company has a...
You’ve been monitoring Bletchley Park Corporation and have calculated the following information. The company has a debt to asset ratio of 57.45%, market beta of 1.26, unlevered beta of .82 (at a 40% marginal tax rate), and a cost of equity of 13.67%. The risk free rate is 1.8%. The risk premium due to financial risk is closest to?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT