1) Mr. Robbins what’s to retire in 30 years with a total amount of $1,000,000. If he invests $75,370 today, determine the annual percentage the investment will have to earn. Assume interest is compound annually.
_________%
2) On January 1, 2015, Roxy Company sold $7,500,000 of 5% bonds, due January 1, 2025. Interest on these bonds is paid on January 1 each year (the first interest payment will be made on January 1, 2016 and the last payment will be made on JANUARY 1, 2025). THE EFFECTIVE INTEREST RATE AT THE DATE OF THE SALE WAS 6%.
REQUIRED: What total amount was received by Roxy Company on January 1, 2015? (8 points)
$____________
Part iii (continues)
4) the Annies company owes a $250,000 debt as of November 1, 2013. Arrangements are made to pay the debt in five equal annual installments the first payment will be made on November 1, 2013.
What id the amount of each installment if the prevailing annual interest rate is 5% (4 points)
$ _________
5) . Stuart Allen realized at age 62 that he had not yet started to plan for his retirement. He plans to retire at age 72. He wants to accumulate a fund that will allow him to remove $90,000 a year, for 18 years, with the first payment starting at age 72, and the last payment at age 89. To prepare for this, Stuart plans to make annual contribution into a retirement fund that has an annual rate of return of 9% during the years of his retirement)
REQUIRED: Determine the amount of each annual contribution into the retirement fund, if the first contribution occurs on his 62nd birthday and the last contribution occurs on his 71st birthday (6 Points)
Amount of each annual contribution: $______________
1)
MATURITY AMOUNT | $ 1,000,000 |
PRINCIPAL AMOUNT | $ 75,370 |
MATURITY AMOUNT = PRINCIPAL (1+ MARKET INTEREST RATE/100)^30 | |
1000000 = 75370 (1+ R/100)^30 | |
1000000/75370 = (1+r/100)^30 | |
132.8021248 | (1 + r/100)^30 |
1.176991972 | = (1+r/100) |
0.176991972 | = r/100 |
R | 18% |
2) | |||
INTEREST AMOUNT RECEIVED AT YEAR END = 7,500,000 * 5% = | $ 375,000 | ||
YEAR | AMOUNT RECEIVED | INTEREST RATE 6%,PV FACTOR | DISCOUNTED AMOUNT |
1 | $ 375,000 | 0.9434 | $ 353,773.58 |
2 | $ 375,000 | 0.8900 | $ 333,748.67 |
3 | $ 375,000 | 0.8396 | $ 314,857.23 |
4 | $ 375,000 | 0.7921 | $ 297,035.12 |
5 | $ 375,000 | 0.7473 | $ 280,221.81 |
6 | $ 375,000 | 0.7050 | $ 264,360.20 |
7 | $ 375,000 | 0.6651 | $ 249,396.42 |
8 | $ 375,000 | 0.6274 | $ 235,279.64 |
9 | $ 375,000 | 0.5919 | $ 221,961.92 |
10 | $ 7,875,000 | 0.5584 | $ 4,397,358.87 |
amount received | $ 6,947,993.47 |
show formula in excel
2) | |||
INTEREST AMOUNT RECEIVED AT YEAR END = 7,500,000 * 5% = | =7500000* 5% | ||
YEAR | AMOUNT RECEIVED | INTEREST RATE 6%,PV FACTOR | DISCOUNTED AMOUNT |
1 | 375000 | =1/(1.06)^A16 | =B16*C16 |
2 | 375000 | =1/(1.06)^A17 | =B17*C17 |
3 | 375000 | =1/(1.06)^A18 | =B18*C18 |
4 | 375000 | =1/(1.06)^A19 | =B19*C19 |
5 | 375000 | =1/(1.06)^A20 | =B20*C20 |
6 | 375000 | =1/(1.06)^A21 | =B21*C21 |
7 | 375000 | =1/(1.06)^A22 | =B22*C22 |
8 | 375000 | =1/(1.06)^A23 | =B23*C23 |
9 | 375000 | =1/(1.06)^A24 | =B24*C24 |
10 | =375000+7500000 | =1/(1.06)^A25 | =B25*C25 |
amount received | =SUM(D16:D25) |
4)
Year | Payment | Principal Paid | Interest Paid | Remaining Balance |
2013 | $57,743.70 | $45,243.70 | $12,500.00 | $204,756.30 |
2014 | $57,743.70 | $47,505.88 | $10,237.82 | $157,250.42 |
2015 | $57,743.70 | $49,881.18 | $7,862.52 | $107,369.24 |
2016 | $57,743.70 | $52,375.24 | $5,368.46 | $54,994.00 |
2017 | $57,743.70 | $54,994.00 | $2,749.70 | $0.00 |
total | $288,718.50 | $250,000.00 | $38,718.50 |
EMI = [P x R x (1+R)^N]/[(1+R)^N-1],
1) Mr. Robbins what’s to retire in 30 years with a total amount of $1,000,000. If...
can
someone give me the formula to calculate the FV(65)? thanks
1. Francis makes deposits into a retirement fund earning an annual effective rate of 7%. The first deposit of $1,000 is made on his 38th birthday and the last deposit is made on his 64th birthday. Every year his deposit increases by 3%. When he attains age 65, he will withdraw all the money in the retirement fund to purchase an annuity-immediate which provides him with monthly payment for...
John starts his career at 21 years old and expects to retire 44 years later at the age of 65. His first annual salary is $72,000 that will increase at 1.5% per year until he finishes his part-time MBA at 28 years old. With his MBA, John expects salary to increase at 3% per year until retirement. At the end of each year, he deposits 10% of his annual salary into a retirement saving plan that pays 6% interest per...
Assume that your father is now 50 years old, plans to retire in 10 years, and expects to live for 25 years after he retires - that is, until age 85. He wants his first retirement payment to have the same purchasing power at the time he retires as $50,000 has today. He wants all of his subsequent retirement payments to be equal to his first retirement payment. (Do not let the retirement payments grow with inflation: Your father realizes...
MAN2 3000A%20May june%202017 %20MCQ9620Removedpdf Question 11 (answer all parts Nick has just turned 25 and considers joining the pension plan offered by his employer. If he joins the pension plan, Nick will need to pay annual contributions during his employment. The first contribution should be paid on his 26th birthday (i.e., in a year's time). Nick plans to retire on his 65 birthday (ie., in 40 years' time). when he would have to pay his last contribution to the pension...
Your best friend Frank just celebrated his 30th birthday and wants to start saving for his anticipated retirement. Frank plans to retire in 35 years and believes that he will have 20 good years of retirement and believes that if he can withdraw $90,000 at the end of each year, he can enjoy his retirement. Assume that a reasonable rate of interest for Frank for all scenarios presented below is 8% per year. This is an annual rate, review each...
Problem #2 (20 pts) 9=21 A man is planning to retire in 30 years. Money can be deposited at 12% Interest compounded monthly and it is also estimated that the future general inflation rate will be 2 per year. He wants to make annual withdrawals of $90,000 in terms of today's dollars over the 20 years of retirement. Assuming that his first withdrawal occurs at the beginning of the first year of retirement a How much money, in terms of...
Assume that your father is now 50 years old, plans to retire in 10 years, and expects to live for 25 years after he retires - that is, until age 85. He wants his first retirement payment to have the same purchasing power at the time he retires as $40,000 has today. He wants all of his subsequent retirement payments to be equal to his first retirement payment. (Do not let the retirement payments grow with inflation: Your father realizes...
5. Carrie Mathison plans to retire in 30 years. She intends to contribute the same amount of money each year to her retirement fund. The fund earns 10% compounded annually. She would like to withdraw $100,000 each year for 20 years, starting one year after the last contribution is made. How much money should she contribute to her fund each year? 10:20 PM
Assume that your father is now 50 years old, plans to retire in 10 years, and expects to live for 25 years after he retires - that is, until age 85. He wants his first retirement payment to have the same purchasing power at the time he retires as $45,000 has today. He wants all his subsequent retirement payments to be equal to his first retirement payment. (Do not let the retirement payments grow with inflation: Your father realizes that...
Assume that your father is now 50 years old, plans to retire in 10 years, and expects to live for 25 years after he retires - that is, until age 85. He wants his first retirement payment to have the same purchasing power at the time he retires as $50,000 has today. He wants all his subsequent retirement payments to be equal to his first retirement payment. (Do not let the retirement payments grow with inflation: Your father realizes that...