solution in excel Problem: : i= 8% per year, n= 12 years, Pv=$ 5000, Fv=$2000 & type: payments are made at the endof a period. Find the annual value (A)?Also use the following equations to find the present worth (Hand calculations &Excel sheet).F=P(1+i)"&A= F,| (1+i)" –1 ]Ans.$558.09

This method can be solved in excel using the PMT function in excel.

Answered: solution in excel

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 15PROB

See similar textbooks

Similar questions

If you invest $15,000 today, how much will you have in (for further instructions on future value in Excel, see Appendix C): A. 20 years at 22% B. 12 years at 10% C. 5 years at 14% D. 2 years at 7%
How much would you invest today in order to receive $30,000 in each of the following (for further Instructions on present value In Excel, see Appendix C): A. 10 years at 9% B. 8 years at 12% C. 14 years at 15% D. 19 years at 18%
If you invest $12,000 today, how much will you have in (for further Instructions on future value in Excel, see Appendix C): A. 10 years at 9% B. 8 years at 12% C. 14 years at l5% D. 19 years at 18%
How much would you invest today in order to receive $30,000 in each of the following (for further instructions on present value in Excel, see Appendix C): A. 20 years at 22% B. 12 years at 10% C. 5 years at 14% D. 2 years at 7%
An investment of 1,000 produces a net cash inflow of 500 in the first year and 750 in the second year. What is the payback period? a. 1.67 years b. 0.50 year c. 2.00 years d. 1.20 years e. Cannot be determined
Investment If $5000 is invested for 6 years atinterest rate r (as a decimal), compounded annually, the future value of the investment is given byS = 5000(1 + r) 6dollars.a. Find the future value of this investment for selectedinterest rates by completing the following table. b. Graph this function for 0 <= r <= 0.20.c. Compute the future value if the rate is 10% and20%. How much more money is earned at 20%?
An investment of $80,000 yields a net income of $10,000 per year. How many years does it toketo recover the initial investment ot nominol interest of 6.5% compounded quarterly? You canuse the spreadsheet functions to solve this question or trial and error procedurea. 16 b.12c.15d.14 e.11
b1. F = Pert , which assumes continuous compounding, says that the Future value (F) of an amount (P) invested today at an annual rate (r), expressed as a decimal for the time (t), in years is given by the function. Thus if you invested $100 at the annual rate of 5 1/2% for 6 years and 3 months you would get back (at the end of the time), F = $100e(0.055)(6.25) = $100e(0.3438) = $100(1.4102) = $141.02. If you invest $15000 today, what amount does the formula say you will get back if you leave it for 5 years and 3 months in a savings account paying 4 1/2% annually?
*Using Matlab* The current amount A of a principal P invested in a savings account paying an annual interest rate r is given by A = P(1+r/n)^(nt) where n is the number of times per year the interest is compounded. For continuous compounding, A = Pe^(rt). Suppose $10,000 is initially invested at 2.5 percent (r = 0.025). a. Plot A versus t for 0 ≤ t ≤ 20 years for four cases: continuous compounding, annual compounding (n = 1), quarterly compounding (n = 4), and monthly compounding (n = 12). Show all four cases on the same subplot and label each curve. On a second subplot, plot the difference between the amount obtained from continuous compounding and the other three cases. b. Redo part a, but plot A versus t on log-log and semilog plots. Which plot gives a straight line?
The future value of a cash flow occurring 36 months from today is $15000, and its present value is $12,000. The effective monthly rate which corresponds to these values is closest to: Group of answer choices A) 0.21% B) 7.72% C) 0.62% D) Need more information to answer the question E) 5.73%
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULASProblem 1 Find the final value (FV or FV) at compound interest of $10,000, for 10 years:(a) at 7.5% effective annual rate. (rates are annual)b) At 7.5% compounded monthly.c) At 7.5% capitalized quarterly.d) At 7.5% compounded semiannually.
Determine the time value of money. Formula: FV = PV(1 + i)N or PV = FV × (1 + i)-N 1. 1. Assume you have just been hired with an annual salary of P300,000. Ifyou expect annual raises of 5%, what will your salary be for thefollowing? a. 5 years?b. 10 years?c. 15 years?d. 30 years? 2. A farmland is currently selling for P200,000 per hectare. If the rate ofincrease has been 2% annually, what was the price of the land 10 yearsago?

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Personal Finance

Finance

ISBN:

9781337669214

Author:

GARMAN

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

EBK CFIN

Finance

ISBN:

9781337671743

Author:

BESLEY

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Personal Finance

Finance

ISBN:

9781337669214

Author:

GARMAN

Publisher:

Cengage

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS