COST BENEFIT ANALYSIS CALCULATOR

[Gaurang Mhatre]

Dear Friends,

I have been told to make COST BENEFIT ANALYSIS CALCULATOR for the company.
Request you to help me in this or share the link if you know.

Thanks in advance for your help.

Regards,
Gaurang.

 

[Hui]

Gaurang

Cost benefit analysis generally refers to developing a cash flow model and then using those cash flows to derive Net Present Values and Internal Rates of Return

A cash flow model may be a total cash flow or incremental cash flow
That is you may be Modelling the total cash flows for the business or simply the incremental cash flows for the project/proposal

Both these require that the cash expenditure and revenue be modeled
The cash flow is then the income minus the costs

These are usually calculated on a monthly, quarterly or yearly basis depending on the project

The costs and incomes modeled will be dependent on the business model you are Modelling

 

[NARAYANK991]

Hi Gaurang ,

Just enter

excel cost benefit

in Google , and see how many results you get ; there are several Excel templates available.

Narayan

 

[Gaurang Mhatre]

Thanks alot Hui and Naryank991 for your prompt response.


Regards,
Gaurang