Alta Vista Coffee Roasters Financial Projections

Alta Vista Coffee Roasters, Your Five-Year Model Your model tells a classic build-then-earn story. Revenue grows from $373,911 in year one to $1.2M in year five, more than tripling, and the business turns profitable in year three, finishing the plan with $389,615 in the bank. The route there runs through a narrow cash window in early 2029, and that window deserves your attention. Revenue and margins. Net revenue climbs every year of the plan, from $373,911 in year one to $1,183,665 in year five. Gross margin starts at 68% and settles at 65%, healthy and stable, which means the profitability story below is driven by scale, not by margin erosion. Path to profitability. The first two years are investment years: the model shows a net loss of $162,042 in year one, narrowing to $73,056 in year two, less than half, as revenue catches up with operating costs. Month 27, March 2029, is your first profitable month, and from that point forward the model stays profitable on a pre-tax basis for the rest of the plan, reaching net income of $192,444 in year five. Cash, the number that matters most. Your cash low point is $14,636, in February 2029, the month before you turn profitable. Your initial funding carries you almost exactly to breakeven, and the levers here are yours: a contingency line of credit arranged before the window opens, or shifting any discretionary spending until after the turn. Cash never goes negative in this plan, but everything between launch and March 2029 is the danger zone, a slow quarter or one delayed account in that window eats directly into that cushion. After the turn, cash builds steadily to $389,615 at the end of year five. A note on taxes. You'll see taxes at $0 for the first four years, then a single charge of $54,801 in December 2031. This is correct, not an error: the model carries your early losses forward (a net operating loss carryforward), so no tax is due until cumulative profits have absorbed those losses, and then the catch-up charge lands. That's also why net income dips in that final month. Debt service and coverage. Your $120,000 loan runs ten years at 9.5% interest, costing $11,077 in interest in year one and declining each year as the balance amortizes, for a total of $47,101 over the five years. Coverage is the lender's first question, and your answer is a good one: the early loss years read negative, normal launch shape, and once operations stabilize, coverage starts at 3.12 in year three, well clear of the 1.25 practitioner norm lenders apply, then climbs to 9.00 and 10.91. The capital need. Before financing, the plan digs to a cumulative low of $323,153 in January 2029, at an average pace of $12,926 a month. Your $235,000 in equity funding and $120,000 loan together cover that hole, the model's financing is sized to the plan it carries. What to watch: - The cash window from launch through March 2029, the $14,636 low is your minimum cushion. Have the contingency line of credit in place before that window, not during it. - Years one and two both run at a loss, with the year-two loss narrowing to less than half of year one. - The December 2031 tax true-up of $54,801, flag it to your accountant now so it's planned cash, not a surprise. Open the workbook and start with the Financials sheet: the monthly view shows exactly how the climb happens.