Complete the yellow cells. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Discounting of user benefits: Discount Project costs User benefits Other Benefits Rate Journey CO₂ Safety Noise, Physical Indirect % Quality, (human costs), Activity- tax health, revenues, £ £ £ £ £ £ £ £ Discounted user benefits: Discount Discounted Project Other discounted benefits: Journey CO₂ Safety, Noise Factor Costs Quality to 2010 (human costs) Physical Activity - tax health Indirect revenues base year £ £ £ £ £ £ 1 £ £ 2022 2023 2024 2025 20,940,000 12,498,890 2026 21,900,000 12,629,859 2027 4,549,983 11,638 1,574 12,169 2028 4,632,123 11,812 1,747 12,340 761 772 105,798 -9,271 0 6,485 877 9,448 107,385 -9,496 0 6,359 941 9,439 591 590 82,140 -5,166 82,140 -5,112 2029 4,714,398 11,990 1,940 12,513 783 108,996 -9,719 0 6,236 1,009 9,430 590 82,140 -5,055 2030 4,797,478 12,169 2,153 12,688 794 110,631 -10,007 0 6,116 1,082 9,420 589 82,140 -5,029 2031 4,881,354 2032 4,966,045 2033 5,051,580 2034 5,137,991 2035 5,225,332 2036 5,313,671 2037 5,403,062 2038 5,493,575 2039 5,585,319 13,914 5,507 12,352 2,390 12,865 12,537 2,653 13,045 12,725 2,944 13,228 12,916 3,268 13,413 13,110 3,628 13,601 13,307 4,027 13,791 13,506 4,470 13,985 13,709 4,962 14,180 14,379 805 816 827 112,291 -10,204 0 5,998 1,160 9,411 589 82,140 -4,955 113,975 -10,572 0 5,882 1,244 9,402 588 82,140 -4,960 115,684 -10,795 0 5,768 1,335 9,392 587 82,140 -4,893 839 117,420 -11,039 0 5,657 1,431 9,383 587 82,140 -4,835 851 119,181 -11,447 0 5,547 1,535 9,374 586 82,140 -4,844 863 120,969 -11,742 0 5,440 1,646 9,365 586 82,140 -4,800 875 122,783 -12,020 0 5,335 1,766 9,355 585 82,140 -4,748 887 124,625 -12,418 0 5,232 1,894 9,346 585 82,140 -4,739 2040 5,678,404 14,123 6,113 14,580 899 912 126,494 -12,760 0 5,131 2,031 9,337 584 82,140 -4,705 128,392 -13,141 0 5,032 2,178 9,328 583 82,140 -4,682 2041 5,772,920 14,335 6,786 2042 5,868,924 14,550 7,532 2043 5,966,400 14,768 8,360 2044 6,065,335 14,990 9,280 14,784 14,991 15,201 15,414 925 130,318 -13,466 0 4,935 2,336 9,319 583 82,140 -4,635 938 132,272 -13,849 0 4,839 2,505 9,309 582 82,140 -4,606 951 134,257 -14,010 0 4,746 2,687 9,300 582 82,140 -4,502 964 136,270 -14,283 0 4,654 2,881 9,291 581 82,140 -4,435 2045 6,165,708 15,215 10,301 15,630 978 138,314 -14,701 0 4,564 3,090 9,282 581 82,140 -4,410 2046 6,267,474 15,443 11,434 15,849 991 140,389 -15,047 0 4,476 3,314 9,273 580 82,140 -4,361 2047 6,370,508 2048 6,474,731 2049 6,580,051 2050 6,686,373 2051 6,793,611 2052 6,901,678 16,886 17,707 17,227 15,674 12,692 16,070 1,005 15,910 14,088 16,295 1,019 16,148 15,638 16,524 1,033 16,390 17,358 16,755 1,048 16,636 17,531 16,989 1,063 1,077 142,495 -15,319 0 4,389 3,554 9,264 579 82,140 -4,290 144,632 -15,527 0 4,305 3,812 9,255 579 82,140 -4,201 146,802 -15,722 0 4,221 4,088 9,245 578 82,140 -4,110 149,004 -15,917 0 4,140 4,384 9,236 578 82,140 -4,020 151,239 -16,123 0 4,060 4,278 9,227 577 82,140 -3,934 153,508 -16,593 0 3,981 4,175 9,218 577 82,140 -3,912

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question

a)How do you calculate the correct social discount rate for each year, for user benefits in excel here 

