Question

3. [20PTS] Mr. Lee deposited a large amount of money in his first bank account. Annual...

3. [20PTS] Mr. Lee deposited a large amount of money in his first bank account. Annual withdrawals of 30,000 pesos starting EOY 1 were made for 7 years to pay for personal expenses. He stopped withdrawing after the 7th year when he was assigned to work abroad. After 3 years of working abroad without withdrawing or depositing from his bank account, he went back to the Philippines. He started withdrawing money again on the 10th year with an amount of 5,000 pesos, 7,000 pesos on the 11th year, 9,000 pesos on the 12th year, and the same trend goes up to the 15th year. After which, the following withdrawals were made: 16th year 2,500 pesos 17th year 3,000 pesos 18th year 3,500 pesos 19th year 4,000 pesos 20th year 4,500 pesos. The bank uses a nominal interest rate of 5% compounded annually.(a) What should be the minimum initial investment to accommodate all the transactions he made?(b) If 500,000 pesos is the initial investment, how much money is left after 25 years?

Homework Answers

Answer #1
Time Amount Discount factor Present value = Amount* discount factor
1 30000 1/(1+5%)^1 = 0.9524 30000*0.9524 = 28572
2 30000 1/(1+5%)^2 = 0.9070 30000*0.9070 = 27210
3 30000 0.8638 25915.13
4 30000 0.8227 24681.07
5 30000 0.7835 23505.78
6 30000 0.7462 22386.46
7 30000 0.7107 21320.44
10 5000 0.6139 3069.57
11 7000 0.5847 4092.76
12 9000 0.5568 5011.54
13 9000 0.5303 4772.89
14 9000 0.5051 4545.61
15 9000 0.4810 4329.15
16 2500 0.4581 1145.28
17 3000 0.4363 1308.89
18 3500 0.4155 1454.32
19 4000 0.3957 1582.94
20 4500 0.3769 1696.00
Sum of all present values 206599.83

(a) Minimum initial investment = 206,599.83

(b) If initial investment = 500,000

Present value (t = 0) of money left = 500,000 - 206,599.83 = 293400.17

Future value (ie value at t = 25) = 293400.17 * (1 + 5%)^25 = 993,557.1 (money left after 25 years)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Daryl wishes to save money to provide for his retirement. Beginning one year from now, Daryl...
Daryl wishes to save money to provide for his retirement. Beginning one year from now, Daryl will begin depositing the same fixed amount each year for the next 30 years into a retirement savings account. Starting one year after making his final deposit, he will withdraw $100,000 annually for each of the following 25 years (i.e. he will make 25 withdrawals in all). Assume that the retirement fund earns 12% annually over both the period that he is depositing money...
An Engineer deposited $12,000 in a bank saving account that pays 3% per quarter. a) How...
An Engineer deposited $12,000 in a bank saving account that pays 3% per quarter. a) How much money the engineer will find in his account after 4 years? b) What will be the effective interest rate per six months? c) What will be the effective interest rate per year?
Suppose $1,000 is deposited in a bank account today (time 0), followed by $1,000 deposits in...
Suppose $1,000 is deposited in a bank account today (time 0), followed by $1,000 deposits in years 2, 4, 6, and 8. At 6% annual interest, how much will the future equivalent be at the end of year 12? Suppose that annual income from a rental property is expected to start at $1,300 per year and decrease at a uniform amount of $50 each year after the first year for the 15-year expected life of the property. The investment cost...
Mr. Gonzales has made beginning-of-year deposits into an investment account for the past 21 years. Each...
Mr. Gonzales has made beginning-of-year deposits into an investment account for the past 21 years. Each deposit was $5500, and the account earned interest at a rate of 4.5% APR, compounded quarterly, each year. Having made his last deposit one year ago, he now plans to transfer all of the accumulated funds today into a money-market account that earns an APR of 1.50% compounded quarterly. If he plans to withdraw $4000 from the account at the end of each quarter...
1. For the next 6 years, you pan to make equal quarterly deposits of $600.00 into...
1. For the next 6 years, you pan to make equal quarterly deposits of $600.00 into an account paying 8% compounded quarterly. How much will be the total you have at the end of the time? 2. How much money will you have to deposit now if you wish to have $5,000 at the end of 8 years. Interest is to be at the rate of 6% compounded semiannually? 3. In the California “Million Dollar Lottery” a winner is paid...
Geoffrey is the owner of a small grocery store, and is considering buying a car to...
Geoffrey is the owner of a small grocery store, and is considering buying a car to help him transport his wares. He has found a suitable used car online that he was able to negotiate to a price of $40,000. After doing a bit more research, he has found the following additional expenses involved in the purchase: Insurance and registration will cost $510 per year, payable at the start of each year Based on mileage estimates, petrol will cost $220...
What role could the governance of ethics have played if it had been in existence in...
What role could the governance of ethics have played if it had been in existence in the organization? Assess the leadership of Enron from an ethical perspective. THE FALL OF ENRON: A STAKEHOLDER FAILURE Once upon a time, there was a gleaming headquarters office tower in Houston, with a giant tilted "£"' in front, slowly revolving in the Texas sun. The Enron Corporation, which once ranked among the top Fortune 500 companies, collapsed in 2001 under a mountain of debt...
Discuss ethical issues that can be identified in this case and the mode of managing ethics...
Discuss ethical issues that can be identified in this case and the mode of managing ethics Enron finds itself in this case. How would you describe the ethical culture and levels of trust at Enron? Provide reasons for your assessment. THE FALL OF ENRON: A STAKEHOLDER FAILURE Once upon a time, there was a gleaming headquarters office tower in Houston, with a giant tilted "£"' in front, slowly revolving in the Texas sun. The Enron Corporation, which once ranked among...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT