Question
can someone please answer this its for excel Ouestion 4 (IS marks) An investment company offers a bond linked to the FT 100 index. On
can someone please answer this its for excel
Ouestion 4 (IS marks) An investment company offers a bond linked to the FT 100 index. On redemption the bond pays the face value plus the largest Of A: the race value times the change in the index. Or B: yearly interest compounded monthly. Thus, for example, 100 invested when the index was 1 10 and redeemed a year later when the index was 125 will pay A: and not B: Implement a VBA function: Bond (Deposit, Years, FVIO, FVI). Ouestion S (15 marks) Write a new function Profit(Income-Expenses) based on the following chart. function should be used inside Profit function. The MsgBox Profit = Income Expenses Profit O ? The profit is greater or equal to O The profit is less than O
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started