[go: up one dir, main page]
Scribd
Upload
15 views3 pages

Cost Benefit Analysis 01

The cost-benefit analysis indicates an overall cost to benefit ratio of 1.24 to 1, with cumulative costs reaching $4,200.00 and cumulative benefits totaling $3,850.00 over five years. The analysis shows a net benefit or cost of -$1,050.00 by year three, with projections for future years. The document includes detailed breakdowns of costs and benefits across multiple years.

Uploaded by

Harizo Rakoto
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
15 views3 pages

Cost Benefit Analysis 01

The cost-benefit analysis indicates an overall cost to benefit ratio of 1.24 to 1, with cumulative costs reaching $4,200.00 and cumulative benefits totaling $3,850.00 over five years. The analysis shows a net benefit or cost of -$1,050.00 by year three, with projections for future years. The document includes detailed breakdowns of costs and benefits across multiple years.

Uploaded by

Harizo Rakoto
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Cost Benefit Analysis

Overall Cost to Benefit Ratio 1.24 to 1

YEAR 1 YEAR 2 YEAR 3

COSTS

Project Expenditures $ 600.00 $ 200.00 $ 400.00


Personnel Expenses $ 200.00 $ 100.00 $ 200.00
Infrastructure Charges $ 100.00 $ 300.00 $ 100.00
Recurring Financial Outlays $ 450.00 $ 50.00 $ 1,500.00

TOTAL $ 1,350.00 $ 650.00 $ 2,200.00


Cumulative Costs $ 1,350.00 $ 2,000.00 $ 4,200.00

BENEFITS

Earnings & Profit $ 200.00 $ 450.00 $ 250.00


Expense Reductions $ 200.00 $ 650.00 $ 100.00
Additional Advantages $ 950.00 $ 250.00 $ 800.00

TOTAL BENEFITS $ 1,350.00 $ 1,350.00 $ 1,150.00


Cumulative Benefits $ 1,350.00 $ 2,700.00 $ 3,850.00
NET BENEFIT OR COST $ - $ 700.00 -$ 1,050.00

Instructions
→ To add more line items, right-click on a row and select "Insert more rows". Ensure you duplicate and drag
→ If you need extra columns, for specific years or months, simply add them and then copy an existing colum
YEAR 4 YEAR 5 TOTAL

C
$ 300.00 $ 1,000.00 $ 2,500.00
Brea
$ 100.00 $ 650.00 $ 1,250.00
$ 200.00 $ 700.00 $ 1,400.00 $9,000.00

$ 200.00 $ 450.00 $ 2,650.00


$ - $8,000.00

$ -
$ - $7,000.00

$ -
$ 800.00 $ 2,800.00 $ 7,800.00 $6,000.00

$ 5,000.00 $ 7,800.00
$5,000.00

$ 700.00 $ 300.00 $ 1,900.00


$4,000.00
$ 700.00 $ 400.00 $ 2,050.00
$ 100.00 $ 200.00 $ 2,300.00
$3,000.00
$ -
$ -
$2,000.00
$ -
$ -
$1,000.00
$ -
$ 1,500.00 $ 900.00 $ 6,250.00
$-
$ 5,350.00 $ 6,250.00 YEAR 1 YEAR 2

$ 700.00 -$ 1,900.00 -$ 1,550.00

nsure you duplicate and drag a previous row downward to retain the formulas.
d then copy an existing column over. Doing so will make certain the formulas stay intact.
Cost / Benefit
Breakeven Analysis

YEAR 2 YEAR 3 YEAR 4 YEAR 5

COSTS BENEFITS

You might also like