On 1 January 2019 the total present value of all the investments is R75,998.34. If the interest rate is 8.75% per year, c the value of X (annuity invested every quarter). Implement your solution in Excel. Show your results after every step you do.

Q: Use graphical approximation techniques or an equation solver to approximate the desired interest…

A: Nominal rate:The nominal rate, in the realm of finance, refers to the stated or advertised interest…

Q: What is the present worth of P500 deposited at the end of every month for 6 years if the interest…

A: Present Value:  The present value is the value of cash flow stream or the fixed lump sum amount at…

Q: 7. What is the present worth of a year annuity paying P 3,000.00 at the end of each year, with…

A: The time value of money is the financial concept that is used for estimating and determining the…

Q: 1. What is the present worth of a P1000 annuity starting at the end of the third year and continuing…

A: Since you have asked multiple question, we will solve the first question for you. If you want any…

Q: For each of the following situations involving annuities, solve for the unknown. Assume that…

A: We can compute the missing values using the follwing excel functions,=PV(rate, nper, pmt)=RATE(nper,…

Q: Find the present value of an annui P6,000 a year for 8 years that is def or 2 years, if the money is…

A: Deferred annuity means that it will start later that means so will be having slightly less value…

Q: Jones expects an immediate Investment of $95,824.80 to return $24,000 annually for five years, with…

A: Annuity is a contract under which one party agrees to pay a fixed amount, at each interval of time,…

Q: What’s the present value of a perpetuity that pays $1500 per year if the appropriate  interest rate…

A: Cash flow per year is $1500 The interest rate is 15% To Find: the present value of a perpetuity

Q: Determine the Future Value after 20 years for an annuity of $500 deposited every 3 months,…

A: We need to use below mention TVM functions to calculate future value. N=Number of periods  I/Y…

Q: Find the present value PV of the annuity account necessary to fund the withdrawal given. (Assume…

A: Here, Withdrawal amount (PMT) is $200 per month Time Duration is 10 years Total time duration is :…

Q: An annuity makes 20 annual payments of $3,000 with the first payment coming today.  What is the…

A: Here, Particulars Values Annual payment (PMT)  $ 3,000.00 Interest rate (RATE) 8.00% Time…

Q: Carla Vista Company is considering investing in an annuity contract that will return $34,500…

A: Present Value of Investment = Annual Return x Present Value of Annuity Factor

Q: If I invest P10,387 today and expect a reimbursement every 6 months with a rate of 11.54% compounded…

A: Total Investment = P10,387 Interest Rate = 11.54% Compounded Semi-Annually = 2 Total no. of years =…

Q: Find the future and present value of a 5 year GHC 1,000.00 annuity if the rate of interest is 12%…

A: FV of Ordinary Annuity= PMT[(1+i)n-1/i] = 1000[(1+0.12)5-1/ 0.12] = 1000[1.7623-1/0.12] =…

Q: Which of the following investments will have the highest future value atthe end of 10 years? Assume…

A: The future value is the value of assets assuming a growth rate. The time value of money states that…

Q: You are paid £3,500 annually for 8 years, with the first payment due in one year and the last…

A: Present value is the current worth of a future payment or stream of payments, taking into account…

Q: Find the present value of a growing annuity that pays year-end cash flows for each of the next 19…

A: An annuity refers to a constant stream of cash flows occurring in each period. A growing annuity is…

Q: Find the future value of an annuity of $1400 paid at the end of each year for 15 years, if interest…

A: Time value of money :— According to this concept, value of money in present day is greater than the…

Q: Find the present value of an annuity stream in which the first payment of $268 is received 8 years…

A: Payment = p $268Time = t = 8 Number of Payment = n = 8Growth Rate = g = -4.5%Discount Rate = r =…

Q: What amount should I invest today, Jan. 18, 2023 so that after 3 years the face value of my…

A: Future Value: What money is anticipated to be worth in the future is referred to as future value, or…

Q: A one-year investment is certain to pay £650. If the annual interest rate is 6%. * Round your…

A: Present Value refers to the method or technique which calculates the value of cash flows today,…

Q: Answer the following question correctly refer to the given problem below and show your Complete…

A: A deferred annuity is a type of annuity that starts after a particular period of time and then…

Q: A company needs to buy an annuity package that will provide a future income to an individual over a…

A: Annuity amount, A1 = £4,421 Period, n1 = 13 years Interest rate per period, r1 = 4.0% The present…

Q: An annuity of 41,431 is to be paid in 5 years at the rate of 4% compounded continuously. What is the…

A: There are investments made by the company for the purpose of gaining financial returns. These would…

Q: What will be the future value on December 31, 2023, of 5 annual $60,000 deposits starting on…

A: A theory that helps to compute the present or future value of the cash flows is term as the TVM…

Q: Find the accumulated value of an investment of $15,000 for 5 years at an interest rate of 1.45% if…

A: Present value = pv = $15,000Time = t = 5 YearsInterest rate = r = 1.45%

Q: Example 2.14: Calculating the present value of an annuity due at 12% An investor wants to buy an…

A: The objective of the question is to calculate the present value of an annuity due at 12% interest…

Q: The present value of an annuity is payable for 4 years, with the first payment at the end of 10…

A: An annuity is a series of payments for a certain period of time and at a certain rate of interest.…

Q: 2) You set up a 45-year investment plan with the intention of amassing 1,500,000 at the end of the…

A: Investment planning is the process of determining where you are financially in terms of the future…

Q: Calculate the present value of the following annuities, assuming each annuity payment is made at the…

A: Using Excel function: =PV(rate,nper,pmt,fv,type)Option 1) =PV(9%/2,3*2,-5600)= 28,884.09Rate= 9%/2 =…

Q: PV=5 $700 per month for 10 years, if the account earns 3% per year and if there is to be $10,000…

A: Present value is the equivalent value today based on interest rate and period of the money that is…

Q: search annuities and calculate an annuity that pays you monthly (like a pension) for a 30 year…

A: Annuities are uniform periodic monthly payments that are paid over the period of time based on the…

Q: Calculate the present value as at 1 January 2019 of a series of payments of £100 payable on the…

A: Monthly annuity=£100Period of annuity= 36 monthsEffective interest rate=8%Deferred period= 12 months…

Q: Suppose that you have inherited an annuity that will initially pay $1,755 six years from now. Each…

A: PMT=$1755growth rate (g)= 3%cost of capital =7% NPER (n) (for payments)= 30

Q: company needs to buy an annuity package that will provide a future income to an individual over a…

A: Annuity is the uniform payments over a period of time and annuity dues are paid at the beginning of…

Q: Find the future value of an annuity due for payments of $450 for 12 years with a rate of 0.24%…

A: Solution:- When an equal amount is paid each period at beginning of each period, it is called…

Q: Today is January 1, 2020. On the first day of the years 2021, 2022, 2023, and 2024, you will invest…

A: An annuity is a stream of fixed cash flows occurring at periodic intervals. The future value of an…

Q: Calculate the present value of the following annuities, assuming each annuity payment is made at the…

A: Present value is the equivalent value today of the future cash flow that is based on the time value…

Q: What is the present value of all these payments using an interest rate of 2%?

A: Given in the question is that 1,000 is received as annuity for the period of seven years. The first…

Q: wR389000nowandrepayitin25equalannualinstalments (payments will be made at the end of each year). If…

A: The given problem can be solved using PMT Function in excel. PMT function computes installment…