Use the following information to fill out the table. Or make up your own table i

Question

Use the following information to fill out the table. Or make up your
own table in Excel.

Use the following information to fill out the table. Or make up your own table in Excel. TIMBER VOLUME (in m^3): 75t^2 - t^3/3 where t is years after harvest. HARVEST COSTS: = $10 000 + $2 per m^3 (fixed + variable costs) TIMBER PRICES: = $10 per m^3. TIME VOL (m^3) Change ion VOL Harvest value Harvest cost Present Value of harvesting r = 2% Present Value of harvesting r = 10% 0 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 0 0 10 000 -10 000 -10 000

Explanation / Answer

Using the formulas we construct the table below

TIME

Vol(m3)

Change in vol

Harvest value

Harvest cost

Value of harvest

PV at 2%

PV at 10%

0

0

0

10000

-10000

-10000

-10000

10

7166.667

7166.667

71666.67

24333.33

47333.33

38829.82

18249.05

20

27333.33

20166.67

273333.3

64666.67

208666.7

140426.7

31016.97

30

58500

31166.67

585000

127000

458000

252848.5

26247.32

40

98666.67

40166.67

986666.7

207333.3

779333.3

352952.6

17219.31

50

145833.3

47166.67

1458333

301666.7

1156667

429733.9

9853.124

60

198000

52166.67

1980000

406000

1574000

479727.3

5169.441

70

253166.7

55166.67

2531667

516333.3

2015333

503889

2551.872

80

309333.3

56166.67

3093333

628666.7

2464667

505527.1

1203.215

90

364500

55166.67

3645000

739000

2906000

488967.7

546.958

100

416666.7

52166.67

4166667

843333.3

3323333

458729.6

241.1601

110

463833.3

47166.67

4638333

937666.7

3700667

419045.4

103.5344

120

504000

40166.67

5040000

1018000

4022000

373612.5

43.38303

130

535166.7

31166.67

5351667

1080333

4271333

325492.6

17.76292

140

555333.3

20166.67

5553333

1120667

4432667

277102.9

7.107046

150

562500

7166.667

5625000

1135000

4490000

230261.1

2.775515

TIME

Vol(m3)

Change in vol

Harvest value

Harvest cost

Value of harvest

PV at 2%

PV at 10%

0

0

0

10000

-10000

-10000

-10000

10

7166.667

7166.667

71666.67

24333.33

47333.33

38829.82

18249.05

20

27333.33

20166.67

273333.3

64666.67

208666.7

140426.7

31016.97

30

58500

31166.67

585000

127000

458000

252848.5

26247.32

40

98666.67

40166.67

986666.7

207333.3

779333.3

352952.6

17219.31

50

145833.3

47166.67

1458333

301666.7

1156667

429733.9

9853.124

60

198000

52166.67

1980000

406000

1574000

479727.3

5169.441

70

253166.7

55166.67

2531667

516333.3

2015333

503889

2551.872

80

309333.3

56166.67

3093333

628666.7

2464667

505527.1

1203.215

90

364500

55166.67

3645000

739000

2906000

488967.7

546.958

100

416666.7

52166.67

4166667

843333.3

3323333

458729.6

241.1601

110

463833.3

47166.67

4638333

937666.7

3700667

419045.4

103.5344

120

504000

40166.67

5040000

1018000

4022000

373612.5

43.38303

130

535166.7

31166.67

5351667

1080333

4271333

325492.6

17.76292

140

555333.3

20166.67

5553333

1120667

4432667

277102.9

7.107046

150

562500

7166.667

5625000

1135000

4490000

230261.1

2.775515

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.