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

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?

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%)⁴
18			$297,035.12	=D14/((1+D6)^H9)
19
20		Hence the amount to be invested today is	$297,035.12
21

jeff jeffy answered 2 years ago

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 will be have to round numbers very often so you decided to create your own...

/*You will be have to round numbers very often so you decided to create your own function round_off() that will receive the number to be rounded and the number of decimal digits that the number should be rounded to and will return the value rounded to the specified number of decimal digits. You need to create a program to test the function. It will ask the user to enter the double precision real number to be rounded and a whole...

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.

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.

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

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.

Question