In a family members will, they would like to establish a perpetual trust to provide for the maintenance of a school's learning lab. If the annual maintenance is fixed at $12,500 per year and the trust can earn 5% interest, how much money must be set aside in the trust?

In a family members will, they would like to establish a perpetual trust to provide for the maintenance of a school's learning lab. If the annual maintenance is fixed at $12,500 per year and the trust can earn 5% interest, how much money must be set aside in the trust?

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

See similar textbooks

Related questions

Q: 5%, what amount must you donate to endow the scholarship?

A: Present Value of Perpetuity: It refers to the present worth of annual cash flows having an infinite…

Q: When will the girl receive the money if the fund is invested at 8% compounded quarterly?

A: Present Value: It represents the current worth of a future sum of money or future cash flows. To…

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: 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: On the day his son was born, a father decided to establish a fund for his son's college education.…

A: Annual withdrawal = 200,000 Period of withdrawal = 4 Years Interest rate (r) = 9% Number of annual…

Q: A generous benefactor to DePaul plans to make a one-time endowment which would generate $15,000 of…

A: Perpetuity in finance is the annual or regular stream of cash flows that is paid for an indefinite…

Q: COMPLETE THE CALCULATIONS ON PAPER FIRST AND WRITE THE ANSWERS IN THE TABLE: What sum of money must…

A: Compound interest is the interest computed on the original principal of a deposit or loan as well as…

Q: An alumnus establishes a perpetual endowment fund to help Saint Louis University. What amount must…

A: Given: Income to be produced = $100,000 Interest rate = 8%

Q: Alain Dupre wants to setup a scholarship fund for his school. The annual scholarship payment is to…

A: The equivalent annual deposit is the periodic payment made towards the acquisition of an asset or…

Q: To benefit the ISU College of Business, Bill Vickers would like to establish a “perpetual”…

A: Future Value (FV)= $210,000 per year Time period (n)= 13 years Annual return (i)= 4.1 percent…

Q: Creekside Engineering wants to establish an engineering scholarship in honor of its founder, Jane…

A: Capitalized cost is referred as an expenses that are added based on the cost of the fixed asset on…

Q: You want to endow a scholarship that will pay $11,000 per year forever, starting one year from now.…

A: In the given question we require to calculate the amount of donation to receive $11000 per year…

Q: An endowment fund is providing an annual scholarship of P50,000 for the first five years, P60,000…

A: Present Value: The present value is the value of cash flow stream or the fixed lump sum amount at…

Q: An annuity that pays out 30,000 a year for 20 years (paid at the beginning of each year) and b.…

A: In this question one needs to find the payment per month. But before doing that one needs to…

Q: a college begins a capital campaign to create a fund to provide scholarships to worthy students, If…

A: Given: Scholarship amount (PMT)=$200000Interest rate =7% or 0.07

Q: By the condition of a will, the sum of P 20,000 is left to a girl to be held in trust fund by her…

A: Time will tell worth of cash changes as it complete long duration of Investement. it will tell value…

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: 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: After a retiring from a successful business career, you would like to make a donation to your…

A: Given, The Donation made is $2,000,000 Returns is 5.5%

Q: Granny Gums has established a scholarship at the Martin College of Dentistry. She will make deposits…

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: A fund is to be donated by a wealthy man to provide annual scholarships to deserving students. The…

A: Fund grant for each year = P120,000 for 5 years Grant each quarter = P30,000 for next 5 years Grant…

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: Tom and Sandy have set up a sinking fund in order to have $18,000.00 in 4 years for their child's…

A: Using excel PMT function

Q: You are head of the Schwartz Family Endowment for the Arts. You have decided to fund an arts school…

A: Effective 4-year Interest Rate = (1+ Interest Rate)^4 - 1 Effective 4-year Interest Rate =…

Q: A recent alumnus of your university gifted money to the school to fund annual scholarships for…

A: This question require us to compute the amount of gift which will provide $50000 annual scholarship…

Q: You are head of the Schwartz Family Endowment for the Arts. You have decided to fund an arts school…

A: Present Value = PaymentEffective Interest Rate Effective Interest Rate = (1+i)t-1

Q: In 1988, your Grandmother left you a trust fund with $10,000 in the account that has been earning 8%…

A: We will use the concept of time value of money here. As per the concept of time value of money the…

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: Find the present worth of this cost.

A: An endowment fund is the fund set aside and invested, the earnings of which will be utilized for the…

Q: A rather wealthy man decides to arrange for his descendants to be well educated. He wants each child…

A: Computation:

Q: Ann and Tom want to establish a fund for their grandson's college education. What lump sum must…

A: PV termed as Present value which is current or the present amount of money which is deposited in…

Q: To create a college fund, a parent makes a sequence of 20 yearly deposits of $4000 each year in a…

A: given information pmt = $4000 interest annually = 2.8% time period = 20 years

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: You wish to establish a permanent scholarship at Bond University providing a worthy student with…

A: In this we have to calculate the present value of perpetuity.

Q: A successful investor has decided to set up a scholarship fund for deserving students at her alma…

A: The annual scholarship to be paid there should be sufficient amount today considering the interest…

Q: By the conditions of a will, the sum of P20,000 is left to a girl to be held in a trust fund by her…

A: When the interest is computed on the principal balance along with the accumulated interest is…

Q: A donor gives $100,000 to a university, and specifies that it is to be used to give annual…

A: Present value is the sum of money that must be invested in order to achieve a specific future goal.…

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: An endowed scholarship is one funded by a single deposit in a permanent scholarship account by a…

A: EAR is the actual return earned on an investment by the investor taking into account the effect of…

Question

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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 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 future value in Excel, see Appendix C.
The Pithybottoms want to make a donation to set up a scholarship trust fund at Hinose College. The fund is to support payments of $5,000 at the end of every three months in perpetuity. If the fund earns 7.5% compounded quarterly, how much must they donate?
. James decided to fund a school in Orange County in perpetuity. The first payment will be made three years from today (at the end of year three) and will be $5,320. Each year after that, the school will receive payment from James annually. The payment will increase at a rate of 3% per year after the first payment. If the annual interest rate is 9%, what is the present value of this endowment?
Linda O’Shay deposited $50,000 in a savings account as a perpetual trust. She believes the account will earn 8% annual interest during the first 10 years and 4% interest thereafter. The trust is to provide a uniform end-of-year scholarship at the university. What uniform amount could be used for the student scholarship each year, beginning at the end of the first year and continuing forever?
A generous alum would like to establish an endowment that would sponsor a student organization's conferences in perpetuity. A one-time cost of $500,000 must be paid today to purchase supplies for the conference. The conference is held once every four years and costs $90,000 . The first conference will take place at the end of year 4 . The alum's gift is invested in an account that earns 4% annually. How much would the alum need to place in the endowment to be able to sponsor the student organization's conferences? [Enter your answer with no dollar sign or comma.]
A donor established a new scholarship that will pay $5,000 every 6 months to a deserving Kelley student. The scholarship will be awarded for the first time in November of 2021 (12 months from today). The donor decides that the scholarship should be provided in perpetuity. The IU Foundation manages investments like this for the Business School. The Foundation anticipates earning an APR of 8% per year on the invested funds, compounded monthly. What is the amount of the donation that must be given to the IU Foundation today to fully endow this Kelley scholarship?
A fund is to be donated by a wealthy man to provide annual scholarships to deserving students. The fund will grant P50,000 for each year for the first 5 years at 8% compounded monthly, P80,000 for each year for the next 5 years at 8% compounded quarterly, and P100,000 each year thereafter at 8% compounded semi-annually interest,. The scholarship will start one year after the fund is established. What is the amount of the donation?
By the condition of a will, the sum of $ 2,000 is left to a girl to be held in trust fund by her guardian until it amounts to $ 5,000, when will the girl received the money if the fund is invested at 8% compounded quarterly? engineering econ
A donor established a scholarship that will pay $15,000 per year to a Kelley student. The scholarship will be awarded for the first time in September of 2023 (i.e., the first payment occurs three years from now). The donor decides that the scholarship should be provided in perpetuity. The IU Foundation manages investments like this for the Business School. The Foundation anticipates earning an APR of 5.6% per year on the invested funds. What is the amount of the donation that must be given to the IU Foundation today to endow this Kelley scholarship?
A charity will be donated by a wealthy man to provide annual scholarships to deserving students. The charity will grant $120,000 each year for the first 5 years, $30,000 per quarter for the next 5 years and $10,000 each month thereafter . The scholarship will start one year after the fund is established. What is the amount of the donation if i = 12% compounded annually?
Ann and Tom want to establish a fund for their grandson's college education. What lump sum must they deposit at a 7% annual interest rate, compounded monthly, in order to have $30,000 in the fund at the end of 15 years?