Tree Value-Excel
http://www.papercamp.com/essay/11828/Tree-Values-Case
Section 1 – Executive Summary
This report analyzes the case “Tree Values” to find an optimal way for Mr. Smith to manage his forestland and harvest the crop trees. The fundamental idea in this report is based on the concept of present value. A number of options are analyzed and the one with highest present value of pay off is considered.
Questions 9, 10, and 11 give Mr. Smith 3 options: * Option 1: Harvest all crop trees now and receive $8,160 * Option 2: Let the forest grow without thinning, then harvest all crop trees 60 years from now and receive $537,962.01 at harvesting, equivalent to $28,800.08 now * Option 3: Thin and manage the forest, then harvest all crop trees 50 years from now and receive $670,033.56 at harvesting, equivalent to $58,429.42 now
Based on the present value of the money received at harvesting, it is highly recommended that Mr. Smith should choose option 3. Furthermore, provided Mr. Smith decides to thin and manage his forest, in case he needs money soon to use for other purposes, he can harvest all of his crop trees at the 40th year to receive $410,608.68 at harvesting, equivalent to $58,325.19 at present, instead of waiting for 10 more years. This is because the present value of money received at the 40th year is just a little ($104.23) less than that of money received at the 50th year.
Section 2 – Analysis
Question 1
In order to choose the best offer, the amount of payment in each offer is discounted to present at the discount rate of 10%. This is just a basic discounting problem, using the formula
PV=FV(1+r)t
In this formula, FV is the amount of payment, r is the discount rate of 10%, t is the number of years from now in each offer. Table 1 in the appendix summarizes the present value of payment in each offer. It also shows that offer 8 has the highest payment’s present value of $140.61. Therefore, offer 8, which pays $274 seven years from now, will be chosen.
|Offer
Section 1 – Executive Summary
This report analyzes the case “Tree Values” to find an optimal way for Mr. Smith to manage his forestland and harvest the crop trees. The fundamental idea in this report is based on the concept of present value. A number of options are analyzed and the one with highest present value of pay off is considered.
Questions 9, 10, and 11 give Mr. Smith 3 options: * Option 1: Harvest all crop trees now and receive $8,160 * Option 2: Let the forest grow without thinning, then harvest all crop trees 60 years from now and receive $537,962.01 at harvesting, equivalent to $28,800.08 now * Option 3: Thin and manage the forest, then harvest all crop trees 50 years from now and receive $670,033.56 at harvesting, equivalent to $58,429.42 now
Based on the present value of the money received at harvesting, it is highly recommended that Mr. Smith should choose option 3. Furthermore, provided Mr. Smith decides to thin and manage his forest, in case he needs money soon to use for other purposes, he can harvest all of his crop trees at the 40th year to receive $410,608.68 at harvesting, equivalent to $58,325.19 at present, instead of waiting for 10 more years. This is because the present value of money received at the 40th year is just a little ($104.23) less than that of money received at the 50th year.
Section 2 – Analysis
Question 1
In order to choose the best offer, the amount of payment in each offer is discounted to present at the discount rate of 10%. This is just a basic discounting problem, using the formula
PV=FV(1+r)t
In this formula, FV is the amount of payment, r is the discount rate of 10%, t is the number of years from now in each offer. Table 1 in the appendix summarizes the present value of payment in each offer. It also shows that offer 8 has the highest payment’s present value of $140.61. Therefore, offer 8, which pays $274 seven years from now, will be chosen.
|Offer