GF599 Unit 5 Capstone Data Provenance Plan Example

Course	GF599 Graduate Capstone in Finance
Unit	Unit 5
Paper type	Data access plan
Length	About 890 words, 6 pages double-spaced
Format	APA 7 student paper
School	Purdue University Global
Program	MS in Finance
Updated	October 2026

Free sample paper for GF599 Unit 5

A Code for Every Number: A Unit 5 Data Access Plan for the Tollbrook Capstone

[Student Name]

Purdue University Global

GF599: Graduate Capstone in Finance

Unit 5 Data Access Plan

[Instructor Name]

[Date]

Tollbrook Tire and Service, its people, its documents and its figures are composite and illustrative; the sources cited are real.

What this part is doingLeading with the source code shows the plan's central device before the register itself appears.

Purpose

A financing recommendation is only as credible as its inputs. If the owner-president asks where the 6.90 percent mortgage rate came from, the answer must be immediate and exact. The register below assigns each input a code, S1 through S9, and every exhibit in later units cites those codes beneath its figures. Data practices that make information findable, accessible and reusable with its origin recorded are now standard in research (Wilkinson et al., 2016), and the same discipline suits a client project.

Provenance Register

1. S1, investor's letter of intent. Holder: the owner-president. Format: signed PDF. Released in Unit 1. Condition: the investor's name is masked in every document the project produces.

2. S2, reviewed financial statements, three years. Holder: the controller. Format: PDF with the accountant's review report. Released in Unit 1.

3. S3, fixed-asset register. Holder: the controller. Format: spreadsheet export. Released in Unit 2. It shows the $8,300,000 tax basis split into land and structures, and $200,000 of annual depreciation.

4. S4, credit agreement. Holder: the chief financial officer. Format: scanned copy with the covenant definitions marked. Released in Unit 2.

5. S5, mortgage indication. Holder: the bank's relationship manager. Format: email. Received in Unit 3. Terms: a ten-year loan at 6.90 percent fixed, up to 65 percent of appraised value, on the five strongest buildings. Condition: marked non-binding and subject to appraisal.

6. S6, blended tax rate. Holder: the outside accountant. Format: signed letter. Received in Unit 3. Rate: 25 percent.

7. S7, cap-rate survey. Holder: public. Format: a national net-lease broker's published survey. Used in place of the broker's workpapers.

8. S8, forward interest rate curve. Holder: public Treasury and swap data. Format: downloaded table, dated.

9. S9, broker's opinion of value. Holder: the owner-president. Format: two-page letter. Released in Unit 2. Condition: workpapers not released.

If a figure cannot be traced to one of the nine codes, it does not appear in an exhibit; that rule is what lets the owner-president check any number without asking the student.

What this part is doingStating the rule that governs the register, not only its contents, shows how the plan protects the analysis.

How Codes Appear in Exhibits

Each exhibit carries a source line. For example, the after-tax cost comparison in Unit 7 will read: "Sources: S1 price and rent; S3 basis and depreciation; S5 mortgage rate; S6 tax rate; S7 cap-rate range." Any figure the project computes, such as the $655,000 tax on the gain, is labeled as derived and lists the codes it comes from. A reader can rebuild any result from the register and the model.

Storage and Access

All files are stored in one encrypted folder on the student's university cloud account, not on a personal laptop or a shared drive. Only the student and the course instructor can open it. The owner-president receives exhibits, not the raw files, which she already holds.

Two documents need extra care. The letter of intent (S1) identifies the investor, so the working copy is redacted before it enters the folder and the original is never uploaded. The credit agreement (S4) contains the bank's pricing for other facilities, which is irrelevant to the project, so only the covenant pages are kept.

Handling Conditions on Release

1. Non-binding terms (S5). Every exhibit using the mortgage rate states that it is an indication, not a commitment, and the roadmap in Unit 9 includes obtaining firm term sheets.

2. Masked investor (S1). The investor appears as "the investor" everywhere.

3. Withheld workpapers (S9). The broker's single value is shown beside the survey range (S7) rather than used alone.

What this part is doingTurning each release condition into a specific handling rule shows the conditions were read and respected.

Version Control

The model is saved with a version number and date each time an input changes. When the accountant's letter confirmed 25 percent, the model moved from version 0.3 to 0.4, and the change log records which outputs moved. The final report will cite the model version that produced each table.

Quality Checks

1. The tax basis in S3 is reconciled to the property line in the reviewed balance sheet in S2.

2. Rent in S1 is recomputed from the price and cap rate.

3. The covenant formula in S4 is applied to last year's figures and checked against the coverage ratio reported to the bank, 1.85.

4. Any public figure in S7 or S8 is recorded with its publication date.

These checks follow the practice of tying model inputs to audited or reviewed sources before analysis begins (Brealey et al., 2023).

Retention and Deletion

Working copies are kept until final grades are posted. Within thirty days after that, the student deletes the folder and confirms deletion to the owner-president in writing. The model itself, with figures replaced by placeholders, may be kept as a template.

Why the Borrowing Rate Gets the Most Scrutiny

Of all nine inputs, the mortgage rate in S5 has the largest effect on the answer, because every cash flow in the comparison is discounted at that rate net of tax (Myers et al., 1976). The plan therefore treats S5 as provisional until a firm term sheet arrives, and the sensitivity tests in Unit 8 vary it explicitly.

