Robert has determined he will need $80,000 at the beginning of each year after he retires....

Robert has determined he will need $80,000 at the beginning of each year after he retires. He expects to earn 5.0% on his funds after retirement, In addition, he wishes to leave $100,000 to the local Humane Society upon his death which will occur 25 years after he retires.

Robert will wok for 45 years before he retires. During his working years, robert will earn 10% on his investments.

1. Calculate the total funds Robert must have on the day he retires in order to meet his financial goals.

2. Calculate the monthly investment that Robert must make to meet his goals.

3. Imagine that Robert has $5,000 that he can invest today to start off his retirement fund. How much must he now save every month?

Round answers to nearest dollar and do NOT enter dollar signs.

Expert Solution

PV of annuity for making pthly payment-Annuity Due

P = PMT+PMT x (((1-(1 + r) ^- (n-1))) / r)
Where:
P = the present value of an annuity stream	To be computed
PMT = the dollar amount of each annuity payment	80000
r = the effective interest rate (also known as the discount rate)	5%
n = the number of periods in which payments will be made	25

PV of retirement withdrawals=	PMT+PMT x (((1-(1 + r) ^- (n-1))) / r)
PV of retirement withdrawals=	80000+80000*(((1-(1 + 5%) ^- (25-1))) / 5%)
PV of retirement withdrawals=	1,183,891

PV of fund left for society=	100000/(1+5%)^25
PV of fund left for society=	29,530

So total funds needed at the time of retirment=	1183891+29530
So total funds needed at the time of retirment=	1,213,422


This fund will be accumulated by monthly contributions

FV of annuity

P = PMT x ((((1 + r) ^ n) - 1) / i)

Where:
P = the future value of an annuity stream	1,213,422
PMT = the dollar amount of each annuity payment	P
r = the effective interest rate (also known as the discount rate)	10.47%	((1+10%/12)^12)-1)
i=nominal Interest rate	10.00%
n = the number of periods in which payments will be made	45

FV of annuity=	PMT x ((((1 + r) ^ n) - 1) / i)
1,213,421.62	=PMT * ((((1 + 10.47%) ^ 45) - 1) / 10%)
Annual payment=	=1213421.62/((((1 + 10.47%) ^ 45) - 1) / 10%)
Annual payment=	1,389
Monthly deposit=	116

If initially 5000 are invested then FV of this amount at retirement=	5000*(1+10%)^45
If initially 5000 are invested then FV of this amount at retirement=	364,452

Remaining funds to be accumulated through monthly deposit=	1213421.62-364452.42
Remaining funds to be accumulated through monthly deposit=	848,969

FV of annuity=	PMT x ((((1 + r) ^ n) - 1) / i)
848,969.20	=PMT * ((((1 + 10.47%) ^ 45) - 1) / 10%)
Annual payment=	=848969.20/((((1 + 10.47%) ^ 45) - 1) / 10%)
Annual payment=	972
Monthly deposit=	81

ekkarill92 answered 2 years ago

Company has determined that they can increase their profitability by $80,000 per year if they outsource...

Company has determined that they can increase their profitability by $80,000 per year if they outsource the production of some parts used to build their most popular product. A significant amount of the cost savings will come from reduced labor force. This includes some long-term employees that served as quality-control inspectors. The parts being outsourced are difficult to manufacture and critical to the performance of the machine where they get installed. The inspectors were highly paid and very proficient at...

Don Draper has signed a contract that will pay him $80,000 at the beginning of each...

Don Draper has signed a contract that will pay him $80,000 at the beginning of each year for the next 7 years, plus an additional $120,000 at the end of year 7. If 7 percent is the appropriate discount rate, what is the present value of this contract? What is the present value of $80,000 at the beginning of each year for the next 7 years if the discount rate is 7 percent?

Robert is a healthy 23-year-old male who has a fractured femur in a full cast. He...

Robert is a healthy 23-year-old male who has a fractured femur in a full cast. He has been ordered crutches for ambulation but is complaining of tingling in his arms when he uses them. What is the possible cause for this? a. The crutches are too short. b. The crutches are too long. c. Robert has a possible blood clot in his arms. d. Robert has poor upper body strength. The nurse is getting a patient up who has a...

After working in a Psychological Hospital, processing the insurance billing for over a year, Robert was...

After working in a Psychological Hospital, processing the insurance billing for over a year, Robert was asked to give some additional help to a medical assistant working in another area of the hospital. While chatting with some of the staff in the office, Robert couldn’t help but notice a change in their behavior when Dr. Salazar came into the office. They seemed to have a level of disrespect and businesslike manner towards the Doctor. Their demeanor countered their previous playful...

Mary makes 10 annual deposits of $1000 each into an account. Beginning one year after the...

Mary makes 10 annual deposits of $1000 each into an account. Beginning one year after the first deposit she receives a check for 6% of the value of this account. She deposits these checks into an account that earns interest at 4%. Find the total value of her accounts one year after she makes the last $1000 deposit.

Wants to be able to withdraw $80,000 per year at the end of each year from...

Wants to be able to withdraw $80,000 per year at the end of each year from his retirement account for 30 years after he retires. Assuming a 7% annual compound interest rate, what is the minimum amount Mr. Smith must-have in this account when he retires? Please indicate what you entered into your calculator to solve these problems.

The demand for widgets has been determined to be 10,000 per year. Each widget sells for...

The demand for widgets has been determined to be 10,000 per year. Each widget sells for $4.00 and costs $2.25 to produce. Using breakeven analysis and an interest rate of 12%, determine the maximum purchase price that could be paid for the required machinery. The machine is expected to last 8 years and to have a salvage value of 5% of the purchase price. Please show the answer in excel if possible

Mary went to the doctor complaining of stomach cramps. After the doctor examined her he determined...

Mary went to the doctor complaining of stomach cramps. After the doctor examined her he determined that she has peritonitis (inflammation of the peritoneum). He asked if she has had a UTI recently and she said yes. Why would a UTI in females lead to peritonitis but not in males? Fully detail the differences and possible pathogen pathway.

A farmer raises corn. Each year that he has a successful crop he grosses $17000 on...

A farmer raises corn. Each year that he has a successful crop he grosses $17000 on expenses of $6000 for seed and labor. Sometimes his crop fails and he grosses only $8000. Each year the farmer has a chance of using two types of fertilizers: Type A at a cost of $2000 guarantees that there is a 60% chance of having a successful crop the next year, and type B at a cost of $3000 guarantees that there is an...

Robert Smith has monthly net income of $1,200. He has a house payment of $550 per...

Robert Smith has monthly net income of $1,200. He has a house payment of $550 per month, a car loan with payments of $250 per month, a Visa card with payments of $40 per month, and a credit card with a local department store with payments of $58 per month. What is Robert’s debt payments-to-income ratio?

Question