Question:

Hypothesise and categorise the above-mentioned financial assets, whether the asset is a Stock (with forecasted dividends), Floating Rate Notes, Fixed Deposit, Zero Coupon Bond or Fixed Rate Bond. After categorising, provide descriptions on the feature of each asset class/category. Your logics and reasoning should be presented in less than 250 words.

The first department you joined was the Relationship Management (RM) Singapore Team. A relationship manager assistant approached you. Her name is Veronica. She just joined the bank recently. She understands Microsoft Excel spreadsheet well but has little knowledge about financial instruments and their characteristics. She realised that you are studying in SUSS and are a subject matter expert in Financial Modelling. She hands an investment portfolio (in Singapore Dollar, SGD) to you and seeks your help to identify the category of each financial asset and have their characteristics explained. She also needs the current value of each financial asset so that she can report to her manager later. E F Veronica's client data: B 1 Cost of Borrowing 2.00% 2 Yield Curve is flat 3 4 (at end of period) 5 Years Asset 1 1 $0 7 2 $0 3 $0 9 4 $100,000 5 Asset 3 6 Asset 2 $1,500 $1,500 $1,500 $101,500 $300 Asset 4 $1,250 $1,600 $1,800 $102,000 Asset 5 $0 $0 $0 $109,000 8 $400 After careful study and analysis, you will be writing her an email with Microsoft Excel spreadsheet screenshots. Your email should contain the following details: The first department you joined was the Relationship Management (RM) Singapore Team. A relationship manager assistant approached you. Her name is Veronica. She just joined the bank recently. She understands Microsoft Excel spreadsheet well but has little knowledge about financial instruments and their characteristics. She realised that you are studying in SUSS and are a subject matter expert in Financial Modelling. She hands an investment portfolio (in Singapore Dollar, SGD) to you and seeks your help to identify the category of each financial asset and have their characteristics explained. She also needs the current value of each financial asset so that she can report to her manager later. E F Veronica's client data: B 1 Cost of Borrowing 2.00% 2 Yield Curve is flat 3 4 (at end of period) 5 Years Asset 1 1 $0 7 2 $0 3 $0 9 4 $100,000 5 Asset 3 6 Asset 2 $1,500 $1,500 $1,500 $101,500 $300 Asset 4 $1,250 $1,600 $1,800 $102,000 Asset 5 $0 $0 $0 $109,000 8 $400 After careful study and analysis, you will be writing her an email with Microsoft Excel spreadsheet screenshots. Your email should contain the following details