eremiah Wood wants to set up a fund to pay for his daughter's education. In order to pay her expenses, he will need $25,000 in four years, $26,900 in five years, $28,700 in six years, and $29,700 in seven years. If he can put money into a fund that pays 5 percent interest, what lump-sum payment must Jeremiah place in the fund today to meet his college funding goals? Round the answer to the nearest cent. Round PV-factor to three decimal places. $__________

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: Your grandfather wants to establish a scholarship in his father’s name at a local university and has…

A: The question is based on the concept of present value of perpetual fixed income. The present value…

Q: Tom and Sandy have set up a sinking fund in order to have $18,000.00 in 4 years for their child's…

A: Money to accumulate in Sinking Fund= $18,000.00 Time period= 4 years Interest rate= 6.84% compounded…

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: Rase High School wants to set up a scholarship fund to provide five $3,000 scholarships for the next…

A: Hi, since you have posted multiple questions, I will answer the first one only, as per the…

Q: Demitri's parents begin saving for his college fund when Demetri is 10 years old. They invest $5,000…

A: Money Deposited when Demetri is 10 = $5000 Interest rate =1.2% compounded annually Years = 18-10 = 8…

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

A: The present value function or concept can be used to determine the present value of a future sum or…

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: RIVATE UNIVERSITY & Fees $25,100 & Board $8,000 Supplies $1,300 xpenses $750 tal (1 Year): 351 50

A: First we have to calculate the college expenses and earnings and than we need to calculate how much…

Q: Mohammed estimate that he will need RO 10,000 in 5 years to fund his university education. How much…

A: Compound interest is referred as the in interest calculated on principal along with all accumulated…

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: You want to endow a scholarship that will pay $11,000 per year forever, starting one year from now.…

A: Framework:If P is the perpetuity and r is the discount rate, then PV of a perpetuity = P / rAmount…

Q: Jamal plans to attend a 4-year private university. He will receive $8,200 in scholarships and grants…

A: In this problem we have to find expenses of university programs and deduct earnings of each year to…

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

A: The present value is the discounted amount of the annuities deposited or received and the redemption…

Q: Will and Jane Sparks are establishing a college fund for their 1-year-old daughter, Jennifer. They…

A: As per the given information: Amount = $40,000Annualized rate of return (r) = 8%No. of years (n) =…

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: Parvati wants to donate enough money to Camosun College to fund an ongoing annual bursary of $1,000…

A: We need to find present value of future donation by using this equation Present value =FV(1+i)n…

Q: Mr. Bates is creating a college investment fund for his daughter. He will putin $850 at the end of…

A: The question is based on the concept of calculation of future value of period fix payment, which is…

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: Allain Dupre wants to set up a scholarship fund for his school. The annual scholarship payment is to…

A: Using excel PV function

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: Don Solomon wants to set up a scholarship program with his alma mater. If ₱778111 is needed per year…

A: Since the scholarship program will be run to perpetuity hence, to pay the annual scholarship, the…

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

A: Given information: Future value is $150,000 APR is 7% Number of years is 6

Q: to adopt a charity foundation once she receives her money. She promised to donate annually to her…

A: The present value is the amount without the interest rate and which is equivalent to the all future…

Q: When Xian was born, his father Brian deposited a sum of money for the college education of Xian.…

A: Present Value = Future Value x 11+in

Q: A man who won 730,000 pesos in a lottery decided to place 50% of his winnings in a trust fund for…

A: A man won a lottery of worth = 730,000 pesos He invested 50% in trust funds for his son education =…

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: A couple with a newborn son wants to save for their child's college expenses in advance. The couple…

A: Given Information: Amount required for college fund = $50,000 Annual Interest rate = 8% Duration of…

Q: Mr. and Mrs. Megabucks would like to set up a college fund for their grandson. They want him to be…

A: Given: N = 24, FV = 0, PMT = 1750, rate = 2.4%/12 = 0.2

Q: With the work-study and her family's contribution, for how many years of college will be paid?…

A: Financial planning refers to a process of planning finances by an individual to identify their…

Q: local businessman has set up a school fund that will last forever that can earn 3.1% annually. How…

A: The given problem deals with the concept of perpetuity. A perpetuity is a series of uniform cash…

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: Sarah Bishop, having become a very successful engineer, wishes to start an endowment at UTM that…

A: Diagram:

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

A:

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: A rather wealthy man decides to arrange for his descendants to be well educated. He wants each child…

A: Computation:

Q: A wealthy man desires to award annual scholarships to deserving ECE students for 5 years. The…

A: Scholarship in year 1 = P 120,000 Scholarship in year 2 and year 3 = P 150,000 Scholarship in year 4…

Q: Amanda Weet who is six years old has been gifted $100,000 (after-tax) towards a college fund. Her…

A: The internal rate of return or IRR is used in capital budgeting to determine the profitability of…

Q: Parvati wants to donate enough money to Camosun College to fund an ongoing annual bursary of $2,250…

A: We need to find present value of future donation by using this equation. Present value =FV(1+r)n…

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: 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: Parvati wants to donate enough money to Camosun College to fund an ongoing annual bursary of $1,500…

A: We need to find present value of donation by using this equation Present value =FV(1+i)n Where FV…

Q: Jeremiah Wood wants to set up a fund to pay for his daughter's education. In order to pay her…

A: We will find present value of the future requirement of funds to know what amount we must invest to…

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: James decided to fund a school in Orange County in perpetuity. The first payment will be made three…

A: First payment three years from now is $5,320 Growth rate is 3% Annual Interest rate is 9% To Find:…

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

A: An annual percentage rate (APR) is the interest rate to be paid each year on a loan, credit card, or…

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

A: RATE  1.  4% 2.  5% YEARS 15 PRESENT VALUE $0 FUTURE VALUE $220,000

Q: You plan to be a doting parent for your three adorable tots (you love to plan ahead). You plan to…

A: For Child 1: At the end of 18 years, amount required for his education would be, present value of an…