Explore BrainMass
Share

Explore BrainMass

    PV, EAR, APR

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

    1) Calculating Present Values. In the 1994 NBA draft, no one was surprised when the Milwaukee Bucks took "Big Dog" Robinson with the first pick. But Robinson wanted big bucks: a 13-year deal worth a total of $100 million. He had to settle for about $68 million over 10 years. His contract called for $2.9 million the first year, with annual raises of $870,000. So how big a bite did "Big Dog" really take? Assume a 12% discount rate. The answer is $34,006,704.09

    2) EAR versus APR. You have just purchased a new warehouse. To finance the purchase, you've arranged for a 30 year mortgage loan for 80 percent of the $1,450,000. purchase price. The monthly payment on this loan will be $9,800. What is the APR on this loan? The EAR? The answer is APR=9.55% EAR=9.98%

    Need help putting cell formulas on excel spread sheet.

    see attached word document

    © BrainMass Inc. brainmass.com October 9, 2019, 4:18 pm ad1c9bdddf
    https://brainmass.com/business/equivalent-annual-annuity/pv-ear-apr-28794

    Attachments

    Solution Summary

    Present Value calculations and EAR versus APR is examined.

    $2.19