Larimer Larry has a moderate-sized truck farming operation in north-central Colorado. He has experience growing food...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Larimer Larry has a moderate-sized truck farming operation in north-central Colorado. He has experience growing food crops in open fields, under shade covers, and in greenhouses and sells his produce both at farmer's markets and via contract with local restaurants and grocery retailers. Larry is contemplating expanding greenhouse capacity in his operation. He is looking to acquire another 15,000 sq. ft. of capacity that will allow him to expand his range of products and increase his total production which will provide opportunities to contract with some regional vendors. Larry has three different options by which he can gain access to the greenhouse space. Under all three options he will have exactly the same new production opportunities so he can think about the problem in the same manner that we do for partial budgeting only the things that are different between the options need to be explicitly accounted in the analysis. In this case, those differences will be confined to the costs detailed next. Larry had done considerable research and determines that he can construct his own heated quonset- style poly greenhouse for $45,000. He will need to pay the annual upkeep and heating costs of $6,100 at the end of each year as long owns the greenhouse. He has two options to pay for the installation of the greenhouse. First, he can take out a loan from the local bank for $35,000 for which he will be charged 5.9% interest and he will repay in five equal annual payments of principal and interest combined at the end of each of the next five years. Alternatively, Larry also judges that he could pull money from his retirement fund and could finance the entire construction cost from those funds without taking out a loan. Larry also has the opportunity to lease a turn-key, hard-side greenhouse solution with the same square footage from a neighbor which will cost $11,000 per year with the lease payments made at the beginning of each of the next eight years. There will be no heating or upkeep costs because the neighbor will provide all of this. Larry has decided that he will retire in eight years, but he needs the additional greenhouse space to carry him over that time. Larry's retirement fund has been averaging a 7.4% annual rate of growth and he expects this to continue at least until his retirement. Upon his retirement Larry plans to sell his property and he expects that if he were to build the greenhouse that it would add $25,000 to the value of his property which he plans to sell at that time. Since all benefits that Larry will accrue will be the same across the three alternatives, we'll apply our techniques focused only on the cost differences. You'll note that Larry made reference to his retirement fund as a reasonable source of funds. The rate of return that he's earning there should immediately jump out at you as an "opportunity cost" of capital funds. It should be clear to you why this will be an important number and how you should use it. 1. Using Excel, develop the before-tax (that is, ignore any potential income tax implications) net present value (NPV) reflecting the cost of acquiring the services of the greenhouse space by (a) purchasing the greenhouse outright, (b) purchasing the greenhouse using the loan described, and (c) leasing greenhouse space from a neighbor. Summarize your findings including a rank-order preference of the three alternatives including justification for your rankings and recommend an option to Larry, briefly discussing any considerations that he should take into account before making the decision. 2. Larry feels somewhat uncertain about his estimate of the market value of the greenhouse when he wants to retire. At what terminal value would Larry be indifferent between buying the greenhouse outright (Option a) versus leasing the neighbor's facility (Option c)? Describe how you determined this value. 3. No mention was made about details of Larry's ambitions to expand his production and marketing opportunities. Discuss how this additional real-world information would be relevant in the analysis of Larry's decision to acquire this new greenhouse space. For all NPV analysis, create your own discount factors, display them, and use them. DO NOT use the NPV function in Excel for anything Larimer Larry has a moderate-sized truck farming operation in north-central Colorado. He has experience growing food crops in open fields, under shade covers, and in greenhouses and sells his produce both at farmer's markets and via contract with local restaurants and grocery retailers. Larry is contemplating expanding greenhouse capacity in his operation. He is looking to acquire another 15,000 sq. ft. of capacity that will allow him to expand his range of products and increase his total production which will provide opportunities to contract with some regional vendors. Larry has three different options by which he can gain access to the greenhouse space. Under all three options he will have exactly the same new production opportunities so he can think about the problem in the same manner that we do for partial budgeting only the things that are different between the options need to be explicitly accounted in the analysis. In this case, those differences will be confined to the costs detailed next. Larry had done considerable research and determines that he can construct his own heated quonset- style poly greenhouse for $45,000. He will need to pay the annual upkeep and heating costs of $6,100 at the end of each year as long owns the greenhouse. He has two options to pay for the installation of the greenhouse. First, he can take out a loan from the local bank for $35,000 for which he will be charged 5.9% interest and he will repay in five equal annual payments of principal and interest combined at the end of each of the next five years. Alternatively, Larry also judges that he could pull money from his retirement fund and could finance the entire construction cost from those funds without taking out a loan. Larry also has the opportunity to lease a turn-key, hard-side greenhouse solution with the same square footage from a neighbor which will cost $11,000 per year with the lease payments made at the beginning of each of the next eight years. There will be no heating or upkeep costs because the neighbor will provide all of this. Larry has decided that he will retire in eight years, but he needs the additional greenhouse space to carry him over that time. Larry's retirement fund has been averaging a 7.4% annual rate of growth and he expects this to continue at least until his retirement. Upon his retirement Larry plans to sell his property and he expects that if he were to build the greenhouse that it would add $25,000 to the value of his property which he plans to sell at that time. Since all benefits that Larry will accrue will be the same across the three alternatives, we'll apply our techniques focused only on the cost differences. You'll note that Larry made reference to his retirement fund as a reasonable source of funds. The rate of return that he's earning there should immediately jump out at you as an "opportunity cost" of capital funds. It should be clear to you why this will be an important number and how you should use it. 1. Using Excel, develop the before-tax (that is, ignore any potential income tax implications) net present value (NPV) reflecting the cost of acquiring the services of the greenhouse space by (a) purchasing the greenhouse outright, (b) purchasing the greenhouse using the loan described, and (c) leasing greenhouse space from a neighbor. Summarize your findings including a rank-order preference of the three alternatives including justification for your rankings and recommend an option to Larry, briefly discussing any considerations that he should take into account before making the decision. 2. Larry feels somewhat uncertain about his estimate of the market value of the greenhouse when he wants to retire. At what terminal value would Larry be indifferent between buying the greenhouse outright (Option a) versus leasing the neighbor's facility (Option c)? Describe how you determined this value. 3. No mention was made about details of Larry's ambitions to expand his production and marketing opportunities. Discuss how this additional real-world information would be relevant in the analysis of Larry's decision to acquire this new greenhouse space. For all NPV analysis, create your own discount factors, display them, and use them. DO NOT use the NPV function in Excel for anything
Expert Answer:
Answer rating: 100% (QA)
In this scenario Larry is considering three options to gain access to additional greenhouse space for his truck farming operation The options are as f... View the full answer
Related Book For
Smith and Roberson Business Law
ISBN: 978-0538473637
15th Edition
Authors: Richard A. Mann, Barry S. Roberts
Posted Date:
Students also viewed these finance questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Determine each of the following as being either true or false. If an angle has a cosine of 0.2, then the secant of the angle is 5.
-
Suppose P(A) = 0.6 and P(B | A) = 0.4. Find P(A& B).
-
Consider the following functions: Assume x equals 10 and y equals 100. Fill in the following table indicating the number of times each of the four functions is called in code fragments AC: long min...
-
Find the separation of variables solution for the longitudinal displacement, \(u(x, t)\), of the equation derived in Problem 8.21. Leave the answer in terms of constants, which must be determined...
-
The partnership of Rachel, Adams, and Nixon has the following trial balance on September 30, 2009: The partners share profits and losses as follows: Rachel, 50 percent; Adams, 30 percent; and Nixon,...
-
Jul 4, 2024: Recorded credit card sales of $110,000, net processor fee of 1% Ignore cost of Goods sold. (Prepare a single compound journal entry.) Date Jul. 1 Accounts and Explanation Debit Credit...
-
Tameka wants you to consider a hybrid aggregate plan, using up to the maximum overtime per employee for any period where demand cannot be satisfied with the current regular-time production and the...
-
Do cultural variations interact to influence education?
-
= 1 and r = 3. Calculate the slope of the secant line through the points on the graph where x = slope =
-
Your first step in analyzing the marketing environment is to examine the competition. What brands and products compete with yours? How strong are these competitors, and what weaknesses do you see?...
-
How do you calculate the Yield ANNUAL and Yield - Nominal, Annualized in Excel? Tax rate: 27% Par Value: 1,000 Bond Price; 1,127 Bond Maturity in Years: 20 Bound Coupon Rate: 0.065 Bond Coupon...
-
write a Java program that doubles the values of an array of numbers. Follow the steps listed below to solve this exercise: declare and assign (at least 5) values to an array of type int use a while...
-
Shouldn't there be a calculation of depreciation in the P&L, Balance sheet and breakeven point? when deciding on the price for the contract shouldn't we use NPV?
-
The rotating shaft in the figure below is loaded by transverse forces 5 kN and 10 kN that cause reaction forces R, and R at the two bearings situated at the two ends of the shaft. Point A is a shaft...
-
Why are stocks usually more risky than bonds?
-
Zenith Steel Company operates a prosperous business. The board of directors voted to spend $20 million of the companys surplus funds to purchase a majority of the stock of two other companiesthe...
-
Seigel, a seventy-three-year-old man, was injured at one of Giant Foods retail food stores when a bottle of Coca-Cola exploded as he was placing a six-pack of Coke into his shopping cart. The...
-
Ronald Nadler was a resident of Maryland and the CEO of Glenmar Cinestate, Inc., a Maryland corporation, as well as its principal stockholder. Glenmar leased certain space in the Westridge Square...
-
Create a complete stable pattern by using the tips and heuristics provided in this chapter.
-
Develop the following systems using the fairness pattern: 1. Tax fairness: A tax platform based on an ideal that aims to create a system of taxation that is fair, clear, and equivalent for all...
-
BOs make this pattern stable and extendible. Do you agree?
Study smarter with the SolutionInn App