You have an older borther who plans to marry his long time gf after 6 years. The couple estimated that they need P 1 000 000 for their wedding 6 yearsrs from now. They plan to save the same amount of money each year starting the end of this year in order to cover the wedding expenses. If they can invest their money in an instrument thay yields 5% annually how much do they need to save every year?

You have an older borther who plans to marry his long time gf after 6 years. The couple estimated that they need P 1 000 000 for their wedding 6 yearsrs from now. They plan to save the same amount of money each year starting the end of this year in order to cover the wedding expenses. If they can invest their money in an instrument thay yields 5% annually how much do they need to save every year?

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 6E

See similar textbooks

Similar questions

You have an older brother who plan to marry his long time girlfriend after 6 years. The couple estimated that they will need P1 000 000 for their wedding in 6 years.. They plan to save the same amount of money each year starting the end of this year. in order to cover wedding expenses. If they can invest their money in an instrument that yields 5% annually, how much do they need to save every year?
A father is trying to save for his daughter’s wedding in two years. (Long engagement!). He thinks he can make the following contributions to an account: $14,545.00 today and $13,130.00 in one year. The father thinks he can earn 7.00% in the market each of the next two years. If the wedding is expected to cost $52,815.00 two years from today, how much will he need to contribute at the time of the wedding to cover its cost?
Aunt Zelda’s son starts college in 5 years for which she will need $15,000 payable at the end of each of the 4 years. Suppose she can buy an annuity in 5 yrs. that will enable her to make the four $15,000 annual payments. Draw a timeline for all cash flows. What will be the cost of the annuity 5 years from today? What is the most she should be willing to pay for it if purchased today? Assume an interest (discount) rate of 6% during these 9 years.
You and your sister are planning a large anniversary party 3 years from today for your parents' 50th wedding anniversary. You have estimated that you will need $6,500 for this party. You can earn 2.6 percent compounded annually on your savings. How much would you and your sister have to deposit today in one lump sum to pay for the entire party? Can the excel and calculator solution be provided?
Anthony and Michelle Constantino just got married and received $20,000 in cash gifts for their wedding. How much will they have on their 25th anniversary if they place half of this money in a fixed-rate investment earning 8 percent compounded annually? Would the future value be larger or smaller if the compounding period was 6 months? How much more or less would they have earned with this shorter compounding period? Click on the table icon to view the FVIF table: If they place half of this money, PV, in a fixed rate investment earning 8 percent compounded annually, the amount (Round to the nearest cent.) they will have, FV, on their 25th anniversary is $
Suppose you have a 1-year old daughter and you want to provide R81 000 in 19 years towards hercollege education. You currently have R2 000 to invest. What interest rate must you earn to havethe R81 000 when you need it?
Anthony and Michelle Constantino just got married and received $28,000in cash gifts for their wedding. How much will they have on their twenty-fifth anniversary if they place half of this money in a fixed-rate investment earning 10percent compounded annually? Would the future value be larger or smaller if the compounding period was 6 months? How much more or less would they have earned with this shorter compounding period? If they place half of this money, PV, in a fixed rate investment earning 10percent compounded annually, the amount they will have, FV, on their twenty-fifth anniversary is $ (Round to the nearest cent.)
john is planning for his wedding with fiance jane. they believe they need 30,000 for ceremony to be held exactly three years from today. she is planning to start depositing 300 per month for the event beginning next month in a unit trust that would provide her 5% return per year on average. if John were to invest in another unit trust investment that will provide him 7% return per annum, how much should he invest every month
Your sister will start college in five years. She has just informed your parentsthat she wants to go to a private university that will cost RM18,000.00 per yearfor four years (assumed at the end of each year). Your parents have startedinvesting RM3,000.00 per year since five years ago. How much will yourparents have to invest each year for the next five years to have the necessaryfunds for your sister's education? Use 10% interest rate throughout thisproblem.
The AGI of the Newtons, a married couple, is $199,000 this year. They would like to contribute to a Roth IRA. 2. What is the maximum amount this couple can contribute to a Roth IRA? Show your calculations using Microsoft Excel. 3. Now suppose that the Newtons will report AGI of less than $196,000 and put $12,000 each year into their Roth IRA for 20 years, earning an annual return of 5%. What future value will accumulate in their Roth at the end of this period?
William Jack and Sophia Rose are planning on their first child education. If they expect that college will cost RM150,000 per year in 18 years, calculate how much should the couple begin depositing annually at the end of each of the next 18 years to accumulate enough funds to pay one year of tuition 18 years from now. Assume they can earn a 6% annual rate of returm on their investment.
Yoir neighbour would like to set money asideto purchase land in 15 years. Theybwould like to gabe S 500,000 set aside in 15 years, if they make annual payments and can earn 12% interest per year, how much money do they need to invest each year?