Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. the question is on the first picture excel onlin

the question is on the first picture Excel Online Structured Activity: Interest rate...

90.2K

Verified Solution

Question

Finance

image
image
the question is on the first picture
Excel Online Structured Activity: Interest rate premium Ayer Treasury band basedA 10-ve Treasury bod yet 6.854 and a 10-y corporate on 11 hentatiets wil w17 OP-3.3) there is no maturity risk premium (MRP-) and that the realitet, man starter test raster that it secuti DRP - LP-:) A 5.ver Corporate bond has the same dal risk and des 10 dered. The state and the the spreadsheet and perform the required analysis to answer the ration below x] What is the vied on this year corporate bond Hound your answer to temo Check My Work L 12 Arial 10 B I : YAY 12 Ft A B C D m F G 3.35% 6.85% 8.15% 3.75% 0.00% 0.00% 0.00% D Formulas #N/A #N/A 1 Interest rate premiums 2 35-year Treasury yield (T5) 4 10-year Treasury yield (T 10) 5 10-year Corporate yield (C10) 6 Inflation Premium over 10 years (IP10) 7 Maturity Risk Premium (MRP) 8 DRP Treasury 9 LP Treasury 10 DRPC + LPcs = DRPC10 + LPC10 11 12 Real risk-free rate.r 13 14 Inflation premium over 5 years (IP) 15 16 DRP 10 + LP 10 17 185-year Corporate yield (C3) 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 #N/A #N/A

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students