Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi i need help with these two programming problems. Finance 4310 Financial Modeling Spring 2016 Assignment # 5 - Due March 27, 2016 at 11:58
Hi i need help with these two programming problems.
Finance 4310 Financial Modeling Spring 2016 Assignment # 5 - Due March 27, 2016 at 11:58 pm. Email to fin4201hw@gmail.com. (This account is to submit assignments ONLY!) Put \"Assignment #5\" in the subject line. All assignment must have a cover sheet showing the student name(s), student ID number(s) and the title of the submission (i.e. Assignment #5). Appearance and clarity count. This includes, but is not limited to, headings, labels and approximate data formats. If your last name begins with A - Ma, complete 1. If your last name begins with Mi - Z, complete 2. All variables and functions are to be typed (declared). Hint: option explicit. SIN and COS are the Excel functions and are for comparison. All students are to complete #3. 1. A cosine can be approximated by the following infinite series: cos x=1 x2 x4 x6 + + . .. 2! 4! 6! ( )( ) ( ) Write a function that will calculate this for any x and y number of terms. If y > 85 or y is not a positive integer, return an error. X Y Cos( x ) MyCosine (x,y) Approximation error 0.31831 9 9. 0.95493 5 1.27324 37 1.59154 65 9 2.22816 88 9 2. A sine can be approximated by the following infinite series: x3 x5 x7 + +. . . Write a function that will calculate this for any x and y number of terms. If y > 85 3! 5! 7! ( )( ) ( ) sin x=x or y is not a positive integer, return an error. X 0.31831 Y 9 9. 0.95493 5 1.27324 37 1.59154 65 9 2.22816 88 9 Sin( x ) MySine (x,y) Approximation error Finance 4310 Financial Modeling Spring 2016 3. A hybrid linked note is an instrument that provides investors fixed income and equity market. It is structured by combining a return that is 75% equity and 25% fixed income. The investment pays the greater of the par value, $1,000, or the price times the 75% percentage increase in the S&P 500 plus 25% the return on the Barclays US Aggregate Index. Write 2 functions (hlnPayoff, hlnReturn). The first, hlnPayoff, calculates the security payoff at maturity. The second, hlnReturn, calculates the annualized return assuming continuous compounding. The function hlnReturn should call the payoff function. Price 953 914 811 733 Years SP5000 1 2 5 8 1783 1298 1288 1335 SP5001 1995 1498 1568 1270 Barclay US Agg0 Barclay US Agg1 1810 1909 1710 1612 Payof 1887 1942 1887 1923 ReturnStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started