Fill in the costs and benefits (including the discounted values) up till year 20 to find the total cost and benefit. Please show the results using the maximum trash amount and the maximum operating cost. parameters trash amount 700 min amount 700 max amount 900 days 260 sorting cost 10 operating cost 80 min cost 50 max cost 80 landfill saving 100 mulch cost 10 discount 0,03 % compostable 58% costs year sorting cost discounted cost 0 $ - $ - 1 $ 1.820.000,00 $ 1.766.990,29 2 3 etc total sorting cost: pv formula year operating cost discounted cost 0 $ - $ - 1 $ 8.444.800,00 $ 8.198.834,95 2 3 etc total operating cost: pv formula year construction cost discounted cost 0 $ 45.000.000,00 $ 45.000.000,00 total fixed cost: $ 45.000.000,00 total cost: benefits year landfill benefit discounted benefit 0 $ - $ - 1 $ 10.556.000,00 $ 10.248.543,69 2 3 etc total saving benefit: pv formula year mulch benefit discounted benefit 0 $ - $ - 1 $ 527.800,00 $ 512.427,18 2 3 etc total mulch benefit: pv formula total benefit: $ -

Fill in the costs and benefits (including the discounted values) up till year 20 to find the total cost and benefit. Please show the results using the maximum trash amount and the maximum operating cost. parameters trash amount 700 min amount 700 max amount 900 days 260 sorting cost 10 operating cost 80 min cost 50 max cost 80 landfill saving 100 mulch cost 10 discount 0,03 % compostable 58% costs year sorting cost discounted cost 0 $ - $ - 1 $ 1.820.000,00 $ 1.766.990,29 2 3 etc total sorting cost: pv formula year operating cost discounted cost 0 $ - $ - 1 $ 8.444.800,00 $ 8.198.834,95 2 3 etc total operating cost: pv formula year construction cost discounted cost 0 $ 45.000.000,00 $ 45.000.000,00 total fixed cost: $ 45.000.000,00 total cost: benefits year landfill benefit discounted benefit 0 $ - $ - 1 $ 10.556.000,00 $ 10.248.543,69 2 3 etc total saving benefit: pv formula year mulch benefit discounted benefit 0 $ - $ - 1 $ 527.800,00 $ 512.427,18 2 3 etc total mulch benefit: pv formula total benefit: $ -

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter28: Statistics And Linear Regression (stats)

Section: Chapter Questions

Problem 1R

See similar textbooks

Related questions

Question

Fill in the costs and benefits (including the discounted values) up till year 20 to find the total cost and benefit.

Please show the results using the maximum trash amount and the maximum operating cost.

parameters
trash amount	700	min amount	700
		max amount	900
days	260
sorting cost	10
operating cost	80	min cost	50
		max cost	80
landfill saving	100
mulch cost	10
discount	0,03
% compostable	58%

costs
year	sorting cost	discounted cost
0	$ -	$ -
1	$ 1.820.000,00	$ 1.766.990,29
2
3
etc
total sorting cost:
pv formula

year	operating cost	discounted cost
0	$ -	$ -
1	$ 8.444.800,00	$ 8.198.834,95
2
3
etc
total operating cost:
pv formula

year	construction cost	discounted cost
0	$ 45.000.000,00	$ 45.000.000,00
total fixed cost:		$ 45.000.000,00

total cost:

benefits
year	landfill benefit	discounted benefit
0	$ -	$ -
1	$ 10.556.000,00	$ 10.248.543,69
2
3
etc
total saving benefit:
pv formula

year	mulch benefit	discounted benefit
0	$ -	$ -
1	$ 527.800,00	$ 512.427,18
2
3
etc
total mulch benefit:
pv formula

total benefit:		$ -

total NPV		$ -

Expert Solution

Step by step

Solved in 4 steps with 13 images

SEE SOLUTION Check out a sample Q&A here