Attachment_G_-_FF_Business_Case_Analysis_Template.xlsx

XLSX spreadsheet 47 KB Posted

Attached to
NextSTEP-2 Appendix K: Commercial Destination Development in Low Earth Orbit Free Flyer Federal contract opportunity
Solicitation number
NNH16ZCQ001K-CDFF
Issued by
National Aeronautics and Space Administration Headquarters

About this file

From the source

Attachment G-Draft Business Case Analysis

View the file

Other files for this federal contract opportunity

Other files attached to NextSTEP-2 Appendix K: Commercial Destination Development in Low Earth Orbit Free Flyer, newest first.
File Type Posted
FF DRFP q&a 1-28-20.docx DOCX document
FF DRFP q&a 1-13-20.docx DOCX document
FF DRFP q&a 1-8-20.docx DOCX document
FF DRFP q&a 1-7-20.docx DOCX document
FF DRFP q&a 12-10-19.docx DOCX document
FF DRFP q&a 11-25-19.docx DOCX document
GCN_Industry_Forum_Charts_Rev_A_-_free_flyer.pptx PPTX presentation
Free_Flyer_Industry_Day_One_on_one.docx DOCX document
NextSTEP-2_BAA_Appendix_K-10-3-19.pdf PDF
Attachment_C_-_Human_Rating_and_Habitability_Criteria_for_FF.docx DOCX document
Attachment_I_-_FF_Request_for_Government_Support_Instructions.docx DOCX document
Attachment_H_-_FF_Pricing_Template.xlsx XLSX spreadsheet
Attachment_E_-_Technical_Library_Contents.pdf PDF
Attachment_D_-_FF_Data_Requirements_List-9-24.docx DOCX document
Attachment_F_-_FF_Requested_Government_Property_Services.docx DOCX document
Attachment_B_-_FF_Model_Contract-9-26-19.docx DOCX document
Attachment_A_-_Statement_of_Work_for_FF.docx DOCX document
FF_q&a.docx DOCX document
Show all 18

On GovTribe

Work with this file on GovTribe

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Overview_Instructions NextSTEP-2 BAA, Appendix K: Commercial Destination Development in Low Earth Orbit (LEO) Free Flyer – Attachment G

Business Case Analysis Template
Revenue, Cost and Commercial Segment Project Financing Instructions
Overview
- The purpose of this workbook is to collect projected yearly revenue, cost and basis of estimate information for the Commercial Destination Free Flyer from GFY 2020 through GFY 2034
- This workbook has separate worksheets for revenue and cost information, revenue basis of estimate, cost basis of estimate, and cash flow information.
- The Business and Technical Approaches should all correlate with one another. The types of Revenue and Cost Projections included in the offeror's workbook should be reflected in their Commercialization, Financial and Technical Approach sections of other documents.
- Below are instructions covering each of these worksheets
Revenue & Cost Projections Worksheet Instructions (Revenue and Cost Worksheet)
General Assumptions
- Revenues and costs are to be entered in then year dollars (escalated)
- Revenues and costs are to be entered in millions of dollars
- Cost information should include direct and indirect or burden costs
- OFI refers to cells for user inputs (Offeror Furnished Information)
Revenue Instructions
- Provide funding and primary revenue streams by product/service as prescribed in the Revenue and Cost worksheet. If there are other categories than the ones listed, there is an Other section with OFI for inclusion.
Cost Instructions
- Cost of Design and Development: Provide the costs associated with Design and Development effort for each element, including any prototype units, with breakdown by work element
- Cost of Flight Unit Build/Test: Provide the costs associated with production, integration and test of the flight element(s), including any loose outfitting hardware such as cables or crew provisions launched separately (if applicable).
- Operations Costs: This includes but is not limited to sustaining engineering, Mission Ops (both ground segment, vehicle processing and on-orbit activities). Also, provide the costs associated with each revenue stream and any other areas required for operations (OFI).
- Transportation: This section is broken out into three categories; element launch, visitor/crew and cargo transportation to and from orbit. Please enter costs into the years that costs are incurred for these services.
- Other. This is to capture costs not included in other template cost categories as required for Operations (OFI).
Proposal Reference or Rationale Instructions (Revenue and Cost Basis of Estimate worksheets)
- Please provide a high level basis of estimate such as vendor quote, historical cost example, in-house estimate or engineering judgement referencing specific Business and Technical Approach descriptions on how each revenue stream or cost category was developed. For example, "Module of similar design and systems previously built in house, estimate based on historical in-house costs, commercialization features based on vendors A and B quotes. Module in-house development and design described in section X and commercialization features described in section Y."
Cash Flow Instructions (Cash Flow worksheet)
- Provide Proforma Cash Flow Statement for Cash Flows from Operating Activities, Cash Flows from Investments, and Cash Flows from Financing Activities.

Revenue and Cost Info

Commercial Segment Revenue and Cost Information
Provider:
Dollars In Millions

Pro Forma Operating Income/Loss Statement

Revenue ($M)

Enterprise-Related Revenue FY20 FY21 FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 FY32 FY33 FY34 Total Proposal Pg. Reference

Accommodations- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
NASA- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Sovereign Govt.- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Tourism- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Research & Development- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
NASA- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Other Govt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Commercial- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Manufacturing- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
NASA- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Other Govt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Commercial- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Satellite Services- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
NASA- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Other Govt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Commercial- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Other- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
NASA - IDIQ Funding- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Total Revenue - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0

Operating Cost ($M)

Enterprise Costs FY20 FY21 FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 FY32 FY33 FY34 Total Proposal Pg. Reference

Commercial Destination Free Flyer NRE Cost (provide additional categories, as needed)

Non Recurring Engineering (NRE) FF- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
NRE OFI
Total Hardware Development Subtotal- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Recurring Engineeering (RE) Flight Unit Build/ Test Cost (provide additional categories, as needed)

FF- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Spares- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Incremental Outfitting Hardware and Delivery (if applicable)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Build/Test- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Total Flight Unit Build and Test Costs Subtotal- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Operation Costs (provide additional categories, as needed) FY20 FY21 FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 FY32 FY33 FY34 Total Proposal Pg. Reference

Sustaining Engineering- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Ground Segment- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Mission Control/Operations- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Vehicle Processing- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Communications, IT, Security- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cost of Accommodations (Professional, NASA, Sovereign, Tourist)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Training
Consumables
Other
Research and Development- 0
Manufacturing- 0
Satellite Services- 0
Other (OFI)- 0
Personnel (Wages/Labor)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Reimbursable ISS Non-Standard Services- 0
Operations Cost Subtotal- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Transportation Cost (provide additional categories, if applicable)

Element Launch- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Element 1- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Element 2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Crew/Visitor Transportation- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cargo Resupply Transportation- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Transportation Subtotal- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Other Costs (provide additional categories, if applicable)

Real Property (Rent, Lease etc)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Insurance- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Licensing- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Other Supplies- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Utilities- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Marketing- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Other Costs Subtotal- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Total Enterprise Costs
Yearly Total Costs- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Operating Income/ Loss Total
Profit / Loss- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cumulative Profit/Loss- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Revenue Basis of Estimate

Commercial Segment Revenue and Financing BOE
Provider:
Dollars In Millions
Revenue ($M)
Define pricing methodology and assumptions for each revenue stream
Enterprise-Related RevenueBasis of Estimate for revenue; include page reference in proposal
Accommodations
NASA
Sovereign Govt.
Tourism
Research & Development
NASA
Other Govt
Commercial
Manufacturing
NASA
Other Govt
Commercial
Satellite Services
NASA
Other Govt
Commercial
Other
NASA - BAA Appx K
OFI
OFI
Financing ($M)
Define pricing methodology and assumptions for each financing source
Project Financing ReceivedBasis of Estimate for financing include page reference in proposal
Project Financing Source 1
OFI
Total Project Financing Received

Cost Basis of Estimate

Commercial Segment Cost BOE
Provider:
Dollars In Millions

Cost ($M)

Enterprise Costs

Commercial Segment NRE Cost Basis of Estimate for NRE Costs with page referance in proposal

Non Recurring Engineering (NRE) FFThis represents the total NRE for FF by lowest reportable work element, including reimbursable NASA services
Work Element 1 - OFI
Work Element 2 - OFI
Work Element 3 - OFI
OFI
NRE OFI
Total Hardware Development Subtotal

Recurring Engineering (RE) Flight Unit Build/ Integrate / Test Cost Basis of Estimate for Recurring Cost with page referance in proposal

FFThis represents the total RE for FF by lowest reportable work element, including reimbursable NASA services
Work Element 1 - OFI
Work Element 2 - OFI
Work Element 3 - OFI
OFI
Spares
OFI
OFI
Incremental Outfitting Hardware and Delivery (if applicable)
Build/Test
Total Flight Unit Build and Test Costs Subtotal
Operations CostsBasis of Estimate for Operations Costs with page referance in proposal
Define quantity and type of crew per year, length of crew stay, and quantity of consumables and experiments flown per year
Sustaining Engineering
Ground Segment
Mission Control/Operations
Vehicle Processing
Communications, IT, Security
Cost of Goods Sold, Materials, Etc.
Accommodations (Professional, NASA, Sovereign, Tourist)
Research and Development
Manufacturing
Satellite Services
Other (OFI)
Program Management Costs
Personnel
Contingency Funding/Management Reserves
Subcontractor 1
Operations Cost Subtotal
Transportation CostBasis of Estimate for Transportation Cost with page referance in proposal
Define number of flights per year, price per kg for cargo, price per seat for crew
Element Launch
Crew/Visitor Transportation
Cargo Resupply Transportation
Transportation Subtotal
Other CostsBasis of Estimate for Other Costs with page referance in proposal
Provide details for each of these "other" costs
Project Financing Source 1
Principal
Interest
Insurance
Licensing
OFI
Other Costs Subtotal

Cash Flow

Commercial Segment Business Approach Template
Provider:
Dollars In Millions
ProForma Statement of Cash Flows
Cash Flow from Operating ActivitiesFY20FY21FY22FY23FY24FY25FY26FY27FY28FY29FY30FY31FY32FY33FY34TotalProposal Pg. Reference
Cash Received from Customers (OFI as needed)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
NASA- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Sovereign Govt.- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Tourism- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cash Paid to Suppliers, Staff & Employees (OFI as needed)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Other Govt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Commercial- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Commercial- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Cash Generated from Operating Activities (OFI as needed)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
NASA- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Other Govt- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Commercial- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Other (OFI as needed)- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Interest Paid- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Taxes Paid- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Net Cash Flow from Operations - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0

Cash Flow from Investment FY20 FY21 FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 FY32 FY33 FY34 Total Proposal Pg. Reference

Equipment Purchases (OFI as needed)

Non Recurring Engineering (NRE) FF- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
OFI- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
NRE OFI
Total Proceeds from Equipment Purchases- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Equipment Replacement

Item#1- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Item #2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Item#3- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Total Proceeds from Equipment Replacement - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0

Proceeds from Equipment Sales

Item#1- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Item#1- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Item#2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Total Proceeds from Equipment sales- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Net Cash Flow from Investment - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0

Cash Flow from Financing FY20 FY21 FY22 FY23 FY24 FY25 FY26 FY27 FY28 FY29 FY30 FY31 FY32 FY33 FY34 Total Proposal Pg. Reference

Proceeds from capital Contributed- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Source 1- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Source 2- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Source 3- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Source 4- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Proceeds from loans- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Source 1- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Source 2- 0
Source 3- 0
Source 4- 0
Source 5- 0
Loan payments- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Source 1- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0
Source 2- 0
Source 3- 0
Source 4- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0

Net Cash Flow from Financing - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0

Net Increase/Decrease in Cash - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0 - 0

File details come from the government source that posted it.