Millet wants to provide a ₱200,000 graduation gift for her daughter Mae who is now 16 years old. She would like the fund to be available by the time her daughter is 20. She decides on an investment that pays 10% compounded quarterly. How large must the deposit be?

Q: need

A: AS the deposits are made at the end of the year. This is an ordinary annuity problem. Formula to…

Q: Mr. Wise is creating a college investment fund for his daughter. He will put in P850 per year for…

A: To open the "FV function" window - MS-Excel --> Formulas --> Financials --> FV.

Q: A couple wants to set up a college fund for their child. The fund will give the child $1,000 per…

A: We need to determine the value of the annuity at the present.  Given: PMT = 1000 Period of annuity =…

Q: A newborn child receives a $9,000 gift toward a college education from her grandparents. How much…

A: As per the given information: Principal amount or amount of money deposited (P) - $9,000 Time period…

Q: Soon-to-be proud parents of a new born baby are planning to establish a scholarship fund for their…

A: To calculate the lump sum amount we need to calculate the present value of all the future cash flows…

Q: . How much should you deposit monthly to accumulate $85,000 in 15 years?

A: Future Value of Annuity: It represents the future worth of current annuity payments made…

Q: 1. Abbigail wish to establish a trust fund from which her daughter can withdraw $6,000 every six…

A: Hello. Since your question has multiple parts, we will solve first question for you. If you want…

Q: 4. Holly wants to have $200,000 to send a recently born child to college. She sets up a 529 plan and…

A: In this question,  we need to find the constant amount that Holly has to invest at the end of each…

Q: I am setting up a fund for my son to go to college. I figure that he will need $50,000 by the time…

A: An annuity is the sum of equal payments made for a certain period, at a particular rate of return.…

Q: Millet wants to provide a P200,000 graduation gift for her daughter Mae who is now 16 years old. She…

A: Given, Amount required is P200,000 Rate 10% compounded quarterly.

Q: Holly wants to have $250,000 to send a recently born child to college. She sets up a 529 plan and…

A: Future value (FV) = $ 250,000 Annual interest rate (R) = 6% Number of annual investment (N) = 17…

Q: .   Holly wants to have $200,000 to send a recently born child to college. She sets up a 529 plan…

A: The question is based on the concept of time value of money with annuity payment , used the equation…

Q: Amy Monroe wants to create a fund today that will enable her to withdraw $25,000 per year for 8…

A: Present value = Future annual withdrawals amount * Present value of discounting factor (8%, 5th to…

Q: If your daughter is 5 and she plans to go to college or university in Canada when she is 18 years…

A: Present Value is the current value of all the cash flows which is to be received in the future which…

Q: 1. Millet wants to provide a P200,000 graduation gift for her daughter Mae who is now 16 years old.…

A: It is the case where multiple questions have been asked and no question has been specified so as per…

Q: Jasica Parker would like to have ​$48,000 to buy a new car in 7 years. To accumulate $48,000 in 7…

A: The monthly invested payment can be calculated using PMT function in excel PMT(rate, nper, pv, [fv],…

Q: Cecilia wants to pay for her daughter's college for four years by banking 20,000 dollars per year.…

A:

Q: Richard and Mary wants to provide full funding for their 3 year old daughter who is expected to…

A: Given Information :  Current cost - $38,000 Growth rate - 3.5% Return on investment - 5.5% Periods -…

Q: Mr. Bienvenido Bautista needs a fund of Php1,000,000 to renovate his house. To provide for this, he…

A: It can be calculated using =NPER(rate,pmt,pv,[fv],[type]) Rate The interest rate for the loan. Nper…

Q: Mr. Cruz wishes his daughter to receive P1, 000, 000 ten years from now. What amount should he…

A: Honor code: Since you have asked multiple questions, we will solve the first question for you. If…

Q: Mr. and Mrs. Maglalang decide to set aside ₱ 500,000 today and place it on a bank savings account…

A: Assuming college debut happens in 18th year, Duration of the fund (n) = 18 years = 72 quarters r =…

Q: Suppose that you want to create a "college fund" for your newborn child and place $300 in a bank…

A: Answer -    Future Value Formula -  = P [ (1+i)n - 1] / I   Given, P = 300 i = 0.07 n = 20 years…

Q: 0,000 now for the college education of his 2 year old son. If the fund earns 14% effective, how much…

A: The given problem can be solved using PMT and FV function in excel. FV function computes amount…

Q: I am setting up a fund for my son to go to college. I figure that he will need Php50,000 by the time…

A: Future value (FV) = Php. 50,000 Annual interest rate = 5.75% Monthly interest rate (r) = 5.75%/12 =…

Q: Revere College predicts that in 18 years it will take $200,000 to attend the college for four years.…

A: Present Value  = Future value / (1+rate)^n Where, Future Value = $200000 n = 18*12 = 216 r= 9%…

Q: 3. Tatsumi invested Php 10,000 now for the college education of his three-year old son. If the fund…

A: Amount invested (A) = Php 10000 Duration till 18th age = 15 years Let the amount son will get from…

Q: . If Jennifer contributes $500 every quarter into her superannuation fund for the next 45 years, how…

A:

Q: Starting on her 30th birthday, a woman will invest an amount every year on her birthday in an…

A: FVA FORMULA: FVA=A×1+RN-1R

Q: Millet wants to provide a 200,000 graduation gift for her daughter mae is now 16 years old. She…

A: We'll use compound interest formula to determine the amount of deposit (principal amount): A=P1+rnnt…

Q: Mrs. Christell Lee deposited Php50,000 now in an account for the college education of her 3-yeard…

A: Future value from present value concept is used to determine the value of deposits before starting…

Q: Your daughter needs to be able to draw $50,000 a year from her college savings fund (you started…

A:

Q: A family wants to have a $160,000 college fund for their children at the end of 15 years. What…

A: Using excel PMT function

Q: on. How much should be deposited?

A: Present Value of Annuity: It represents the present worth of the future value of the annuity and is…

Q: Anthony and Michelle Constantino just got married and received ​$28,000in cash gifts for their…

A: Data given: Amount received =$28,000 PV=Amount to be invested = $28000 /2 = $14000 r=Rate = 10%…

Q: The Turners have 10 years to save a lump-sum amount for their child’s college education. Today a…

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

Q: Suppose you make an annual contribution of P9,993 each year to a college fund for a niece. He is 6…

A: Annual contribution (P) = P 9,993 Period from 6th year to 19th year (n) = 13 Annual interest rate…

Q: Holly wants to have $200,000 to send a recently born child to college. She sets up a 529 plan and…

A: Using excel PMT function

Q: A man invested P50,000 now for the college education of his 2-year old son. If the fund earns 14%…

A: Future value can be calculated using FV (rate, nper, pmt, [Pv], [type]) Rate The interest rate Nper…

Q: Millet wants to provide a P200,000 graduation gift for her daughter Mae who is now 16 years old. She…

A: Present value = Future value/(1 + r)n Present value = Amount needed to be deposited Future value =…

Q: Clarissa wants to fund a growing perpetuity that will pay $10,000 per year to a local museum,…

A: Present value of the growing perpetuity is the amount she needs to fund today This can be calculated…

Q: A mother wishes to put enough money in a fund today for her son to attend college starting in 10…

A: Determine the value of fund at the end of 10 years assuming that the college fees is to be paid at…

Q: Jean invests $1000 in Year 1 in a socially responsible fund, and doubles the amount each year after…

A: a) Computation:

Q: Arnett College predicts that in 18 years it will take $⁢350,000 to attend the college for four…

A: Amount =P 1 +R100N Where P = Principal amount r = Rate of Interest n = Number of Years / Months

Q: A family wants to have a $220,000 college fund for their children at the end of 16 years. What…

A: The series of regular payment at the end of each specified intervals is known as ordinary annuity.…

Q: A family want to have a $241,000.00 higher education fund for their children at the end of 22 years.…

A: The calculation is:

Q: 1) millet wants to provide a ₱200,000 graduation gift for her daughter mae who is now 16 years old.…

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