$75.00 USD
After purchase, the template will be immediately available to download. This is also included in the industrial sector models bundle, the industry-specific models bundle, and The Super Smart Bundle.
Template Features:
- Account for 4 lines of business: Launch Services, Satellite Manufacturing, Satellite Operation and Management, Constellation (direct-to-consumer services).
- Includes 3-statement model integration (monthly and annual) Income Statement, Balance Sheet, and Statement of Cash Flows.
- Includes an annual executive summary and key visualizations that are dynamic.
- All output reports automatically update as assumptions are adjusted.
- Includes customer payment timing offsets, vendor payment offsets, and all relevant effects on cash flow and balance sheet line items (accounts receivable, accounts payable, unearned revenue, and inventory).
Launch Service Economics:
- Up to 3 launch types.
- Define revenue and cost per launch.
- Define the count of launch missions started per month by type.
- Define the number of months it takes from the mission start to the actual launch event.
- Define when customer payments are collected relative to the mission start month.
- Define when direct launch costs are paid relative to the mission start month.
Satellite Manufacturing and Ongoing Management:
- Up to 3 satellite types.
- Define sales price per type and direct material costs per type.
- Define when customer payments are collected relative to the order month as well as when material costs are paid relative to order month.
- The user can define how many months in advance direct materials are purchased for.
- Define the length of time each type of satellite is in orbit for (in months), the percentage of satellites manufactured that will be managed, and the ongoing monthly revenues and direct expenses to manage those satellites.
- Indirect factory overhead is also included in manufacturing gross profit.
- Property, Plant, and Equipment depreciation are shown in the manufacturing gross profit.
Constellation Services:
- Define customers added per month for up to 3 pricing tiers.
- Define monthly price, monthly retention curves for each, one-time revenue, one-time costs, direct customer acquisition costs by type, and ongoing costs to maintain these accounts.
Fixed Cost Schedule:
- To account for non-direct expenses such as research and development, executive salaries, and a workforce that scales over time, I've built a robust schedule with 100s of slots that can be filled out to account for corporate overheads and other fixed costs over the 10-year period.
I've also included a few inputs to account for manufacturing waste, launch failures, and payroll taxes / benefits.
After you have gone through and configured all these assumptions, a monthly and annual pro forma will automatically populate for up to a 10-year period. The user can select how long they want this forecast to last for be selecting an end month on the 'Control' tab.
In my opinion, this financial model has a lot of utility for many types of businesses. The logical frameworks, customer / vendor payment offsets, and recurring revenue assumptions make it a really good reference for any manufacturing company, large-ticket service provider, and/or B2C SaaS.
Check out More Templates:
