You received a high-yield savings account that contains, Ask an Expert

Finance

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.

View complete question

Financial Management, Finance

Category:- Financial Management
Reference No.:- M92796209

Have any Question?Write your Review or question?

Related Questions in Financial Management

International business letterabout frac34 of a page to one

International business Letter About ¾ of a page to one full page business letter (formatting as researched culture may dictate) + several paragraphs of rationale One of the great things about entering a field under the s ...

Unit 3 dbthe president of eec recently called a meeting to

Unit 3 DB The President of EEC recently called a meeting to announce that one of the firm's largest suppliers of component parts has approached EEC about a possible purchase of the supplier. The President has requested t ...

Watch the video moral imaginationand answer the following

Watch the video: "Moral Imagination" And Answer the following questions: 1. Can you think of a time when you or someone whom you know used moral imagination? If so, what motivated you (or this individual) to use moral im ...

Financial management assignment questions -1 if you assume

Financial Management Assignment Questions - 1. If you assume market interest rates are expected to increase over the term of the loan, would you prefer a loan with a fixed interest rate for the life of the loan or rather ...

Please respond to the followingnbsp under 300 wordsa

Please respond to the following: UNDER 300 Words a) Justify why a small investor would benefit from investing in a mutual fund, as compared to the many other investments that exist. Provide support for your justificatio ...

Part 1 conduct internet research sources must be documented

Part 1. Conduct Internet research, (sources must be documented using MLA format), and write a brief analysis of the current status of the U.S. economy. Include current values and trends for at least three of the followin ...

Test1 if a persons required return decreases for an

TEST 1) If a person's required return decreases for an increase in risk, that person is said to be risk-seeking. risk-indifferent. risk-adverse. risk-aware. 2) Last year Mike bought 100 shares of Dallas Corp. common stoc ...

Rsearch paper issue identificationidentify your issue

Research Paper : Issue Identification Identify your issue: Clearly define the issue(s) and or crisis the company is facing. Identify the "triggering event:" This is a recent occurrence (or series of occurrences) that bro ...

Assignmentcomplete the following questions in addition to

Assignment Complete the following questions. In addition to answering the items below, you must submit an analysis of the assignment. Analyze the specific outcomes and write an analysis directed toward the management tea ...

Managerial financenbspplease submit a word document

Managerial Finance: Please submit a Word document including your answers to the 4 questions at the end of the instructions. Johnson Company The Johnson company and wants to increase its sales and would like to seek ad ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Financial Management Expert