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.