Basic Capital Budgeting Techniques; Uneven Net Cash Inflows with Taxes; SpreadsheetApplication Use the same information for this problem as you did for Problem 12-47, except thatthe discount rate is 10% (not 12%), the investment is subject to taxes, and the projected pretax operating cash inflows are as follows:[LO 12-4, 12-6]Year Pretax Cash Inflow Year Pretax Cash Inflow1 $ 65,000 6 $300,0002 80,000 7 270,0003 120,000 8 240,0004 200,000 9 120,0005 240,000 10 80,000Jensen has been paying 25% for combined federal, state, and local income taxes, a rate that is notexpected to change during the period of this investment. The firm uses straight-line depreciation.Assume, for simplicity, that MACRS depreciation rules do not apply.Required Using Excel, compute the following for the proposed investment:1. The payback period (in years), under the assumption that the cash inflows occur evenly throughout theyear. Round your answer to 1 decimal place. 2. The accounting (book) rate of return based on (a) initial investment, and (b) average investment. Roundboth answers to 1 decimal place (e.g., 13.417% = 13.4%). 3. The net present value (NPV), rounded to the nearest whole dollar.4. The present value payback period of the proposed investment under the assumption that the cash inflowsoccur evenly throughout the year. (Note: Use the formula at the bottom of Appendix C, Table 1 to calculate present value factors.) 5. The internal rate of return (IRR), rounded to 1 decimal place (e.g., 5.491% = 5.5%).6. The modified internal rate of return (MIRR), rounded to 1 decimal place. (In conjunction with thisrequirement, you might want to consult either of the following two references: https://support.office.com/en-us/Search/results?query=mirr+function&src=as and/or http://www.journalofaccountancy.com/issues/2017/feb/calculate-internal-rate-of-return-in-excel.html.)

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Basic Capital Budgeting Techniques; Uneven Net Cash Inflows with Taxes; Spreadsheet
Application Use the same information for this problem as you did for Problem 12-47, except that
the discount rate is 10% (not 12%), the investment is subject to taxes, and the projected pretax operating cash inflows are as follows:
[LO 12-4, 12-6]
Year Pretax Cash Inflow Year Pretax Cash Inflow
1 $ 65,000 6 $300,000
2 80,000 7 270,000
3 120,000 8 240,000
4 200,000 9 120,000
5 240,000 10 80,000
Jensen has been paying 25% for combined federal, state, and local income taxes, a rate that is not
expected to change during the period of this investment. The firm uses straight-line depreciation.
Assume, for simplicity, that MACRS depreciation rules do not apply.
Required Using Excel, compute the following for the proposed investment:
1. The payback period (in years), under the assumption that the cash inflows occur evenly throughout the
year. Round your answer to 1 decimal place.
2. The accounting (book) rate of return based on (a) initial investment, and (b) average investment. Round
both answers to 1 decimal place (e.g., 13.417% = 13.4%).
3. The net present value (NPV), rounded to the nearest whole dollar.
4. The present value payback period of the proposed investment under the assumption that the cash inflows
occur evenly throughout the year. (Note: Use the formula at the bottom of Appendix C, Table 1 to calculate present value factors.)
5. The internal rate of return (IRR), rounded to 1 decimal place (e.g., 5.491% = 5.5%).
6. The modified internal rate of return (MIRR), rounded to 1 decimal place. (In conjunction with this
requirement, you might want to consult either of the following two references: https://support.office.com/
en-us/Search/results?query=mirr+function&src=as and/or http://www.journalofaccountancy
.com/issues/2017/feb/calculate-internal-rate-of-return-in-excel.html.)

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 6 steps with 8 images

Blurred answer
Knowledge Booster
Analytical Techniques
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
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education