# Calculating Present and Future Value and Loan Amortizations

Please see the attached file.

Complete problems 2, 4, 13, 17, 26, 30, 37, 38, & 40 on text pp. 207-211 of Ch. 6.

2. If you require a 9 percent return on your investments, which would you prefer?

a. $5,000 today

b. $15,000 five years from today

c. $1,000 per year for 15 years

4. The Mutual Assurance and Life Company is offering an insurance policy

under either of the following two terms:

a. Make a series of 12 payments of $1,200 at the beginning of each of the

next 12 years (the first payment being made today)

b. Make a single lump-sum payment today of $10,000 and receive coverage

for the next 12 years

If you had investment opportunities offering an 8 percent annual return,

which alternative would you prefer?

13. You decide to purchase a building for $30,000 by paying $5,000 down and assuming

a mortgage of $25,000. The bank offers you a 15-year mortgage requiring

annual end-of-year payments of $3,188 each. The bank also requires you to

pay a 3 percent loan origination fee, which will reduce the effective amount the

bank lends to you. Compute the annual percentage rate of interest on this loan.

17. Construct a loan amortization schedule for a 3-year, 11 percent loan of

$30,000. The loan requires three equal, end-of-year payments.

26. IRA Investments develops retirement programs for individuals. You are 30

years old and plan to retire on your 60th birthday. You want to establish a plan

with IRA that will require a series of equal, annual, end-of-year deposits into

the retirement account. The first deposit will be made 1 year from today on

your 31st birthday. The final payment on the account will be made on your

60th birthday. The retirement plan will allow you to withdraw $120,000 per

year for 15 years, with the first withdrawal on your 61st birthday. Also at the

end of the 15th year, you wish to withdraw an additional $250,000. The retirement

account promises to earn 12 percent annually.

What periodic payment must be made into the account to achieve your

retirement objective?

30. Crab State Bank has offered you a $1,000,000 5-year loan at an interest rate of

11.25 percent, requiring equal annual end-of-year payments that include both

principal and interest on the unpaid balance. Develop an amortization schedule

for this loan.

