1.) Miller likes to invest in annuity that will pay him Php. 5000 at the end of each month for 5 years after his retirement. What is the present value of the annuity if the prevailing interest rate is 12% per year ? 2.) Dory deposits a certain amount of money into her savings account at the beginning of each quarter for the next 4 years. She wants to have Php. 100,000.00 after 4 years. If the interest rate is 8% compounded quarterly, how much does she have to deposit at the beginning of each quarter? Create an amortization table for each questi

Q: Ayesha wants to deposit 300 per year in a bank for the next 10 years. The bank pays annual interest…

A: Future value refers to the worth of the amount which is invested today at some future specified date…

Q: How much does Tim need to save each year for 9 years as a regular savings payment if he wants to…

A: Formulas to be used   In excel PMT(rate, nper, pv, [fv], [type]) Rate The interest rate for the…

Q: Your uncle is about to retire, and he wants to buy an annuity that will provide him with $75,000 of…

A: The cost to buy an annuity today is calculated by discounting the annuity values with the present…

Q: Roger decides to start an investment account by depositing $5,000 today. In one year he will invest…

A: Initial deposit (Year 0) = $5,000 Year 1 Deposit = $500 Year 2 Deposit = $600 Year 3 Deposit = $700…

Q: 1. Manda Bamkeng deposits Php 50,000 every beginning of the month for 4 years with 2% compounded…

A: Note: As per the rules of Bartleby,in case of multiple unspecified questions only the first question…

Q: money should he have

A: A retirement plan refers to the financial strategies of saving, investments, or distributing money…

Q: Wally and Paolo are bestfriends. Wally desires Paolo to receive 200000 in twelve years. What should…

A: We need to use future value  formula to calculate the amount to be invested today. PV =FV(1+r)n…

Q: David invests $300 into an account with a 2.3% interest rate that is compounded semiannually. How…

A: Time value of money (TVM) refers to the method or concept which is used to determine the amount of…

Q: JOSH WANTS TO BUY A HOUSE AND WOULD NEED A $200,000 LOAN. HE WILL AMORTIZE THE LOAN FOR OVER 15…

A: Solution Firstly lets calculate the annual installment Annual installment          = loan amount/…

Q: Emma is saving for a new car. She deposits $2200 into an annuity account at the end of every year,…

A: Future value of annuity can be calculated with the help of annuity table given in the question.…

Q: (a) She wants her first payout to have the same purchasing power as does $17,000 today. How big…

A: Note: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts…

Q: Luis has $170,000 in his retirement account at his present company. Because he is assuming a…

A: This account works as a combination of two separate account: fixed principal of $170,000 compounded…

Q: Your uncle is about to retire, and he wants to buy an annuity that will provide him with $73,000 of…

A: The provided information are: Particular Value RATE 5.25% YEARS 19 PMT (MONTHLY PAYMENT)…

Q: Dean Gooch is planning for his retirement, so he is setting up a payout annuity with his bank. He…

A: Payout annuity is the amount that an investor receives at a regular interval after a certain period…

Q: esslyn has just given an insurance company RM1 million, a sum of money she just received from her…

A: The given problem can be solved using RATE function in excel. RATE function provides interest rate…

Q: Ms. Perez wants to invest in a savings account with interest rate of 9% per year. She decided to…

A: Present value of annuity is the current value of the future payments that are calculated using the…

Q: Michael Jones plans to save $5,928 every year for the next eight years, starting today. At the end…

A: The future value is the amount that will be received at the end of a certain period. In simple…

Q: Samy would like to buy a house with cash ten (10) years from now. The house is currently selling at…

A: Annuity means a series of finite number of payments which are the same in size and made in equal…

Q: Your uncle is about to retire, and he wants to buy an annuity that will provide him with $7,000 of…

A: Annual income (C) = $ 7000 Number of annual payments (n) = 21 Annual interest rate (r) = 5.25%

Q: He wants to deposit his savings into a bank account. How much does Jacob have to deposit now in the…

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

Q: Christopher wants to have 50,000 pesos in 4 years by saving equal regular payments. He can make a…

A: Present value is the sum of the current value of money of future cash flows. It is also known as a…

Q: Hannah wants to have $ 7500 to help pay for a new deck in 16 years. If she wants to put her money…

A: GIVEN, Future Value  = $7500 Interest rate(r)  = 6.25/100 = 0.0625 Time Period(t) = 16 years Present…

Q: Betty wants to invest a monthly sum of money in order to accumulate R100000 in seven years. How much…

