How to calculate risk free rate return using excel

Assignment Help Finance Basics
Reference no: EM133116406

Stocks

Standard Deviation

Average Daily Return

CIMB (1023.KL)

1.392064068

0.110412281

HONG LEONG BANK (5819.KL)

0.917486147

0.008759785

MAYBANK (1155.KL)

0.825754256

0.01968605

PBB (1295.KL)

1.048821862

0.008729963

RHB CAPITAL (1066.KL)

1.088655859

0.01469079

SIME DARBY (4197.KL)

1.492164764

-0.001397119

GENTING (3182.KL)

1.685587134

0.013488929

AXIATA (6888.KL)

1.905758842

0.052230636

DIGI (6947.KL)

1.921317213

0.034610101

MAXIS (6012.KL)

1.446731279

-0.012946194

Month

3-yr MGS Closing Yield (End of month)

Jan-20

2.86%

Feb-20

2.61%

Mar-20

2.75%

Apr-20

2.40%

May-20

2.27%

Jun-20

2.24%

Jul-20

1.90%

Aug-20

1.83%

Sep-20

1.99%

Oct-20

1.75%

Nov-20

1.91%

Dec-20

1.87%

Jan-21

1.84%

Feb-21

1.98%

Mar-21

2.13%

Apr-21

2.34%

May-21

2.31%

Jun-21

2.27%

Jul-21

2.28%

Aug-21

2.34%

Sep-21

2.44%

Oct-21

2.68%

Nov-21

2.67%

How to calculate Risk Free Rate Return using excel?

Reference no: EM133116406

Questions Cloud

Determine the present value of a cash flows stream : Determine the present value of a cash flows stream of $2,250 to be received every year at a required rate of return of 5%. How the value would differ if the cas
What is the company degree of operating leverage : The company has no beginning or ending inventories. A total of 20,000 units were produced and sold last month. What is the company degree of operating leverage
Calculate the effective annual yield on bond : This is semiannual coupon, the bond matures in ten years. Calculate the bond's price. Calculate the effective annual yield on this bond.
How might agency conflicts arise in family-owned corporation : Discuss if the goal of family-owned public listed corporations is similar to those of corporations at large. How might agency conflicts arise in family-owned co
How to calculate risk free rate return using excel : How to calculate Risk Free Rate Return using excel?
Prepare a classified balance sheet for yahoo! inc : Suppose the following items are taken from the 2022 balance sheet of Yahoo! Inc. Prepare a classified balance sheet for Yahoo! Inc
Coefficient of variation and the Interquartile Range : What does the graph tell you about typical scores, spread, and shape of the data and Which is most appropriate in describing this set of data and why
New end-of-period spot rate : The current spot rate is VND 21.705/KRW. Vietnamese dong (VND) appreciates against the South Korean won (KRW) by 6.08% over the coming period, then what will be
What percentage has the us dollar changed : Assume that over a particular period the US dollar appreciated against the Swiss franc by 16.1% and the Swiss franc appreciated against the Colombian peso by 25

Reviews

Write a Review

Finance Basics Questions & Answers

  What will the price be in 2 years

You hold a 6 year bond with a coupon of 5% and a price of 92.56%. In two years' time the discount rate applied to the bond is 5.75%.

  Annuity-perpetuity

(Annuity - perpetuity) 3 years from now (at t=3) you will begin to receive cash flows of $1000 per year. These cash flows will continue forever. If the discount rate is 5%, what is the present value (now, at t=0) of these cash flows?

  What is the retailer effective cost of trade credit

What is the retailer's effective cost of trade credit? Assume a 365-day year. Do not round intermediate calculations. Round your answer to two decimal places.

  What is the yield to maturity at a current market

Harrimon Industries bonds have 6 years left to maturity. Interest is paid annually, and the bonds have a $1000 par value and a coupon rate of 10%.

  What must municipals offer for the investor

An investor is in a 30% combined federal plus state tax bracket . if corporate bonds offer 9% yields, what must municipals offer for the investor to prefer them to corporate bonds?

  Prepare the balance sheet after the partnership formation

The inventory contributed by ZZ includes obsolete items with a recorded cost of P20,000. Prepare the balance sheet after the partnership formation

  What is the yield to maturity of the? bonds

Springfield Nuclear Energy Inc. bonds are currently trading at ?$1 comma 1,167.21. The bonds have a face value of ?$1 comma 1,000?, a coupon rate

  What is her cash flow now

What will Ms. Browns cash flow be under the proposed capital structure of the firm? Assume that she keeps all 250 of her shares. (Do not round intermediate calculations and round your final answer to 2 decimal places. (e.g., 32.16))

  You must make a payment of 162901 in 10 years to get the

a it is now january 1. you plan to make a total of 5 deposits of 500 each one every 6 months with the first

  What would be the dollar amount of required reserves

Assume that the Fed decides to increase the required reserve percentage on transaction accounts above $40 million from 8 percent to 10 percent.

  Describe the differences between flexible and fixed budgets

How would you describe the differences between flexible and fixed budgets? Are there situations where one would be preferable to the other and vice versa?

  Three-quarters of its revenue from overseas markets

Coca-Cola, a well-known U.S. multinational company, derives about three-quarters of its revenue from overseas markets. It is thus highly likely that the company is exposed to currency risks. Investigate the company's exchange risk management polic..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd