Question: Please do it in excel and show excel formular At the end of 2016, Susan had saved 65 000 for her retirement, She plans to

Please do it in excel and show excel formular At the

Please do it in excel and show excel formular

At the end of 2016, Susan had saved 65 000 for her retirement, She plans to withdraw at the end of each year from 2023 until the end of 2030 the same amount every year, Calculate the amount she can withdraw annually. The interest rate of her account is 1.65 %, and the source tax rate is 30 %. Present value Number of payments Interest rate Source tax Net interest rate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Please do it in excel and show excel formular Peter graduated at the end of 2017 and he received then a gift of 12 000 which he deposited on his account He has started to work and saves some more...

First, complete page one of the worksheet first by closely following the directions of each question. Much of the assignment is subjective based on your own financial goals, but the math is objective...

This is a real world exercise to determine the amount of savings you should have put away for your retirement. This is a dynamic and powerful assignment to demonstrate the power of the time value of...

Hi, I have an Assignment for my Finance Subject. I have attached the necessary documentation here for you to view including the Lecture slides of all the Topics covered for this assignment. Please...

This is a real world demonstration to determine the amount of savings you should have put away for your retirement. This is a dynamic and powerful exercise to demonstrate the power of the time value...

I am working on a excel two input data table and having issues getting it work properly. It's Question 2D on the uploaded documents. One is the word version with question, 2nd is the excel version. I...

Retirement Worksheet (please do the questions and put the formula on number 3 My salary is 85,000 age 53 retire at 67 expectancy age 80 1.Question one how much should I withdraw to have 70% of my...

John and Jane Doe are married retired taxpayers who care for their three-year-old grandson. The following information was provided to you as documentation necessary to prepare their 2017 tax return....

I need this 3 tax assignement done its about 1040 and Schedule d Form 1040 2016 (99) Department of the TreasuryInternal Revenue Service U.S. Individual Income Tax Return OMB No. 1545-0074 , 2016,...

. By implementing the stack concept, create a program that will implement the algorithm delimiter Matching(). Examples Input 1+(2-(2+3)*4 / (3+1)) * 5 (2+3) - (2+3) (2 + 3) (3 + 1) (2 Output (2+3) *...

Alpine Consulting is a consulting firm owned and operated by Scott Young. The end-of- period spreadsheet (work sheet) shown below was prepared for the year ended March 31, 2010. Based on the...

Of the following items, the only one that should not be classified as a current liability is short - term obligations expected to be refinanced on a long - term basis. sales taves payable. current...

a X2 X1 b FA1 b a,b a b + Y2 Y1 Y3 FA2 Using the algorithm given during the proof of Kleene's theorem, construct FAB for the product language (FAI FA2). Show all of the steps in obtaining the new 2...