Question: Suppose the returns on bonds and T-bills are normally distributed. Based on the historical record, use the NORMDIST function in Microsoft Excel to answer the

Suppose the returns on bonds and T-bills are normally distributed. Based on the historical record, use the NORMDIST function in Microsoft Excel to answer the following questions:
a. What is the probability that in any given year, the return on bonds will be greater than 10 percent? Less than 0 percent?
b. What is the probability that in any given year, the return on T-bills will be greater than 10 percent? Less than 0 percent?
c. In 1979, the return on bonds was -4.18 percent. How likely is it that a return this low will recur at some point in the future? T-bills had a return of 10.56 percent in this same year. How likely is it that a return on T-bills this high will recur at some point in the future?

Step by Step Solution

★★★★★

3.46 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style16 msonumberformat00220022 00000220022 00000220022 00220022 msostylenameCurrency msostyleid4 style0 msonumberformatGenera... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

472-B-C-F-R-A-R (781).xlsx

300 KBs Excel File

Students Have Also Explored These Related Corporate Finance Questions!

a what is the probability that the person responded Increase oil, gas and coal b what is the probability that the person responded Equally important or had no opinion Suppose we select three people...

12. The Supplemental Poverty Measure (SPM) can be more accurate than the Official Poverty Line (OPL) because: O none of the other answers are true; the SPM simply updates the OPL methodology by using...

Use the diagram to answer the following questions (ad). a. At the equilibrium price before the tax is imposed, what area represents consumer surplus? What area represents producer surplus? b. Say...

Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Based on the historical record, use NORMDIST function in Excel text to answer the following questions: Refer to...

Suppose the returns on bonds and T-bills are normally distributed. Based on the historical record in Table 10.2, use the NORMDIST function in Microsoft Excel to answer the following questions: (Do...

Suppose the returns on bonds and T-bills are normally distributed. Based on the historical record in: Table 10 2 : use the NORMDIST function in Microsoft Excel to answer the following questions: (Do...

Suppose the returns on long - term corporate bonds and T - bills are normally distributed. Based on the historical record, use the NORMDIST function in Excel to answer the following questions: a ....

Let X be an Exponentially distributed random variable with expected value 1/2. Let Y = X2.

Acid has been found to be a primary cause of dental caries (cavities). It is theorized that oral mouthwashes contribute to the development of caries due to the antiseptic agent oxidizing into acid...

Ayratonia, a working project manager and promising musician, wants to purchase a new guitar and case for $ 8 2 0 0 . When they learned of this opportunity, the grandparents provided a gift of $ 2 1 0...

The Theater Arts Guild of Dallas (TAG-D) employs five people in its Publication Department. These people lay out pages for pamphlets, brochures, magazines, and other publications for the TAG-D...

On January 1, 2017, Phantom Corp. acquires $300,000 of Spider Products, Inc. 9% bonds at a price of $278,384. The interest is payable each December 31, and the bonds mature on December 31, 2019. The...

United States Steel's 7.375% bonds due in 2020 were reported as selling for 103.00. Were the bonds selling at a premium or at a discount? Why is United States Steel able to sell its bonds at this...

Romero issues $3,400,000 of 10%, 10-year bonds dated January 1, 2016, that pay interest semiannually on June 30 and December 31. The bonds are issued at a price of $3,010,000. Required 1. Prepare the...

Moss Co. issued $42,000,000 of five-year, 11% bonds, with interest payable semiannually, at a market (effective) interest rate of 9%. Determine the present value of the bonds payable using the...

What are the key elements that make up business value?

J&R Renovation, Inc., is trying to determine its cost of debt. The firm has a debt issue outstanding with 14 years to maturity that is quoted at 95 percent of face value. The issue makes semiannual...

The Angelina Corporations common stock has a beta of 1.08. If the risk-free rate is 3.7 percent and the expected return on the market is 10 percent, what is the companys cost of equity?

Suppose you observe the following situation: a. Calculate the expected return on each stock. b. Assuming the capital asset pricing model holds and Stock As beta is greater than Stock Bs beta by .34,...

Perrin Company designs industrial prototypes for outside companies. Budgeted overhead for the year was $390,000, and budgeted direct labor hours were 26,000. The average wage rate for direct labor is...

12-24 Budgeted costs, kaizen improvements. Trendy T-Shirt Factory manufactures plain white and solid-colored T-shirts. Inputs include the following: Additionally, the colored T-shirts require 3...

Hart Labs, Inc. provides mad cow disease testing for both state and federal governmental agricultural agencies. Because the company's customers are governmental agencies, prices are strictly...