What happens if you delay start of savings for five years

Assignment Help Finance Basics
Reference no: EM131380333

Assignment

Please fix this before proceeding to next task I have attached the spreadsheet.

Your calculations were all correct except that the car loan in parts 1 & 2 should have been for six years instead of five.

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 don't 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

IRA's....

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.

Part 2 B (must be completed in Excel)

Scenario Analysis:

Run at least 3 different scenarios to see the impact of decisions. Some examples may include:

What happens if you delay start of Savings for 5 years?

What happens if you work 3 more years?

What if the interest rate is higher/lower?

What if you have more to save after student loans are paid off?

Part 3 (must be turned in Word Via TurnItin)

Reflection

Once you are completed with the three sections above write a page or two on what you learned from this project. This is open ended but I expect at a minimum of 1 page as a write up. Reflection could include but is not limited to the following questions:

What did you learn?
Was there anything unexpected?
What changes will you be making as a result?
How do you plan on investing their funds - why? How often will you review the Plan?
What benefits are there to budgeting?
What specific changes will you make as a result of this assignment?

Please note: APA formatting required for all outside sources.

Attachment:- Amoritization_Table_Lequisha_Seldon.xls

Reference no: EM131380333

What communication strategies did you use to resolve

Describe the situation briefly and consider which response to conflict was demonstrated by either you OR the other person in the conflict. (Examples would be avoidance or co

The replica designs case

You agreed to analyze her business operations and to advise her how to reach her modest goal of earning $25,000 per year, after taxes. After some calculation and some thought,

What should be the value of this stock

The Joseph Company has a stock issue that pays a fixed dividend of $3.00 per share annually. Investors believe the nominal risk-free rate is 4 percent and that this stock shou

Draw the net present value profiles for both projects on the

All techniques: Decision among mutually exclusive investments Pound Industries is attempting to select the best of three mutually exclusive projects. The initial investment an

What conclusions can you draw about this child brain funct

Thinking about what you know of human development and its relationship to the process of learning, and memory, what conclusions can you draw about this child's brain functions

How much money must you pay into an account at the beginning

How much money must you pay into an account at the beginning of each of 20 years in order to have $10,000 at the end of the 20th year? Assume that the account pays 12% per y

What is the value of a right

Image Storage Corporation has 1,000,000 shares outstanding. It wishes to issue 500,000 new shares using a (North American) rights issue. If the current stock price is $50 an

State has offered you three payment options

You have won the Lottery! The state has offered you three payment options - a) $1 million today tax free; b) $1.5 million a the end of year 2 taxed at 20%; c) $1 million at

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd