Explore BrainMass

Explore BrainMass

    Calcuating for Present Value

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

    Can you please show me how to solve the following problems in excel? Please note that PV stands for present value.

    PV of multiple cash flows: Jack Stuart has loaned money to his brother at an interest rate of 5.75 percent. He expects to receive $625, $650, $700, and $800 at the end of the next four years as complete repayment of the loan with interest. How much did he loan out to his brother? (Round to the nearest dollar.)

    PV of multiple cash flows: Hassan Ali has made an investment that will pay him $11,455, $16,376, and $19,812 at the end of the next three years. His investment was to fetch him a return of 14 percent. What is the present value of these cash flows? (Round to the nearest dollar.)

    PV of multiple cash flows: Pam Gregg is expecting cash flows of $50,000, $75,000, $125,000, and $250,000 from an inheritance over the next four years. If she can earn 11 percent on any investment that she makes, what is the present value of her inheritance? (Round to the nearest dollar.)

    Bond price: Briar Corp is issuing a 10-year bond with a coupon rate of 7 percent. The interest rate for similar bonds is currently 9 percent. Assuming annual payments, what is the present value of the bond? (Round to the nearest dollar.)

    PV of dividends: Cortez, Inc., is expecting to pay out a dividend of $2.50 next year. After that it expects its dividend to grow at 7 percent for the next four years. What is the present value of dividends over the next five-year period if the required rate of return is 10 percent?

    PV of dividends: Givens, Inc., is a fast growing technology company that paid a $1.25 dividend last week. The company's expected growth rates over the next four years are as follows: 25 percent, 30 percent, 35 percent, and 30 percent. The company then expects to settle down to a constant-growth rate of 8 percent annually. If the required rate of return is 12 percent, what is the present value of the dividends over the fast growth phase?

    © BrainMass Inc. brainmass.com June 4, 2020, 4:13 am ad1c9bdddf
    https://brainmass.com/business/finance/calcuating-present-value-550469

    Solution Preview

    Please see the attachment.

    Thanks for using BrainMass.

    . PV of multiple cash flows: Jack Stuart has loaned money to his brother at an interest rate of 5.75 percent. He expects to receive $625, $650, $700, and $800 at the end of the next four years as complete repayment of the loan with interest. How much did he loan out to his brother?
    PRESENT VALUE OF CASH FLOWS
    Future value $2,775
    Duration 4
    Interest rate 5.75%
    Present value (Value of loan) $2,219 =$2,775/((1 + 5.75%)^Duration)

    2. PV of multiple cash flows: Hassan Ali has made an investment that will pay him $11,455, $16,376, and $19,812 at the end of the next three years. His investment was to fetch him a return of 14 percent. What is the ...

    Solution Summary

    The present values are calculated for Hassan Ali investments. The present value of the cash flows are given.

    $2.19

    ADVERTISEMENT