Details of this Paper

Need to be done in excel with full work and calcul...

Description

Solution

Question

Need to be done in excel with full work and calculation (3-1) Days Sales Outstanding Greene Sisters has a DSO of 20 days. The company?s average daily sales are \$20,000. What is the level of its accounts receivable? Assume there are 365 days in a year. (3-2) Debt Ratio Vigo Vacations has an equity multiplier of 2.5. The company?s assets are financed with some combination of long-term debt and common equity. What is the company?s debtratio? (3-3) Market/Book Ratio Winston Washers?s stock price is \$75 per share. Winston has \$10 billion in total assets. Its balance sheet shows \$1 billion in current liabilities, \$3 billion in long-term debt, and \$6 billion in common equity. It has 800 million shares of common stock outstanding. What is Winston?s market/book ratio? (3-4) Price/Earnings Ratio A company has an EPS of \$1.50, a cash flow per share of \$3.00, and a price/cash flow ratio of 8.0. What is its P/E ratio? (3-5) ROE Needham Pharmaceuticals has a profit margin of 3% and an equity multiplier of 2.0. Its sales are \$100 million and it has total assets of \$50 million. What is its ROE? Intermediate Problems 6-10 (3-6) Du Pont Analysis Donaldson & Son has an ROA of 10%, a 2% profit margin, and a return on equity equal to 15%. What is the company?s total assets turnover? What is the firm?s equity multiplier? (3-7) Current and Quick Ratios Ace Industries has current assets equal to \$3 million. The company?s current ratio is 1.5, and its quick ratio is 1.0. What is the firm?s level of current liabilities? What is the firm?s level of inventories? (4-1) Future Value of a Single Payment If you deposit \$10,000 in a bank account that pays 10% interest annually, how much will be in your account after 5 years? (4-2) Present Value of a Single Payment What is the present value of a security that will pay \$5,000 in 20 years if securities of equal risk pay 7% annually? (4-6) Future Value: ordinary Annuity versus Annuity Due What is the future value of a 7%, 5-year ordinary annuity that pays \$300 each year? If this were an annuity due, what would its future value be? (4-13) A Present Value of an Annuity Find the present value of the following ordinary annuities (see the Notes to Problem 4-12). ? a. \$400 per year for 10 years at 10% ? d. Now rework parts a, b, and c assuming that payments are made at the beginning of each year; that is, they are annuities due. (4-14) Uneven Cash Flow Stream Find the present values of the following cash flow streams. The appropriate interest rate is 8%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator?s cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, Year Cash Stream A Cash Stream B 1 \$100 \$300 2 400 400 3 400 400 4 400 400 5 300 100

Paper#6868 | Written in 18-Jul-2015

Price : \$25