Interest revenue and revenue earned from principal deduction

Assignment Help Financial Management

Reference no: EM131958552

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.

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.

Reference no: EM131958552

Questions Cloud

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

What is the tcp well-known-port number : What is the TCP well-known-port number used by the SSH to make secure connections to remote hosts?

How much must you deposit in account today : How much must you deposit in an account today (lump sum), so that you may have enough funds for retirement?

How does your hypothetical program address the clinical area : How does your hypothetical program address the clinical area of concern for the population it seeks to serve? Provide an explanation of the treatment.

Interest revenue and revenue earned from principal deduction : Decompose your annual withdrawals into interest revenue and revenue earned from principal deduction.

Investment decisions-define short run versus long run : Investment decisions: look ahead and reason back. define compounding and discounting? define short run versus long run?

How you might increase the cultural appropriateness : Keeping your specialization area in mind, provide examples of how you might increase the cultural appropriateness of a counseling theory, technique.

Security and privacy issues that could impact : Identify and discuss five or more security and privacy issues that could impact a company's ability to benefit from its intellectual property

Present a series of arguments to prove your position : You will present a series of arguments to prove your position and support those arguments with evidence consisting of facts and statistics and expert opinions.

User Account

All Pages