A composite distributor's thirteen weeks, receipts drawn from a collection curve and outflows dated, show borrowing peaking at 49.6 million in this GF583 Unit 5 weekly cash forecast. Searches like "gf 583 unit 5 assignment example", "gf583 unit 5 sample" and "gf583 unit 5 example" land here.
What a finished GF583 Unit 5 weekly cash forecast looks like
A table of thirteen weekly columns on one page, an assumptions page before it and a variance template after. Opening cash is 26.0 million and the policy minimum 12.0 million. Invoiced sales start near 44.0 million a week and climb by 1.6 million weekly through the spring build to 56.8 million in week nine. Receipts follow a stated curve: 8 percent of a week's invoices collected one week later, 22 percent at two weeks, 30 at three, 21 at four, and the rest over weeks five to seven, with half a percent assumed uncollected. Outflows are listed by type and date. Week seven carries the 38.5-million vaccine invoice, payroll and an 11.2-million tax payment, 100.7 million against receipts of 48.1, so the line peaks at 49.6 million.
How a GF583 Unit 5 example is structured
Assumptions come before any figure, numbered so every row in the table can cite one: the collection curve and the invoice history it was fitted to, purchase commitments from the buying plan, payroll dates from the calendar, tax dates from the prior year's estimates, and the minimum balance with its reason. The table keeps a fixed row order: opening cash, receipts, disbursements by type, net flow, cash before financing, draw or repayment, cumulative borrowing and closing cash. Borrowing is formula-driven rather than typed in, drawing whatever keeps closing cash at 12.0 million and repaying as surpluses appear, so the peak in week seven and the 6.5 million still owed after week thirteen fall out of the arithmetic. A sensitivity strip then slows the collection curve by one week. The variance template, blank actuals columns beside each forecast week, closes the document.
Numbered assumptions, cited by row
Seven numbered assumptions sit on the page before the table, and each receipt or payment row carries the number of the assumption it depends on.
A curve fitted to invoice history
Collections of 8, 22, 30 and 21 percent over the first four weeks, with the remainder spread across three more, turn each week's invoicing into dated receipts.
Week seven, row by row
Purchases of 77.0 million including the vaccine invoice, payroll of 9.4, operating costs of 3.1 and tax of 11.2 total 100.7 million, which the week's 48.1 million of receipts cannot meet.
Borrowing that calculates itself
Draws and repayments follow from the 12.0-million minimum, so the 49.6-million peak and the 6.5 million outstanding after week thirteen are outputs of the model, not entries.
Actuals column left open
Beside every forecast week sits an empty column for actual receipts and payments, which turns next month's variance review into a matter of filling cells.
Where marks go in GF583 Unit 5
Receipts entered as round numbers with no link to invoices are where GF583 forecasts typically give up the most credit, since a grader cannot test a figure that rests on nothing. A monthly forecast submitted for a weekly prompt draws comment as well, because the week-seven cluster disappears inside a month that nets out comfortably. Borrowing typed as a fixed amount, instead of calculated from the minimum balance, breaks as soon as any line changes and shows the mechanism was not understood. Outflows missing a known date, such as a quarterly tax payment, understate the trough. Without any sensitivity, a forecast reads as a certainty. Leaving out the variance template costs less on its own but removes the check a treasurer would run the following month against actual receipts.
Get a GF583 Unit 5 example written to your instructions
Whatever the Unit 5 case hands over, sales history, payment terms, a payroll calendar or a starting balance, forward it with the rubric and whatever template the instructor posted. A custom forecast ties every row to a stated assumption and computes financing from the minimum balance, returned in 24-48h and free the first time.
GF583 Unit 5 questions, answered
How many weeks should the forecast cover?
Thirteen, one quarter, is the common treasury convention and a frequent default in course prompts, but follow the length your assignment sets. Shorter horizons suit a firm under strain, where each week matters, and longer ones usually switch to monthly columns beyond the first quarter. Whatever the length, weekly columns should cover the period where timing decides whether cash runs short.
Where does a collection curve come from?
From the firm's own history: take several months of invoices, record the week each one was paid, then average the percentages collected at each lag. If the case supplies aging data rather than payment history, derive an approximate curve from it and say so. A curve stated with its source persuades a grader far more than a single average collection period does.
Should borrowing appear inside the forecast or after it?
Inside, as its own rows below cash before financing. Showing draws and repayments in the table lets a reader see when the line is used, how long each draw lasts and whether the forecast ends with debt still outstanding. Placing financing only in a note hides the number a lender or treasurer looks for first, which is the peak.