Question 1 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. D E Veronica's client data: A B 1 Cost of Borrowing 2.00% 2 Yield Curve is flat 3 4 (at end of period) 5 Years Asset 1 6 1 $0 7 2 $0 8 3 $0 $100,000 Asset 3 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 9 4 $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: (a) 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. (10 marks) (b) Solve for the present value for each financial asset using the relevant Microsoft Excel function. Show your use of function with the inputs (e.g., =PV($A$1, $B$1,,C1). You may use the FORMULATE () function in Excel). All answers should be expressed in the relevant currency and round-off to two (2) decimal places. (5 marks) (C) To help Veronica to convince her manager on the accuracy of the computation, verify all the answers in Question 1(b) using the formula approach and show your formula with the inputs. All answers should be expressed in the relevant currency and round-off to two (2) decimal places. (5 marks) Question 1 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. D E Veronica's client data: A B 1 Cost of Borrowing 2.00% 2 Yield Curve is flat 3 4 (at end of period) 5 Years Asset 1 6 1 $0 7 2 $0 8 3 $0 $100,000 Asset 3 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 9 4 $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: (a) 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. (10 marks) (b) Solve for the present value for each financial asset using the relevant Microsoft Excel function. Show your use of function with the inputs (e.g., =PV($A$1, $B$1,,C1). You may use the FORMULATE () function in Excel). All answers should be expressed in the relevant currency and round-off to two (2) decimal places. (5 marks) (C) To help Veronica to convince her manager on the accuracy of the computation, verify all the answers in Question 1(b) using the formula approach and show your formula with the inputs. All answers should be expressed in the relevant currency and round-off to two (2) decimal places
