ACC 486 Topic 7 pro forma forecast with assumptions example

Financial Statement Analysis Grand Canyon University Free custom sample in 24 to 48h

This ACC 486 Topic 7 sample paper is a three-year pro forma forecast whose first half contains no statements at all, only an assumption register. It was prepared for GCU ACC 486, Financial Statement Analysis, catalog code ACC-486, in the Grand Canyon University BS in Accounting program. Revenue growth of 8 percent, a 36 percent gross margin, selling expense at 24 percent, 45 days of receivables, 70 days of inventory, 40 days of payables, capital spending at 5 percent and a 25 percent tax rate each sit beside their historical range and source. Receivables at 45 days falls outside a 47 to 52 day record and is flagged, and balancing statements and a test follow.

CourseACC 486 Financial Statement Analysis
TopicTopic 7
Paper typePro forma forecast with assumptions
LengthAbout 960 words, 2 pages
FormatAPA 7 student paper
SchoolGrand Canyon University (GCU)
ProgramBS in Accounting
UpdatedSeptember 2026

Free sample paper for ACC 486 Topic 7

1

Assumptions First, Statements Second: A Three-Year Pro Forma Forecast for Cobalt Industrial Supply With a Register That Flags the One Break From History

[Author Name]

Colangelo College of Business, Grand Canyon University

ACC-486: Financial Statement Analysis

Topic 7 Assignment

[Instructor Name]

[Date]

The organization, setting and figures below are a composite written as a model document. No real employer, client, colleague or patient is described.

What this page is doingThe title describes the forecast's structure, a register before any statement, and signals that one assumption departs from the record. Cobalt Industrial Supply and all figures are illustrative composites; the sources are real.
2

Assumptions First, Statements Second: A Three-Year Pro Forma Forecast for Cobalt Industrial Supply With a Register That Flags the One Break From History

Why the Register Comes First

A pro forma forecast is only as credible as its assumptions, so this forecast for Cobalt Industrial Supply, a composite distributor of maintenance supplies, presents its assumptions before any statement. Each sits beside its three-year historical range and the source or reason for the value chosen. A reader can then see which assumptions simply extend the past and which depart from it, and can challenge any of them before looking at the result (Koller et al., 2020). Amounts are illustrative and shown in millions.

The Assumption Register

Table 1

Assumption Register

AssumptionForecast valueThree-year historical rangeSource or reasonFlag
Revenue growth8% a year6% to 10%Order backlog and management's guidance
Gross margin36%35.2% to 36.4%Historical average
Selling and administrative expense24% of revenue23.5% to 24.8%Historical average
Depreciation3% of revenue2.9% to 3.1%Historical average
Receivables45 days of sales47 to 52 daysNew collections policy introduced mid-yearOutside history
Inventory70 days of cost of sales68 to 74 daysHistorical average
Payables40 days of cost of sales38 to 42 daysHistorical average
Capital spending5% of revenue4.5% to 5.5%Capital plan
Tax rate25%24% to 26%Statutory and state rates
Interest6% on $40 million of debtLoan agreement

One assumption falls outside its history. Receivables are forecast at 45 days of sales against a record of 47 to 52 days. The register flags it and gives the reason: Cobalt introduced a new collections policy in the middle of the base year, requiring deposits on large orders and tightening terms for slow payers, and receivables at the end of the base year had already fallen to 50 days from 52. Management expects 45 days for a full year under the policy. The flag tells a reader that this is the assumption to test first. Every other assumption sits within its historical range, so a skeptical reader can accept them provisionally and concentrate on the one that is new.

The Income Statement

Table 2

Forecast Income Statement

Income statement, $ millionsBaseYear 1Year 2Year 3
Revenue300.0324.0349.9377.9
Cost of sales192.0207.4223.9241.9
Selling and administrative72.077.884.090.7
Depreciation9.09.710.511.3
Operating income27.029.231.534.0
Interest2.42.42.4
Income tax6.77.37.9
Net income20.121.823.7

Revenue grows 8% a year from $300 million to about $378 million. With gross margin, selling expense and depreciation held at their historical proportions, operating income grows in line with revenue, from $27 million to about $34 million. Net income rises from about $20 million to about $24 million, with interest fixed on the $40 million of debt.

The Balance Sheet

Table 3

Forecast Balance Sheet

Balance sheet, $ millionsBaseYear 1Year 2Year 3
Cash15.028.538.850.0
Receivables41.139.943.146.6
Inventory36.839.842.946.4
Property, net90.096.5103.5111.0
Payables21.022.724.526.5
Debt40.040.040.040.0
Equity121.9142.0163.8187.5
Check: assets less liabilities and equity0.00.00.00.0

Working capital accounts follow the day-count assumptions, property grows with capital spending less depreciation, equity grows with net income because no dividends are assumed, and cash is the balancing account. The check row confirms that assets equal liabilities and equity in every year, which is the test that the statements are internally consistent.

Why Cash Balances the Statements

The forecast lets cash absorb whatever the other accounts imply, rather than forcing a cash figure and adjusting something else. Each noncash line is driven by its own assumption: receivables, inventory and payables by their day counts, property by capital spending and depreciation, debt by the loan agreement and equity by net income. Cash is then what remains. That choice matters for interpretation. If the forecast had instead held cash at a minimum balance and plugged debt, the same assumptions would show Cobalt repaying its loan, and a reader might mistake a modeling convention for a financing plan. With cash as the balance, the build-up is a result the reader can see and question: it measures how much the business generates beyond its reinvestment needs, before any decision about how to use it.