37. Using an online mortgage financial calculator (see http://moyer.swlearning.com),

solve for the monthly savings and the number of months it takes to recoup the

refinancing costs in problem 34. (Hint: Under the question "What will it cost

you?" enter 2850 for "Other" and 0 for all other items.)

38. Use an online savings or retirement calculator (see http://moyer.swlearning.

com) to solve following problem: You are now 30 years old and would like to

accumulate $2,000,000 in your retirement account at age 65. You currently

have $50,000 saved in the retirement account. How much must you set aside at

the end of each year over the next 35 years to attain your retirement goal if

the account earns 6.5 percent per year? How much would you have to set aside

each year if you currently have a zero balance in the retirement account?

40. Using one of the mortgage loan calculators available on the Internet (see

http://moyer.swlearning.com), do a loan amortization for a $150,000, 30-year

mortgage loan at a rate of 5 percent and answer the following questions:

a. How much is the monthly payment?

b. How much of the first payment (i.e., year 1, month 1) goes towards interest?

How much toward principal reduction?

c. How much of the 180th payment (i.e., year 15, month 12) goes toward

interest? How much toward principal reduction?

d. What is the remaining balance on the loan at the end of the fifth year?

https://brainmass.com/business/annuity/calculating-present-and-future-value-and-loan-amortizations-206573

#### Solution Preview

Complete problems 2, 4, 13, 17, 26, 30, 37, 38, & 40 on text pp. 207-211 of Ch. 6.

2. If you require a 9 percent return on your investments, which would you prefer?

a. $5,000 today

b. $15,000 five years from today

PV = FV/ (1+R)N where PV is the present value

FV is the future value

R is the interest rate

N is the period

PV = 15,000/(1 + 0.09)5

= 9,748.97

c. $1,000 per year for 15 years

PVA = W x 1 - 1 where PVA is the present value

(1 + R)N W is the amount required of annuity each year

R R is the interest rate

N is the period

PVA = 1,000 x 1 - 1

(1 + 0.09)15

0.09

PVA = 8,060.69

Answer: I would prefer choice b. because it provides highest present value.

4. The Mutual Assurance and Life Company is offering an insurance policy under either of the following two terms:

a. Make a series of 12 payments of $1,200 at the beginning of each of the next 12 years (the first payment being made today)

You have to use annuity due to find the fair value.

PVA = W x 1 - 1 x (1 + i) where PVA is the present value

(1 + i)n W is the amount required to pay yearly

i i is the interest rate

n is the period

PVA = 1,200 x 1 - 1 x (1 + 0.08)

(1 + 0.08)12

0.08

PVA = 9,766.76

b. Make a single lump-sum payment today of $10,000 and receive coverage for the next 12 years

If you had investment opportunities offering an 8 percent annual return, which alternative would you prefer?

I would prefer alternative a. because the present value is lower.

13. You decide to purchase a building for $30,000 by paying $5,000 down and assuming

a mortgage of $25,000. The bank offers you a 15-year mortgage requiring annual end-of-year payments of $3,188 each. The bank also requires you to pay a 3 percent loan origination fee, which will reduce the effective amount the bank lends to you. Compute the annual percentage rate of interest on this loan.

Actual amount to be lent = $25,000 - ($25,000 x 3%) = $24,250

PVA = W x 1 - 1 where PVA is the present value

(1 + R)N W is the amount required of annuity each year

R R is the interest rate

N is the period

$24,250= 3,188 x 1 - 1

...

#### Solution Summary

This solution is comprised of a detailed explanation to calculate present and future value and loan amortizations and construct a loan amortization schedule for a 3-year, 11 percent loan of $30,000.

Calculating Present and Future Value and Loan Amortizations

2.

If you require a 9 percent return on your investments, which would you prefer?

a. $5,000 today

b. $15,000 five years from today

c. $1,000 per year for 15 years

4.

The Mutual Assurance and Life Company is offering an insurance policy under either of the following two terms:

a. Make a series of 12 payments of $1,200 at the beginning of each of the next 12 years (the first payment being due today)

b. Make a single lump sum payment today of $10,000 and receive coverage for the next 12 years

If you had investment opportunities offering an 8 percent annual return, which alternative would you prefer?

13.

You decide to purchase a building for $30,000 by paying $5,000 down and assuming a mortgage of $25,000. The bank offers you a 15 year mortgage requiring annual end of year payments of $3,188 each. The bank also requires you to pay a three percent loan origination fee, which will reduce the effective amount the bank lends to you. Compute the annual percentage rate of interest on this loan.

17.

Construct a loan amortization schedule for a 3-year, 11 percent loan of $30,000. The loan requires three equal end of year payments.

26.

IRA Investments develops retirement programs for individuals. You are 30 years old and plan to retire on your 60th birthday. You want to establish a plan with IRA that will require a series of equal, annual, end of year deposits into the retirement account. The first deposit will be made 1 year from today on your 31st birthday. The final payment on the account will be made on your 60th birthday. The retirement plan will allow you to withdraw $120,000 per year, for 15 years, with the 1st withdraw on your 61st birthday. Also, at the end of your 15th year, you wish to withdraw an additional $250,000. The retirement plan promises to earn 12 percent annually.

What periodic payment must be made into the account to achieve your retirement objectives?

30.

Crab State Bank has offered you a $1,000,000 5-year loan at an interest rate of 11.25 percent, requiring equal annual end of year payments that include both principal and interest on the unpaid balance. Develop an amortization schedule for this loan.

38.

You are now 30 years old and would like to accumulate $2,000,000 in your retirement account at age 65. You currently have $50,000 saved in the retirement account. How much must you set aside at the end of each year over the next 35 years to attain your retirement goal if the account earns 6.5 percent per year? How much would you have to set aside each year if you currently have a zero balance in the retirement account?

40.

Do a loan amortization for a $150,000, 30 year mortgage loan at a rate of 5% and answer the following questions:

a. How much is the monthly payment?

b. How much of the 1st payment is goes toward interest? How much toward principal reduction?

c. How much of the 180th payment (year 15, month 12) goes toward interest? How much toward principal reduction?

d. What is the remaining balance on the loan at the end of the fifth year?