Answer the question in excel please1 suppose you manage a 4, Ask an Expert

Finance

Answer the question in Excel please.

1) Suppose you manage a $4 million fund that consists of four stocks with the following investments:

If the market's required rate of return is 14% and the risk-free rate is 6%, what is the fund's required rate of return?

2) Vigo Vacations has $200 million in total assets, $5 million in notes payable, and $25 million in long-term debt. What is the debt ratio?

View complete question

Basic Finance, Finance

Category:- Basic Finance
Reference No.:- M92047319

Have any Question?Write your Review or question?

Related Questions in Basic Finance

Leo received 7500 today and will receive another 5000 two

Leo received $7,500 today and will receive another $5,000 two years from today. He will invest these funds when he receives them and expects to earn a rate of return of 11.5 percent. What value does he expect his investm ...

Quality home made ice cream has plans to pay decreasing

Quality Home Made Ice Cream has plans to pay decreasing annual dividends of $1.50, $1.25, and $1.00 over the next three years, respectively. After that, the firm will increase the dividend by 4% each year. what is the va ...

Suppose the annualized yield on a one-year security today

Suppose the annualized yield on a one-year security today is 0.01. The markets expect the annualized yield on a one-year security to be 0.02 one year from today, 0.03 two years from today, and 0.04 three years from today ...

General mills has a 1000 par value 15-year to maturity bond

General Mills has a $1,000 par value, 15-year to maturity bond outstanding with an annual coupon rate of 8.01 percent per year, paid semiannually. Market interest rates on similar bonds are 8.15 percent. Calculate the bo ...

Skyco corporation is considering a project with the

SkyCo Corporation is considering a project with the following expected NOCF's: Year NOCFt 1 $390,000 2 $410,000 3 $385,000 A) If the firm's WACC is 12.1%, and the project costs $850,000, what is the NPV? B) What is the M ...

Set up an amortization schedule for a 15000 loan to be

Set up an amortization schedule for a $15,000 loan to be repaid in equal installments at the end of each of the next 4 years. The interest rate is 10%. How large must each payment be if the loan is for $30,000? Assume th ...

I dont understand certain financial ratios for elizabeth

I dont understand, Certain financial ratios for Elizabeth Arden for its most recent year below, along with the average ratios for its industry. Based on those ratios a. Does Arden seem to prefer to finance its assets wit ...

You have a chance to buy an annuity that pays 1400 at the

You have a chance to buy an annuity that pays $1,400 at the beginning of each year for 3 years. You could earn 5.5% on your money in other investments with equal risk. What is the most you should pay for the annuity?

Corporate finance questionan investment pays you 30000 at

Corporate Finance Question: An investment pays you $30,000 at the end of this year, and $10,000 at the end of each of the four following years. What is the present value (PV) of this investment, given that the interest r ...

Calculate the value of a bonds with face value of 1000 a

Calculate the value of a bonds with face value of $1,000 a coupon interest rate of 8 percent paid semiannually; and a maturity of 10 years. Assume the following discount rate (a) 6 percent (b) 8 percent (c) 10 percent

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Basic Finance Expert