September borrowing near 41,000 dollars is where MT209's Unit 5 cash flow projection lands once three collection patterns meet the rush, every assumption labeled. Searches like "mt 209 unit 5 assignment example", "mt209 unit 5 sample" and "mt209 unit 5 example" land here.
What a finished MT209 Unit 5 cash flow projection looks like
A spreadsheet of twelve monthly columns beginning in January, with an assumptions page in front. Receipts are split by customer group because each pays differently: counter sales arrive the same day, business accounts about thirty days after invoice, and school purchase orders about fifty-two days, so August's shipments turn into cash in October. Payments follow their own timing: blank garments paid thirty days after delivery, payroll every two weeks, rent of 4,200 dollars, an equipment loan, and the owner's draw. The running balance starts at 22,000 dollars, falls through August as blanks are bought for the rush, and reaches its lowest point in late September, when 41,000 dollars of the credit line is drawn. A sensitivity table shows the trough if schools pay twenty days later.
How a MT209 Unit 5 example is structured
Assumptions, receipts, payments, balance, sensitivity, responses. The assumptions page leads because a projection is only as credible as its stated collection and payment timing, and every figure after it can be traced to a line there. Receipts come next, built from the sales calendar in the business profile and shifted forward by each group's payment lag, which is where the seasonal shape first appears. Payments are entered on the dates cash actually leaves, not the dates costs are incurred. The balance row runs beneath both, with the credit line shown as a separate row so borrowing is visible rather than netted away. A sensitivity section tests the two assumptions the trough depends on most, school payment timing and August volume. The projection closes with three responses sized to the gap: deposits on booster orders, card payment for small school orders, and longer distributor terms on August purchases.
An assumptions page first
Collection lags by customer group, payment terms by supplier, payroll dates, rent and the owner's draw, each on one line that later cells refer back to.
Three ways customers pay
Counter sales settle the same day, business accounts in about thirty days, school purchase orders in about fifty-two, which carries August's work into October's receipts.
Cash out on the day it leaves
Blanks bought for the rush are paid thirty days after delivery, so the heaviest outflows land in August and September, before school money arrives.
The credit line in its own row
Borrowing peaks near 41,000 dollars in late September, shown separately so the reader sees exactly how close the shop comes to its 50,000-dollar limit.
If schools pay twenty days later
The sensitivity table deepens the trough past the credit limit, the finding that makes deposits and card payment for small orders worth proposing.
Where marks go in MT209 Unit 5
Projections that report monthly profit and call it cash flow lose the largest share, since the unit exists to separate the two. A shop that invoices 110,000 dollars in September and collects half of it in November has a September problem no income statement shows. Missing assumptions come next; a column of figures without stated collection timing cannot be checked or adjusted. Treating all customers as paying alike flattens the pattern that causes the trough. Hiding the credit line inside the balance understates how close the business comes to its limit. Many sections expect at least one sensitivity test, since the projection's value lies in what happens when a key assumption slips. Responses that are not sized to the gap, such as general advice to cut costs, earn little.
Get a MT209 Unit 5 example written to your instructions
Share whatever figures the owner will release, sales by month, how each customer group pays, the main bills, and include the MT209 Unit 5 instructions and rubric. The projection is built monthly, assumptions stated up front, borrowing shown separately and a sensitivity test run on the weakest assumption. First custom sample free, delivered in 24-48h.
MT209 Unit 5 questions, answered
Should the projection be monthly or weekly?
Monthly is standard in most MT209 sections and is what the sample uses. A business with a sharp seasonal peak may benefit from weekly detail for its tightest months, since a monthly view can hide a mid-month low when payroll falls before receipts arrive. If your instructions specify a period, follow them; otherwise monthly with a note about the tight weeks is usually enough.
Where do the collection timing figures come from?
Ideally from the business's own records, such as the average days between invoice and payment for each customer group. The sample's lags are composite figures of the kind an owner could pull from accounting software, and each is labeled. Without records, an owner's estimate stated as an estimate is acceptable, and the sensitivity table shows what happens if it proves wrong.
What is the difference between this and a profit forecast?
A profit forecast records sales when earned and costs when incurred; a cash flow projection records money when it actually moves. The two diverge whenever customers pay late or supplies are bought ahead of sales. The sample's shop is profitable for the year yet nearly exhausts its credit line in September, which only the cash view reveals.