| Course | BUS 550 Business Finance |
|---|---|
| Module | Module 7 |
| Paper type | Project risk analysis |
| Length | About 1,015 words, 6 pages |
| Format | APA 7 student paper |
| School | Aspen University |
| Program | MBA |
| Updated | October 2026 |
Free sample paper for BUS 550 Module 7
Positive on Paper, Fragile in Practice: Cash Flow Estimation and Risk Analysis for a Cold Storage Warehouse
Student Name
MBA Program, Aspen University
BUS 550: Business Finance
Instructor Name
Month Day, Year
Positive on Paper, Fragile in Practice: Cash Flow Estimation and Risk Analysis for a Cold Storage Warehouse
Valley Fresh Distribution, a composite food distributor in Fresno, California, moves produce and frozen foods from growers and processors to grocery chains. Its own cold storage is full most of the year, and growers in the region often struggle to find refrigerated space during harvest. The company proposes building an $8.5 million cold storage warehouse with 12,000 pallet positions on land it already owns next to its distribution center, renting space to outside growers and processors. This paper estimates the project's cash flows and analyzes its risk.
What Belongs in the Cash Flows
A capital project should be judged on its incremental cash flows, the cash that changes because the project is undertaken (Brigham & Ehrhardt, 2020). Three items in this project need careful treatment. The land is already owned, but it is not free: a neighboring logistics company has offered $900,000 for it, so using it for the warehouse means giving up that sale, an opportunity cost that belongs in the initial outlay. The company has already spent $120,000 on a feasibility study; nothing the board decides now can bring that money back, so it stays out of the analysis. And the project requires $300,000 of added working capital for receivables and supplies, recovered at the end. Interest on any loan used to build the warehouse is excluded, because financing costs are reflected in the discount rate.
The Base Case
The finance team's base case assumes the warehouse will be 85% occupied on average at $16 per pallet position per month, producing revenue of about $1.96 million a year. After operating costs, including electricity for refrigeration, labor and maintenance, and after taxes, with depreciation's tax shield included, the project produces about $1.15 million a year for 15 years. At the end, the building and land are expected to be worth about $3 million, and working capital is recovered. The initial outlay totals $9.7 million: $8.5 million for construction, $900,000 for the land's opportunity cost and $300,000 of working capital. At a 9% cost of capital, net present value is about $480,000.
Sensitivity Analysis
A positive base case is only as reliable as its assumptions. Sensitivity testing moves a single assumption while holding the rest, to see which ones the answer leans on.
Occupancy dominates. A ten-point shortfall erases the project's value, while rent and construction cost matter less, and electricity least of all.
| Change from base case | Net present value, approximately |
|---|---|
| Base case | plus $480,000 |
| Occupancy 75% instead of 85% | minus $910,000 |
| Rent $15 instead of $16 per pallet a month | minus $260,000 |
| Construction cost 10% higher | minus $370,000 |
| Electricity cost 20% higher | plus $90,000 |
| Occupancy 92% instead of 85% | plus $1,450,000 |
Scenarios
Variables tend to move together. In a pessimistic scenario, a weak harvest year lowers demand, occupancy averages 75%, rents slip to $15 and construction runs 10% over budget; net present value is about minus $1.6 million. In an optimistic scenario, a major processor signs a long lease, occupancy averages 92% at $17; net present value is about $2.1 million. The base case lies between, but the range is wide relative to the project's size.
Simulation
Hertz (1964) proposed that managers evaluate risky investments by simulating many possible outcomes, drawing each key variable from a probability distribution rather than using a single best estimate, so that decision-makers see the full range of results and their likelihood. Valley Fresh's analyst ran 5,000 trials, drawing occupancy from a distribution centered on 83% with a standard deviation of 7 points, rent from $15 to $17, construction cost from 5% below to 15% above budget and electricity prices from a range based on recent years. Across the trials the mean result was about $390,000 of added value, slightly below the base case because cost overruns are more likely than savings, and a 38% probability that net present value would be negative.
Why the Base Case May Be Optimistic
Kahneman and Lovallo (1993) argued that managers making forecasts tend to adopt an inside view, building a story of how the specific project will unfold and overlooking the outside view, the record of how similar projects have turned out. The inside view produces bold forecasts that are systematically too optimistic. Valley Fresh's 85% occupancy assumption came from the team's survey of growers who expressed interest. An outside view would ask how quickly comparable cold storage facilities in the Central Valley reached stable occupancy, information the team should gather before deciding.
What Drives Occupancy
Because occupancy matters most, its drivers deserve attention. Demand for cold storage in the Central Valley rises and falls with harvests, export markets and the expansion plans of food processors. A strong almond or citrus year fills every warehouse in the region; a drought year can leave space empty. New competitors also matter: two other companies have announced cold storage projects within 40 miles, which could add capacity just as Valley Fresh opens. The team's grower survey measured interest, not commitments, and growers who expressed interest may still choose a warehouse closer to their fields or with lower rents.
Reducing the Risk
The analysis points to a specific way to reduce risk: securing occupancy before building. A ten-year lease with a large processor for 4,000 pallet positions, a third of capacity, would sharply narrow the range of outcomes. With such a lease, the simulation's probability of a negative net present value falls to about 15%.
Recommendation
Valley Fresh should not approve construction on the current base case alone. It should seek an anchor lease for at least a third of capacity, gather data on occupancy at comparable facilities, and obtain fixed-price construction bids. If those conditions are met, the project should proceed.
Conclusion
Correct cash flow estimation, including the land's opportunity cost and excluding the sunk study, gives a positive base case. Risk analysis shows that the result rests heavily on occupancy and carries a substantial chance of loss. Simulation, scenarios and research on forecasting bias all point to the same step: lock in demand before pouring concrete.
References
Brigham, E. F., & Ehrhardt, M. C. (2020). Financial management: Theory and practice (16th ed.). Cengage.
Hertz, D. B. (1964). Risk analysis in capital investment. Harvard Business Review, 42(1), 95-106.
Kahneman, D., & Lovallo, D. (1993). Timid choices and bold forecasts: A cognitive perspective on risk taking. Management Science, 39(1), 17-31. https://doi.org/10.1287/mnsc.39.1.17
What the BUS 550 Module 7 instructions ask for
Aspen's catalog for BUS 550 includes cash flow estimation and project risk with capital budgeting, so this module usually asks students to build a project's cash flows correctly and analyze how risky the result is. The classroom prompt sets the requirements; this example works through both tasks for one project. Identify incremental cash flows, including opportunity costs, working capital and taxes, and exclude sunk costs and financing costs. Compute a base case net present value. Test the variables that matter most with sensitivity analysis, and build scenarios that change several variables together. Use simulation or a similar method if your course covers it. Discuss why forecasts tend to be optimistic. Recommend a decision and any steps that reduce the project's risk before money is committed.
How this BUS 550 Module 7 example is built
The paper opens with Valley Fresh Distribution's plan to build a 12,000-pallet cold storage warehouse to rent space to growers and processors. A section explains incremental cash flows with Brigham and Ehrhardt's guidance, setting the land's $900,000 market value as an opportunity cost and excluding the feasibility study. The base case assumes 85% occupancy at $16 per pallet a month, after-tax cash flows of $1.15 million a year for 15 years and a residual value. Net present value at 9% is about $480,000. A sensitivity table shows the effect of occupancy, rent and building cost. Three scenarios range from about minus $1.6 million to about $2.1 million. A simulation of 5,000 trials, following Hertz's Harvard Business Review approach, gives a 38% chance of negative value. Kahneman and Lovallo's Management Science article explains why base cases run optimistic. The recommendation conditions approval on an anchor lease.
Reading the BUS 550 Module 7 grading rubric
A risk paper of this kind earns its marks by getting the project's own cash flows right, doing the arithmetic carefully and letting the risk work change the decision. This example shows the treatment of each contested item, land, the feasibility study and working capital, so the grader can see the reasoning behind the cash flows. The sensitivity table and scenarios state their inputs, and the simulation is described with its distributions and number of trials. Hertz's Harvard Business Review article grounds the simulation approach, Kahneman and Lovallo's Management Science article explains forecasting bias, and Brigham and Ehrhardt's text supplies the rules for cash flow estimation. The recommendation turns risk analysis into action by identifying what would make the project safer, which is the purpose of the analysis.
BUS 550 Module 7 help from the desk
The most common errors in Module 7 are counting sunk costs, ignoring opportunity costs and including interest in project cash flows. Ask of every item whether it changes because of the project. Another weakness is a risk analysis that varies one input at a time without explaining which inputs matter most; rank them. Scenarios should change several assumptions together in consistent ways. If you use simulation, describe the distributions and the number of trials, and report the probability of a loss, not only the average. Discuss why your base case might be optimistic. Do not let risk analysis end in a list of numbers; use it to recommend a decision or a step that reduces risk. Finally, be consistent about timing and taxes throughout.
Write yours, or have the desk draft it
This paper is an original model document written by our desk, not a submitted student paper and not an official Aspen University document. Read it for the moves, then write your own to the instructions in your classroom. If you want one built to your exact prompt and rubric, the first custom sample is free and arrives in 24 to 48 hours.
More BUS 550 and MBA sample papers
- BUS 550 Module 1: Statements and Cash Flow
- BUS 550 Module 2: Time Value of Money
- BUS 550 Module 3: Bonds and Interest Rates
- BUS 550 Module 4: Stock Valuation
- BUS 550 Module 5: Risk and Return
- BUS 550 Module 6: Capital Budgeting
- BUS 550 Module 8: The Cost of Capital
- BUS 530 Module 3: Customer Insight and Research
- BUS 551 Module 7: Options and Risk Management
- BUS 799 Module 4: Capstone Findings
- BUS 552 Module 5: Real Options
BUS 550 Module 7 questions, answered
What does BUS 550 Module 7 usually ask for?
Aspen's BUS 550 covers cash flow estimation and project risk in this module, so building a project's incremental cash flows and testing them with sensitivity, scenario or simulation analysis is typical. Check your classroom prompt.
What is an incremental cash flow?
A cash flow that occurs only because the project is undertaken, including opportunity costs and working capital, but excluding sunk costs.
What is the difference between sensitivity and scenario analysis?
Sensitivity analysis changes one variable at a time to see its effect; scenario analysis changes several variables together to describe a possible future.
Where can I find a free BUS 550 Module 7 sample paper?
The full analysis is shown above: a cold storage warehouse's incremental cash flows, base case net present value, sensitivity table, scenarios and simulation, with a conditional recommendation.
Why are project forecasts often too optimistic?
Research by Kahneman and Lovallo found that planners tend to focus on the specific case and its best path, overlooking how often similar projects fall short.