Please show how to solve in simplest way with work, if needed excel is acceptable: [multi part question]

Compute the fair rate of return for a stock. Stock beta is 1.20 Treasury yields are 4.25% and the S&P 500 had a return of 14.63% . a.) 15.28% b.) 12.46% c.) 13.63% d.) 16.71% e.) 14.25%

Please show how to solve in simplest way with work, if needed excel is acceptable:

Given the following annual return metrics for stock ABC, calculate the historical average return.

2015: 10% 2016: 18% 2017: -8% 2018: 12% 2019: 6% 2020: -2% a.) 8.22% b.) 8.86% c.) 7.81% d.) 6.59% e.) 6.00%

Please show how to solve in simplest way with work, if needed excel is acceptable:

Rogers Inc. has a beta of .086 . If the overall market returns 11.5% and the risk-free rate is 2.25% what is the appropriate required return for Rogers Inc ?

a.) 11.63%
b.) 10.21%
c.) 13.75%
d.) 7.76%
e.) 9.25%

Please show how to solve in simplest way with work, if needed excel is acceptable:

Assume that you own a portfolio which contains the following four stocks: A: $3,100 & 9.60% return B: $4,150 & 8.80% return C: $8,600 & 4.20% return D: $5,150 & 6.80% return What is the overall portfolio return? a.) 6.54% b.) 7.35% c.) 6.85% d.) 8.04% e.) 7.78%

Please show how to solve in simplest way with work, if needed excel is acceptable:

What is the present value of an ordinary annual annuity with 8 payments of $2,150 if the appropriate interest rate is 6.56% ?

a.) $16,478
b.) $20,679
c.) $13,060
d.) $11,320
e.) $18,529

Please show how to solve in simplest way with work, if needed excel is acceptable:

What is the present value of a perpetuity that pays $210 per year if the appropriate interest rate is 7.33% ? a.) $2,865 b.) $2,021 c.) $4,015 d.) $3,398 e.) $3,893

Please show how to solve in simplest way with work, if needed excel is acceptable:

Your monthly budget for a car is $435,000. Based on your credit profile, you can obtain a 4-year loan with a 4.75% annual rate (assume monthly compounding) With these parameters in place, how much car can you afford to buy? How much Additional car could you buy if you took out a 5-year loan as opposed to a 4-year loan? (assume all other parameters remain constant?) a.) $18,982 and $3,244.78 b.) $19,636.75 and $4,354.41 c.) $18,982.19 and $3,159.35 d.) $18.982.19 and $4,209.26 e.) $19.636.75 and $3,244.78

Please show how to solve in simplest way with work, if needed excel is acceptable:

Suppose you inherited $250,000 and invested it at 6.25% compounded annually. How much could you withdraw at the end of each of the next 15 years? a.) $16,667 b.) $22,024 c.) $19,258 d.) $26,163 e.) $28,361

Please show how to solve in simplest way with work, if needed excel is acceptable:

If you were lucky to be in the position to negotiate either a signing bonus of $2 million today or a payment of $2.5 million three years from now, what should you do? Assume you can earn 7% annually on your invested funds.

Please show how to solve in simplest way with work, if needed excel is acceptable:

If you were lucky to be in the position to negotiate either a signing bonus of $2 million today or a payment of $2.5 million three years from now, what should you do? Assume you can earn 7% annually on your invested funds.

a.) take the signing bonus because it has the lower present value b.) take the signing bonus because it has higher present value. c.) take the payment in three years because it has the higher present value. d.) take the payment in 3 years because it has the lower present value

Please show how to solve in simplest way with work, if needed excel is acceptable:

You need to borrow $46,000 to purchase a new truck. The current loan rate is 4.9% compounded Monthly. You decided that you want to pay the loan off in equal monthly payments over 5 years. What is the size of your monthly payment?

a.) $685.26
b.) $865.97
c.) $701.37
d.) $442.93
e.) $533.99

Please show how to solve in simplest way with work, if needed excel is acceptable:

How much would you have to invest today at 4.50% compounded Monthly to have $18,000 available for purchase of a car six years from now?

a.) $14,743.27
b.) $13,747.77
c.) $12,879.11
d.) $11,976.11
e.) $14,258.47

Please show how to solve in simplest way with work, if needed excel is acceptable:

What is the present value of an ordinary annual annuity with 8 payments of $2,150 if the appropriate interest rate is 6.56% ? a.) $16,487 b.) $20,679 c.) $13,060 d.) $11,320 e.) $18.529

Please show how to solve in simplest way with work, if needed excel is acceptable:

How much will accumulate in an account with an initial deposit of $133 , and which earns 9% interest compounded quarterly for 4 years?

a.) $212.36 b.) $133.10 c.) $134.49 d.) $313.84 e.) $189.97

Please show how to solve in simplest way with work, if needed excel is acceptable:

Ari recently obtained a $134,00 loan with a 4.875% annual interest rate (compounded monthly) . Which he needs to repay in 15 years. What will be the Loan Balance after the second monthly payment is made?

a.) $132,716.58
b.) $133,106.71
c.) $134,386.22
d.) $132,984.77
e.) $133,493.42