Be sure to answer all of the blank yellow shaded blocks on each sheet. Attach how you did all calculations in handwriting by taking a picture of it, so I can see your work.
B C D H Net Present Value - Revenue - Expense Acres 50 E F 1% Future Value = PV x (1 + i)^N 7% Present Value = FV / (1 + i)^N Inflation Rate (i) Opportunity Cost (1) 1 Ply CNS Pulp Per Unit Stumpage in 2021 Dollars $30.00/ton $14.00/ton $10.00/ton Thinning @17 years remove Pulp 30 tons/ac @13 years remove Pulp 40 tons/ac Ply(+0)CNS(+0) Pulp(+5) Ply(+0)CNS(+5)Pulp(+5) Stumpage Value in 2021 Dollars Per Acre Expense in 2021 Dollars Change Clearcut Volume Per Acre 0 Open Pollen Seedling & Plant $ 100.00 Ply(+30)CNS(+40)Pulp(-60) 1 Closed pollen Seedlings & Plants 125.00 Ply(+40)CNS(+50)Pulp(-50) 2 Herbicide 5 140.00 Ply(+10)CNS(+10) Pulp(+5) 3 Shear & Bed $ 300.00 Ply(+20)CNS(+0)Pulp(+5) 4 5 Thinning Yr 6 Tons Per AcreTotal Tons Per Unit Stumpage in 2038 Dollars Stumpage Value in 2038 Dollars 7 Ply Tons 3 CNS Tons 9 Pulp Tons 0 Total Total 1 Clearcut Yr. 2051 2 Tons Per AcreTotal Tons Per Unit Stumpage in 2051 Dollars Stumpage Value in 2051 Dollars 3 Ply Tons 4 CNS Tons 5 Pulp Tons 6 Total Total Stumpage Value in 2021 Dollars D E Expense in year it ooours Revenue in year it occurs (-)Expense or (Revenue in 2021 Dollars B C 27 28 Years Year 29 0 2021 Invest 30 1 2022 31 2 2023 32 3 2024 33 4 2025 34 5 2026 35 6 2027 36 7 2028 37 8 2029 38 9 2030 39 10 2031 10 11 2032 11 12 2033 32 13 2034 13 14 2035 14 15 2036 35 16 2037 16 17 2038 Thin 37 18 2039 18 19 2040 19 20 2041 CO 21 2042 1 22 2043 -2 23 2044 -3 24 2045 -4 25 2046 -5 26 2047 -6 27 2048 -7 28 2049 -8 29 2050 9 30 2051 Clearcut 50 1 Net Present Value 2021 Dollars 2 53 54 B C D H Net Present Value - Revenue - Expense Acres 50 E F 1% Future Value = PV x (1 + i)^N 7% Present Value = FV / (1 + i)^N Inflation Rate (i) Opportunity Cost (1) 1 Ply CNS Pulp Per Unit Stumpage in 2021 Dollars $30.00/ton $14.00/ton $10.00/ton Thinning @17 years remove Pulp 30 tons/ac @13 years remove Pulp 40 tons/ac Ply(+0)CNS(+0) Pulp(+5) Ply(+0)CNS(+5)Pulp(+5) Stumpage Value in 2021 Dollars Per Acre Expense in 2021 Dollars Change Clearcut Volume Per Acre 0 Open Pollen Seedling & Plant $ 100.00 Ply(+30)CNS(+40)Pulp(-60) 1 Closed pollen Seedlings & Plants 125.00 Ply(+40)CNS(+50)Pulp(-50) 2 Herbicide 5 140.00 Ply(+10)CNS(+10) Pulp(+5) 3 Shear & Bed $ 300.00 Ply(+20)CNS(+0)Pulp(+5) 4 5 Thinning Yr 6 Tons Per AcreTotal Tons Per Unit Stumpage in 2038 Dollars Stumpage Value in 2038 Dollars 7 Ply Tons 3 CNS Tons 9 Pulp Tons 0 Total Total 1 Clearcut Yr. 2051 2 Tons Per AcreTotal Tons Per Unit Stumpage in 2051 Dollars Stumpage Value in 2051 Dollars 3 Ply Tons 4 CNS Tons 5 Pulp Tons 6 Total Total Stumpage Value in 2021 Dollars D E Expense in year it ooours Revenue in year it occurs (-)Expense or (Revenue in 2021 Dollars B C 27 28 Years Year 29 0 2021 Invest 30 1 2022 31 2 2023 32 3 2024 33 4 2025 34 5 2026 35 6 2027 36 7 2028 37 8 2029 38 9 2030 39 10 2031 10 11 2032 11 12 2033 32 13 2034 13 14 2035 14 15 2036 35 16 2037 16 17 2038 Thin 37 18 2039 18 19 2040 19 20 2041 CO 21 2042 1 22 2043 -2 23 2044 -3 24 2045 -4 25 2046 -5 26 2047 -6 27 2048 -7 28 2049 -8 29 2050 9 30 2051 Clearcut 50 1 Net Present Value 2021 Dollars 2 53 54
