Parvati wants to donate enough money to Camosun College to fund an ongoing annual bursary of $1,000 to a deserving finance student. How much must she donate today in order for the first payment to to be given out right away? Assume an interest rate of jq=4%.

Parvati wants to donate enough money to Camosun College to fund an ongoing annual bursary of $1,000 to a deserving finance student. How much must she donate today in order for the first payment to to be given out right away? Assume an interest rate of jq=4%.

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

Related questions

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

A: Amount needed in 4 years (CF1) = $25,000 Amount needed in 5 years (CF2) = $26900 Amount needed in 6…

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

A: The periodic payment can be made monthly, quarterly, semi-annually or annually. Periodic payment is…

Q: Carolyn is helping to save for her granddaughter’s college fund. It will probably take 18 years…

A: Future value required (FV) = $150,000 Interest rate (r) = 6% Number of annual payments (n) = 18…

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: Mr. and Mrs. Revilla decided to sell their house and to deposit the fund in a bank. After computing…

A: Determine the present value of the annual withdrawals after 5 year of deposit using the Excel PV…

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

A: The question gives the following information:

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: Suppose your parents have decided that after your graduation at the end of the year they would start…

A: The Present Value of Annuity (PVAF) is the cash value of all future annuity payments discounted at a…

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: You want to set up a college savings plan for your daughter. She is currently 10 years old and will…

A: An Annuity is a series of payments of fixed amounts and at fixed intervals. These can be of two…

Q: Kate Rose is setting up an annuity for a memorial scholarship. What lump sum does she need to set…

A: Given information: Annual interest rate is 7% Annuity payment is $2,500 Number of years is 10

Q: For this, he needs to borrow $4M from a local bank. The bank’s financing terms allows Hanifa to…

A: This is a problem involving discounting loan. This this type of loan, the bank collects the interest…

Q: Meredith, who is single, would like to contribute $6,000 annually to her Roth IRA. Her AGI is…

A: Roth IRA is a scheme for contribution into retirement account by the citizens of the United States…

Q: hat do you think the future worth of her investment will be? b. How much interest will she earn?

A: Interest: Interest is the income generated from investing an amount in a bank or any other financial…

Q: Suppose you make an annual contribution of BD100 each year to a college education fund for a niece.…

A: Here, Annual Deposits is BD100 Interest Rate is 6.5% Current Age is 4 years Last Deposit is made on…

Q: Elena wanted to invest in a trust fund. She borrows from a credit corporation that charges 8% simple…

A: Borrowings are the liability of the company which is used to finance the requirement of the funds.…

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.…

Q: Skye plans to attend a 4-year public university. She will receive $4,300 in scholarships and grants…

A: Savings refers to the disposable income which is left by incurring all expenses. In order to…

Q: The Chan family would like to establish a bursary at Camosun College. The bursary pay $2,000 to a…

A: This payment is a perpetuity, meaning that this payment will occurs indefinitely. In a perpetuity,…

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: a young woman, 22 years old, has just graduated from college. she accepts a good job and desires to…

A: Dear student, we need to use excel NPER function to calculate number of years of deposit that…

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: is thinking of establishing a fund for his daughter’s college education. He wants his daughter to be…

A: There is need of planning for savings for the education of the children so that they can study…

Q: Janet's parents want her to go to the same college that they did. They decided to pay a lump sum…

A: Lump sum Payment as on today (PV)=$126,000 Duration (n)=8*4=32 periods Rate per period (i)=6%4=0.015

Q: Mr. J. J. Parker is creating a college fund for his daughter. He plans to make 15 yearly payments of…

A: GIVEN, YEARLY PAYMENT = $1500 N = 15 YEARS R = 12% LET FOUR YEARLY WITHDRAWAL = A withdrawal from…

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

A: Introduction Sinking Fund A sinking fund is an account earning compound interest into which you make…

Q: The Pithybottoms want to make a donation to set up a scholarship trust fund at Hinose College. The…

A: When the cash flow are regular and for an indefinite time period, the cash flow is knows as…

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: A wealthy donor wants to establish a scholarship that pays an award of $1,000 in perpetuity at the…

A: Present value refers to the current valuation for a future sum. Investors determine the present…

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

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: A mother is thinking about funding her daughter’s medical education in 6 years when she is expected…

A: A concept through which it is studied that the current worth of money is higher than its future…

Q: To help with his child's college fund, Ravi needs to invest. Assuming an interest rate of 2.23%…

A: Interest Rate 2.23% Time Period 15 Future Value $ 94,300.00

Q: Sean expects to receive $300,000 in 5 years from a trust fund. If a bank loans money at an interest…

A: In the given case, Seam is expected to receive $300,000 in 5 years from a trust fund. He can borrow…

Q: Tala McLouf, a 21-year-old BBA graduate, likes to plan for her future ahead, and would like to save…

A: Since the question has more than 3 sub-parts, the first 3 subparts are answered. If you want the…

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: Laura needs to invest to help with her child's college fund. How much would she have to invest to…

A: Future Value = $63,400 Time Period = 13 Years Interest Rate = 2.21%

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: Ann was given a gift of $10,000 by her grandparents. She has a choice between 2 accounts to invest…

A: Option 1- Present value of gift (PV)= $10,000 Interest rate (r)= 2.35% compounded monthly= 0.001958…

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: Mr. Crabapple wants to donate money now for an account that will allow a favored charity to make…

A: Annnuity at the end of each year from year 19 to 44 = $17,000 Time = 26 years Rate = 4.3% annually…

Q: I need help working this problem out. Figuring out what table to use, whether to use: compound…

A: Hi, this is an example of simple interest. Hence no table ca be used, as the interests are neither…

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

Question

Parvati wants to donate enough money to Camosun College to fund an ongoing
annual bursary of $1,000 to a deserving finance student.
How much must she donate today in order for the first payment to to be given out
right away? Assume an interest rate of jq=4%.
Your Answer:
Answer

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1 Analysis

VIEW

Step 2 Calculation of present value of donation today

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Money Management and Achieving Financial Goals

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Your friend has a trust fund that will pay her the following amounts at the given interest rate for the given number of years. Calculate the current (present) value of your friends trust fund payments. For further instructions on present value in Excel, see Appendix C.
Your grandfather wants to establish a scholarship in his father’s name at a local university and has stipulated that you will administer it. As you’ve committed to fund a $25,000 scholarship every year beginning one year from tomorrow, you’ll want to set aside the money for the scholarship immediately. At tomorrow’s meeting with your grandfather and the bank’s representative, How much will need to deposit? rounded to the nearest whole dollar) so that you can fund the scholarship forever, assuming that the account will earn 5.50% per annum every year. The bank representative just reported that he misquoted the available interest rate on the scholarship’s account. Your account should earn 3.50%. The amount of your required deposit should be revised to?
Your daughter needs to be able to draw $50,000 a year from her college savings fund (you started from birth) to pay for college expenses to obtain a medical degree (assume she spends 4 years for bachelor, 4 years for med school, then additional 2 years as resident and yearly spending will be consistent from year to year). At start of her college career, she intends to invest her savings in government securities that should return 5.5% a year compuounded continuously. a. Obtain the equation for dP/dt and then find the genearl solution of P(t) with, as yet undetermined, initial value P_0. b. How large must your daughter's initial college savings be so that she can continue drawing her $50,000 income until she becomes a doctor?
Your daughter is expected to the university next year. It is estimated that she will need 10,000 each year for the for years university education. You are planning to deposit a lump sum in an account that will yield 10% per anum to cater for her university education. How much should be deposited?
Mr. and Mrs. Maglalang decide to set aside ₱ 500,000 today and place it on a bank savings account for their newborn daughter’s college education. How much will be available for college education when their daughter celebrates her debut, considering that They found an equity fund that offers an average interest rate of 6% compounded quarterly.
Your grandfather wants to establish a scholarship in his father’s name at a local university and has stipulated that you will administer it. As you’ve committed to fund a $15,000 scholarship every year beginning one year from tomorrow, you’ll want to set aside the money for the scholarship immediately. At tomorrow’s meeting with your grandfather and the bank’s representative, you will need to deposit ___________ (rounded to the nearest whole dollar) so that you can fund the scholarship forever, assuming that the account will earn 4.50% per annum every year. Oops! The bank representative just reported that he misquoted the available interest rate on the scholarship’s account. Your account should earn 7.00%. The amount of your required deposit should be revised to____________. This suggests there is (an inverse / a direct) relationship between the interest rate earned on the account and the present value of the perpetuity.
Clarissa wants to fund a growing perpetuity that will pay $10,000 per year to a local museum, starting next year. She wants the annual amount paid to the museum to gro by 5% per year. Given that the interest rate is 9%, how much does she need to fund this perpetuity?
Your grandfather wants to establish a scholarship in his father’s name at a local university and has stipulated that you will administer it. As you’ve committed to fund a $10,000 scholarship every year beginning one year from tomorrow, you’ll want to set aside the money for the scholarship immediately. At tomorrow’s meeting with your grandfather and the bank’s representative, you will need to deposit$200,000 (rounded to the nearest whole dollar) so that you can fund the scholarship forever, assuming that the account will earn 6.00% per annum every year.
Mrs. Maria Alading borrowed 20,000 pesos from her friend Ms. Petra Hausen to pay the tuition fee of her son. How much money will she pay Mrs. Hausen after a year, if an annual simple interest rate of 12 % is asked?
Melissa agrees to contribute $500 to the alumni fund at the end of each year for the next 4 years. Shannon wants to match Melissa's gift, but he wants to make a lump-sum contribution. If the current interest rate is 4.5% compounded annually, how much should Shannon contribute to equal Melissa's gift? (Round your answer to the nearest cent.)$
Allain Dupre wants to set up a scholarship fund for his school. The annual scholarship payment is to be $3,600 with the first such payment due four years after his deposit into the fund. If the fund pays 4.4%compounded annually , how much must Alain deposit?
Mr. Crabapple wants to donate money now for an account that will allow a favored charity to make $17,000 withdrawals at the end of each of years 19 to 44. How much should he contribute today if investment managers Dogwood Associates expect to earn returns averaging 4.3% per year on the charity's foundation account? (This is a 26-year deferred annuity, with $17,000 to be paid out at the end of each of years 19 to 44.) A. $128,584.54 B. $115,644.17 C $263,040.12 D. $123,283.36 E. $156,230.80