Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A client has four financial instruments to identify and evaluate. The following figure shows the numerical details. He lost the document that described their classification

A client has four financial instruments to identify and evaluate. The following figure shows the numerical details. He lost the document that described their classification and prices. He engages your consultation service to identify the financial asset class/instrument category that these financial instruments belong to, their characteristics and ultimately calculate their prices in SGD (Singapore Dollar).

CurrencySGDEURSGDUSD
Yearly Cost of Borrowing4%3%4%2%
Yield Curves are flat for all countries

YearsFinancial Instrument 1Financial Instrument 2Financial Instrument 3Financial Instrument 4

1

$0

$1,900$2,500$0

2

$0$1,500$2,500$0

3

$0$2,100$2,500$0

4

$0$1,800$2,500$0

5

$100,000$102,000$102,500$103,000

EUR = The Euro

USD = United States Dollar

SGD = Singapore Dollar

Spot prices (mid)

EUR/USD 1.14

USD/SGD 1.35

Notation

USD/SGD is in SGD per USD

(a) Indicate, for the the above-mentioned instruments, whether each instrument is a Floating Rate Note (FRN), Fixed Deposit (FD), Fixed Rate Bond (FRB) or ZeroCoupon Bond (ZCB), with suitable reasons. 

(b) Solve for the mid-spot price of EUR/SGD (in SGD per EUR). Round off to two decimal places. 

(c) Solve for the current (spot) prices of each financial instrument in their respective currency using the relevant Microsoft Excel function. Show the Excel functions involved. All answers should be expressed in the original currency and round off to two decimal places.

(d) Convert the current (spot) price of financial instrument in EUR (namely, the financial instrument 2) to SGD and round off to two decimal places.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

a Identifying the Financial Instruments 1 Financial Instrument 1 Zero Coupon Bond ZCB This is a zero... 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

Elementary Statistics

Authors: Robert R. Johnson, Patricia J. Kuby

11th Edition

978-053873350, 9781133169321, 538733500, 1133169325, 978-0538733502

More Books

Students also viewed these Finance questions

Question

Excel caculation on cascade mental health clinic

Answered: 1 week ago

Question

8.7 Explain how cultures influence the perception of time.

Answered: 1 week ago