Tree Value-Excel

The concern is mainly on recognition of the value of standing timberlands. Under US GAAP, standing timber is accounted for on a historical cost basis. On the other hand, the relevant accounting

The third scenario was ignoring the option to invest in the second-generation project and selling the equipment in year 2. We evaluated this option as a put option. First, we calculated the probabilities for going up and down based on the assumption of a risk neutral word. As a result, the probability of going upward is calculated as 0.3375 and downward probability is 0.6625. In order to determine the present value of all the sequence cash flow at the end of year 2, we calculated the upside change rate and downside change rate as 64.87% and -39.35%, respectfully. The next step is to analyze the option value by using the “Binomial Tree” method. In order to determine the present value of all the subsequence cash flow at the end of year 2, we calculated the cash flow at each node on the tree, until 2006. We discounted all the cash flow at the risk free rate at 10%. The End of Year NPV of all the subsequence cash flow at Year 2 is calculated as $7,571,752, and the selling price of the equipment at end of 2 is $4,000,000, which is the salvage value. We found the NPV of selling the machine at end of Year 2 to be -$2,951,861 as of Year 0, which is negative. The APV of the project after adding the option turned out to be -$6,321,932. This negative APV suggest that the

a) In the first set of calculations, the staff used a discount rate of 20%, a five-year time horizon, and ignored taxes and terminal value. What is the relative attractiveness of these three alternatives?

Grappling with the potential purchase of Olive Hill Farm, we decided to conduct a financial analysis to determine whether the project should be taken or not. Our financial analysis include scenarios for the best, worse, and most likely outcomes of purchasing the farm. For each scenario a Net Present Worth (NPW) and an Internal Rate of Return (IRR) was calculated and compared. This revealed that there was little gain for the worst case scenario and large gains for the other two scenarios. A sensitivity analysis and a break-even analysis was also conducted. The sensitivity analysis identified the most influential factors on the NPW. In the end, the analysis favored buying Olive Hill Farm because it would be a low risk, high reward investment.

EEC calculated the amount of time involved the anticipation of its cost ($3 million). The timeline in recovering their cost of investment ($2 million) initially for the foundation of this investment any profit made in the future of this investment will be justified as a profit for the company. If EEC can anticipate a fast return on its investment it is a profitable wise decision in making the investment financial, it is considered to be an easier way of formulating investments financially. On the basis of one year all cash flows is added together equal to the sum of $2 million originally invested, then it is divided by the annual cash flow of $500,000. The calculation of the payback period would equal four years. After this time frame any financial proceeds will be considered profitable for the company. I conclude that the timeframe is adequate in comparison of the investment in this worthwhile investment financial venture for the company.

2. Edgar Co. acquired 60% of Kindall Co. on January 1, 2009. During 2009, Edgar made several sales of inventory to Kindall. The cost and selling price of the goods were $140,000 and $200,000, respectively. Kindall still owned one-fourth of the goods at

certain amount of land. This land was then valued at a price and depending on that price the

financial gain but is not best for the long-term or the trees. It is the

General Foods is a large corporation organized by product lines. They are evaluating Super Project, the manufacture of a new powdered dessert. Crosby Sanberg, a financial analysis manager, must determine the value in accepting the proposal, along with J.C. Kresslin, the Corporate Controller. The Super Project will increase profit with a payback period of less than ten years. The proposed capital investment for the project is $200,000 ($80,000 for building modifications and $120,000 for machinery and equipment) and production would take place

Our approach to valuing the processing plant can easily be decomposed into three distinct steps first, find the value of the foreseeable free cash flows. Next, calculate the terminal value of the project. Finally, take the present value of those flows. The next few paragraphs walk through each of these steps in order of progression.

In January 2003, Michael Pogonowski, the chief financial officer of Aurora Textile Company, was questioning whether the company should install a new ring-spinning machine, the Zinser 351, in the Hunter production facility. This new machine has ability to produce a finer-quality yarn that would be used for higher-quality and higher-margin products. In deciding whether or not to invest this new machine, NPV and the payback period are critical factors. Firstly, we need to forecast the cash flows that the Zinser 351 will generate in the future. After calculation, the ten-year NPV will be $3, 172,582. Secondly, we use the payback period to analyze the acceptance of this project. Based on this analysis,

Assessing the likelihood of each option and assigning weight to each possibility is an inexact science, but I believe it in unlikely that in the current political climate we will not see both a reduction in the tax rate and an increase in the length of time over which we are required to depreciate capital assets. I have assigned weights to each option with this in mind, and have come up with an average weighted estimate of the net present value of the investment of: $1.7 million.

Deforestation is one of the most significant issues of our time; considerable measures must be taken to prevent further pillaging of our unique forest resource.

to be grown trees have to be cut down and I have explained the effects

There are several traditional methods that can be used in appraising investment decisions. For instance, the net present value method (NPV) which entails estimating the costs and revenues of a project and discounting these figures to get their present values. Projects with the biggest positive net present value are the ones chosen as they represent the best stream of benefits of investing in the project over and above recovering the cost of initiating the projects. The discount rate is another method which is similar to the net present value method but reflects more on the time preference. This approach may focus on the opportunity cost of