## Questions with Answer in Excel Sheet

1. How long does it take for the following to happen? \$450 grows into \$725.50 at 12% compounded monthly.
2. How long does it take for the following to happen? \$5,000 grows into \$6724.44 at 10% compounded quarterly.
3. How long does it take for the following to happen? \$856 grows into \$1,122 at 7%.
4. Find out present value when interest rate is 18%. Effective interest rate is 19.56% and future value is \$10,000 and time period is 3 years.
5. The Lexington Property Development Company has a \$10,000 note receivable from a customer due in three years. How much is the note worth today if the interest rate is 7% compounded continuously?
6. The Lexington Property Development Company has a \$10,000 note receivable from a customer due in three years. How much is the note worth today if the interest rate is 9%?
7. What interest rates are implied by the following lending arrangements? You borrow \$500 and repay \$555 in one year?
8. What interest rates are implied by the following lending arrangements? You lend \$750 and are repaid \$1,114.46 in five years with quarterly compounding.
9. What will a deposit of \$4,500 left in the bank be worth under the following conditions: Left for five years at 8% compounded quarterly?
10.  What will a deposit of \$4,500 left in the bank be worth under the following conditions: Left for six years at 10% compounded semiannually?

Need Assistance…??  email us at caresolvemyquestion.com.

If you need any type of help regarding Homework, Assignments, Projects,  Case study, Essay writing or any thing else then just email us at question@solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

## Alpha, Beta and Fitted Line for Colgate-Palmolive (CL)

Case Study on page 447-448 within the Ross textbook

1.   Go to finance.yahoo.com and download the ending monthly stock prices for Colgate-Palmolive for the last 60 months. Use the adjusted closing price, which adjusts for dividend payments and stock splits. Next, download the ending value of the S&P 500 index over the same period. For the historical risk-free rate, go to the St. Louis Federal Reserve Web site  (www.stlouisfed.org) and find the three-month Treasury bill secondary market rate. Download this file. What are the monthly returns, average monthly returns, and standard deviations for

Colgate-Palmolive stock, the three-month Treasury bill. and the S&P 500 tbr this period?

2.   Beta is often estimated by linear regression. A model often used is called the market model, which is:

## Finance Questions

Finance Questions in \$10 only

1. How long does it take for the following to happen? \$450 grows into \$725.50 at 12% compounded monthly.

2. How long does it take for the following to happen? \$5,000 grows into \$6724.44 at 10% compounded quarterly.

3. How long does it take for the following to happen? \$856 grows into \$1,122 at 7%.

4. The Lexington Property Development Company has a \$10,000 note receivable from a customer due in three years. How much is the note worth today if the interest rate is 18% compounded monthly?

5. The Lexington Property Development Company has a \$10,000 note receivable from a customer due in three years. How much is the note worth today if the interest rate is 7% compounded continuously?

6. The Lexington Property Development Company has a \$10,000 note receivable from a customer due in three years. How much is the note worth today if the interest rate is 9%?

7. What interest rates are implied by the following lending arrangements? You borrow \$500 and repay \$555 in one year

8. What interest rates are implied by the following lending arrangements? You lend \$750 and are repaid \$1,114.46 in five years with quarterly compounding.

9. What will a deposit of \$4,500 left in the bank be worth under the following conditions: Left for five years at 8% compounded quarterly?

10. What will a deposit of \$4,500 left in the bank be worth under the following conditions: Left for six years at 10% compounded semi-annually?