GF540 Unit 9 Valuation Sensitivity Table Example

Reviewed by Chester Goodwin, MBA Investment and Securities Analysis Purdue University Global Free custom sample in 24 to 48h

This GF540 Unit 9 sensitivity table finds which inputs could overturn a garage door maker's $58.40 valuation against its $52 price. Purdue Global GF 540, Investment and Securities Analysis, asks MS in Finance students to locate a valuation's weakest input. The sample moves five inputs one at a time, ranks them in a tornado list led by cost of capital, with a $26.50 swing, and operating margin, $21.00, and crosses cost of capital with terminal growth in a grid. Value falls below price above an 8.94 percent cost of capital or below a 12.8 percent margin, while growth and reinvestment alone cannot reverse it. A combined case reaches about $47.70.

CourseGF540 Investment and Securities Analysis
UnitUnit 9
Paper typeSensitivity table
LengthAbout 870 words, 6 pages double-spaced
FormatAPA 7 student paper
SchoolPurdue University Global
ProgramMS in Finance
UpdatedOctober 2026

Free sample paper for GF540 Unit 9

1

Two Inputs Decide the Answer: A Unit 9 Sensitivity Table for a Garage Door Maker's Valuation

[Student Name]

Purdue University Global

GF540: Investment and Securities Analysis

Unit 9 Sensitivity Table

[Instructor Name]

[Date]

The company and every figure are composite and illustrative, carried from the Unit 7 valuation; the textbooks cited are real.

What this part is doingNaming the base value, the market price and the threshold test in the lead tells the reader what each exhibit is for.
2

The Base Case and the Question

The Unit 7 model valued the shares at $58.40 against a market price of $52.00, using a weighted cost of capital of 8.4 percent, terminal growth of 2.5 percent, an operating margin of 14 percent, revenue growth of 5, 5, 4, 4 and 3 percent, and reinvestment of 30 percent of after-tax operating income. The question here is narrower than the valuation's: which of those inputs, if wrong by a plausible amount, would make the shares worth less than they cost?

Exhibit 1: One-Way Table

Each input is moved across its range while the others stay at base values. Ranges reflect what would be defensible, not extreme.

Weighted cost of capital, 7.4 to 9.4 percent. Value per share: $73.90 at 7.4, $65.40 at 7.9, $58.40 at 8.4, $52.50 at 8.9 and $47.40 at 9.4.

Terminal growth, 1.5 to 3.5 percent. $54.70 at 1.5, $56.40 at 2.0, $58.40 at 2.5, $60.70 at 3.0 and $63.50 at 3.5.

Operating margin, 12 to 16 percent. $47.90 at 12, $58.40 at 14 and $68.90 at 16.

Revenue growth, two points either side of the base path. $52.20 with growth two points lower each year, $65.10 with growth two points higher.

Reinvestment rate, 20 to 40 percent. $60.70 at 20 percent and $56.10 at 40 percent.

*Commentary.* Terminal growth moves value less than many students expect, because the model ties reinvestment to growth through a 12 percent return on new capital: faster growth requires more reinvestment, which offsets much of its benefit (Koller et al., 2020).

Exhibit 2: Tornado Ranking

Inputs ranked by the swing in value across their ranges:

1. Weighted cost of capital: $26.50, from $47.40 to $73.90.

2. Operating margin: $21.00, from $47.90 to $68.90.

3. Revenue growth: $12.90, from $52.20 to $65.10.

4. Terminal growth: $8.80, from $54.70 to $63.50.

5. Reinvestment rate: $4.60, from $56.10 to $60.70.

Exhibit 3: Two-Way Grid

Crossing the cost of capital with terminal growth, value per share is:

1. At 7.4 percent: $67.30, $70.30, $73.90, $78.30 and $83.70 for terminal growth of 1.5 to 3.5 percent.

2. At 7.9 percent: $60.50, $62.80, $65.40, $68.60 and $72.50.

3. At 8.4 percent: $54.70, $56.40, $58.40, $60.70 and $63.50.

4. At 8.9 percent: $49.70, $51.00, $52.50, $54.20 and $56.20.

5. At 9.4 percent: $45.40, $46.30, $47.40, $48.70 and $50.10.

Cells below the $52.00 price are all of the 9.4 percent row and the two lowest-growth cells of the 8.9 percent row: seven of twenty-five.

Breakpoints

Cost of capital. Value falls below $52.00 above about 8.94 percent, roughly half a point above the base estimate.

Operating margin. Value falls below $52.00 below about 12.8 percent, a little over one point under the base.

Revenue growth, terminal growth and reinvestment. None of these alone pushes value under $52.00 within its range. Growth two points lower every year comes closest, at $52.20.

The conclusion that the shares are undervalued rests on two inputs only: if the cost of capital is half a point higher or the operating margin a point lower than assumed, the case disappears, while plausible errors in growth or reinvestment leave it intact.

What this part is doingThe highlighted sentence turns the tables into a statement about where the thesis is fragile, the finding graders expect from a sensitivity analysis.
3

Combined Moves

Inputs rarely move alone. A housing slowdown would likely lower margins and raise the company's perceived risk at the same time. With the margin at 13 percent and the cost of capital at 8.9 percent, value falls to about $47.70, roughly 8 percent below the market price. Sensitivity tables that move one input at a time understate this kind of joint risk, so the combined case belongs beside them (Damodaran, 2012).

How Plausible Are the Breakpoints?

