Explore BrainMass
Share

Explore BrainMass

    Calculating Present Values and Multiple Cash Flows

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

    1. Calculating Present Values: For each of the following compute the present value. Answer in Excel.

    Present Value____Years____Interest Rate____Future Value
    ?_______________6__________7%_________$13,827
    ?_______________9__________15__________$43,852
    ?_______________19_________11__________$725,380
    ?_______________23_________18__________$590,710

    2. Calculating Interest Rates: Solve for the unknown interest rate in each of the following: Answer in Excel
    Present Value____Years____Interest Rate____Future Value
    $__ 242___________4__________?_________$_____307
    $__ 410___________8__________?_______________896
    $51,700__________16__________?__________$162,181
    $18,750__________27__________?__________$483,500

    3. Calculating the Number of Periods: Solve for the unknown number of years in each of the following: Answer in Excel
    Present Value____Years____Interest Rate____Future Value
    $___625__________?___________9%_______$__1,284
    $___810__________?__________11_________$__4,341
    $18,400___________?_________17__________$402,662
    $21,500___________?__________8__________$173,439

    4. Present Value and Multiple Cash Flows: Farley Company has identified an investment project with the following cash flows. Answer in Excel
    Year________Cash Flow
    __1_________$960
    __2_________$840
    __3_________ $935
    __4________$1,350

    a. If the discount rate is 10 percent, what is the present value of these cash flows?
    b. What is the present value at 18 present?
    c. At 24 percent?

    5. Present Value and Multiple Cash Flows: Investment X offers to pay you $4,500 per year for nine years, whereas Investment Y offers to pay you $7,000 per year for five years.
    a. Which of these cash flow streams has the higher present value if the discount rate 5 percent? Explain.
    b. If the discount rate is 22 percent?

    © BrainMass Inc. brainmass.com October 10, 2019, 6:34 am ad1c9bdddf
    https://brainmass.com/business/cash/549140

    Solution Summary

    Your tutorial is in excel, attached using the PV, RATE, NPER, NPV functions.

    $2.19