FINC 600 Assignment 7 Complete the following problems

| February 25, 2017

Question
FINC 600 Assignment 7

Complete the following problems in either Microsoft Word or Excel.
Your work must be organized. Highlight your final answer.

Chapter 18

18-2Question
You are considering buying a new house in a new city. You want to know the average price of the houses in a new community to which you are considering moving. Do you want to know the mean, median or mode price for the price of homes in that community? Why?

Table 18.11 gives abbreviated balance sheets and income statements for Estée Lauder Companies.

TABLE 18.11

End of Year Start of Year

Balance Sheet

Assets

Current Assets:

Cash and Marketable Securities 402 254

Accounts Receivable 1039 861

Inventories 987 856

Other Current Assets 360 269

Total Current Assets 2787 2239

Fixed Assets:

Tangible fixed assets

Property, Plant & Equipment 2394 2113

Less accumulated depreciation 1351 1232

Net Tangible Fixed Assets 1043 881

Long-term investments 24 22

Other long-term assets 1157 984

Total Assets 5011 4126

Liabilities and Shareholder’s Equity

Current Liabilities

Debt due for repayment 119 60

Accounts payable 1581 1440

Total Current Liabilities 1699 1501

Long-term debt 1078 1028

Other long-term liabilities 581 398

Total Liabilities 3358 2927

Total Shareholders’ equity 1653 1199

Total Liabilities and shareholders’ equity 5011 4126

Income Statement

Net Sales 7911

Cost of goods sold 1997

Selling, general and administrative expenses 4852

Depreciation 251

Earnings before interest and taxes (EBIT) 811

Interest expense 67

Taxable income 744

Tax 260

Minority interest 10

Net income 474

Dividends 107

Addition to retained earnings 367

Calculate the following ratios:

a. Return on assets.

b. Operating profit margin.

c. Sales-to-assets ratio.

d. Inventory turnover.

e. Debt–equity ratio.

f. Current ratio.

g. Quick ratio

18-4

Look again at Table 18.11. At the end of fiscal 2008 Estée Lauder had 195 million shares outstanding19 with a share price of $45.50. The company’s weighted-average cost of capital was about 10%.

Calculate:

a. Market value added.

b. Market-to-book ratio.

c. Economic value added.

d. Return on capital.

Chapter 19

19-3

Here is a forecast of sales by National Bromide for the first four months of 2010 (figures in $ thousands):

Month 1 Month 2 Month 3 Month 4

Cash Sales 15 24 18 14

Sales on Credit 100 120 90 70

On the average 50% of credit sales are paid for in the current month, 30% are paid in the next month, and the remainders are paid in the month after that. What is the expected cash inflow from operations in months 3 and 4?

19-8

Abbreviated financial statements for Archimedes Levers are shown in Table 19.12. If sales increase by 10% in 2011 and all other items, including debt, increase correspondingly, what must be the balancing item? What will be its value?

TABLE 19.12

Income Statement

Sales $4000

Costs, including interest $3,500

Net income $500

Balance Sheet, Year-End

2010 2009 2010 2009

Assets $3,200 $2,700 Debt $1,200 $1,033

Equity $2,000 $1,677

Total $3,200 $2,700 Total $3,200 $2,700

Show all your work to earn partial credit.

Get a 30 % discount on an order above $ 100
Use the following coupon code:
ESSAY30
Positive SSL