Explore BrainMass

Explore BrainMass

    Calculating Expected Cash Flows, NPV, and Present Value

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

    Please help with the following problem.

    Calculating Expected Cash Flows, NPV, and Present Value for The UPS Store Franchise Opportunity

    Calculate the following:
    Expected cash flows given forecasted profit
    Present value and net present value
    You will use this and previously developed information to formulate your final recommendation due next week.

    © BrainMass Inc. brainmass.com June 4, 2020, 2:23 am ad1c9bdddf
    https://brainmass.com/business/capital-budgeting/calculating-expected-cash-flows-npv-and-present-value-455267

    Solution Preview

    Please see the attached file(s) for the complete tutorial. Thank you for the opportunity to be of assistance and of course, the opportunity to learn as well.
    Anna, 108710

    Expected Cash Flows, NPV, and Present Value

    Expected cash flows
    These are computed from the forecasted statement of income created for years 1 to 5. It is assumed that all expenses are paid when incurred and all revenues are collected when provided.
    The UPS Store Franchise
    Statement of Cash Flows

    Year 0 1 2 3 4 5
    Net income 2,119 1,432 1,326 1,208 1,080
    Add: Depreciation ...

    Solution Summary

    This solution helps calculate expected cash flows, NPV and present value. The answer is provided in an Excel spreadsheet.

    $2.19

    ADVERTISEMENT