I am new to SharePoint technologies and trying to figure out its suitability for a product to be developed.
I am targeting using only SharePoint Foundation (not the server). Here are some of the key aspect of the target product:
From what you have described, I dont see anything that Sharepoint could do to help you.
Use Sharepoint to create a community portal around sharing of documents and content.
Your requirements would be better suited to an ASP.NET MVC app with a reporting system or templated Excel downloads using OOXML or similar.