References

Brealey, R. A., Myers, S. C., & Allen, F. (2023). Principles of corporate finance (14th ed.). McGraw Hill.

Myers, S. C., Dill, D. A., & Bautista, A. J. (1976). Valuation of financial lease contracts. The Journal of Finance, 31(3), 799-819. https://doi.org/10.1111/j.1540-6261.1976.tb01924.x

Wilkinson, M. D., Dumontier, M., Aalbersberg, I. J., Appleton, G., Axton, M., Baak, A., Blomberg, N., Boiten, J., da Silva Santos, L. B., Bourne, P. E., Bouwman, J., Brookes, A. J., Clark, T., Crosas, M., Dillo, I., Dumon, O., Edmunds, S., Evelo, C. T., Finkers, R., ... Mons, B. (2016). The FAIR guiding principles for scientific data management and stewardship. Scientific Data, 3, Article 160018. https://doi.org/10.1038/sdata.2016.18

GF599 Unit 5 instructions, in plain terms

Unit 5 in GF599 asks how you will obtain, record, store and protect the data your analysis uses. Build a register that gives each input a short code, its holder, its format, when it was released and any condition attached. Explain how those codes will appear in later exhibits, so any figure can be traced back. State where files will be kept and who can open them, with extra care for documents that identify third parties or contain information you do not need. Turn each release condition into a handling rule. Describe how you will track versions of your model as inputs change. List quality checks that tie inputs to reviewed or audited sources. Set a date for deleting working copies and say how you will confirm it. Identify the input with the largest effect on the answer and how you will treat it. Cite a data management standard and finance sources in APA 7.

Inside the GF599 Unit 5 example

A purpose paragraph explains why the owner-president must be able to trace any figure, citing the FAIR principles of Wilkinson and colleagues. The register lists nine numbered inputs, each with holder, format, timing and conditions. The highlighted sentence states the rule that untraceable figures do not appear. An example source line shows how Unit 7's exhibit will cite S1, S3, S5, S6 and S7. Storage is an encrypted university folder open only to the student and instructor, with the letter of intent redacted and the credit agreement trimmed to covenant pages. Three release conditions become handling rules. A version-control paragraph records the move from model 0.3 to 0.4 when the tax rate was confirmed. Four quality checks follow the Brealey, Myers and Allen practice of tying inputs to reviewed sources. Deletion terms and a note on the mortgage rate's weight close the plan.

GF599 Unit 5 rubric: what earns full points

Instructors scoring this GF599 plan look first at the register. Each input should have a holder, a format, a date and its conditions, and a missing condition can matter more than a missing date. The code system earns credit when the plan shows how it will be used in exhibits, not merely assigned. Storage and access rules are graded as professional practice, especially for documents naming outside parties. Converting release conditions into specific handling rules shows the student read and respected what the organization agreed to. Version control and quality checks are signs that the analysis can be audited later. A deletion date with written confirmation completes the data life cycle. Naming the most influential input and planning its treatment links the data plan to the method. A data stewardship standard and two finance sources, in APA 7, support the plan's approach without overloading it.

GF599 Unit 5 help: mistakes that cost points

GF599 Unit 5 plans often list data sources without recording the conditions under which they were released, which leads to problems when a draft names a party that asked to stay anonymous. Others assign codes but never explain how they will appear in exhibits. Storage is frequently described as a personal laptop or a shared drive, which an organization may not accept. Some plans keep every page of a sensitive document when only a few are needed. Version control is often missing, so later results cannot be matched to the inputs that produced them. Quality checks are vague or absent. Deletion is forgotten. A plan that treats every input as equally important misses the one that drives the answer. Write the register first, then make every later section answer a question about it: how codes are used, where files live, how conditions are honored and when copies disappear.

Get a GF599 Unit 5 example written to your instructions

List the sources your project uses and anything their holders asked of you, and add your Unit 5 prompt and rubric. The plan drafted for you gives each source a code, a holder, a date and its conditions, records gaps and substitutes, and sets a citation rule for later units. Expect it inside 24-48h, and the first one costs nothing. 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 GF599 papers and MS in Finance samples

GF599 Unit 5 questions, answered

Why give each source a code?

So a figure can be traced without searching the text. A note reading S3 and S6 tells a grader that a tax amount came from the asset register and the accountant's rate, and from nothing else. It also makes revisions safer: when a source changes, every exhibit citing its code can be found and updated in one pass.

Is it acceptable to rely on a non-binding bank indication?

For a capstone, generally yes, provided the plan says it is non-binding and dates it. Rates move, and a firm commitment would require an application the organization may not want to make for a course project. The sample labels the 6.90 percent quote as an indication and tests the verdict against higher rates in later units.

Where can I find a free GF599 Unit 5 sample paper?

This page carries a full GF599 Unit 5 data access plan with a nine-item provenance register, exhibit source lines, storage and handling rules, version control, quality checks and APA 7 references.

How does the plan handle the withheld broker workpapers?

The broker released only a two-page opinion of value, so every exhibit shows that single figure beside the published cap-rate survey range instead of relying on it alone, and the register records the condition under code S9.

When are the working files deleted in GF599 Unit 5?

Within thirty days after final grades are posted. The student deletes the encrypted folder and confirms deletion to the owner-president in writing, keeping only a version of the model with the figures replaced by placeholders.