Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed 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 Return

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Financial Management Concise

Authors: Eugene F. Brigham, Joel F. Houston

11th Edition

0357517717, 9780357517710

More Books

Students also viewed these Finance questions

Question

How are product expenses different from period expenses?

Answered: 1 week ago

Question

Context, i.e. the context of the information presented and received

Answered: 1 week ago