What the Forecast Shows

Cash builds from $15 million to about $50 million over three years, because operating cash flow of about $28 to $30 million a year exceeds capital spending of $16 to $19 million. Part of the build in year one comes from the collections policy: receivables fall from $41.1 million to $39.9 million even as revenue grows 8%, releasing cash. The forecast therefore implies that Cobalt could repay its $40 million of debt, raise its dividend or fund an acquisition by year three, which is a question for management rather than a conclusion of the model.

Testing the Flagged Assumption

If the collections policy fails and receivables stay at 50 days, year one receivables would be about $44.4 million rather than $39.9 million, and cash about $4.5 million lower; by year three the gap would be about $5 million. The effect is modest because receivables are not a large share of Cobalt's assets, but it shows how much of the year one cash improvement depends on the policy working.

The receivables assumption should be checked against the first two quarterly reports. If days outstanding are not moving toward 45, the forecast should be revised to the historical range. A forecast whose assumptions are set out this way can be updated one line at a time as evidence arrives, rather than being defended or abandoned as a whole (Palepu & Healy, 2013; Penman, 2013).

References

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

Palepu, K. G., & Healy, P. M. (2013). Business analysis and valuation: Using financial statements (5th ed.). Cengage Learning.

Penman, S. H. (2013). Financial statement analysis and security valuation (5th ed.). McGraw-Hill.

What the ACC 486 Topic 7 instructions ask for

ACC-486 Topic 7 asks students to prepare pro forma financial statements from explicit assumptions. Many submissions present statements with assumptions buried in formulas. The assignment rewards forecasts that begin with an assumption register showing each value, its historical range and its source, and flag any assumption outside its history with a reason. Students should build an income statement and balance sheet that balance, explain which account balances the statements, interpret what the forecast implies, and test the flagged assumption to show how much of the result depends on it.

How the ACC-486 Topic 7 example is put together

The finished forecast has two halves, and the first contains no statements at all. It is an assumption register: revenue growth of 8 percent, gross margin of 36 percent, selling and administrative expense at 24 percent of revenue, 45 days of receivables, 70 days of inventory and 40 days of payables on cost of sales, capital spending at 5 percent of revenue and a 25 percent tax rate, all figures illustrative. Beside each sits the three-year historical range and the source. One assumption falls outside its history, receivables at 45 days against a record of 47 to 52, and the register flags it with the reason given, a collections policy management announced. The second half projects the statements: revenue of $324 million, receivables of $39.9 million, inventory of $39.8 million, and a revolver draw that makes the balance sheet balance.

ACC 486 Topic 7 rubric: what Excellent looks like

Faculty grading the pro forma forecast reward assumptions visible before results. Excellent forecasts place historical ranges beside every assumption and flag the one that departs from history with its reason. Credit goes to statements that balance in every year, with a check row and cash as the balancing account explained. The rubric values interpreting the cash build as a result rather than a plan. The highest level tests the flagged assumption and quantifies its effect. Forecasts whose balance sheets do not balance, or whose assumptions are unstated, usually lose marks.

Common ACC 486 Topic 7 mistakes, and how to avoid them

Pro forma work is often marked down before any statement is read, because the assumptions cannot be found. Figures typed directly into projected statements, with no register behind them, leave a marker unable to tell a deliberate assumption from a keying error. Assumptions presented without history give no way to judge whether they are plausible, and many rubrics ask for that comparison. An improvement that departs from the company's record, such as faster collection, carried without a stated reason quietly inflates projected cash. Balance sheets forced to balance by an unexplained plug in equity or other assets are a common and visible defect. Forecasts that project only the income statement lose the most, since the working capital and financing consequences of growth appear only once all three statements are linked.

Get an ACC-486 Topic 7 example written to your instructions

Send the ACC-486 Topic 7 instructions, the rubric and the company or base-year statements your section supplied. We write a custom example to them, with a separate assumption register, each input set against its history and sourced, three linked projected statements and the balancing item explained, in 24 to 48 hours. The first one costs nothing.

More ACC 486 papers and BS in Accounting samples

ACC 486 Topic 7 questions, answered

What is a pro forma statement?

A projected financial statement prepared on stated assumptions rather than from recorded transactions. In coursework the term usually means a forecast income statement, balance sheet and cash flow statement for one or more future years. The statements are only as meaningful as the assumptions behind them, and for that reason the example keeps those assumptions separate and labels every figure as illustrative.

Why does the forecast need a balancing item?

Because projected assets and projected liabilities plus equity are built from different assumptions and will not agree on their own. Something has to absorb the difference, usually cash when the company generates a surplus or a credit line when it needs funding. Reporting the size of that item turns it into a finding: it tells the reader how much financing the forecast implies.

How should an assumption outside the historical range be handled?

By giving it a reason or changing it. A departure from history is not wrong in itself, since companies do change policies and markets shift, but it needs support: an announced plan, a contract, a disclosed change in terms. Where no support exists, the example uses a value inside the range and notes the more optimistic alternative for comparison.

Where can I find a free ACC 486 Topic 7 sample paper?

This page holds the complete forecast: why the register comes first, the register, the income statement, the balance sheet, why cash balances the statements, what the forecast shows and the flagged assumption tested. Send the base-year figures and we will draft the forecast free.

Which assumption is flagged in ACC 486 Topic 7?

Receivables at 45 days of sales, below a 47 to 52 day history, justified by a new collections policy introduced mid-year.