Product Profitability Analysis

[ramesh chandra keer]

Please make me understand how to do evaluation of Product Profitability Analysis using excel,by any example

 

[brettdj]

This is a very broad question about building a finanicial model

For input you would be best served looking for a template, or existing free model on the web

That said this should be relatively easy for you to build up

- set an appropriate time period (years/quarters/months etc)
- units of production
- fixed and variable costs
- investment capital and depreciation
- revenue assumptions
- tax/royalty assumptions etc

Cheers

Dave