show steps to calculation to put in excel!!! - - Suppose 10-year Treasury Bond yields in the bond market are 5.87% annual, and the mortgage market requires a contract yield risk premium of 200 basis points. If a property has a (annual) net operating income (NOI) of $1,000,000, and the underwriting criteria require a debt service coverage ratio (DSCR) of at least 120%, then what is the maximum loan that can be offered assuming a 25-year amortization rate and constant monthly payments on the mortgage?

show steps to calculation to put in excel!!! - - Suppose 10-year Treasury Bond yields in the bond market are 5.87% annual, and the mortgage market requires a contract yield risk premium of 200 basis points. If a property has a (annual) net operating income (NOI) of $1,000,000, and the underwriting criteria require a debt service coverage ratio (DSCR) of at least 120%, then what is the maximum loan that can be offered assuming a 25-year amortization rate and constant monthly payments on the mortgage?

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Answer briefly the following questions:a) Write the formula of the Price-Earnings ratio and explain how a result of 11 should be interpreted.b) Write the equation for the PV of 200.000₺ to be received two years later when the market interest rate isforecast as 17%.c) Define the yield to maturity of a 4-year maturity bond whose face value will be repaid at the end of thematurity.d) Define the intrinsic value of a 2-year maturity bond whose face value will be repaid in equal installments.
Consider a 1-year, 10% annual payment corporate bond priced at par value. If the recovery rate is 30%, what is the expected loss given default?
(d) Which of the following investments has the highest annual percentage yield (APY)? (Assume that all CDs are of equal risk.) Bank A that pays 8 percent interest compounded quarterly.Bank B that pays 8 percent compounded monthly.Bank C that pays 8.25 percent annually Show your working to justify your decision.
The REIT is facing a $300 million mortgage debt maturity in 2018, and could do either a senior notes offering at a 4.25% interest rate, or a perpetual preferred offering at a yield of 6.5%. What is the impact on the following credit ratio of each alternative? A Leverag B Fixed Charge coverage
An analyst observes a 10- year, 10% semi annual-pay bond. The face amount is £1,000. The analyst believes that the yield to maturity for this bond should be 15% based on this yield estimate, what would be the amount ? what is the method to solve this equation and the solution? Thank you.
The risk-free rate on long-term Treasury bonds is 6.04%. Assume thatthe market risk premium is 5%. What is the required return on the market? Now use the SML equation to calculate the two companies’ requiredreturns.
You will be paying $8,600 a year In tultion expenses at the end of the next two years. Bonds currently yleld 7%. Q. What is the present value and duration of your obligation? b. What maturity zero-coupon bond would Immunize your obligation? c. Suppose you buy a zero-coupon bond with value and duration equal to your obligation. Now suppose that rates immediately Increase to 9%. What happens to your net position, that is, to the difference between the value of the bond and that of your tultion obligation? d. What if rates fall Immediately to 5% ? Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D What is the present value and duration of your obligation? (Do not round intermediate calculations. Round "Present value" to 2 decimal places and "Duration" to 4 decimal places.) \table[[,,,],[Present value,,,,,],[Duration,,years,,,]]
b. Suppose you are considering two possible investment opportunities: a 12-year Treasury bond and a 7-year, A-rated corporate bond. The current real risk-free rate is 5%, and inflation is expected to be 2% for the next 2 years, 3% for the following 4 years, and 4% thereafter. The maturity risk premium is estimated by this formula: MRP Io.01(t-1)%. The liquidity premium (LP) for the corporate bond is estimated to be 0.2%. You may determine the default risk premium (DRP), given the company's bond rating, from the following table. Remember to subtract the bond's LP from the corporate spread given in the table to arrive at the bond's DRR U.S. Treasury AAA corporate AA corporate A corporate Rate 0.83% 0.93 1.27 1.71 Corporate Bond Yield Spread - DRP + LP What yield would you predict for each of these two investments? Round your answers to three decimal places. 12-year Treasury yield: 7-year Corporate yield: 184.7 0.10% 0.44 0.88 % %
Duration and price sensitivity a) Calculate the duration and modified duration of a bond with a face of $1,000, a 6% coupon rate, and a 5% YTM with 1 payment per year and a maturity of 10 years, using the Excel DURATION and MDURATION formulas. b) Calculate the following: 1. What are the approximate percentage and dollar changes in price for a 1% change in interest rates using the duration approximation formula? 2. What are the actual percentage and dollar changes in price if interest rates increase by 1%?
Suppose you open The National Post and see that 30-year Canada Bonds are ylelding 8.5%. This Is an example of Multiple Choice a default risk premium a nominal return a real return an inflation premium a taxability premium
Estimate the default premium and the maturity premium given the following three investment opportunities: a Treasury bill with a current interest rate of 3.5%; a Treasury bond with a twenty-year maturity and a current interest rate of 5.25%; and a AAA, corporate bond with a twenty-year maturity and an interest rate of 7.5%. What is the default premium? nothing% (Round to two decimal places.)
D3) Finance The spread between the yield on a five-year bond issued by a company and the yield on a similar risk-free bond is 80 basis points. Assuming a recovery rate of 40%, estimate the average hazard rate per year over the five-year period. If the spread is 70 basis points for a three-year bond, what do your results indicate about the average hazard rate in years 4 and 5?

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS