Question: consider AAA=4, BBB=37954, CCC=37954 solve the problem in excel only,,,! (Economic Decision Making subject) Part - 1: How long does it take for an investment
Part - 1: How long does it take for an investment to double in value if it earns (a) 5%, (b) 7%, (c) 9%, (d) 11%, (c) 13% annual compound interest? Solve above using method of 1) Interpolation (Using Tables) 2) Mathematically (Using log) 3) Goal Seek (Using Excel) Part -2 : Consider the following cash flow diagram if i=(5+AAA)%. a) Find the uniform equivalence using the appropriate gradient and uniform series from tables. b) Find the uniform equivalence using Excel. c) Find the gradient equivalence using Excel. Part - 3: Patricia has a bank account in which she deposits $250 at the end of every monch. The bank account earns (AAA+5)% per year compounded quarterly. How long will it take ber to have a total of $30,000 in that bank accocust
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