Over the past decade the company's margin ranged from about 10 to 15 percent, so a margin below 12.8 percent has happened in weaker housing years. The cost of capital estimate depends on a five-year beta of 1.10; a beta of 1.20, within the range of estimates from different data windows, would add about 0.4 points to the cost of capital on its own. Both breakpoints are therefore within reach, which means the undervaluation case is modest rather than strong (Bodie et al., 2024).

What the Tables Cannot Show

Sensitivity tables assume each input can be set independently and treat every value in a range as equally likely. Neither is true. A simulation that drew inputs from estimated distributions, with margin and cost of capital linked, would give a probability that value exceeds price rather than a list of thresholds. For a unit exercise, the breakpoints and the combined case carry most of that information more simply.

Conclusion

The valuation's margin of safety is small. The shares look undervalued only if the company keeps margins near the top of their historical range and investors price its risk close to the estimate here. The research report in the next unit should present the value as a range and name margin and discount rate as the two inputs to watch.

What this part is doingEnding with what the report should carry forward shows the sensitivity work shapes the final recommendation.
4

References

Bodie, Z., Kane, A., & Marcus, A. J. (2024). Investments (13th ed.). McGraw Hill.

Damodaran, A. (2012). Investment valuation: Tools and techniques for determining the value of any asset (3rd ed.). Wiley.

Koller, T., Goedhart, M., & Wessels, D. (2020). Valuation: Measuring and managing the value of companies (7th ed.). Wiley.

The Purdue Global GF540 Unit 9 instructions

Unit 9 of GF540 asks you to test your valuation with sensitivity analysis. Restate the base case and the question the tables answer, usually whether value stays above or below the market price. Move each important input across a range you can defend, holding the others fixed, and report value at each step. Rank the inputs by the swing they produce. Cross the two most powerful inputs in a two-way grid and mark the cells where the conclusion reverses. Report the breakpoint for each input, or state that none exists within its range. Test a combined move in inputs that are likely to change together. Judge how plausible each breakpoint is against history. Close with what the final report should carry forward. Cite valuation texts in APA 7.

How the GF 540 Unit 9 example is put together

The sample restates the Unit 7 base case and frames the question as whether any plausible error makes the shares worth less than they cost. Exhibit 1 lists value at each step for five inputs, with commentary on why terminal growth matters less when reinvestment is tied to returns, citing Koller, Goedhart and Wessels. Exhibit 2 ranks the swings, and Exhibit 3 lays out twenty-five grid values, counting seven below price. Breakpoints come next, and the highlighted sentence says the conclusion rests on two inputs only. A combined case with a lower margin and higher rate follows, citing Damodaran on joint moves, then a plausibility check against margin history and beta estimates citing Bodie, Kane and Marcus. A note on what tables cannot show precedes the conclusion.

GF540 Unit 9 rubric: what earns full points

Credit in this GF540 unit rests on correct values at every step and on ranges that are defensible rather than arbitrary. The tornado ranking and the two-way grid earn the next share when they are built correctly and actually used in the commentary. Breakpoints are the most valuable output, because they turn tables into a statement a reader can act on, and graders look for them explicitly. A combined-move case shows awareness that inputs are related. Judging the plausibility of breakpoints against history demonstrates analytical maturity valued in the MS in Finance program. A conclusion that tells the final report what to carry forward, and APA 7 references to valuation sources, complete the marks.

GF540 Unit 9 help from the desk

Many GF540 Unit 9 tables vary every input by the same arbitrary percentage, which produces tidy columns but meaningless comparisons. Others present a grid without saying what it shows. Breakpoints are omitted, leaving the reader to search the tables. Inputs that move together, such as margins and risk in a downturn, are only ever tested alone. Ranges are not compared with the company's history, so the reader cannot judge whether a breakpoint is likely. Commentary repeats the tables in words. For any valuation your course builds, keep the same structure: base case and question, one-way table, ranking, grid, breakpoints, a combined case, a plausibility check and a conclusion.

Get a GF540 Unit 9 example written to your instructions

Your valuation model or the base case your GF540 Unit 9 prompt supplies, the inputs it names and the rubric: that is enough for the table. Ranges are argued, a breakpoint is reported for each input, and the commentary ranks what the conclusion depends on. Nothing is charged for a first custom sample, and most arrive within 24-48h. The paper above is an original model document written by our desk, not a submitted student paper and not an official Purdue University Global document.

More GF540 papers and MS in Finance samples

GF540 Unit 9 questions, answered

How wide should each input's range be?

Wide enough to cover what could plausibly happen, and no wider. The sample ties each range to evidence: margin swings from the company's last downturn, discount rates from the spread of published estimates. A uniform ten percent move on every input is easy to build but hard to defend, and most graders will ask why a margin and a growth rate should share the same range.

What is a breakpoint and why include one?

It is the value of an input at which the model's answer equals the market price, so the recommendation flips. Reporting breakpoints turns a table of numbers into a statement a reader can use: the conclusion holds unless the cost of capital rises above a stated level. The sample reports one for every input and ranks them by how close each sits to the base case.

Should the table include a scenario analysis as well?

Only if your prompt asks. A scenario changes several inputs together to tell a coherent story, such as a recession with lower margins and slower growth, while a sensitivity table isolates each input in turn. The sample keeps the two separate and adds a short note on which scenario would be worth building next, which some rubrics credit.

Where can I find a free GF540 Unit 9 sample paper?

A complete GF540 Unit 9 sensitivity table for a composite garage door maker's valuation is on this page, with one-way and two-way tables, a tornado ranking, breakpoints and APA 7 references.

Why does terminal growth move value so little here?

The model ties reinvestment to growth through a 12 percent return on new capital. Faster growth requires reinvesting more of each year's profit, which offsets most of the benefit of the higher growth rate.