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
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
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
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
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
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)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
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-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education