3. A Green House Operator is Growing Young Trees to Transplant to Residential Lawns. Over a 6-year period, a tree left to grow for 6 years sells for $7500. For shorter periods, the sales prices are: Sold at yr1= $1,000; yr2 = $2,100; yr3 = 3,300; yr4 = $4500; yr5 = $5,800. If the interest rate is 10%, which generates the greatest return over 6 years. Show the year 6 return for each. 1 Six Year Rotation. 3 Two Year Rotations. 2 Three year Rotations. 1 Four year rotation followed by 1 Two Year Rotation. 1 Two Year Rotation followed by 1 Four year Rotation. Six One Year Rotations. Create a chart using Excel to Show your work.
3. A Green House Operator is Growing Young Trees to Transplant to Residential Lawns. Over a 6-year period, a tree left to grow for 6 years sells for $7500. For shorter periods, the sales prices are: Sold at yr1= $1,000; yr2 = $2,100; yr3 = 3,300; yr4 = $4500; yr5 = $5,800. If the interest rate is 10%, which generates the greatest return over 6 years. Show the year 6 return for each. 1 Six Year Rotation. 3 Two Year Rotations. 2 Three year Rotations. 1 Four year rotation followed by 1 Two Year Rotation. 1 Two Year Rotation followed by 1 Four year Rotation. Six One Year Rotations. Create a chart using Excel to Show your work.
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
Related questions
Question
.
![3. A Green House Operator is Growing Young Trees to Transplant to Residential Lawns.
Over a 6-year period, a tree left to grow for 6 years sells for $7500. For shorter periods, the
sales prices are:
Sold at yrl = $1,000; yr2 = $2,100; yr3 = 3,300; yr4 = $4500; yr5 = $5,800.
%3D
If the interest rate is 10%, which generates the greatest return over 6 years. Show the year
return for each.
1 Six Year Rotation.
3 Two Year Rotations.
2 Three year Rotations.
1 Four year rotation followed by 1 Two Year Rotation.
1 Two Year Rotation followed by 1 Four year Rotation.
Six One Year Rotations.
Create a chart using Excel to Show your work.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3a78ac24-a649-404a-b72c-3da309171ebd%2F2cbba537-57dd-4563-996d-b535f03aa6c1%2F7u2nnyf_processed.jpeg&w=3840&q=75)
Transcribed Image Text:3. A Green House Operator is Growing Young Trees to Transplant to Residential Lawns.
Over a 6-year period, a tree left to grow for 6 years sells for $7500. For shorter periods, the
sales prices are:
Sold at yrl = $1,000; yr2 = $2,100; yr3 = 3,300; yr4 = $4500; yr5 = $5,800.
%3D
If the interest rate is 10%, which generates the greatest return over 6 years. Show the year
return for each.
1 Six Year Rotation.
3 Two Year Rotations.
2 Three year Rotations.
1 Four year rotation followed by 1 Two Year Rotation.
1 Two Year Rotation followed by 1 Four year Rotation.
Six One Year Rotations.
Create a chart using Excel to Show your work.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 16 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.Recommended textbooks for you
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
![ENGR.ECONOMIC ANALYSIS](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9780190931919/9780190931919_smallCoverImage.gif)
![Principles of Economics (12th Edition)](https://www.bartleby.com/isbn_cover_images/9780134078779/9780134078779_smallCoverImage.gif)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
![Engineering Economy (17th Edition)](https://www.bartleby.com/isbn_cover_images/9780134870069/9780134870069_smallCoverImage.gif)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
![Principles of Economics (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305585126/9781305585126_smallCoverImage.gif)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
![Managerial Economics: A Problem Solving Approach](https://www.bartleby.com/isbn_cover_images/9781337106665/9781337106665_smallCoverImage.gif)
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
![Managerial Economics & Business Strategy (Mcgraw-…](https://www.bartleby.com/isbn_cover_images/9781259290619/9781259290619_smallCoverImage.gif)
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education