User Account

All Pages

Determine what annual payment will need to be invested

Assignment Help Accounting Basics
Reference no: EM131947933

Question: Recently, I had to choose between opening a savings account and a certificate of deposit (CD). The savings account offered 1.05% of interest and the CD, 2.75%. I had to compare both investments in a 5-year horizon in order to reach the achieved calculation.

In this case, I relied on the Future Value (VF); which is the value that will have in the future a certain amount of money that we maintain today or that we decide to invest in a certain project. Future Value (VF) allows us to calculate how the value of the money we have today (today) will be modified considering the different investment alternatives available to us. In order to calculate the VF, we need to know the value of our money is the current moment and the interest rate that will be applied in the coming periods. Future Value is used to evaluate the best alternative as to what to do with our money today. Also to see how the value of money changes in the future.

The first alternative has an FV of $5,268.07, while the second alternative offered an FV of $5,726.37. The FV of the CD is greater than the savings account; as a result, it means a more attractive investment than the alternative.

Explanation:

Task 2: Determine the present value of $75,000 discounted at 6% over 6 years.

FV= $75,000

Rate= 6%

Period= 6 years

PV = $52,872.04

Determine the future value of $100,000 invested today at 4% for 5 years.

FV = $121,665.29

Rate= 4%

Period= 5 years

PV = $100,000

Determine what monthly 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%.

Monthly payment = $193.66

PV= $10,000

FV= $100,000

Period= 20 years

Rate= 4.5%

References: Patnaik, P. (2009). The value of money. Staff, I. (2018, March 6). Time Value of Money - TVM.

INSTRUCTOR:

Task 2: = PV(0.06,6,0,75000)

What would be the formula if the interest rate were compounded monthly?

THE ORIGINAL ASSIGNMENT AS FOR

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

i. Determine the present value of $75,000 discounted at 6% over 6 years.

ii. Determine the future value of $100,000 invested today at 4% for 5 years.

iii. 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%.

Information related to above question is enclosed below:

Attachment:- MS6014_M2A1_workbook1.rar

Reference no: EM131947933

Questions Cloud

Corporate leader of a large multinational company : Could Mother Teresa have been a good corporate leader of a large multinational company? Explain why you think she would have been a good corporate
Predicting job performance in business organization : Please explain why the Five Factor (Big Five) Model (FFM) is useful in predicting job performance in business organization.
What is the cd effective rate : Security National Bank is quoting 1-year certificates of deposit with an interest rate of 6% compounded semiannually. Joe Saver purchased a $5,600 CD.
How much will lynn receive at the end of 6 years : How much will Lynn receive at the end of 6 years? (Do not round intermediate calculations. Round your answer to the nearest cent.)
Determine what annual payment will need to be invested : 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%.
Compare the institutional structure of the untied states : Compare the institutional structure of the Untied States, Japan and China to determine if they promote globalization
How you would explain to your friend psychopathology : How you would explain to your friend psychopathology, what constitutes major depression, and at least two possible treatments.
What is the difference between brainwashing and an argument : What is the difference between brainwashing and an argument? What does it mean to dispute an argument on the basis of the facts?
Explain the types of products or services of the company : Suggest five (5) ways in which the primary stakeholders can influence the organization's financial performance. Provide support for the response.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Theory of interest - term structure of interest rates

Term Structure of Interest Rates

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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