GF540 · Unit 9

GF540 Unit 9 sensitivity table example

Investment and Securities Analysis Purdue University Global Free custom sample in 24 to 48h

A valuation is only as strong as its weakest input, and the sensitivity table that often occupies Unit 9 of GF540 exists to find that input. The table shown takes the cash flow valuation of a composite coatings maker, moves five inputs one at a time across stated ranges, adds a two-way grid, and names the threshold at which each input overturns the conclusion.

What this page holds

Where does a composite coatings valuation stop exceeding its price? The GF540 Unit 9 sensitivity table answers input by input, with a breakpoint for each and one two-way grid. Searches like "gf 540 unit 9 assignment example", "gf540 unit 9 sample" and "gf540 unit 9 example" land here.

What a finished GF540 Unit 9 sensitivity table looks like

Three exhibits and about three pages of commentary. The first exhibit is a one-way table: weighted cost of capital from [7.4] to [9.4] percent, terminal growth from [1.5] to [3.5], operating margin two points either side of [16] percent, and revenue growth and the reinvestment rate each across a stated band, with value per share at every step and the base case of [58.40] marked. The second is a tornado chart ranking the five inputs by the swing they produce, with the discount rate and terminal growth at the top. The third is a two-way grid crossing those two inputs, shaded where value falls below the [52.00] market price. The commentary reports breakpoints: value drops under price if the cost of capital passes [8.9] percent, terminal growth falls below [1.9] percent or margin slips under [14.2].

How a GF540 Unit 9 example is structured

The commentary is organized by input, not by exhibit, because the unit's question is which assumptions the conclusion depends on. Each input gets a short block: the base value and its source, the range tested and why that range is plausible rather than arbitrary, the value per share at each end, and the breakpoint where value equals price. Ranges are justified from evidence, such as the spread of analyst cost-of-capital estimates or the company's own margin history over a full cycle. The two-way grid section explains why the discount rate and terminal growth interact, and flags the corner where growth approaches the discount rate and the terminal formula stops meaning anything. The last block orders the inputs by how close their breakpoint sits to the base case, which tells the reader which assumption most needs defending.

Ranges argued from evidence

Each input's band comes from something observable, the company's margin history through a downturn or the spread of published cost-of-capital estimates, rather than a symmetric guess.

One input moved, four held

The one-way table changes a single driver per row and holds every other at base, so each swing is attributable to one assumption alone.

A tornado, ranked by swing

Bars ordered by the width of their value range show discount rate and terminal growth dominating, with revenue growth a distant third.

Breakpoints against price

For each input the table reports the level at which value equals the [52.00] quote, turning sensitivity into a statement about the recommendation.

The grid's broken corner

Where terminal growth nears the discount rate, value balloons; the grid greys out those cells and says the formula, not the business, produced them.

Where marks go in GF540 Unit 9

Sensitivity tables are marked on whether they answer a question, and the usual question is which assumption the conclusion depends on. Tables that vary every input by the same arbitrary ten percent, with no reason for the range, show movement without showing plausibility. Changing two inputs at once in a one-way table makes each swing impossible to attribute. The largest loss at this point is a table with no breakpoints: a reader sees values rise and fall but never learns where the recommendation reverses. Grids that print impossible values where growth meets or exceeds the discount rate, without comment, suggest nobody looked at the output. Commentary that repeats the table in words instead of ranking the risks leaves the grader to do the analysis the unit assigned.

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.

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.