Purchase Solution

Calculating Expected Cash Flows, NPV, and Present Value

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution
Solution Summary

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

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 ...

Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

View More Free Quizzes
Related BrainMass Solutions

  • Cash flows in preferred and common stock

    //Before writing about the cash flows associated with preferred stock and common stock, we will write about the concept of ' Present Value' and 'Net Present Value' (NPV).

  • Calculating a Project's Net Present Value

    NPV = PV of annuity cash flows - initial investment PV of annuity cash flows = C/R* [1-1/(1+R)^T] Where C = annual cash flow, R = interest rate and T = time PV of net income = 2.35/10% [ 1 - 1/(1.1)^13] = 16.6929M NPV = 16.6929 - 23 = -6.31M

  • Capital budgeting Practice True False Exam Questions

    Internal rate of return is a method of calculating the expected gain or loss from a project by discounting all expected future cash inflows and outflows to the present point in time.

  • Replacement Decision- Unequal Lives

    Two new models are available: Machine 190-3, which has a cost of $190,000, a 3-year expected life, and after-tax cash flows (labor savings and depreciation) of $87,000 per year; and Machine 360-6, which has a cost of $360,000, a 6-year life, and after-tax

  • Long Term Financing Analysis: Capital Investment & Analyses

    The decision to accept or reject a capital budgeting project depends on an analysis of the cash flows generated by the project and its cost. Let us understand the concepts. NPV = present value of future cash flows - initial cash outflow.

  • Calculating NPV of given investment proposal

    367052 Capital Budgeting A machine costs $380,000 and is expected to produce the following cash flows: Year 1 2 3 4 5 6 7 8 9 10 Cash Flows (000s)

  • Calculating NPV & IRR of cash flows associated with Project

    199931 Calculating NPV & IRR of cash flows associated with Project 1.Consider a project with the expected cash flows: Year Cash flow 0 - $615,000 1 + 141,000 2 + 300,000 3

  • MTV

    NPV is calculated by finding the present value of each cash flow, including both cash inflows and outflows, discounted at the project's cost of capital.

  • Walker Landscaping Company end of year cash flows

    the present value of a machine's expected savings to the present value of the machine's costs: PV(expected savings) = PV(Investment costs), or the rate which forces the NPV to equal zero.

View More Related Solutions