Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please give the the EXCEL formula for each! 3 Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Based on the values

image text in transcribedimage text in transcribed

Please give the the EXCEL formula for each!

3 Suppose the returns on long-term corporate bonds and T-bills are normally distributed. Based on the values below answer the following questions: a. What is the probability that in any given year, the return on long-term corporate 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 long-term corporate bonds was -2.76 percent. How likely is it that such a low return 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 such a high return on T-bills will recur at some point in the future? 4 5 6 6 7 6.30% 8.40% 8 9 10 11 Long-term corporate bonds Average return Standard deviation T-bills Average return Standard deviation a. Return greater than Return less than b. Return greater than Return less than C. Return less than 12 55 13 3.50% 3.10% 10.00% 0.00% 10.00% 0.00% -2.76% 14 15 16 Sheet1 A B D E F G H 13 14 15 Return less than b. Return greater than Return less than c. Return less than Return greater than 0.00% 10.00% 0.00% -2.76% 10.56% 16 17 18 19 20 Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel functions to answer this question. 21 22 a. Probability of return greater than 10% Probability of return less than 0% 23 24 25 b. Probability of return greater than 10% Probability of return less than 0% 26 27 28 c. Probability of return less than -2.76% Probability of return greater than 10.56% 29 30 31 32 33 Sheet1 E 100 READY Attempt(s) 6/6 Hint

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Airline Management Finance

Authors: Victor Hughes

1st Edition

1138610690, 978-1138610699

More Books

Students also viewed these Finance questions

Question

Show the third and fourth steps in the sequencing of oxytocin.

Answered: 1 week ago

Question

2. What is the meaning and definition of Banking?

Answered: 1 week ago

Question

3.What are the Importance / Role of Bank in Business?

Answered: 1 week ago