The Oakes realize that if they started from scratch, they would need patience and plenty of capital before

they would be able to sell trees. Christmas tree operators buy two$-$year$-$old trees $("$seedlings$")$ for

transplanting onto their land. The cost of each seedling depends on the type of evergreen. Table $1$ gives

the prices for seedlings. They plan to continue the tree farm's current operation and plant $1,100$ trees per

acre. However, the agriculture extension service says that with space for access to the trees every four or

five rows and spacing trees six feet apart, operators can plant $1,200$ trees per acre. The trees then grow for

the next $5$ to $8$ years before being cut down and sold between $7$ and $10$ years of age. Pricing per tree

depends on the height, type, and quality of the tree. Table $2$ provides the current Christmas tree wholesale

and retail prices. Both the seedling cost and tree prices are expected to rise by $2\%$ annually.

The current owners began operating their Christmas tree farm $30$ years ago, first as a hobby and later as

their primary source of income. They have always grown Douglas Firs $(60\%$ of the trees$)$ and Fraser Firs

$(40\%)$ on the tree farm. Each year they cut one$-$third of their available trees for selling wholesale, while they

sell the remaining two$-$thirds as cut$-$your$-$own trees. Table $3$ provides information on the acreage planted

with trees and the projected percentage of trees sold.

The current owners now want to sell their business and move closer to their children and grandchildren.

Their listing price for the operation is USD $190,000.$

Sarah and James have received advice on expected revenue and operating expenses from the local

agricultural extension service. Table $4$ provides the estimates of operating expenses. These operating

expenses are also expected to increase each year by $2\%.$ The purchase includes fixed assets consisting of

land, a barn, skid steer, tree shaker, tractor, and implements $($see Table $5).$ While none of this equipment,

all considered to be in good condition, should need to be replaced in the near future, excluding the land,

the couple will be able to depreciate all except for the barn, using a seven$-$year MACRS depreciation

schedule $($see Table $6).$ The barn will be depreciated using the $20-$year schedule. The couple has decided

that they will need one year's worth of operating expenses on hand as cash.

They will obtain a Direct Farm Ownership Loan from the U$.$S$.$ Department of Agriculture Farm Service

Agency. The rate on this loan is a fixed rate set at $200$ basis points $(2\%)$ above the current prime rate.

Though this loan program could provide $100\%$ financing, the Oakes expect to finance $25\%$ of the

investment from their inheritance. Since their alternative is investing in the equity markets, the Oakes

expect a $9\%$ return on their investment. While they expect to keep the operation until they reach

retirement age, $10$ years is used as the time horizon for analysis of this investment. During this time, land

prices are expected to increase by $4\%.$ Closing costs associated with this transaction are expected to be

USD $12,000.$ Finally, they expect a combined federal and state tax rate of $28\%.$

Sarah and James wonder if this a good investment and how much they should offer for Escarpment

Evergreens.

Please show how to do the calculations in excel

$1.$

Calculate the investment, operating, and terminal cash flows for this investment.

$2.$

Calculate the weighted average cost of capital and the unlevered required rate of return.

$3.$

At the asking price of USD $190,000,$ would you recommend purchase of Escarpment Evergreens?

$4.$

Calculate the enterprise value of the investment.

$5.$

What is the adjusted present value $($APV$)$ for an investment in Escarpment Evergreens? What is the value of the interest tax shield?

$6.$

How much would you offer for Escarpment Evergreens?