all variables and functons are To be Typed (declared).HinT:opton expliciT.SIN and COS are The Excel functons and arefor comparison.1. A cosine can be approximaTed by The following inFniTe series:cosx=1−(x22!)+(x44!)−(x66!)+…WriTe a functon ThaT will calculaTe This for any x and y number of Terms.If y >85 or y is noT a positve inTeger, reTurn an error.XYCos( x)MyCosine(x,y)Approximaton error0.3183190.954939.51.27324371.591549652.228169882.An index linked note is an instrument that provides investors fixed income-like principal protection togetherwith equity market upside exposure.It is structured by combining the economics of a long call option on equitywith a long discount bond position.The investment pays the greater of the par value, $1,000, or the price timesthe percentage increase in the S&P 500.Write 2 functions (elnPayoff, elnReturn).The first, elnPayoff, calculates the security payoff at maturity.Thesecond, elnReturn, calculates the annualized return assuming continuous compounding.The function elnReturnshould call the payoff function.PriceYearsSP5000SP5001Payo±ReTurn961117831995923212981498819512881568727813351270
Stop worrying about assignment deadlines, let us help with this paper!
Smart students don’t copy paste information from all over the web hoping to get a good grade! Watch the video below to learn what they do: