View the step-by-step solution to:

# Need to be done in Excl with full work/calculations (3-1) Days Sales Outstanding Greene Sisters has a DSO of 20 days. The company's average daily

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

Need to be done in Excl with full work/calculations (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 CF 0 = 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

If you want the formulas and any calculations, select the corresponding cell and press F2(Function Key on key board), It will show all calculations and formulas Automatically Question: (3-1) Days...

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents