Question

In: Finance

You have decided to create a perpetual fund to support the Boston Harbor Islands and would...

  1. You have decided to create a perpetual fund to support the Boston Harbor Islands and would like the first payment to be made in 5 years. Interest rates are 6% and you would like the payments to increase by 2% each year. How much should you invest today if you want the first payment to be $15,000 in 5 years?

How should I solve this using an hp10bii+ calculator? Could you please show me the steps?

Solutions

Expert Solution

A B C D E F G H I J K L M
2
3 First payment starts at year 5
4 First payment value $15,000
5 Growth rate of payment 2%
6 Interest rate 6%
7
8 The amount required today will be the present value of future cash flows.
9 Year 0 1 2 3 4 5 6
10 Payment $15,000 $15,300 $15,606 =J10*(1+$D$5)
11
12 Present value of payments at year 4 =Present value of growing perpetuity at year 4
13 =$15,000 / (6%-2%)
14 $375,000.00 =D4/(D6-D5)
15
16 Present value of payments =$375,000*(P/A,6%,4)
17 =$375,000 / (1+6%)4
18 $297,035.12 =D14/((1+D6)^H9)
19
20 Hence the amount to be invested today is $297,035.12
21

Related Solutions

1. You have recently decided to create an investment portfolio. You have been told that a...
1. You have recently decided to create an investment portfolio. You have been told that a “standard” portfolio for someone in your age range is 80% equity and 20% debt. Thus, you have specifically honed in on three specific assets that you are going to use: Common Stock A: Firm is expected to pay $5 next year in dividends, with an expected growth rate of 10% for the following three years after that, followed by 2% forever after that. The...
As manager of the St. Cloud Theatre​ Company, you have decided that concession sales will support...
As manager of the St. Cloud Theatre​ Company, you have decided that concession sales will support themselves. The following table provides the information you have been able to put together thus​ far: Item                Selling Price               Variable Cost             % of Revenue Soft Drink       $1.20                          $0.60                          26 Wine               $1.80                          $0.95                          26 Coffee             $1.00                          $0.35                          29 Candy             $1.00                          $0.35                        19 Last year�s manager, Jim Freeland, has advised you to be sure to add 10% of variable cost as a waste allowance for all...
You have found a mutual fund that you would like to invest in that will earn...
You have found a mutual fund that you would like to invest in that will earn 5% annually. If you invest $1000 each year for the next 10 years, how much will you have at the end of those 10 years, approximately? $18,753 $10,000 $12,578 $1,628
You would like to purchase a car that costs $32,000. You have decided to finance the...
You would like to purchase a car that costs $32,000. You have decided to finance the car with a four-year car loan. If the APR (annual percentage rate) is 5 percent, compute your monthly payment. Construct a loan amortization table in Excel for the car loan.   You should do the problem in Excel using monthly payments and should submit the spreadsheet.
The Kucharskis have decided to invest in a college fund for their young son. They invested...
The Kucharskis have decided to invest in a college fund for their young son. They invested $30,000 in a deferred annuity that will pay their son at the beginning of every month for 4 years, while he goes to college. If the account earns 3.00% compounded monthly and the annuity payments are deferred for 15 years, what will be the size of the monthly payments?
Identify the accounting theories that you have learnt that would support a research study in the...
Identify the accounting theories that you have learnt that would support a research study in the area of stakeholder engagement. Explain the relevance of the theories through reflecting on your viewpoint about to whom the firm is responsible.
you have an idea to improvr patient care that you would like upper management to support...
you have an idea to improvr patient care that you would like upper management to support and fund . what type of communication tool wuld ypu use to present your idea and why
1a) You would like to purchase a car that costs$34,000.  You have decided to finance the...
1a) You would like to purchase a car that costs $34,000.  You have decided to finance the car with a six-year car loan.  If the APR (annual percentage rate) is 4.25 percent, compute your monthly payment.1b) Construct a loan amortization table in Excel for the car loan in Problem 1a.   You should do the problem in Excel using monthly payments and should submit the spreadsheet.
Kelly Fernandez and Michael Webster have decided to create a business. They have financing available and...
Kelly Fernandez and Michael Webster have decided to create a business. They have financing available and have a well-developed business plan. However, they have not yet decided which type of legal business structure would be best for them. Required Write a report for these two individuals outlining the types of situations in which the CORPORATE form of legal structure would be the best choice.
You are a new consultant with the Boston Group and have been sent to advise the...
You are a new consultant with the Boston Group and have been sent to advise the executives of penury Company. The company recently acquired product line L from an out-of-state concern and now plans to produce it, along with its old standby K, under one roof in a newly renovated facility. Management is quite proud of the acquisition, contending that the larger size and related cost savings will make the company far more profitable. The planner results of the month’s...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT