Question

In: Finance

Two brothers each open IRAs in 2015 and plan to invest $10,000 per year for the...

Two brothers each open IRAs in 2015 and plan to invest $10,000 per year for the next 25 years time makes his first deposit on January 1, 2015 I will make all future deposits on the first day of the year Michael. makes is the first deposit on December 31, 2015 and will continue to make us any deposits on the last day of each year at the end 25 years the difference in value of the IRA assuming an interest rate of 4% per year it will be?

Solutions

Expert Solution

Investment of Brother who started to Invest as on 01/01/2015
Year Opening Balance Amount Deposit Interest Closing Balance
01/01/2015 $                           -   $           10,000.00 $                 -   $         10,000.00
01/01/2016 $            10,000.00 $           10,000.00 $        400.00 $         20,400.00
01/01/2017 $            20,400.00 $           10,000.00 $        816.00 $         31,216.00
01/01/2018 $            31,216.00 $           10,000.00 $    1,248.64 $         42,464.64
01/01/2019 $            42,464.64 $           10,000.00 $    1,698.59 $         54,163.23
01/01/2020 $            54,163.23 $           10,000.00 $    2,166.53 $         66,329.76
01/01/2021 $            66,329.76 $           10,000.00 $    2,653.19 $         78,982.95
01/01/2022 $            78,982.95 $           10,000.00 $    3,159.32 $         92,142.27
01/01/2023 $            92,142.27 $           10,000.00 $    3,685.69 $       105,827.96
01/01/2024 $          105,827.96 $           10,000.00 $    4,233.12 $       120,061.08
01/01/2025 $          120,061.08 $           10,000.00 $    4,802.44 $       134,863.52
01/01/2026 $          134,863.52 $           10,000.00 $    5,394.54 $       150,258.06
01/01/2027 $          150,258.06 $           10,000.00 $    6,010.32 $       166,268.38
01/01/2028 $          166,268.38 $           10,000.00 $    6,650.74 $       182,919.12
01/01/2029 $          182,919.12 $           10,000.00 $    7,316.76 $       200,235.88
01/01/2030 $          200,235.88 $           10,000.00 $    8,009.44 $       218,245.32
01/01/2031 $          218,245.32 $           10,000.00 $    8,729.81 $       236,975.13
01/01/2032 $          236,975.13 $           10,000.00 $    9,479.01 $       256,454.14
01/01/2033 $          256,454.14 $           10,000.00 $ 10,258.17 $       276,712.31
01/01/2034 $          276,712.31 $           10,000.00 $ 11,068.49 $       297,780.80
01/01/2035 $          297,780.80 $           10,000.00 $ 11,911.23 $       319,692.03
01/01/2036 $          319,692.03 $           10,000.00 $ 12,787.68 $       342,479.71
01/01/2037 $          342,479.71 $           10,000.00 $ 13,699.19 $       366,178.90
01/01/2038 $          366,178.90 $           10,000.00 $ 14,647.16 $       390,826.06
01/01/2039 $          390,826.06 $           10,000.00 $ 15,633.04 $       416,459.10
01/01/2040 $          416,459.10 $           10,000.00 $ 16,658.36 $       443,117.46
Investment of Brother who started to Invest as on 31/12/2015
Year Opening Balance Amount Deposit Interest Closing Balance
01/01/2015 $                           -   $                          -   $                 -   $                         -  
31/12/2015 $                           -   $           10,000.00 $                 -   $         10,000.00
31/12/2016 $            10,000.00 $           10,000.00 $        400.00 $         20,400.00
31/12/2017 $            20,400.00 $           10,000.00 $        816.00 $         31,216.00
31/12/2018 $            31,216.00 $           10,000.00 $    1,248.64 $         42,464.64
31/12/2019 $            42,464.64 $           10,000.00 $    1,698.59 $         54,163.23
31/12/2020 $            54,163.23 $           10,000.00 $    2,166.53 $         66,329.76
31/12/2021 $            66,329.76 $           10,000.00 $    2,653.19 $         78,982.95
31/12/2022 $            78,982.95 $           10,000.00 $    3,159.32 $         92,142.27
31/12/2023 $            92,142.27 $           10,000.00 $    3,685.69 $       105,827.96
31/12/2024 $          105,827.96 $           10,000.00 $    4,233.12 $       120,061.08
31/12/2025 $          120,061.08 $           10,000.00 $    4,802.44 $       134,863.52
31/12/2026 $          134,863.52 $           10,000.00 $    5,394.54 $       150,258.06
31/12/2027 $          150,258.06 $           10,000.00 $    6,010.32 $       166,268.38
31/12/2028 $          166,268.38 $           10,000.00 $    6,650.74 $       182,919.12
31/12/2029 $          182,919.12 $           10,000.00 $    7,316.76 $       200,235.88
31/12/2030 $          200,235.88 $           10,000.00 $    8,009.44 $       218,245.32
31/12/2031 $          218,245.32 $           10,000.00 $    8,729.81 $       236,975.13
31/12/2032 $          236,975.13 $           10,000.00 $    9,479.01 $       256,454.14
31/12/2033 $          256,454.14 $   &nb

