Explore BrainMass
Share

Explore BrainMass

    Discounted Cash flow valuation

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

    Your company will generate $65,000 in cash flow each year for the next 10 years from a new information database. The computer system needed to set up the database costs $307,000. (Round your answer to 2 decimal places. Omit the "$" sign in your response.)

    1) If you can borrow the money to buy the computer system at 8.25 percent annual interest, the present value of the savings is $ ----------- .

    2) The present value of the revenue ----------- greater than the cost, so your company ----------- afford the equipment.

    3) An investment will pay you $59,000 in 6 years. If the appropriate discount rate is 9 percent compounded daily, the present value is $ -------- . (Round your answer to 2 decimal places.

    4) Beginning three months from now, you want to be able to withdraw $1,000 each quarter from your bank account to cover college expenses over the next 4 years. If the account pays 1.25 percent interest per quarter, you need to have $ --------- in your bank account today to meet your expense needs over the next four years .(Round your answer to 2 decimal places

    5) Amortization with Equal Principal Payments
    Prepare an amortization schedule for a 3-year loan of $45,000. The interest rate is 15 percent per year, and the loan calls for a principal reduction of $15,000 every year. (Omit the "$" sign in your response.)

    Year Beginning Balance Total Payment Interest Payment Principal Payment Ending Balance
    1 45,000
    2
    3

    Total interest paid: $

    6) Calculating Present Values
    In 2001, an athlete signed a contract reported to be worth $302 million. Including a deferred signing bonus, he would receive $29 million per year from 2001-2004, $32 million in 2005, $30 million in 2006, and $31 million per year from 2007-2010. Assume the first payment is made immediately, and the next payment occurs in exactly one year. If the appropriate interest rate is 12 percent, the present value of the contract is $ --------- .

    Please check the attachment.

    © BrainMass Inc. brainmass.com April 3, 2020, 7:47 pm ad1c9bdddf
    https://brainmass.com/business/discounted-cash-flows-model/discounted-cash-flow-valuation-280791

    Attachments

    Solution Preview

    The answers are in attached file:

    Note:
    PVIF= Present Value Interest Factor for a single Sum
    PVIFA= Present Value Interest Factor for an annuity
    Your company will generate $65,000 in cash flow each year for the next 10 years from a new information database. The computer system needed to set up the database costs $307,000. (Round your answer to 2 decimal places. Omit the "$" sign in your response.)

    If you can borrow the money to buy the computer system at 8.25 percent annual interest, the present value of the savings is $ .

    Present Value of savings = Present value interest factor for annuity (PVIFA) x Annuity
    PVIFA (10 years, 8.25%) = 6.635070
    Annuity = $65,000
    Therefore, present value of savings = 6.635070 x $ 65,000 =$ 431,279.54
    The present value of the revenue greater than the cost, so your company afford the equipment.

    An investment will pay you $59,000 in 6 ...

    Solution Summary

    Questions on Discounted Cash flow valuation have been answered.

    $2.19

    ADVERTISEMENT