Hello Sir/ Mam
YOUR REQUIRED ANSWER IS $174,635.57
There can be multiple ways to solve this one.
As we are depositing $5000 each year and only $3000 is one different amount, we better assume it to be $5000 and decreasing $2000 from the final answer ,as it is a terminal outflow and using annuity function on the rest.
So,
Using,
PV = -10000
I/Y = 6.5
n = 17
PMT = -5000
CPT -> FV
We get FV = $176,635.57
Hence, decreasing $2000 from it, we get our answer, FV = $174,635.57
Please drop an upvote if you find this helpful.
Thanks!
Please answer the following question: You deposite $10,000 in a savings fund today. You continue to...
If you deposit $1,067 per month into a savings account that pays an annual rate of 4.7 percent, compounded monthly, how much will you have in the account after 31 years? Show using Excel Functions. Nper Rate PV FV PMT
please answer all 2pt per question. Show your work clearly to eam partial credit! Read the questions carefully! Suppose you invest $100, $200, & $300 at the end of year 1 to 3 in the next 3 years and earn 6% each year. What is the future value at the end of year 3? tcompute the PV: using CF function: CO0-0, CO1- 100, C02=200 , C03-300, I-6, CPT NPV= FV,=PV (1r)624.36 Suppose you expect your investment to earn 6 %...
Aisha is a pension fund manager. According to her estimates, retirees will be paid benefits worth $800,000 annually 12 years from now. Given a discount rate of 6 percent, what is the present value of the payments today if these annuity payments start at the beginning of the year rather than at the end of each of the next twelve years? An example in the book: PEARSON 4.4 Annuity Due and Perpetuity (continued) Example 4: Annuity Due versus Ordinary Annuity...
Please show all your work for the following question. answer with PV, FV, PMT, IY, and N butfons for financial calculators if possible. 3. A) For a deposit, what APR compounded quarterly will produce the same effective annual rate as 12% APR compounded weekly? B) For a deposit, what APR compounded semi-annually will produce the same effective annual rate as 12% APR compounded monthly?
you plan to open a savings account by depositing $1,000.00 in the bank today and continuing to deposit the same amount every year for a total of 10 deposits. if the bank pays 3% interest rate, how much will you have in the bank 10 years from now? - please write down the formually youd use to solve it manually but solve it using excel
Judge Drago has decided to set up an educational fund for his favorite granddaughter, Emma, who will start college in one year. The judge plans to deposit an amount in a savings account that pays 7% annual interest. He wants to deposit an amount that is sufficient to permit Emma to withdraw $20,500 for tuition starting in one year and continuing each year for a total of four years. (FV of $1, PV of $1 FVA of $1, and PVA...
I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...
Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...
Judge Drago has decided to set up an educational fund for his favorite granddaughter, Emma, who will start college in one year. The judge plans to deposit an amount in a savings account that pays 7% annual interest. He wants to deposit an amount that is sufficient to permit Emma to withdraw $21,100 for tuition starting in one year and continuing each year for a total of four years. (FV of $1, PV of $1, FVA of $1, and PVA...
1. If we place $7,654 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 8.5 years? PLEASE SHOW ME EXACTLY HOW TO DO THE PROBLEM!!!! I INSERTED A PICTURE FOR AN EXAMPLE! Future Value after 9 years is calculated using EXCEL FUNCTION FV(rate, nper,pmt, pv,type) where rate-1.5%; nper-9; pmt-o; pe-3520000; type=0; Here, value for pv is negative as it denotes cash inflows; type as interest is compounded at the end of...