Question

In: Finance

You have saved $26,704.00 for a three-year vacation to Germany. You will keep your money invested...

You have saved $26,704.00 for a three-year vacation to Germany. You will keep your money invested in an account paying 7.32% APR with monthly compounding while you live in Munich. You will make your withdrawals at the beginning of the month.

How much can you withdraw each month?

What is the balance on the account after the first month? (This is the balance prior to the withdrawal for the second month)

Solutions

Expert Solution

Amount to be invest at the BEGINNING of each year = PV of Annuity = P*[1-{(1+i)^-n}]/i

Note: For the purpose of calculation (so that formula can be applied), it will be considered that amount will be received for 4 years at the end of each year starting from 1 year from now, and we will also add an additional annuity that will be received today. Effectively, we have a total of PV of next 4 installments and today’s installment.

Therefore, Present Value = PV of 35 Withdrawals + Today’s Withdrawal

Where, PV = $26704, i = Interest Rate = 0.073/12 = 0.006083, n = Number of Periods = (3*12)-1 = 35

Therefore,

26704 = P*[1-{(1+0.006083)^-35}]/0.006083 – P

26704 = P*31.43918 – P

26704 = 30.43918P

Therefore, Amount to be wtithdrawn each month = P = 26704/30.43918 = $877.29

Balance after 1st month = (Initial Balance-1st Withdrawal)*(1+Monthly Interest Rate) = (26704-877.29)*(1+0.006083) = 25826.71*1.006083 = $25983.82


Related Solutions

5. You intend to buy a vacation home in eight years and plan to have saved...
5. You intend to buy a vacation home in eight years and plan to have saved $75,000 for a down payment. How much money would you have to place today into an invest that earns 9% per year to have enough for your desired down payment? A) $37,640 B) $37,218 C) $35,335 D) $34,989
Why are the owners of the firm content to keep their money invested in the firm...
Why are the owners of the firm content to keep their money invested in the firm when profit π = 0?
You and your wife have finally saved up enough money to buy your dream home.  You purchase...
You and your wife have finally saved up enough money to buy your dream home.  You purchase a $210,000 home in a nice neighborhood, paying 5% down as a down payment and obtaining the rest of the proceeds to buy your home from the local bank.  Assume that the loan requires you to make monthly payments, with the annual interest rate stated as 5.75% and the term of the loan being 30 years. (12 points) A.        What is your monthly payment? $1166.32             B.        Set...
You have one million dollars in your investment account and choose to keep your money allocated...
You have one million dollars in your investment account and choose to keep your money allocated in the following proportion and rebalance each quarter: i. 60% in stocks via ETF SPY; ii. 40% in bonds via ETF AGG. Over the past quarter, AGG went up by 3% and SPY went up by 1%. a. What is your account balance before rebalancing? b. How do you rebalance your account? What to buy and what to sell? How many dollars to buy...
Assume that you have half your money invested in Times Mirror, the media company, and the...
Assume that you have half your money invested in Times Mirror, the media company, and the other half invested in Unilever, the consumer product giant. The expected returns and standard deviations on the two investments are summarized below: ----------------------Times Mirror------ Unilever Expected Return 14%------------- 18% Standard Deviation 25% ------------40% Estimate the variance of the portfolio as a function of the correlation coefficient (Start with –1 and increase the correlation to +1 in 0.2 increments).
You have decided to buy a house for $600,000. You have saved enough money to make...
You have decided to buy a house for $600,000. You have saved enough money to make a 20% down payment, but you will need to borrow the remainder. You arrange for a 30-year mortgage (monthly payments) with a local bank at a stated rate of 3.6% APR. a) What will be your monthly payment? b) Construct the amortization table for the first 12 months of payments (showing how much of your payment goes to principal, how much goes to interest,...
Problem 4. You would like to have enough money saved to receive $200,000 per year after...
Problem 4. You would like to have enough money saved to receive $200,000 per year after retirement so that you and your family can lead a good life for 30 years (from age 65 to 95). You will make your first withdraw of $200,000 at the end of year when you are 65. If you will be 35 years old when you graduate and plan on making savings contributions at the end of your first year out of school, how...
You have already saved $6850 to buy a used car. You invest this money in a...
You have already saved $6850 to buy a used car. You invest this money in a certificate of deposit earning 0.30% APR compounded monthly. How many years will it take your account to reach your target of $7275 in order to buy the new car?
Topic: Sunk Costs a. If you have invested money into a project, but the remainder of...
Topic: Sunk Costs a. If you have invested money into a project, but the remainder of the project has a negative npv, what should you do? should you continue the project? discuss your course of action relating to the topic stated above. b. You have been given a project proposal. The project is expected to finish in five years (year 5) and has a cost of capital of 10%. If the initial costs of equipment is $400,000, the additional anticipated...
When you reach retirement​ age, you would like to have enough money saved to be able...
When you reach retirement​ age, you would like to have enough money saved to be able to​ “pay yourself” an annual salary of ​$70​,000 per year for 20 years. To put this another​ way, your plan is to start your retirement with a large amount of money​ saved, and you will withdraw ​$70​,000 from these savings once a year for the next 20 years until all of your savings are depleted. In the​ meantime, you are a​ 25-year-old new UIC​...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT