FIN 375 Week 1 Small Business Finance and Forecasting Example

A Bike Shop Owner's First Real Forecast: Why Financial Management Decides Whether a Small Business Survives, and a Sales Forecast Built From Units, Seasons and E-Bike Growth

[Student Name]

University of Phoenix

FIN/375: Financial Management in the Small Business

Week 1 Assignment

[Instructor Name]

[Date]

The bicycle shop and all figures are composites written for a model paper; concepts and research findings come from the sources listed.

A composite bicycle shop has operated for eleven years, now from two locations in a college town and a nearby suburb. It sells road, mountain, gravel and children's bikes, a growing line of electric bikes, parts and accessories and a repair service that runs at capacity each spring. Sales last year were $2.3 million. The owner, a former mechanic, has kept books with a part-time bookkeeper but has never prepared a forecast. After a spring in which the shop ran short of cash while its stockroom was full, the owner decided to learn to plan. In a small business, the owner is also the finance department, and the first tool that department needs is an honest forecast of sales. This paper explains the role of financial management and builds that forecast.

Why Financial Management Decides Survival

Small businesses differ from large corporations in ways that make finance more urgent. They cannot issue stock or bonds, so they rely on the owner's money, retained profits and bank credit. They often have thin cash cushions. And their owners must manage finance alongside sales, staff and operations. A profitable shop can still fail if cash runs out during a season when inventory must be bought before customers arrive. Studies of small business failure repeatedly point to undercapitalization and poor cash management among the main causes (Scarborough & Cornwall, 2019).

The Owner's Financial Duties

The owner's duties are practical: keep accurate records each week, review cash and payables every Monday, forecast sales and cash for the season ahead, set prices that cover costs, decide how much inventory to order and when and maintain a relationship with the bank before credit is needed, since small firms with established banking relationships find credit easier to obtain (Petersen & Rajan, 1994). Each later week of planning, budgets, cash management, financing and performance monitoring, depends on the forecast built here.

Building the Forecast by Line

The shop's sales come from four lines with different drivers. Conventional bikes, road, mountain, gravel and children's, sold 1,120 units last year at an average of $820, about $918,000. Industry reports after the pandemic surge describe a market that has settled back toward pre-2020 levels, and the shop's own unit sales fell 4% last year. The forecast assumes units flat and prices up 3%, about $946,000.

Electric bikes sold 260 units at an average of $2,600, about $676,000, up 35% in units from the prior year as commuters and older riders adopted them. The forecast assumes 20% unit growth, slower than last year because competition from online brands is rising, and a flat average price, about $811,000.

Parts and accessories, helmets, lights, locks, tires and clothing, have run at about 28% of bike sales, since most accessory sales accompany a bike purchase. At that rate they forecast about $492,000.

Repairs are limited by capacity: four mechanics, each billing about 1,450 hours a year at an average labor and parts ticket of $68 per hour of work, about $394,000. The owner plans to add a fifth mechanic for the spring season, adding about 500 hours and $34,000. Repair revenue forecasts at about $428,000.

Total forecast sales are about $2.68 million, up about 16%, mostly from e-bikes and repairs.

Seasonality

The shop's sales are highly seasonal. Over the past three years, about 42% of annual sales came in April through June and only about 12% in December through February, with a smaller bump before the holidays for children's bikes. The forecast applies monthly weights from those three years to each line, with repairs weighted more evenly because winter tune-ups and indoor trainer setups keep mechanics busy. The monthly forecast shows May as the peak, at about $390,000, and January as the low, at about $95,000.

Gross Margin by Line

The forecast also sets the stage for profit planning, because each line carries a different margin. Conventional bikes earn a gross margin of about 38%, e-bikes about 30% because of competition, parts and accessories about 48% and repairs about 70%, since labor is the main cost. The shift toward e-bikes lowers the average margin slightly, while growth in repairs raises it. The owner can see from the forecast that the repair shop, though smaller in revenue, contributes a large share of gross profit, which supports adding the fifth mechanic.

Testing the Forecast

The forecast was checked three ways. Applying the same method to the prior year's starting data would have forecast last year's sales within 5%. The e-bike growth assumption is below the shop's recent growth but above national unit growth reported by industry groups, a middle position. And the total implies sales per square foot and per employee within the range the shop achieved before the pandemic surge.

Risks in the Forecast

The riskiest assumption is e-bike growth. If it slows to 5%, forecast sales fall by about $100,000. A wet spring could shift sales into summer or reduce them. A new online brand opening a local showroom could lower conventional bike sales. The owner will compare actual sales with the monthly forecast each month and update the forecast in May, when the season's direction is clear.

Why the Forecast Matters

Timmons and Spinelli (2009) emphasize that entrepreneurs must manage the cash needs created by growth, since growth consumes cash before it produces it. For the bike shop, the forecast is the starting point for the inventory purchases, staffing and borrowing that will be planned in the coming weeks.

Conclusion

Financial management in a small business is the owner's daily work of records, cash and planning. The bike shop's forecast, built line by line from units, prices and repair capacity and spread across months by seasonal weights, projects sales of about $2.68 million, driven by electric bikes and repairs, with a sharp spring peak. That monthly shape, more than the annual total, will drive the budgets and cash plan that follow.

References

Petersen, M. A., & Rajan, R. G. (1994). The benefits of lending relationships: Evidence from small business data. The Journal of Finance, 49(1), 3-37. https://doi.org/10.1111/j.1540-6261.1994.tb04418.x

Scarborough, N. M., & Cornwall, J. R. (2019). Essentials of entrepreneurship and small business management (9th ed.). Pearson.

Timmons, J. A., & Spinelli, S. (2009). New venture creation: Entrepreneurship for the 21st century (8th ed.). McGraw-Hill.