Instructions: Use Excel to do these problems and paste the answers into this Word Document – Include all calculations.

What is the holding period return to an investor who bought 100 shares of Charter Oil nine months ago for $36 a share, received two $50 dividend checks, and sold the stock today at $38 a share?

What is the market price of a share of stock for a firm that pays dividends of $1.20 per share, has a P/E of 14, and a dividend payout ratio of 0.4?

A firm’s current ratio is 1.5, and its quick ratio is 1.0. If its current liabilities are $10,000, what are its inventories?

Determine the amount you would be wiling to pay for a $1,000 par value bond paying $80 interest each year (annual) and maturing in 12 years, assuming you wanted to earn a 9% rate of return.

Your grandparents put $1,000 into a saving account for you when you were born 30 years ago. This account has been earning interest at a compound rate of 7%. What is its value today?

An insurance company offers you and end of year annuity of $48,000 per year for the next 20 years. They claim your return on the annuity is 9%. What is the most you would be willing to pay today for this annuity?

1st bank offers you a car loan at an annual interest rate of 10% compounded monthly. What effective annual interest rate is the bank charging you?

Compute the risk premium for the stock of Omega Tools if the risk free rate is 6%, the expected market return is 12%, and Omega’s stock has a beta of .8.

Elephant Company common stock has a beta of 1.2. The risk-free rate is 6% and the expected market rate of return is 12%. Determine the required rate of return on the security.

nd end of year annuity of $48,000 per year for the next 20 years. They claim your return on the annuity is 9%. What is the most you would be willing to pay today for this annuity?

1st bank offers you a car loan at an annual interest rate of 10% compounded…