In: Accounting
During the past year, Cindy McGill planted a new vineyard on 150 acres of land that she leases for $31,840 a year. She has asked you, as her accountant, to assist her in determining the value of her vineyard operation.
The vineyard will bear no grapes for the first 5 years (1–5). In the next 5 years (6–10), Cindy estimates that the vines will bear grapes that can be sold for $64,820 each year. For the next 20 years (11–30), she expects the harvest will provide annual revenues of $111,510. But during the last 10 years (31–40) of the vineyard’s life, she estimates that revenues will decline to $76,650 per year.
During the first 5 years, the annual cost of pruning, fertilizing, and caring for the vineyard is estimated at $8,330; during the years of production, 6–40, these costs will rise to $12,270 per year. The relevant market rate of interest for the entire period is 4%. Assume that all receipts and payments are made at the end of each year.
Click here to view factor tables - https://knowledgequity.com.au/wp-content/uploads/2015/08/KEQ-FV-and-PV-tables.pdf
Paul Button has offered to buy Cindy’s vineyard business by assuming the 40-year lease. On the basis of the current value of the business, what is the minimum price Cindy should accept? (Round factor values to 5 decimal places, e.g. 1.25124 and final answer to 0 decimal places, e.g. 458,581.)
The Current value of Cindys Business would depend on the present Value of all the Future Cash Flows (i.e inflows less Outflows) .The present value would be calculated on the basis of Current market rate of interest which is given as 4% for the Entire Period.
The cash flows during the Period would include
(1) Revenue from sale of Grapes - Cash Inflow
(2) annual cost of pruning, fertilizing, and caring Vineyard- Cash Outflow
(3) Annual lease rent payable - Cash outflow
Analysis of the Future cash flows has been done in the following table
Years | Annual Revenue from sale of Grapes | Annual cost of Maintaining Vineyard | Lease Cost | Net Cash Flow | PV@ 4% | Present Value of Cash Flow |
1-5 | - | 8330 | 31840 | -40170 | 4.45182 | -178829.6094 |
6-10 | 64820 | 12270 | 31840 | 20710 | 3.6591 | 75779.961 |
11-30 | 111510 | 12270 | 31840 | 67400 | 9.18114 | 618808.836 |
31-40 | 76650 | 12270 | 31840 | 32540 | 2.5007 | 81372.778 |
Total | 597131.9656 |
Pv of business is $5,97,131.9656 hence that would be the minimum price Cindy would expect to receive.