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)
Background image of page 1
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
Background image of page 2
Sign up to view the entire interaction

Top Answer

Hi Please find the... View the full answer

8420846.xls

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...

Sign up to view the full answer

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
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online