Related Solutions

you plan to invest $10,000 on the last day of every year for the next five...
you plan to invest $10,000 on the last day of every year for the next five years, if the interest rate on the investment is 6 percent, the present value of your investment is...
A government has only 10,000 dollars to invest in open space. It can invest now or...
A government has only 10,000 dollars to invest in open space. It can invest now or wait five years and invest in the park after planning is finished. The planning cost was spent 5 years ago and cost 5,000 dollars. a. If the government waits to invest, how much money will it be able to spend in five years if the interest rate is 6%? b. How much will it be able to spend in 5 years, with 10% interest...
Broom Brothers produces and sells one product. The firm currently sells 10,000 units per year for...
Broom Brothers produces and sells one product. The firm currently sells 10,000 units per year for $80 per unit. Total variable costs are $60 per unit and fixed costs are $150,000. a) What is breakeven sales in units? b) What is the margin of safety in units? What’s the margin of safety in dollars? c) What is the degree of operating leverage? d) If sales increase to 15,000 units per year, profits will increase by ____%. e) How many units...
➤If you invest $10,000 at 10% per year on average, when will you (on average) have...
➤If you invest $10,000 at 10% per year on average, when will you (on average) have this grow to $40,000? When will it grow to $160,000?
1) Broom Brothers produces and sells one product. The firm currently sells 10,000 units per year...
1) Broom Brothers produces and sells one product. The firm currently sells 10,000 units per year for $90 per unit. Direct material costs are $5 per unit. Direct labor costs are $10 per unit. Variable manufacturing cost are $15 per unit. Fixed manufacturing costs are $150,000. Variable selling costs are $15. Variable administrative costs are $5 per unit. Fixed selling costs are $50,000 a) What is breakeven sales in units? What is breakeven sales in dollars? b) What is the...
Cassandra invested one part of her $10,000 at 7.5% per year and the other part at 8.5% per year. Her income from the two investment was $820. How much did she invest at each rate?
Cassandra invested one part of her $10,000 at 7.5% per year and the other part at 8.5% per year. Her income from the two investment was $820. How much did she invest at each rate?
You invest $50,000 now and receive $10,000 per year for 15 years starting at the end...
You invest $50,000 now and receive $10,000 per year for 15 years starting at the end of the first year. What is the discounted payback period? Use i = 9% annual rate compounded annually. Give the discounted payback period between two consecutive integers.
1) You invest $50,000 now and receive $10,000 per year for 15 years starting at the...
1) You invest $50,000 now and receive $10,000 per year for 15 years starting at the end of the first year. What is the payback period in whole number years for this investment? In other words, in what year do you break even on this investment? Use i = 9% annual rate compounded annually, and use the discounted payback approach (not Simple Payback).
Please use excel and show formulas You are planning to invest $10,000 per year to save...
Please use excel and show formulas You are planning to invest $10,000 per year to save for retirement. Assume you'll get an annual rate of return of 7%, and that you'll make the yearly investments at the beginning of each period. If you plan on retiring at 65, compare the difference between starting these yearly investments at 30 years old versus starting at 40 years old.
Assume you are looking to invest $10,000 and you have two friends each of which is...
Assume you are looking to invest $10,000 and you have two friends each of which is offering to sell you a 25% stake in his/her business in exchange for your $10,000. list at least 5 questions you would ask each of your two friends for each question explain how the answer would help you make your investment decision for each question explain what concerns you would have regarding the answers received.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT