Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have decided to invest $5,000 today into an investment account and you expect to earn 8% per year compounded quarterly during the first 30

You have decided to invest $5,000 today into an investment account and you expect to earn 8% per year compounded quarterly during the first 30 years. After that, you will be more conservative and expect to earn 4% per year compounded semiannually. Which of the formulas will allow you to determine how much money you will have 45 years from now?

Remember the basic syntax of FV is FV(rate, nper, pmt, pv, type).

Please check the attached excel file for the spreadsheetTVM.xlsx .

Initial Investment $5,000
Years 45
Years of aggressive investment period 30
Compounding frequency during the first 30 years 4
Compounding frequency after the first 30 years 2
Annual interest rate during the first 30 years 8%
Annual interest rate after the first 30 years 4%

= FV(B7/B4, (B2-B3)*B4, 0, -FV(B6/B5, B3*B5, 0, -B1, 0), 0)

=FV(B5,B3+B4,0,-B1)

=FV(B6,B4,0,-PV(B5,B3,0,-B1))

= FV(B7/B5, (B2-B3)*B5, 0, -FV(B6/B4, B3*B4, 0, -B1, 0), 0)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Handbook Of Fixed Income Securities

Authors: Frank Fabozzi, Steven Mann, Francesco Fabozzi

9th Edition

ISBN: 1260473899, 978-1260473896

More Books

Students also viewed these Finance questions

Question

For what reasons do home countries intervene in FDI?

Answered: 1 week ago

Question

s(t) = In(ej e-t)

Answered: 1 week ago

Question

mple 10. Determine d dx S 0 t dt.

Answered: 1 week ago