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-2
Table 18.11 gives abbreviated balance sheets and income statements for Este?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 Shareholders 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. Debtequity ratio.
f. Current ratio.
g. Quick ratio
18-4
Look again at Table 18.11. At the end of fiscal 2008 Este?e Lauder had 195 million shares outstanding19 with a share price of $45.50. The companys 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.