{"id":37408,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/fi4000-fundamentals-of-valuation"},"modified":"2017-08-16T06:57:26","modified_gmt":"2017-08-16T06:57:26","slug":"fi4000-fundamentals-of-valuation","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/fi4000-fundamentals-of-valuation\/","title":{"rendered":"FI4000 Fundamentals of Valuation"},"content":{"rendered":"<div class=\"the_content_wrapper\">\n<p>FI4000 Fundamentals of Valuation<\/p>\n<p>1. Bond Pricing<br \/> Using Excel\u2019s bond pricing function [=price(qualifiers)], determine the price of a bond with a settlement date of 1 July 2016, and a maturity date of 1 July <\/p>\n<p>2036. The coupon rate of the bond is 6.5% and the bond pays coupons semi-annually with a yield to maturity (YTM) of 4.0%. <\/p>\n<p>Prove Excel\u2019s bond pricing is correct by determining the price by summing the discounted cash flows. Use cell addresses whenever possible.<\/p>\n<p>2. Duration<br \/> Using Excel\u2019s duration function [=duration(qualifiers)], find duration of a bond that has a settlement date of 1 July 2016, and a maturity date of 1 July 2036. The <\/p>\n<p>coupon rate of the bond is 6.5% and the bond pays coupons semi-annually. The bond is selling at a yield to maturity of 4.00%.<br \/> A. Find the duration of the bond.<br \/> B. What if the coupon on the bond were 1.50% (but all else was unchanged) , what is the duration?<br \/> C. Explain, in a few sentences, the differences in the duration from Part A and Part B.<br \/> D. Find the bond\u2019s modified duration using Excel\u2019s modified duration formula (=mduration, etc.)<br \/> E. Make a small table (data table, if you like) that shows the Duration predicted price of the bond using modified duration for ytm\u2019s ranging from 2.5% through <\/p>\n<p>8.5% in increments of 50 basis points.<\/p>\n<p>3. Term Structure of Interest Rates<br \/> Using Bloomberg, Yahoo.com\/finance, MSN Money, The Wall Street Journal, Data Stream, Google.com\/finance or any other reliable financial data service, find the yields <\/p>\n<p>and maturities of at least ten US Treasury Stripped Principal securities. These are US government guaranteed zero coupon securities. (Data must be gathered all at <\/p>\n<p>one time, not over days or even hours.) Maturities should range from 3 months to 30 years. <\/p>\n<p>Plot the data in Excel on an XY scatter graph, assuring the maturity is on the X axis and yield on the Y axis.<\/p>\n<p>What is the shape of the yield curve? What does that tell you about future interest rates?<\/p>\n<p>\u2003<\/p>\n<p>General instructions: Use Excel to answer all questions, including non-quantitative questions. ALL ANSWERS MUST BE CLEARLY LABELED, clearly printed, ORGANIZED AND <\/p>\n<p>EASY TO READ. Hand in one print version, as well as one electronic version (gbrown@gsu.edu) on or before the due date. The output font should be 10 or greater. You <\/p>\n<p>will lose more points than you believe are justified if your OUTPUT font is less than 10 and\/or you turn in difficult to read or disorganized work. On time <\/p>\n<p>assignment: 15 minutes after class begins (or before). Not on time? 10 points off per day. Follow directions. Answer all questions asked. You are graded on <\/p>\n<p>accuracy, completeness and organization, as well as your ability to follow directions. Make your work easy to read and follow. Put all questions on one spreadsheet. <\/p>\n<p>You may use different worksheets in that file, but use one file. Remember, I am grading this. The harder it is to find your work and grade, the lower your grade will <\/p>\n<p>be. <\/p>\n<p>All questions about the assignment should be directed to me only. Work on this assignment should be yours and yours alone. Don\u2019t let anyone look at your Excel file <\/p>\n<p>or copy any portions, ask or answer questions about your assignment to any other students. Any collaboration with others is a violation of the University\u2019s policy on <\/p>\n<p>Academic Honesty and can result in expulsion from GSU.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>FI4000 Fundamentals of Valuation 1. Bond Pricing Using Excel\u2019s bond pricing function [=price(qualifiers)], determine the price of a bond with a settlement date of 1 July 2016, and a maturity date of 1 July 2036. The coupon rate of the <a href=\"https:\/\/www.benedictsol.com\/blogs\/fi4000-fundamentals-of-valuation\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-37408","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/37408","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=37408"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/37408\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=37408"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=37408"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=37408"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}