Explore BrainMass
Share

Explore BrainMass

    Calculating Present and Future Value and Loan Amortizations

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com October 9, 2019, 10:03 pm ad1c9bdddf
    https://brainmass.com/business/annuity/calculating-present-and-future-value-and-loan-amortizations-206573

    Attachments

    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.

    $2.19