Understand the calculations in the spreadsheet "Tile Drainage". Which of the following statement(s) is/are correct? Select all that apply. The tile drainage project will pay for itself in 10 years. The discount rate is 10%. Based on the current assumptions of 25 years useful life and 10 percent yield increase, Mr. Dietrich should not invest in the tile drainage project since the net present value (NPV) is negative. The net present value (NPV) will increase if the tile drainage could be effective for 50 years.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Crop
Expected yield per acre without drainage
Yield boost 10%
Expected price per acre:
Additional revenue per acre
Additional revenue
Average
A
Acres tiled
Price per acre for tile
Total investment
Tax rate
Capital cost allowance (depreciation)
Discount rate
Expected yield boost
Year
4
...
0
1
2
3
4
5
6
7
GRE22856456E5000
11
12
13
14
15
16
17
18
19
21
23
Corn
B
Profitability Ratios
220
22
5
117
17,490
14.145
150
1,500
225,000
15%
25%
6%
10%
UCC Beginnir CCA
225,000
196,875
147,656
110,742
83,057
62.292
46.719
35,040
26.280
19,710
14.782
11,087
8.315
6,236
4,677
3.508
2,631
1,973
1.480
1.110
832
624
468
C
Soybeans
351
263
198
58
6
16
93
13,920
28,125
49,219
36,914
27,686
20,764
15.573
11,680
8,760
6,570
4.927
3.696
2,772
2.079
1,559
1.169
877
658
493
370
277
208
156
117
88
66
49
Ratio Analysis
D
Wheat
E
105
11
7
74
11,025 150 acre
UCC Ending
196,875 half year rule
147,656
110,742
83,057
62.292
46,719
35,040
26,280
19,710
14,782
11,087
8,315
6,236
4,677
3,508
2,631
1,973
1,480
1.110.
832
624
468
351
263
198
148
F
Depreciation Tax Saving
4,219
% of Sales Method
7.383
5,537
4.153
3,115
2.336
1,752
1,314
985
739
554
416
312
234
175
132
99
74
55
42
31
23
18
C... +
13
10
7
⠀
4
G
H
J
Investment Increase revenue After Tax Cashflow
(225,000)
14.145
14.145
14,145
14.145
14.145
14,145
14.145
14.145
14.145
14.145
14,145
14,145
14,145
14,145
14.145
14.145
14.145
14.145
14,145
14.145
14,145
14,145
14.145
14.145
14.145
(187,031)
19,406
17,560
16.176
15,138
14.359
13,775
13,337
13,009
12,762
12.578
12,439
12.335
12.257
12.199
12.155
12,122
12,097
12,079
12,065
12.054
12,047
12.041
12,036
12,033
12,031
(9.522.41) NPV
K
▶
Transcribed Image Text:Crop Expected yield per acre without drainage Yield boost 10% Expected price per acre: Additional revenue per acre Additional revenue Average A Acres tiled Price per acre for tile Total investment Tax rate Capital cost allowance (depreciation) Discount rate Expected yield boost Year 4 ... 0 1 2 3 4 5 6 7 GRE22856456E5000 11 12 13 14 15 16 17 18 19 21 23 Corn B Profitability Ratios 220 22 5 117 17,490 14.145 150 1,500 225,000 15% 25% 6% 10% UCC Beginnir CCA 225,000 196,875 147,656 110,742 83,057 62.292 46.719 35,040 26.280 19,710 14.782 11,087 8.315 6,236 4,677 3.508 2,631 1,973 1.480 1.110 832 624 468 C Soybeans 351 263 198 58 6 16 93 13,920 28,125 49,219 36,914 27,686 20,764 15.573 11,680 8,760 6,570 4.927 3.696 2,772 2.079 1,559 1.169 877 658 493 370 277 208 156 117 88 66 49 Ratio Analysis D Wheat E 105 11 7 74 11,025 150 acre UCC Ending 196,875 half year rule 147,656 110,742 83,057 62.292 46,719 35,040 26,280 19,710 14,782 11,087 8,315 6,236 4,677 3,508 2,631 1,973 1,480 1.110. 832 624 468 351 263 198 148 F Depreciation Tax Saving 4,219 % of Sales Method 7.383 5,537 4.153 3,115 2.336 1,752 1,314 985 739 554 416 312 234 175 132 99 74 55 42 31 23 18 C... + 13 10 7 ⠀ 4 G H J Investment Increase revenue After Tax Cashflow (225,000) 14.145 14.145 14,145 14.145 14.145 14,145 14.145 14.145 14.145 14.145 14,145 14,145 14,145 14,145 14.145 14.145 14.145 14.145 14,145 14.145 14,145 14,145 14.145 14.145 14.145 (187,031) 19,406 17,560 16.176 15,138 14.359 13,775 13,337 13,009 12,762 12.578 12,439 12.335 12.257 12.199 12.155 12,122 12,097 12,079 12,065 12.054 12,047 12.041 12,036 12,033 12,031 (9.522.41) NPV K ▶
Understand the calculations in the spreadsheet "Tile Drainage". Which of the
following statement(s) is/are correct? Select all that apply.
The tile drainage project will pay for itself in 10 years.
The discount rate is 10%.
Based on the current assumptions of 25 years useful life and 10 percent yield
increase, Mr. Dietrich should not invest in the tile drainage project since the net
present value (NPV) is negative.
The net present value (NPV) will increase if the tile drainage could be effective
for 50 years.
Transcribed Image Text:Understand the calculations in the spreadsheet "Tile Drainage". Which of the following statement(s) is/are correct? Select all that apply. The tile drainage project will pay for itself in 10 years. The discount rate is 10%. Based on the current assumptions of 25 years useful life and 10 percent yield increase, Mr. Dietrich should not invest in the tile drainage project since the net present value (NPV) is negative. The net present value (NPV) will increase if the tile drainage could be effective for 50 years.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

What is the math behind the net present value calculation?

 

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education