b) how do you calculate the discount factor for each year using the discount rates from (a) in excel . Assume that the base year for discounting is 2010 

 

 

 

Complete the yellow cells.
Year
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
Discounting of user benefits:
Discount
Project costs
User benefits
Other Benefits
Rate
Journey
CO₂
Safety
Noise,
Physical Indirect
%
Quality,
(human
costs),
Activity- tax
health,
revenues,
£
£
£
£
£
£
£
£
Discounted user benefits:
Discount
Discounted
Project
Other discounted benefits:
Journey
CO₂
Safety,
Noise
Factor
Costs
Quality
to 2010
(human
costs)
Physical
Activity - tax
health
Indirect
revenues
base year
£
£
£
£
£
£
1
£
£
2022
2023
2024
2025
20,940,000
12,498,890
2026
21,900,000
12,629,859
2027
4,549,983
11,638 1,574 12,169
2028
4,632,123
11,812 1,747 12,340
761
772
105,798
-9,271
0
6,485
877
9,448
107,385
-9,496
0
6,359
941
9,439
591
590
82,140
-5,166
82,140
-5,112
2029
4,714,398
11,990 1,940 12,513
783
108,996
-9,719
0
6,236
1,009
9,430
590
82,140
-5,055
2030
4,797,478
12,169 2,153 12,688
794
110,631
-10,007
0
6,116
1,082
9,420
589
82,140
-5,029
2031
4,881,354
2032
4,966,045
2033
5,051,580
2034
5,137,991
2035
5,225,332
2036
5,313,671
2037
5,403,062
2038
5,493,575
2039
5,585,319
13,914 5,507
12,352 2,390 12,865
12,537 2,653 13,045
12,725 2,944 13,228
12,916 3,268 13,413
13,110 3,628
13,601
13,307 4,027 13,791
13,506 4,470 13,985
13,709 4,962
14,180
14,379
805
816
827
112,291
-10,204
0
5,998
1,160
9,411
589
82,140
-4,955
113,975
-10,572
0
5,882
1,244
9,402
588
82,140
-4,960
115,684
-10,795
0
5,768
1,335
9,392
587
82,140
-4,893
839 117,420
-11,039
0
5,657
1,431
9,383
587
82,140
-4,835
851 119,181
-11,447
0
5,547
1,535
9,374
586
82,140
-4,844
863
120,969
-11,742
0
5,440
1,646
9,365
586
82,140
-4,800
875 122,783
-12,020
0
5,335
1,766
9,355
585
82,140
-4,748
887 124,625
-12,418
0
5,232
1,894
9,346
585
82,140
-4,739
2040
5,678,404
14,123 6,113 14,580
899
912
126,494
-12,760
0
5,131
2,031
9,337
584
82,140
-4,705
128,392
-13,141
0
5,032
2,178
9,328
583
82,140
-4,682
2041
5,772,920
14,335 6,786
2042
5,868,924
14,550 7,532
2043
5,966,400
14,768 8,360
2044
6,065,335
14,990 9,280
14,784
14,991
15,201
15,414
925
130,318
-13,466
0
4,935
2,336
9,319
583
82,140
-4,635
938
132,272
-13,849
0
4,839
2,505
9,309
582
82,140
-4,606
951
134,257
-14,010
0
4,746
2,687
9,300
582
82,140
-4,502
964
136,270
-14,283
0
4,654
2,881
9,291
581
82,140
-4,435
2045
6,165,708
15,215 10,301 15,630
978
138,314
-14,701
0
4,564
3,090
9,282
581
82,140
-4,410
2046
6,267,474
15,443 11,434 15,849
991
140,389
-15,047
0
4,476
3,314
9,273
580
82,140
-4,361
2047
6,370,508
2048
6,474,731
2049
6,580,051
2050
6,686,373
2051
6,793,611
2052
6,901,678
16,886 17,707 17,227
15,674 12,692 16,070 1,005
15,910 14,088 16,295 1,019
16,148 15,638 16,524 1,033
16,390 17,358 16,755 1,048
16,636 17,531 16,989 1,063
1,077
142,495
-15,319
0
4,389
3,554
9,264
579
82,140
-4,290
144,632
-15,527
0
4,305
3,812
9,255
579
82,140
-4,201
146,802
-15,722
0
4,221
4,088
9,245
578
82,140
-4,110
149,004
-15,917
0
4,140
4,384
9,236
578
82,140
-4,020
151,239
-16,123
0
4,060
4,278
9,227
577
82,140
-3,934
153,508
-16,593
0
3,981
4,175
9,218
577
82,140
-3,912
Transcribed Image Text:Complete the yellow cells. Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Discounting of user benefits: Discount Project costs User benefits Other Benefits Rate Journey CO₂ Safety Noise, Physical Indirect % Quality, (human costs), Activity- tax health, revenues, £ £ £ £ £ £ £ £ Discounted user benefits: Discount Discounted Project Other discounted benefits: Journey CO₂ Safety, Noise Factor Costs Quality to 2010 (human costs) Physical Activity - tax health Indirect revenues base year £ £ £ £ £ £ 1 £ £ 2022 2023 2024 2025 20,940,000 12,498,890 2026 21,900,000 12,629,859 2027 4,549,983 11,638 1,574 12,169 2028 4,632,123 11,812 1,747 12,340 761 772 105,798 -9,271 0 6,485 877 9,448 107,385 -9,496 0 6,359 941 9,439 591 590 82,140 -5,166 82,140 -5,112 2029 4,714,398 11,990 1,940 12,513 783 108,996 -9,719 0 6,236 1,009 9,430 590 82,140 -5,055 2030 4,797,478 12,169 2,153 12,688 794 110,631 -10,007 0 6,116 1,082 9,420 589 82,140 -5,029 2031 4,881,354 2032 4,966,045 2033 5,051,580 2034 5,137,991 2035 5,225,332 2036 5,313,671 2037 5,403,062 2038 5,493,575 2039 5,585,319 13,914 5,507 12,352 2,390 12,865 12,537 2,653 13,045 12,725 2,944 13,228 12,916 3,268 13,413 13,110 3,628 13,601 13,307 4,027 13,791 13,506 4,470 13,985 13,709 4,962 14,180 14,379 805 816 827 112,291 -10,204 0 5,998 1,160 9,411 589 82,140 -4,955 113,975 -10,572 0 5,882 1,244 9,402 588 82,140 -4,960 115,684 -10,795 0 5,768 1,335 9,392 587 82,140 -4,893 839 117,420 -11,039 0 5,657 1,431 9,383 587 82,140 -4,835 851 119,181 -11,447 0 5,547 1,535 9,374 586 82,140 -4,844 863 120,969 -11,742 0 5,440 1,646 9,365 586 82,140 -4,800 875 122,783 -12,020 0 5,335 1,766 9,355 585 82,140 -4,748 887 124,625 -12,418 0 5,232 1,894 9,346 585 82,140 -4,739 2040 5,678,404 14,123 6,113 14,580 899 912 126,494 -12,760 0 5,131 2,031 9,337 584 82,140 -4,705 128,392 -13,141 0 5,032 2,178 9,328 583 82,140 -4,682 2041 5,772,920 14,335 6,786 2042 5,868,924 14,550 7,532 2043 5,966,400 14,768 8,360 2044 6,065,335 14,990 9,280 14,784 14,991 15,201 15,414 925 130,318 -13,466 0 4,935 2,336 9,319 583 82,140 -4,635 938 132,272 -13,849 0 4,839 2,505 9,309 582 82,140 -4,606 951 134,257 -14,010 0 4,746 2,687 9,300 582 82,140 -4,502 964 136,270 -14,283 0 4,654 2,881 9,291 581 82,140 -4,435 2045 6,165,708 15,215 10,301 15,630 978 138,314 -14,701 0 4,564 3,090 9,282 581 82,140 -4,410 2046 6,267,474 15,443 11,434 15,849 991 140,389 -15,047 0 4,476 3,314 9,273 580 82,140 -4,361 2047 6,370,508 2048 6,474,731 2049 6,580,051 2050 6,686,373 2051 6,793,611 2052 6,901,678 16,886 17,707 17,227 15,674 12,692 16,070 1,005 15,910 14,088 16,295 1,019 16,148 15,638 16,524 1,033 16,390 17,358 16,755 1,048 16,636 17,531 16,989 1,063 1,077 142,495 -15,319 0 4,389 3,554 9,264 579 82,140 -4,290 144,632 -15,527 0 4,305 3,812 9,255 579 82,140 -4,201 146,802 -15,722 0 4,221 4,088 9,245 578 82,140 -4,110 149,004 -15,917 0 4,140 4,384 9,236 578 82,140 -4,020 151,239 -16,123 0 4,060 4,278 9,227 577 82,140 -3,934 153,508 -16,593 0 3,981 4,175 9,218 577 82,140 -3,912
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education