Calculate what annual payment will need to be invested

Reference no: EM131812888

Assignment: Time Value of Money

Time value of money analysis has many applications-both personally and professionally. The calculations can be performed using Microsoft Excel, factor tables, or a financial calculator to help make informed decisions, such as planning for retirement, loan decisions, and capital projects.

The concept of time value of money helps managers value cash flows and assess risk within the organizations.
In this assignment, you will discuss specific situations where the time value of money is applied in personal and professional situations.

Tasks:

1. Share any professional and personal decisions you made in which the concept of time value of money was utilized and include the following:

o The specific decision for which you used time value of money.
o The manner in which you applied the concept.
o The tools you used to complete the analysis, including the timeline.
o An explanation of how using the concept helped you reach a more accurate decision than if time value of money had not been utilized.

Your response should consist of a minimum of 300 words and demonstrate critical thinking and analysis.

2. Download the MS6014_M2A1_workbook.xlsx template, and using the appropriate Excel financial functions, do the following:

o Determine the present value of $75,000 discounted at 6% over 6 years.
o Determine the future value of $100,000 invested today at 4% for 5 years.
o Determine what annual payment will need to be invested if you have $10,000 today and want it to grow to $100,000 over 20 years at 4.5%.

Copy and paste the results of task #2 into your post underneath your response to task #1.

Reference no: EM131812888

Questions Cloud

International development researcher : As an international development researcher, you would like to know African Citizen's perceptions about current levels of democracy. Your working hypothesis

Determine the regulatory oversight that was in place : Determine the regulatory oversight that was in place while the Ponzi scheme was operating, and speculate on the main reasons why they did not discover scheme.

Is there evidence to reject the null hypothesis : Consider again the situation described in Assignment 2 Question 5: from a random sample of 60 motorists during a particular week, 9 had purchased diesel.

Compute the upper limit : Assuming the random variable X is normally distributed, compute the upper limit of the 95% confidence interval for the population mean if a random sample

Calculate what annual payment will need to be invested : Calculate what annual payment will need to be invested if you have $10,000 today and want it to grow to $100,000 over 20 years at 4.5%.

Determine the significant of a proposed correlation : When performing a T-test to determine the significant of a proposed correlation, the T-test value must fall within the non-critical region

Find the annual rate of return : The straight-line method of depreciation would be used. If the equipment is purchased, the annual rate of return expected on this equipment is

Students before using the random digit table : You want to choose an SRS of 3 of these students. A correct way to assign labels to the 34 students before using the random digit table is

Calculate the operating income for july : Preppy Co. makes and sells a single product. The current selling price is $30 per unit. Calculate the operating income for July

User Account

All Pages