Interest rate = 6%
Now we need to have 50,000 for 20 years starting after 5 years.
So 50,000 is our annual payment

Use PV () function to find the present values
Note that present value we have found in 1st part is basically value we need after 5 years.
So that is future value of today's investment
This arrangement is called "Annuity"
Question #2 50,000 per You would like to setup a series of fixed payments where you...
You would like to buy a house that costs $350,000. You have $50,000 in cash that you can put down on the house, but you need to borrow the rest of the purchase price. The bank is offering you a 30-year mortgage that requires annual payments and has an interest rate of 10% per year. You can afford to pay only $31,190 per year. The bank agrees to allow you to pay this amount each year, yet still borrow $300,000....
You would like to buy a house that costs $350,000. You have $50,000 in cash that you can put down on the house, but you need to borrow the rest of the purchase price. The bank is offering you a 30-year mortgage that requires annual payments and has an interest rate of 8% per year. You can afford to pay only $25,580 per year. The bank agrees to allow you to pay this amount each year, yet still borrow $300,000....
You are planning for your future needs and retirement. You want to receive $50,000 five years from today and retirement annuity of $100,000 per year for 25 years with the first payment 10 years from today. To pay for this, you will make 5 payments of $A per year beginning today and 10 annual payments of $A with the first payment 8 years from today. With an interest rate of 8%, what is the value of A?
38. You would like to buy a boat and know you can afford boat payments of $500 a month for 3 years. The interest rate is 3.6%, compounded monthly. How much money can you afford to borrow? $16,287 $15,222 $17,038 $19,025 45. A company is expected to pay their first annual dividend at the end of this year. That payment will be $0.50 a share. The company will increase the dividend by 4% per year in the future. The required...
You would like to setup a trust fund for your two children to ensure that they will be taken care of in the future. At the end of this year, you would like each of your children to receive $20,000 (2 x $20,000= $40,000 payment received at the end of the year), and you would like to have this amount grow at the rate of inflation, (which will be assumed to be 3.5% forever) How much do you need to...
Question 10 5 pts You will receive a series of $1,216 payments, annually, beginning exactly 6 years from today, for a total of 10 payments. The relevant interest rate (your opportunity cost) is 8% (as an EAR). What is the present value today. (year O) of this series of payments? Do not round any intermediate work. Round your final answer to 2 decimal places (ex: if your answer is 12.345678 then you should enter 12.35). Margin of error for correct...
Jack would like to buy a piece of machinery by borrowing $50,000 from a bank for 4 years at an interest rate of 7% per year. For the first 2 years, Jack expects to pay $3200 at the end of each quarter as payment toward the loan. Jack then expects to increase the equal quarterly payments for the remainder of the loan term. After the 2 years, what equal quarterly payments will Jack make for the remainder of the the...
Karen has won $50,000 from a lawsuit. The money will be paid out in 8 equal-sized annual payments (payments are made at the end of each year). If Karen invests each payment in an account that earns 4.6% interest, compounded annually, how much will she have at the end of 8 years? Preview After Karen wins her lawsuit, she is approached by a structured settlement company. They offer her $48,500, paid immediately, in return for her annual lawsuit payments. How...
You are considering acquiring a common stock that you would like to hold for one year. You expect to receive both $2.01 in dividends and $39.00 from the sale of the stock at the end of the year. What is the maximum price you will pay for the stock today if you want to earn a return of 11%? (Round your answer to 2 decimal places.) 38 Maximum price
20pts) 5. William would like to purchase a house worth $350,000. He can afford to make a down payment of $50,000 and needs to take out a mortgage. The bank offers him a 35-year mortgage with monthly payments. The interest rate is 7% APR with semi-annual compounding. a) What will be his monthly payments? b) He can only afford to make payments of $ 1500 per month. The bank agrees to this provided he pays the remaining amount in a...