How much would you be able to withdraw every year

Assignment Help Financial Management

Reference no: EM131956525

You received a high-yield savings account that contains $1,000,000. The account has a 7% annual interest rate and you want to take out a constant amount every year for 40 years.

1. How much would you be able to withdraw every year? Hint: the annual interest rate should be used as the discount rate in the finite time annuity formula.

2. Using Microsoft Excel, decompose your annual withdrawals into interest revenue and revenue earned from principal deduction (for example, at t=1, you get 7% x $1,000,000 in interest, and take the remaining amount from the principal – these together should equal the amount you determined in (1)). Graph interest revenue and principal revenue together, with time on the xaxis. Report the graph based on all 40 years, and only report the interest revenue and principal revenue numbers for the first 10 years.

3. Suppose you want to take out $100,000 per year. For how many years would you be able to make this exact withdrawal?

4. After your last exact withdrawal from (3), you decide to withdraw everything in your account one year later. How much money would you get from your final withdrawal?

Reference no: EM131956525

Questions Cloud

Discuss in the detail the balance sheet : Discuss in the detail the Balance Sheet. What is shown on the Balance Sheet? Why is the Balance Sheet important to a hospitality firm?

What is the most you should pay for annuity : You could earn 5.5% on your money in other investments with equal risk. What is the most you should pay for the annuity?

Issues that could arise from implementing new policy : Identify potential ethical/moral issues that could arise from implementing this new policy - whether the policy is considered an ethical

Evaluate the level of responsibility of the company : Acc 564 accounting information system -Evaluate the level of responsibility of the company in terms of the effectiveness of the response to the security breach

How much would you be able to withdraw every year : How much would you be able to withdraw every year? how many years would you be able to make this exact withdrawal?

Nicholas would have to pay on convertible-callable bond : Which of the following most accurately describes the coupon rate that Nicholas would have to pay on the convertible, callable bond?

Write a program in a programming language : Write a program in a programming language of your choice that simulates customers shopping and waiting in line at a grocery store.

As the value of us current account deficit increases : As the value of US current account deficit increases, what is likely to happen to the value of US dollar? Explain.

What is the required average rate of return per year : What is the required average rate of return per year from this account necessary to achieve your goal?

User Account

All Pages