A: The PMT function or concept can be used to determine the periodic payments required to accumulate a…

Q: Arabella converted her loan to light payments which gives her an option to pay 12,000 every 2 years…

A: Present Value of annuity refers to the today's value of cash flows of a series of equal cash flows…

Q: Joe would like to have $80,000 saved in 10 years. If he invests his money in an ordinary annuity…

A: Future value of annuity = P * [ (1+r)^n  - 1 ] /r  FV = $80,000 n = no. of compounding period 10*12…

Q: Rita desires to purchase an ordinary annuity that will pay her $4,000 a year for the next 20 years.…

A: The present value of the ordinary annuity table is used when the periodic payments are made at the…

Q: Liz plans to deposit $10,000 in the bank now and another $5,000 two years from now. If she plans to…

A: Before making any calculation let us first arrange these cashflows into a cashflow time line chart.…

Q: Manuel plans to set aside money for his young daughter’s college tuition. He will deposit money in…

A: Annuity is referred as the instalment paid at the regular interval for a particular period. The…

Q: Cheryl is setting up a payout annuity with her bank. She wants to receive a payout of $1200 per…

A: Using excel PV function

Q: Mark deposits $40,000 now into an account which will earn interest at a rate of 8% per year, how…

A: Present value of annuity concept is used to calculate the annual withdrawal amount.

Q: Without using Excel and using the formula, Cheryl is setting up a payout annuity and wishes to…

A: Present Value of annuity refers to the present value of all the future payments of and series of…

Q: Dean Gooch is planning for his retirement, so he is setting up a payout annuity with his bank. He…

A: The annuity is a series of cash flow wherein an equal amount is paid every period.

Q: Kobe is retiring in 19 years, and wants to save some money. He will make bi-weekly deposits of…

A: Bi-weekly Deposit = $513.38 Time Period = 19 Years Interest Rate = 2.750% compounded semi-annually

Q: Diane wants to receive annuity payments of $2500 at the beginning of each quarter for eight years.…

A: The present value of annuity refers to the current value of the future payments from the payment…

Q: Salem wishes to withdraw AED 30,000 at the end of each year of the next 6 years from his bank…

A: Annual withdrawal amount (A) = AED 30000 n = 6 years r = 10%

Q: Hannah wants to have $1500 to help pay for a new deck in 13 years. If she wants to put her money…

A: Present Value = Future value / e^rt Where r = 8.50% t = 13 years

Q: Mr. Arman has decided to start saving for his retirement. Beginning on his twenty-sixth birthday,…

A: It is required to find the future value in the accounts of Mr. A and Mr. J to know who will be…

Q: An investor deposits $100 into his credit union account that pays interest at the rate of 3.25% per…

A: Future Value = Present Value * (1+interest %)^N Future Value = 100*(1.0325)^7 Future Value =…

Q: Mr.Sarwar wants to save $2000 after every 6 months in a financial institution, which pays him…

A: The future value of the annuity is the future worth of a cash flow series at a certain rate of…

Q: Mr & Mrs. John have decided to start a monthly savings program in order to provide for their son's…

A: Accumulated amount (F) = RM 50,000 Annual interest rate = 6% Monthly interest rate (r) = 6%/12 =…

Q: Your aunt is planning to invest in a bank CD that will pay 7.5% interest semi annually. If she has…

A: SEMI ANNUAL INTEREST RATE  (7.50%/2) 3.75% PERIOD (4*2) 8 PRESENT VALUE $5,000 PMT 0

Q: Suppose you wish to invest in an annuity so that you will have $120,000 at some future date for your…

A: We invest $350 monthly at a interest rate of 5.85% per month in order to give the child $120,000 at…

Q: Dory deposits a certain amount of money into her savings account at the beginning of each quarter…

A: Future value of a present value is the value of that amount after taking into account the time value…

Q: Aunt Zelda’s son starts college in 5 years for which she will need $15,000 payable at the end of…

A: Aunt Zelda will buy an annuity at the beginning of year 5 that will pay $15000 for college at the…

Q: A young couple wants to have a college fund that will pay $40,000 at the end of each half-year for 8…

A: Time value of money refers that, a sum of money today has more value than the same amount received…

Q: Bob purchases an annuity that will pay him $10,000 a year for the next 15 years starting a year from…

A: Present Value of Ordinary Annuity refers to the concept which gives out the discounted or today's…

Q: Mrs Sam has deposited $ 18,000 in a bank at the rate of 7% per annum. Find out how much she will…

A: Given: Deposit = $18,000 Period 12 years Interest rate = 7% or 10%