Constructing a loan amortization schedule


Problem 1: 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

Problem 2: 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?

Problem 3: 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.

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

Problem 5: 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?

Problem 6: 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.

Problem 7: Using an online mortgage financial calculator (see https://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.)

Problem 8. Use an online savings or retirement calculator 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?

Problem 9: Using one of the mortgage loan calculators available on the Internet, 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?

Solution Preview :

Prepared by a verified Expert
Finance Basics: Constructing a loan amortization schedule
Reference No:- TGS02035863

Now Priced at $25 (50% Discount)

Recommended (91%)

Rated (4.3/5)