I need help with this assignment. Can anyone help?

Instructions NAME: To complete the homework assignments in the templates provided: 1. The question is provided for each problem. You may need to refer to your textbook f information in a few cases. 2. You will enter the required information into the shaded cells. 3. The cells are coded: a) T requires a text answer. Essay questions require references; use the textbook. b) C requires a calculation, using Excel formulas or functions. You cannot perform th calculator and then type the answer in the cell. You will enter the calculation in the c final answer will show in the cell. I will be able to review your calculation and correct c) F requires a number only. In some problems, a \"Step 1\" is added to help you solve d) Formula requires a written formula, not the numbers. For example, the rate of retu nominal)/ (1+inflation)]-1, or D (debt) + E (equity) = V (value). 4. Name your assignment file as "lastnamefirstinitial-FINC600-Week#", and submit by 7. ions efer to your textbook for additional es; use the textbook. You cannot perform the operation on a he calculation in the cell, and only the calculation and correct, if necessary. added to help you solve the problem. xample, the rate of return = [(1 + Week#", and submit by midnight ET, Day Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer. Problem 18-2 Table 18.11 (p. 484 and also provided below) gives abbreviated balance sheets and income statements for Estee Lauder Companies. Calculate the following ratios: Answers: a. Ratio Return on assets T Formula (in words) C b. Operating profit margin T C c. Sales-to-assets ratio T C d, Inventory turnover T C e. Debt-equity ratio T C f. Current ratio T C g. Quick ratio T C Principles of Corporate Finance, Concise, 2nd Edition Calculation Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer. Principles of Corporate Finance, Concise, 2nd Edition Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer. ncome statements for TIP: Interest rate - p. 468 Principles of Corporate Finance, Concise, 2nd Edition Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer. Principles of Corporate Finance, Concise, 2nd Edition Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer. Problem 18-23 Suppose that you wish to use financial ratios to estimate the risk of a company's stock. Which of those that we have described in this chapter are likely to be helpful? Can you think of other accounting measures of risk? Answer: T Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer. ch of those that we easures of risk? Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer. Problem 19-11 If a firm pays its bills with a 30-day delay, what fraction of its purchases will be paid in the current quarter? In the following quarter? What if the delay is 60 days? Step 1: Worksheet - 30 day delay 2012 Qtr. 4 2013 Qtr.1 2013 Qtr.2 2013 Qtr.3 2013 Qtr.4 Month of Purchase Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Month for Payment T T T T T T T T T T T T T Step 2: Answers: 30 day delay - Payment made at end of 2013 Qtr1 Fraction from last quarter F Fraction from this quarter F Fraction for next quarter F 60 day delay - Payment made at end of 2013 Qtr1 Fraction from last quarter F Fraction from this quarter F Fraction for next quarter F Worksheet - 60 day delay 2012 Qtr. 4 2013 Qtr.1 2013 Qtr.2 2013 Qtr.3 2013 Qtr.4 Month of Purchase Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer. rrent quarter? In the heet - 60 day delay Month for Payment T T T T T T T T T T T T T T Instructions: Please refer to your book for assistance with your homework. Post your work in the worksheet. Highlight your final answer. Problem 19-17 Corporate financial plans are often used as a basis for judging subsequent performance. What do you think can be learned from such comparisons? What problems are likely to arise, and how might you cope with these problems? Answer: What do you think can be learned from such comparisons? T What problems are likely to arise, and how might you cope with these problems? T