Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Accounting Basics Expert

Accounting


Home >> Accounting Basics

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

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M92785591
  • Price:- $25

Priced at Now at $25, Verified Solution

Have any Question?


Related Questions in Accounting Basics

Question - assume andersons general store bought on credit

Question - Assume Andersons general store bought on credit, a truckload of merchandise from American wholesaling costing $24,500. If Anderson paid National Trucking $800 cash for transportation, immediately returned good ...

Question - describe the allocation of inventoriable costs

Question - Describe the allocation of inventoriable costs may be made under any of the following assumptions as to the flow of costs (a) first-in, first-out (FIFO), (b) last-in, first-out (LIFO), or (c) average cost.

Question - the community college instructor has asked for

Question - The community college instructor has asked for your help again. He or she wants you to personally create a document he or she could give to students. Write an 875 to 1,050-word paper in which you: Analyze the ...

Question - selfish gene company is a merchandising firm the

Question - Selfish Gene Company is a merchandising firm. The following events occurred during the month of May. (Note: Selfish Gene maintains a perpetual inventory system.) May 1. Received $40,000 cash as new stockholder ...

Question - eastern manufacturing is involved with several

Question - Eastern Manufacturing is involved with several situations that possibly involve contingencies. Each is described below. Eastern's fiscal year ends December 31, and the 2018 financial statements are issued on M ...

Question - cassy reports a gross tax liability of 1110 she

Question - Cassy reports a gross tax liability of $1,110. She also claims $510 of nonrefundable personal credits, $755 of refundable personal credits, and $310 of business credits. What is Cassy's tax refund or tax liabi ...

Question - x companys profit equation next year is expected

Question - X Company's profit equation next year is expected to be 0.47R-$12,900, where R is total revenue. Assuming a tax rate of 36%, what must next year's revenue be in order for X Company to earn after-tax profits of ...

Question - the will of the decedent established a trust for

Question - The will of the decedent established a trust for the benefit of his wife and two sons. The trust states that the trustee shall pay to the widow $25,000 a year and $12,500 a year to each of his two sons. There ...

Question - personal budgetat the beginning of the school

Question - Personal Budget At the beginning of the school year, Priscilla Wescott decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on Dec ...

Question during the current year merchandise is sold for

Question: During the current year, merchandise is sold for $18,300 cash and $295,700 on account. The The cost that is reported as an expense when merchandise is sold.cost of the merchandise sold is $188,000. What is the ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved