3. If the operating cost is 20% HIGHER in each project year, what is the CHANGE in the IRR for the project? a. -3.8 b. -6.7 C. -9.5 d. -12.4

Financial Reporting, Financial Statement Analysis and Valuation
8th Edition
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Chapter4: Profitability Analysis
Section: Chapter Questions
Problem 23PC
icon
Related questions
icon
Concept explainers
Topic Video
Question
Years
Revenue
Cash Expense
Book
Depreciation
Book Income
Pre-Tax
Book Tax at
32%
After Tax Book
Income
Financial
Measures
Profit Margin
%
Net Assets
ROA %
Cashflow
Revenue
Cash Expense
Tax
Depreciation
Pretax Income
Tax at 32%
After Tax
Income
After Tax
Cashflow
Cumulative
Cashflow
Payback
Period
Present Worth
10
PW12
PW15
IRR
PV Index(15)
Facility Cost
Income Tax
Rate
0
C. -9.5
d. -12.4
$ 100,000.00
2.2 Years
91740.92679
0.395702526
1
0.684350818
$ 100,000.00
32%
$30,000.00
$100,000.00 $120,000.00 $140,000.00 $150,000.00 $150,000.00
$50,000.00 $60,000.00 $70,000.00 $75,000.00 $75,000.00
2
$20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00
$0.20
$20,400.00 $27,200.00
$0.26
$9,600.00 $12,800.00 $16,000.00 $17,600.00 $17,600.00
$20,400.00
($100,000.00) $40,400.00 $51,040.00
($100,000.00) -$59,600.00 -$8,560.00
$40,000.00 $50,000.00 $55,000.00 $55,000.00
$0.23
3
$0.45
$36,727.27
$80,000.00 $60,000.00 $40,000.00 $20,000.00
$0.85
$1.87
4
$19,040.00
5
$34,000.00 $37,400.00
$0.24
$42,181.82
$0.25
$100,000.00 $120,000.00 $140,000.00 $150,000.00 $150,000.00
$50,000.00 $60,000.00 $70,000.00 $75,000.00 $75,000.00
$20,000.00 $32,000.00 $19,000.00 $12,000.00 $17,000.00
$30,000.00 $28,000.00 $51,000.00 $63,000.00 $58,000.00
$9,600.00 $8,960.00 $16,320.00 $20,160.00 $18,560.00
$37,400.00
$40,330.58 $37,456.46 $35,044.80
81845.95094 $36,071.43 $40,688.78 $38,208.36 $34,851.81 $32,025.57
68435.08185 $35,130.43 $38,593.57 $35,295.47 $31,354.95 $28,060.65
$0.25
$0.00
#DIV/0!
$34,680.00 $42,840.00 $39,440.00
$53,680.00 $54,840.00 $56,440.00
$45,120.00 $99,960.00 $156,400.00
3. If the operating cost is 20% HIGHER in each project year, what is the CHANGE in the IRR for the project?
-3.8
a.
b. -6.7
Transcribed Image Text:Years Revenue Cash Expense Book Depreciation Book Income Pre-Tax Book Tax at 32% After Tax Book Income Financial Measures Profit Margin % Net Assets ROA % Cashflow Revenue Cash Expense Tax Depreciation Pretax Income Tax at 32% After Tax Income After Tax Cashflow Cumulative Cashflow Payback Period Present Worth 10 PW12 PW15 IRR PV Index(15) Facility Cost Income Tax Rate 0 C. -9.5 d. -12.4 $ 100,000.00 2.2 Years 91740.92679 0.395702526 1 0.684350818 $ 100,000.00 32% $30,000.00 $100,000.00 $120,000.00 $140,000.00 $150,000.00 $150,000.00 $50,000.00 $60,000.00 $70,000.00 $75,000.00 $75,000.00 2 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $20,000.00 $0.20 $20,400.00 $27,200.00 $0.26 $9,600.00 $12,800.00 $16,000.00 $17,600.00 $17,600.00 $20,400.00 ($100,000.00) $40,400.00 $51,040.00 ($100,000.00) -$59,600.00 -$8,560.00 $40,000.00 $50,000.00 $55,000.00 $55,000.00 $0.23 3 $0.45 $36,727.27 $80,000.00 $60,000.00 $40,000.00 $20,000.00 $0.85 $1.87 4 $19,040.00 5 $34,000.00 $37,400.00 $0.24 $42,181.82 $0.25 $100,000.00 $120,000.00 $140,000.00 $150,000.00 $150,000.00 $50,000.00 $60,000.00 $70,000.00 $75,000.00 $75,000.00 $20,000.00 $32,000.00 $19,000.00 $12,000.00 $17,000.00 $30,000.00 $28,000.00 $51,000.00 $63,000.00 $58,000.00 $9,600.00 $8,960.00 $16,320.00 $20,160.00 $18,560.00 $37,400.00 $40,330.58 $37,456.46 $35,044.80 81845.95094 $36,071.43 $40,688.78 $38,208.36 $34,851.81 $32,025.57 68435.08185 $35,130.43 $38,593.57 $35,295.47 $31,354.95 $28,060.65 $0.25 $0.00 #DIV/0! $34,680.00 $42,840.00 $39,440.00 $53,680.00 $54,840.00 $56,440.00 $45,120.00 $99,960.00 $156,400.00 3. If the operating cost is 20% HIGHER in each project year, what is the CHANGE in the IRR for the project? -3.8 a. b. -6.7
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
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, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Financial Reporting, Financial Statement Analysis…
Financial Reporting, Financial Statement Analysis…
Finance
ISBN:
9781285190907
Author:
James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:
Cengage Learning