Question
Complete work is in Excel sheet, you have just got your first salary cheque and you have taken the decision of savings. Your annual income
Complete work is in Excel sheet, you have just got your first salary cheque and you have taken the decision of savings. Your annual income is $96000. Your income will be increased by 1.5 %annually and 1 % monthly. Earlier also you have decent bank balance. You decided to save 30% of your income. Bank interest rate is 2.5% per annum. But after ten years you decided to invest in your companies shares, bonds and stocks of rising nature, to get return rate of at least 8.5%. you have other business future plans also and other fixed investments like medical care. House , child education traveling , higher professional courses. All these give you a lot to think but you just wants to focus on savings and investments
1. Sketch the influence diagram of your model.
2. Design the whole strategy concept tabular module.
3. Again discuss the complete scenerio if the rate is decreased by 0.85 % and the investment rate is only 1.7%.
4. Construct the spread sheet model of your savings, investment ,donations and expenses without factoring the small expenses.
5. Work out these changes mbinations of savings, interest and returns rates, one for each goal, that you can actually apply.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Here is the analysis of the savings and investment scenario provided 1 Influence diagram Income incr...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