I need help completing 1-3 50°FCloudyXCourse AnnouncementsFormulasClass,Here are some formulas that you can refer to for Set 1 Parts 1 and 2#1 Use the PV FormulaPV = 60,000*1/(1+0.09)^8#2 Use the FV FormulaFV = 110,000*(1+0.11)^9#3 Use the PV FormulaPV = 200,000*1/(1+.12)^15Example Part 2#1 = NPV(Discount Rate, range of values)+initial investment.#2 = NPV(Discount Rate, range of values)+initial investment.IIn addition to your text, you can also visit Investopedia.com. There you should be able theRespectfully,Dr. McLetchieO Search 3 Future value formula:4Question1. If you want to have $60,000 in 8 years, howmuch do you need to deposit in the bank today ifthe account pays an interest rate of 9%?52. What will $110,000 grow to be in 9 years if it6 is invested today at 11%?3. You would like to have $200,000 in a collegefund in 15 years. How much do you need todayif you expect to earn 12% while you are7 investing to pay for your child's college?Answer+Insert your answer.Insert your answer.Insert your answer.

The concept of money's time worth states that any sum of money is worth more currently than what it…

Question 1. If you want to have $60,000 in 8 years, how much do you need to deposit in the bank today if the account pays an interest rate of 9%? 2. What will $110,000 grow to be in 9 years if it is invested today at 11%? 3. You would like to have $200,000 in a college fund in 15 years. How much do you need today if you expect to earn 12% while you are investing to pay for your child's college? Answer Insert your answer. Insert your answer. Insert your answer.

Question 1. If you want to have $60,000 in 8 years, how much do you need to deposit in the bank today if the account pays an interest rate of 9%? 2. What will $110,000 grow to be in 9 years if it is invested today at 11%? 3. You would like to have $200,000 in a college fund in 15 years. How much do you need today if you expect to earn 12% while you are investing to pay for your child's college? Answer Insert your answer. Insert your answer. Insert your answer.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 2R

See similar textbooks

Similar questions

What is the value of (F/A, i, N) if (P/A, i, N) = 6.1343? O a. 3.0672 O b. 5.5209 O c. 6.1343 O d. 1.0000 O e. 36.3400
Calculate: where x=1.0315, and n=31
Need your help. Thank you
$1.20 1.30 0.8 0.9 1.1 Pulangan Geometrik = _% Geometric return= _% OA-2.15 OB-2.53 OC -2.84 OD-2.79 OE-2.68
ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=D0&launchUrl=https%253A%252F%252Fblackboard.waketech.edu%252Fwebapps%252Fporta Find the future value. (Use the Table 12.1.) (Do not round intermediate calculations. Round the "FV factor" to 4 decimal places and final answer to the nearest cent.) On FV Table 12.1 Period Present value Length of time Rate Compounded Rate used FV factor used Future value used 12,988.90 5 years 8 % Quarterly 20 2 % ....*...... acer ... %24
montife Installme Parment: 678.41 perjod Beginning Bolah prezare t firs) twe
brary TE(18,3.25,-139.90,100) E F RATE Nper 18 Pmt 3.25 PV Fv Type -139.90 100 Defined Names Formula result = 0.008500381 Help on this function Function Arguments = 18 = = -139.9 = 100 = number 3.25 Formula Auditing ? = 0.008500381 Returns the interest rate per period of a loan or an investment. For example, use 6%/4 for quarterly payments at 6% APR. OK X Fv is the future value, or a cash balance you want to attain after the last payment is made. If omitted, uses Fv = 0. Cancel
Show clear calculation in figures how you got NPV of 612 483.44
2. Fill in the blanks
Solve the following problem. PV=$18,372; n = 79; i = 0.021; PMT= ?; PMT=$(Round to two decimal places.) Help me solve this View an example 4 Go
Please Solve In 10mins Both Questions
using an excel worksheet, for FV equation, what does it mean the following: =FV(rate, nper,pmt,(pv),(type)) and, how it will show in this formula PV-8453 T=16 years r=8%