Reference no: EM131061285
Case Study 1: Financial Statement Analysis
Introduction: Gemini Electronics
Sarah McIvor, CA, a junior partner with Price Waterhouse Coopers, has been selected to conduct a financial review of Gemini Electronics Ltd. Gemini is an "up- start" American electronics company who recently went public and now wants to expand its business to rival the major Korean and Japanese producers. Before the company finalizes any expansion plans, Dr. Wang, the founder, feels it is prudent to conduct an independent evaluation of Gemini's financial condition.
The two-page evaluation memo should be divided into sections entitled liquidity, asset management, long-term debt paying ability, profitability, and recommendations. It should be single-spaced, 11-point Arial font with 0.7 inch margins. All headings should be in 12-point bold font.
In addition to the two-page memo, the following financial exhibits for 2005 through 2009 should be included:
- ratio table
- vertical analysis of income statements and balance sheets
- horizontal analysis (index numbers) of income statements and balance sheets
- cash flow statements (2006 through 2009)
- five-part analysis of ROE
All ratios should be calculated based on year-end totals only-no averages should be used. The specific ratios to be used include the following:
|
|
2005
|
2006
|
2007
|
2008
|
2009
|
Industry Average
|
|
Liquidity
|
|
|
|
|
|
|
|
Current ratio
|
|
|
|
|
|
|
|
Cash ratio
|
|
|
|
|
|
|
|
Asset Management
|
|
|
|
|
|
|
|
Parts inventory turnover in days
|
|
|
|
|
|
|
|
Work-in-progress turnover in days
|
|
|
|
|
|
|
|
Finished goods turnover in days
|
|
|
|
|
|
|
|
A/R turnover in days
|
|
|
|
|
|
|
|
A/P turnover in days
|
|
|
|
|
|
|
|
Cash conversion cycle
|
|
|
|
|
|
|
|
Fixed assets turnover
|
|
|
|
|
|
|
|
Total asset turnover
|
|
|
|
|
|
|
|
Long-term debt paying ability
|
|
|
|
|
|
|
|
Debt Ratio
|
|
|
|
|
|
|
|
Long-term debt to total capitalization
|
|
|
|
|
|
|
|
Times Interest Earned
|
|
|
|
|
|
|
|
Cash flow coverage
|
|
|
|
|
|
|
|
Profitability
|
|
|
|
|
|
|
|
Gross margin
|
|
|
|
|
|
|
|
Operating profit margin
|
|
|
|
|
|
|
|
Net profit margin
|
|
|
|
|
|
|
|
ROA
|
|
|
|
|
|
|
|
ROE
|
|
|
|
|
|
|
| Analysis of ROE |
|
|
EBIT/Sales
|
EBT/EBIT
|
NI/EBT
|
Total Asset Turnover
|
Debt Ratio
|
ROE
|
|
2005
|
|
|
|
|
|
|
|
2006
|
|
|
|
|
|
|
|
2007
|
|
|
|
|
|
|
|
2008
|
|
|
|
|
|
|
|
2009
|
|
|
|
|
|
|
Attachment:- Case-Gemini-Electronics.pdf
|
What is the confidence interval for the true mean
: What is the confidence interval for the true mean for a probability level of 0.95 and 0.99? How much could the confidence range be improved if the number of analyses were doubled assuming the original distribution remained unchanged?
|
|
Reasons for the suggested investment
: Select a quoted property company or a Real Estate investment trust in which to invest £10,000. Prepare a report of up to 2000 words to describe the reasons for the suggested investment?
|
|
Calculating the npv for the investment
: Seattle Corp. is looking at an investment which will result in cashflows of $30,000 per year in years 1 thru 4, $35,000 per year in years 5 through 9, and $40,000 in year 10. The project will cost $150,000 today, and the firm's required rate of re..
|
|
Calculate total stockholders equity
: Zoeckler Mowing & Landscaping's year-end 2012 balance sheet lists current assets of $436,700, fixed assets of $551,300, current liabilities of $418,100, and long-term debt of $317,500. Calculate Zoeckler's total stockholders' equity.
|
|
Calculate the given ratios based on year-end totals
: Sarah McIvor, CA, a junior partner with Price Waterhouse Coopers, has been selected to conduct a financial review of Gemini Electronics Ltd. Calculate the given ratios based on year-end totals only-no averages should be used.
|
|
Calculating the bond price
: Consider a bond which pays 8% semiannually and has 8 years to maturity. The market requires an interest rate of 10% on bonds of this risk. What is this bond's price?
|
|
What is the coupon rate on bond
: Moonbeam, Inc. has a bond issue outstanding with a face value of $1,000 trading at $988.52. It makes a semiannual coupon payment, has a YTM of 6.31%, and will mature in 8.56 years. What is the coupon rate on this bond?
|
|
Difference between the two materials
: If the scatter in the individual samples of the previous problem is reduced to that listed below, would there be a justification (0.95 probability level) for saying there was a difference between the two materials? (Note that mean values of the tw..
|
|
Current state of the art of an emerging knowledge domain
: MN502: Network Security Assignment. The purpose of this assignment is to develop skills to independently think of innovation. In this assignment students will first learn how to develop knowledge based on current state of the art of an emerging kn..
|