Please find answer of question 1 in attached image.

As per HOMEWORKLIB POLICY, you can ask only 1 question in one post.
Please post 2nd question in other post.
Thanks
Need Help for both. Q1-What is the present equivalent of the following cash flow? Assume interest...
A- What is the present equivalent of the following cash flow? Assume interest rate is 8%. B- Imagine you have some rich cousin who looks down at you. She thinks you are incapable of managing your own affairs and talks you into supplementing some form of future retirement income through some individual retirement plan. You are supposed to retire in 15 years. You have to make 15 annual deposits into your account until you retire. The first deposit is $10K,...
Imagine you have some rich cousin who looks down at you. She thinks you are incapable of managing your own affairs and talks you into supplementing some form of future retirement income through some individual retirement plan. You are supposed to retire in 15 years. You have to make 15 annual deposits into your account until you retire. The first deposit is $10K, and each subsequent deposit will increase at a 4% rate. Then, good times come and you can...
What is the present equivalent of the following cash flow? Assume interest rate is 8%. l Do 6o 8o go bo L40 20 20
Please show how to solve in Excel. I only need the discounted
cash flow from queston 8. All others are completed.
65 Input Current age Retirement age Number of years until retirement Annual withdrawal (S) Number of years to withdraw Interest rate (%) 150,000 7.00% Calculation & Output Question 7 Present value of withdrawals at age 65 Annual deposit until retirement $1,366,187 $6,843 Question 8 Present value of lump sum $91,234 Discounted Cash Flow I only need the answer to...
You have just turned 40 and you plan to save for retirement. You plan to retire in 20 years. Once you retire you would like to have an income of $80,000 per year for the next 10 years. Determine the amount you must deposit at the beginning of each year to finance your retirement income. Use the following assumptions to determine this annual deposit: All savings compound at a rate of 12% per year. You make the first deposit today...
Today is your 25th birthday (Happy Bday!). You plan on retiring 35 years from today. Every month you work, starting today (t=0), you wish to put an equal amount of money into a savings account with your last deposit on the day you retire. After you retire, you will need to withdraw $10,000 a month with your last withdrawal on your 80th birthday (first withdrawal is one month after you retire). Also when you turn 80, you plan on giving...
You would like to start saving for retirement and you have 40 years until the planned retirement date. Each year, during your retirement years (assume 30 years), you would like to spend an amount equivalent to the purchasing power of $50,000 today. You estimate that the expected rate of return on some recommended investment portfolio is 8%AER and you plan to select that portfolio during the working (savings) years. Assume 4%AER yield on your investments during retirement years. The annual...
PLEASE SHOW HOW YOU WOULD SOLVE USING EXCEL SOFTWARE
You realize the wisdom of starting early at age 22 in saving for your retirement and plan on making 43 equal end of the year annual deposits in an IRA account in hopes of having at least 1,000,000 once you retire at age 65 (immediately after your last deposit into the IRA account) but you think it would be best to have $1,750,000 at age 65 to retire. Answer the following...
Q5: Find the present values of the following cash flow streams. The appropriate interest rate is 6%. Year Cash Stream A 1 $100 2 400 3 400 4 400 5 300 Q6: You need to accumulate $10,000. To do so, you plan to make deposits of $1,950 per year - with the first payment being made a year from today - into a bank account that pays 8.05% annual interest. Your last deposit will be less than $1,950 if less...
My current age to be used in the problem:
20 years old.
My next birthday: October 15th, 2020
Last digit in student code: 4.
,,I=_ Possible Points: 8 possible points (added to Exam 1 score) Helpful Hint: Begin by making a number line to help structure the problem. Count the dates you will deposit/withdraw from the account. This will help ensure you have the number of payments correct. Requirements: 1. (4 points) Using your present age, calculate the annual deposit...