Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PROBLEM # 1 : You are a local small investor in Houston, TX . You opened a bank account today with a deposit of $
PROBLEM # : You are a local small investor in Houston, TX You opened a bank account today with a deposit of $ Your plan is to make additional deposit of $ every two months starting from the first month till the fifth month. At the seventh month you want to make a withdrawal of $ every two months till the month. At the end of the year the month you will make a withdrawal of $ Assuming that the bank gives you an interest rate of per month what is a the present worth of your investment in your transactions with the bank b what interest rate should the bank give you so that at the end of the year you have $ in your bank account? Draw the cash flow diagram. HINT: The withdrawals and deposits are made bimonthly, so it is better to convert the given interest rate per month compounded monthly to an effective interest rate per bimonthly compounded bimonthly. To find the interest rate that will give you $ in your bank account at the end of the year, do trial and error of different interest rates and use a linear interpolation method to get the interest rate that will give you a future value of $ at the end of the year. Or use the MS Excel function GOALSEEK to set up your Future Worth of your transactions to set a goal to seek for an interest rate that will make your future worth of your transactions at the end of the year to $
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