Question

In: Finance

No Excel Please! I am trying to learn the math for the exam! Thank you!! You...

No Excel Please! I am trying to learn the math for the exam! Thank you!!

You are 35 years old today and are considering your retirement needs. You expect to retire at age 65 (in 30 years) and you plan to live to age 99. You want to buy a house costing $300,000 on your 65th birthday and your living expenses will be $30,000 a year after that (starting at the end of year 65 and continuing through the end of year 99, i.e. for 35 years). Assume an annual interest rate of 8%, annual compounding: i) How much will you need to have saved by your retirement date to be able to afford this course of action? ii) Suppose you already have $50,000 in savings today. If you can invest money at 8% a year, how much would you need to save at the end of each year for the next 30 years to be able to afford this retirement plan?

Solutions

Expert Solution

The formula to calculate present value of an annuity is given below:

The present value of annualliving expenses after age 65 is calculated below:

Individual also want to buy a house at age 65 of $300,000.

so, total amount required at age 65 to meet the given course of action is $300,000 + $349,637.0465 = $649,637.0465.

The accumulated amount of current saving 50,000 and annual savings till age 65 must be equal to $649,637.0465.

The formula for accumulation is given below:

The annual amount is calculated below:

Individual must save $1,293.256 at the end of each year.


Related Solutions

No excel please! I am trying to learn the math for Exam! Thank yoU! You have...
No excel please! I am trying to learn the math for Exam! Thank yoU! You have just joined the investment banking firm of Mckenzie & Co. They have offered you two different salary arrangements. You can have $75,000 per year for the next two years, or you can have $55,000 per year for the next two years, along with a $30,000 signing bonus today. If the interest rate is 12% compounded monthly, which is a better offer? NB: first convert...
No execel please! I am trying to learn the math for the exam! Thank you!! Shanna...
No execel please! I am trying to learn the math for the exam! Thank you!! Shanna wants to buy a house costing $325,000 and has obtained a loan from TD Bank. A minimum down payment of 15% would be required and the bank will provide the difference. Her grandparent have told her that they will cover her down payment. a. TD Bank has quoted her mortgage interest rate is 4.5%; this rate would be compounded semiannually, while her payments would...
Please show how you got the answer. I am trying to learn! Drilling Experts, Inc. Drilling...
Please show how you got the answer. I am trying to learn! Drilling Experts, Inc. Drilling Experts, Inc. (DEI) finds and develops oil properties and then sells the successful ones to major oil refining companies. DEI is now considering a new potential field, and its geologists have developed the following data, in thousands of dollars. t = 0. A $400 feasibility study would be conducted at t = 0. The results of this study would determine if the company should...
(trig based physics) Please explain what is happening, I am trying to LEARN how to do...
(trig based physics) Please explain what is happening, I am trying to LEARN how to do these problems as well! Ignore air resistance and gravity in all questions. 1. When Hydrogen is heated on earth, it emits 4 colours of visible light of wavelengths 410 nm, 434 nm, 486 nm and 656 nm. When Hydrogen on a distant galaxy is observed, the 410 nm light appears to have a wavelength of 409 nm. a) Is the galaxy moving towards earth...
Exam prep question I am struggling with. Could anyone give me a solution with steps? Thank...
Exam prep question I am struggling with. Could anyone give me a solution with steps? Thank you! You are an executive at WX Resorts and you have executive stock options as part of your compensation. You hold 1,000 options that expire six months from today at a strike price of 50 but that can be exercised early. WX is trading at $55 and just announced a $1 dividend per share that will be paid four months from today to stockholders...
I am trying to implement a search function for a binary search tree. I am trying...
I am trying to implement a search function for a binary search tree. I am trying to get the output to print each element preceding the the target of the search. For example, in the code when I search for 19, the output should be "5-8-9-18-20-19" Please only modify the search function and also please walk me through what I did wrong. I am trying to figure this out. Here is my code: #include<iostream> using namespace std; class node {...
PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please) [EXCEL]...
PLEASE ANSWER IN EXCEL FORMAT THAT IS EASILY UNDERSTOOD ONLY, THANK YOU!! (no writing please) [EXCEL] Percent of sales: Cattail Corporation's financial statements for the fiscal year just ended are shown below: Cattail Corporation Income Statement Net Sales: $1500 Costs: $350 Net Income: $1150 Balance Sheet Assets $700 = $700 Debt $600 Equity 100 = $700 Cattail management expects sales to increase by 14 percent next year. Assume that the financial statement accounts vary directly with changes in sales and...
Hello! If possible, could you provide how and in excel? I'm stuck and trying to learn...
Hello! If possible, could you provide how and in excel? I'm stuck and trying to learn so I can do well on the exam! A 20-year annuity pays $2,350 per month at the end of each month. If the discount rate is 13 percent compounded monthly for the first eight years and 10 percent compounded monthly thereafter, what is the present value of the annuity? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The following are the runs scored totals for 9 players for the 2016 New York Yankees: 56,43,63,68,58,80,71,32,19 (a) Find the mean and median (b) Find the standard deviation of this population (c) Considering this as a normal sample of American League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 . (d) Considering...
Please give an explanation or what the rational of the code is about, I am trying...
Please give an explanation or what the rational of the code is about, I am trying to figure it out what it means so to better understand it. Discuss the Code Provision on Square and Rectangular HSS and Box- Shaped Members, Rounds HSS, Tees and Double Angles Loaded in the Plane of Symmetry, and Single Angles.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT