Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part 2 A: (must be completed in Excel) Analysis : Using the budget in part 1; Use as many time lines as you need forecast

Part 2 A: (must be completed in Excel) Analysis : Using the budget in part 1; Use as many time lines as you need forecast all your projected savings(investments) to get each investments future value. You will have to determine your PV, I/y, N, PMT then calc FV If you dont have any idea on the I/y you could use 5 or 6% to be conservative. N depends on your current age and when you think you will retire. Savings 401k or (403B) whichever you use IRAs. Home Ect. Once you add up all the future values from step 2 above, and do a time line to determine how much you will be able to spend each year assuming you are going to spend all your money. I.e. your future value will be 0. To calculate N, you have to make a lot of assumptions. For example, if you are planning on retiring at age 65 and think (hope) you will life until you are 90 (25 years) your N will be 25.

Any examples or help of how I can go about starting this Part of my budget project?

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

Options Futures And Other Derivatives

Authors: John C. Hull

7th Edition

0136015867, 9780136015864

More Books

Students also viewed these Finance questions

Question

=+ What scenarios could draw the audience in?

Answered: 1 week ago

Question

=+ What graphics could stop the viewer?

Answered: 1 week ago