Financial stability of ecosystems

Assignment Help Financial Management
Reference no: EM13334898

Financial Statement Preparation

"The numbers" (or, the "language of business", as Warren Buffett has said) is usually a great place to start in analyzing an enterprise and making prudent business decisions. So ... as background for the Group Project Situational Analysis and Report you will be preparing, you are required to create a properly classified Balance Sheet, Income Statement, Cash Flows Statement, and Ratio Analysis Statement from information provided to you.

The information you need is in the file under "Project". The file includes a Data worksheet with a complete listing of accounts and balances in alphabetical order for EcoSystems Industries and worksheet templates for a Balance Sheet, Income Statement, Cash Flows Statement, and Ratios. The templates have been prepared for the Balance Sheet and Income Statement such that you need only copy/paste from the Data worksheet into the appropriate position on those financial statements and then determine the appropriate sub-total and total amounts. Templates have also been prepared for the Cash Flows Statement and for Ratio Analysis but the nature of those items do not as easily lend themselves to simple "copy/paste" functionality. For the Cash Flows and Ratios worksheets, and for that matter also for the Balance Sheet and Income Statement if you prefer, feel free to either manually enter your answers and supporting computations into Excel or print the template worksheets and write your answers/supporting computations on the printed paper. Do whatever is easiest for you. Attach additional sheets if necessary.  The formulae for five of the six Ratios requested are identified on a supplemental "Ratios" file. The only ratio not included is the Gross Profit ratio, which is computed as Gross Profit divided by Net Sales.

Project - Situational Analysis and Report

You are the CFO (Chief Financial Officer) for SciTech Industries, a company which designs, manufactures, and sells research instrumentation worldwide. SciTech sells direct to the customer in the United States, but utilizes aDistributor network to sell instruments internationally. The research instruments are expensive (up to $75,000 each) and, therefore, purchase decisions by the end user are not taken lightly. Distributors are independent companies who buy from you (SciTech) at a discounted sales price and then sell to their customers at whatever price they choose. With occasional assistance (financial and otherwise) and advice from you, Distributorsperform their own marketing and sales efforts, and also perform equipment installation, repairs, training, and other service functions for your equipmentwhich they have sold in their territory. It is a very costly and time-consuming process for youto first identify appropriate Distributors and then to maintain that ongoing relationship. Distributors, as independent entities, also sell other companies' products. To your knowledge, none of yourDistributorssell any of yourcompetitors' products.

Your sales terms to Distributors are 2/20, n/60. In the process of monitoring payment activity for all Distributors you have noticed that your Distributor in Italy, EcoSystems Industries, over the past six months has not only neglected to take advantage of your discount payment terms, but has progressively fallen further behind in payments for the full invoice price, to the point where payments are now typically 10 days past the 60-day due date.

EcoSystems is a family owned and operated Company with 30 employees, and has been your Italian Distributor for 15 years. EcoSystems has been a cooperative "business partner", and you have generally been pleased with their performance in selling and servicing your products in their territoryover the years. Feedback you receive on occasion from their customers is usually positive, and you receive very few complaints. EcoSystems payment terms offered to its customers are net/45 days (i.e. no early payment discount is offered), and you (SciTech) representapproximately 40% of EcoSystems annual Sales. You have expressed your concern to EcoSystems about the trend in payment history of their account with you. At your request, EcoSystems has provided financial information (represented by the financial statements you have already prepared), and Ecosystems is very willing to answer any questions you might have.

Required:

In a double-spaced, 2to 3page narrative report (i.e. not including any exhibits you wish to attach), address the questions below and any other considerations which come to mind. As additional information, EcoSystemsratios for prior years are shown in the following table:

 

2013

2012

2011

 

 

 

 

Current Ratio

??

2.6 to 1

2.8 to 1

 

 

 

 

Accounts Rec. Turnover

??

39 days

33 days

 

 

 

 

Inventory Turnover

??

55 days

52 days

 

 

 

 

Gross Profit on Sales

??

44.2%

44.6%

 

 

 

 

Profit Margin on Sales

??

3.2%

5.3%

 

 

 

 

Rate of Return on Assets

??

9.9%

10.3%

 

 

 

 

Your score will be based on your situational analysis, and on the wording/grammar, "flow", and generalcommunication aspects of your report. Provide your thoughts and the decisionyou might be leaning toward lacking any additional information and answers to your questions, but there is no right or wrong answer to this .

  • What are your thoughts as to the financial stability of EcoSystems? What positive aspects of the financial statements and ratios strike you and what "red flags" of concern have drawn your attention? If you had the opportunity to dialogue and interact with the owners of EcoSystems, what questionswould you have concerning their operation? What aspects of your financial analysis are in need of answers and/or further explanation?
  • SciTech reviews, modifies as appropriate, and renewsDistributor agreements annually. The Ecosystems agreement is up for renewal in three months, so you have the opportunity to terminate this Distributor relationship andlocate another Italian Distributor, or sellyour instruments (and service and support) direct from your offices in the U.S., or not sell into Italy at all. What factors, financial and also non-financial, are worthy of consideration in deciding the best future course of action?

Attachment:- EcoSystem.xlsx

Reference no: EM13334898

Questions Cloud

Find the value of brewsters angle : A light beam is incident on a piece of zircon (n = 1.923) at the Brewster's angle. Find the value of Brewster's angle
As an investment advisor : As an investment advisor you have been approached by a client called Ramesh
Which is the amount that should be paid for a stock : Which is the amount that should be paid for a stock that will pay a dividend of $4.65 in one year and $5.38 in two years. After that, the stock price will grow at a constant 5% per year forever.
Calculate the magnetic dipole moment of the loop : A circular wire loop whose radius is 10.0 cm carries current of 2.10 A. Calculate the magnetic dipole moment of the loop
Financial stability of ecosystems : What are your thoughts as to the financial stability of EcoSystems and what positive aspects of the financial statements and ratios strike you and what "red flags" of concern have drawn your attention
Determine the maximum torque exerted on the loop : A particle of charge q = e moves in a circle of radius = 0.54 m with speed v = 1.000×107 m/s. find the maximum torque exerted on the loop by a uniform magnetic field of magnitude B = 1.00 T
Calculate the firms weighted average cost of capital : A company has determined that its optimal capital structure consists of 40 percent debt and 60 percent equity. Given the following information, calculate the firm's weighted average cost of capital.
Write a program called render.java : Optionally you may wish to add texture mapping to make your models look more realistic, and you may want to supply the user some controls that affect the colours and lighting.
Determine what is the yield on 2-year treasury securities : The real -risk-rate is 3%. Inflation is expected to be 2% this year and 4% during the next 2 years. Assume that the maturity risk premium is zero. What is the yield on 2-year Treasury securities

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd