Answered step by step
Verified Expert Solution
Question
1 Approved Answer
accumulate RO 10,000 for this brother in std 7 and to accumulate RO 12,000 for this brother in std 5 . He has come up
accumulate RO 10,000 for this brother in std 7 and to accumulate RO 12,000 for this brother in std 5 .
He has come up with two proposals.
Proposal A- Invest in Shares of company
The investment in share will be earning a return of 8%. The amount of investment will be at the end of
2 Abdullah AL Hashmi has two brothers studying in the school in standard 5
send to UK for getting Masters. As there is increasing inflation in the economy every year Mr Abdullah is planning to make some smart investment of funds so that after 10 years from now he should be able to
every year. The investment will be sold at the end of 10th year.
and 7
.He is planning to
th
4
Proposal B Invest in Bonds issued by some company
This investment will be made at the end of each year in the Bonds issued by company in Oman. The
investment in Bonds will be fetching a return of 6%. The investment will be sold at the end of 10th year.
You are required to calculate for the above two proposal
a) The investment to be made in each year for Proposal A and
b) The investment to be made in each year for Proposal B
* using MS Excel.
Q1. Abdullah AL Hashmi has two brothers studying in the school in standard 5th and 7th .He is planning to send to UK for getting Masters. As there is increasing inflation in the economy every year Mr Abdullah is planning to make some smart investment of funds so that after 10 years from now he should be able to accumulate RO 10,000 for this brother in std 7th and to accumulate RO 12,000 for this brother in std 5th. He has come up with two proposals.
Proposal A- Invest in Shares of company The investment in share will be earning a return of 8%. The amount of investment will be at the end of every year. The investment will be sold at the end of 10th year.
Proposal B Invest in Bonds issued by some company This investment will be made at the end of each year in the Bonds issued by company in Oman. The investment in Bonds will be fetching a return of 6%. The investment will be sold at the end of 10th year.
*You are required to calculate for the above two proposal
a) The investment to be made in each year for Proposal A ?
b) The investment to be made in each year for Proposal B ?
* using MS Excel.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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