custom writing services

Need help: Write an email to our support staff support@myprivatementor.com or


whatsapp us

order order
Average score 4.97 out of 5 based on 836 opinions

financial management assignment for The_Writer ONLY

with attached Excel Spreadsheet showing calculations

 

  • First, you will need to estimate the future cost of 3 lifestyles assuming an inflation rate of 3% and the number of years before you turn 67 years old.
    • Comfortable lifestyle current cost is approximately $100,000/year.

PV of Life Style
(Given)

Average Rate of Inflation
(RATE)

Years to Retirement
(NPER)

Find FV of Life Style

$100,000

3.0%

 

 

 

  • Next, you will need to estimate the 5-year average rate of return of the stock market (you should use the top 500 stocks, which can be researched at finance Web sites).
    • At this rate of return, how long would it take for an investment to double?

Top 500 Stocks Value 5 yrs. ago (PV)

Top 500 Stocks Value Now (FV)

Number of Periods (NPER)

5-Year Return on Top 500 Stocks (RATE)

 

 

5

 

 

  • If an individual needed the following amounts to retire, how much would he or she have to invest today at the rate of return that you calculated in the previous step, assuming he or she will turn 67 in the same year you do?
    • $3,000,000

FV of Account
(Given)

5-Year Return on Top 500 Stocks
(RATE)

Years to Retirement
(NPER)

Find PV of Investment

$ 3,000,000

 

 

 

 

  • Now, you will need to estimate the life expectancy of the retiree.
    • Use 90 years of age as an estimate.
  • Now, you can subtract the life expectancy of the retiree from 67 (the retirement age) and use the first of the 2 tables below to calculate the required amount at retirement to support the following lifestyles adjusted for inflation (hint: the inflation adjusted amounts will be the payment as you will be calculating the present value of this annuity using a rate of return of 12%)
  • Now, using the second table, you can calculate the annual contribution that needs to be made to have each required amount at retirement.
    • To determine the annual contribution, use the amount that you calculated above as the future value, the market rate of return from Phase 1 as interest rate, and number of periods as 67 minus your current age.

FV of Life Style (PMT)

Given Expected Rate of Return (RATE)

Years in Retirement (NPER)

Required Value at Retirement
(Find PV of Annuity)

 

12.0%

23

 

 

FV of Account (Use PV of Annuity from above)

5-Year Return on Top 500 Stocks (Rate)

Years to Retirement
(NPER)

Annual Contribution Required to meet goal (Find PMT)

 

 

 

 

 

  • After completing the required calculations, explain your results in a Word Document and attach the spreadsheet showing your work. Be sure to explain the following:
    • The difference between present and future values
    • How the present value and future value calculations are calculated and related
    • The difference between compounding and discounting

NEED TO MAKE AN ORDER? HERE IS HOW IT WORKS

order-process

Need an answer from similar question?Click here and get a solution now

order You have just landed to the most confidential, trustful essay writing service to order the paper from. We have a dedicated team of professional writers who will assist you with any kind of assignment that you have. Your work is handled confidentially with a specific writer who ensures you are satisfied. Be assured of quality, unique and price friendly task delivered in good time when you place an order at our website. banner We have a team of dedicated writers with degrees from all spheres of study. We readily accept all types of essays and we assure you of content that will meet your expectations. Our staff can be reached  via live chat, email or by phone at any given time with prompt response.  

Prices starting at:

High school
Undergrad.(yrs 1-2)
Undergrad.(yrs 3-4)
Master’s
Doctoral
$10 / page
$10/ page
$12/ page
$15 / page
$17/ page

Note: The prices in the table above are applicable to orders completed within 14 days. Kindly see the full price table for more prices..

We urge you to provide as much information as possible to avoid many revisions. Set your deadline, choose your level, give payment information and relax while you track your work. We will deliver your paper on time. Are you in a quagmire and you are unable to complete your assignments? Do you doubt yourself on the quality of the essay you have written? Myprivatementor.com  is here to assist you. We will offer you unmatched quality that is plagiarism free. Place an order at myprivatementor.com  for guaranteed  high grades. order download

we offer gifts to our paper help customersPayment Methods

you can request our services and pay via paypal

we offer gifts to our paper help customersOur Guarantees

  1. Zero plagiarism.
  2. 100% confidentiality.
  3. FREE Reference page
  4. High Quality papers
  5. 24/7 Customer support

Our Testimonials Testimonials

I ordered a 7 page college essay and was delivered on time. Thank you guys I will definitely order again!

9.5
, FL

Our statisticsOur Statistics

  • Orders Completed todate 72387

  • Number of writers 500

  • Satisfied customers 99.7%

  • Returning customers 92.3%

  • Orders placed today 87