The most recent data from the annual balance sheets of Liukin Holdings Inc. are given in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The most recent data from the annual balance sheets of Liukin Holdings Inc. are given in the balance sheet and the income statement given below: 1 2 3 4 8 9 5 Cash 6 Accounts receivable 7 Inventories 10 11 12 13 A 14 15 16 17 Balance Sheet Assets Current assets: Total current assets Net fixed assets: Net plant and equipment Total assets $3,136 1,148 3,366 7,650 9,350 17,000 с Liabilities & Equity Current liabilities: Accounts payable Accruals Notes payable Total current liabilities Long-term bonds Total debt Common equity Common stock Retained earnings Total common equity Total liabilities and equity D $0 0 5,737 5,737 7,013 12,750 2,763 1,487 4,250 17,000 EF Income Statement Net Sales Operating costs except depreciation and amortization Depreciation and amortization Total Operating Costs Operating Income (or EBIT) Less: Interest Earnings before taxes (EBT) Less: Taxes (40%) Net Income G 4,000 1,040 160 1,200 2,800 294 2,506 1,002 1,504 Using the data you have and the formula you will be using in ratio analysis, solve for the ratios using Excel commands: A 7 8 1 2 3 Current ratio 4 Inventory turnover ratio Fixed assets turnover ratio 5 6 Total assets turnover ratio Debt ratio. Times interest ratio Ratio B Formula Current Assets / Current Liabilities Sales / Inventories Sales/ Net Fixed Assets Sales/ Total Assets Total Debt / Total Assets EBIT/ Interest Expense C Excel Solution The most recent data from the annual balance sheets of Liukin Holdings Inc. are given in the balance sheet and the income statement given below: 1 2 3 4 8 9 5 Cash 6 Accounts receivable 7 Inventories 10 11 12 13 A 14 15 16 17 Balance Sheet Assets Current assets: Total current assets Net fixed assets: Net plant and equipment Total assets $3,136 1,148 3,366 7,650 9,350 17,000 с Liabilities & Equity Current liabilities: Accounts payable Accruals Notes payable Total current liabilities Long-term bonds Total debt Common equity Common stock Retained earnings Total common equity Total liabilities and equity D $0 0 5,737 5,737 7,013 12,750 2,763 1,487 4,250 17,000 EF Income Statement Net Sales Operating costs except depreciation and amortization Depreciation and amortization Total Operating Costs Operating Income (or EBIT) Less: Interest Earnings before taxes (EBT) Less: Taxes (40%) Net Income G 4,000 1,040 160 1,200 2,800 294 2,506 1,002 1,504 Using the data you have and the formula you will be using in ratio analysis, solve for the ratios using Excel commands: A 7 8 1 2 3 Current ratio 4 Inventory turnover ratio Fixed assets turnover ratio 5 6 Total assets turnover ratio Debt ratio. Times interest ratio Ratio B Formula Current Assets / Current Liabilities Sales / Inventories Sales/ Net Fixed Assets Sales/ Total Assets Total Debt / Total Assets EBIT/ Interest Expense C Excel Solution
Expert Answer:
Answer rating: 100% (QA)
SOLUTION Current Ratio Current Assets Current Liabilities 7650 5737 1334 Inventory Turnover ... View the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-0133400694
1st canadian edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford, David A. Stangeland, Andras Marosi
Posted Date:
Students also viewed these corporate finance questions
-
You work for the strategy department at Bank of America. They have developed a new retirement investment product and are trying to figure out the most cost effective way to encourage customers to...
-
a. b. For the AM signal given below appearing across a load of 502, determine: the modulation index (m), the peak value of the unmodulated carrier (Vc) sketch and label clearly the AM spectrum C. 2V...
-
The 2016 and 2015 comparative balance sheets and 2016 income statement of King Supply Corp. follow: King Supply had no noncash investing and financing transactions during 2016. During the year, there...
-
Assume a companys estimated sales is 27,000 units. Its desired ending finished goods inventory is 5,000 units, and its beginning finished goods inventory is 3,000 units. What is the required...
-
A train is moving parallel to a highway with a constant speed of 20.0 m/s. A car is traveling in the same direction as the train with a speed of 40.0 m/s. The car horn sounds at a frequency of 510...
-
A retail store has a preferred customer plan where customers may earn discounts on all their purchases. The amount of a customer's discount is determined by the amount of the customer's cumulative...
-
A uniform flow of \(110,000 \mathrm{ft}^{3} / \mathrm{s}\) is measured in a natural channel that is approximately rectangular in shape with a \(2650-\mathrm{ft}\) width and \(17.5-\mathrm{ft}\)...
-
Refer to Problem 2.9. Assume that Walmart (WMT) has accounted for the value of the land at acquisition cost and sells the land on December 31, 2011, for a two-year note receivable with a present...
-
Discuss the effect of fiscal policy on inflation. Discuss the effect of persistent fiscal stimulus on the economy in the long run. Describe the mechanism of how changes in fiscal policy affect output...
-
Whitestone Company produces two subassemblies, JR-14 and RM-13, used in manufacturing trucks. The company is currently using an absorption costing system that applies overhead based on direct-labor...
-
Briefly describe the type of information and data you would need to prepare a Cost-Volume-Profit and Break-Even-Point graph.
-
5. Suppose the company Liver Corporation earned $ 1.57 per share in 2010 and after 8 years, in 2018, the company earned $ 3.10. Determine the growth rate of earnings per share (EPS) over the 8 years....
-
You can invest $10,500 today into an investment with a promised constant cash flow growth of 3% per year. Calculate PV of this investment if r = 6.5%.
-
A tank of coefficient of volume expansion 6.0 x10^-5/C filled with 2.0 m^3 of a liquid of coefficient of volume 18 x 10^-5/C is at a temperature of 40 degrees C and is in thermal equilibrium. The...
-
An investor longs a 3 months maturity call option with K = 220, and shorts a half year call with K = 220. Currently, S0 = 220, risk-free rate r = 0.06 (continuously compounded), and = 0.25. The stock...
-
How often should urinalysis be performed to screen for microalbuminuria in the management of a patient with type 2 diabetes?
-
A corporation reports the following year-end balance sheet data. Calculate the following ratios: (a) acid-test ratio (must use format x.xx) Cash.. $ 40,000 Accounts receivable............ 35,000...
-
Activator rod AB exerts on crank BCD a force P directed along line AB. Knowing that P must have a 100-N component perpendicular to arm BC of the crank, determine (a) The magnitude of the force P, (b)...
-
What are the three main things that the financial manager can accomplish by building a long-term financial model of the firm?
-
How can a hostile acquirer get around a poison pill?
-
What is the optimal time for a firm to pay its accounts payable?
-
Vertical analysis would rarely be performed on which of the following statements or schedules? a. Income statement b. Adjusting entry worksheet c. Balance sheet d. All of the above are common targets...
-
A statement that lists the assets, liabilities, and stockholders equity of a company in percentages only with no dollar amounts is a a. common-size income statement. b. benchmarking analysis. c....
-
In vertical analysis, the base used for comparison on the income statement is a. total expenses. b. total assets. c. net sales. d. gross profit.
Study smarter with the SolutionInn App