The projected costs for a new plant are given below (all numbers are in Millions): Land Cost = $10 Fixed Capital Investment without land = $100 ($40 at end of year 1, $40 at end of year 2, and $20 at end of year 3) Working Capital = $20 (at start-up) Start-up at end of year 3 Revenue from sales are $80 for the entire project lifetime of 10 years. Cost of manufacturing (without depreciation) = $25 Tax rate = 40% Depreciation method = Current MACRS over 5 years Internal rate of return = 10% p.a. (Interest rate) (1). For this project, please do the following: a. Draw a cumulative (non-discounted) after-tax cash flow diagram. b. From Part (a), calculate the following non-discounted profitability criteria for the project: (i) Cumulative cash position and cumulative cash ratio (ii) Payback period (iii) Rate of return on investment c. Draw a cumulative (discounted) after-tax cash flow diagram. d. From Part (c), calculate the following discounted profitability criteria for the project: (i) Net present value and net present value ratio (ii) Discounted payback period (iii) Discounted cash flow rate of return (DCFROR)
The projected costs for a new plant are given below (all numbers are in Millions): Land Cost = $10 Fixed Capital Investment without land = $100 ($40 at end of year 1, $40 at end of year 2, and $20 at end of year 3) Working Capital = $20 (at start-up) Start-up at end of year 3 Revenue from sales are $80 for the entire project lifetime of 10 years. Cost of manufacturing (without depreciation) = $25 Tax rate = 40% Depreciation method = Current MACRS over 5 years Internal rate of return = 10% p.a. (Interest rate) (1). For this project, please do the following: a. Draw a cumulative (non-discounted) after-tax cash flow diagram. b. From Part (a), calculate the following non-discounted profitability criteria for the project: (i) Cumulative cash position and cumulative cash ratio (ii) Payback period (iii) Rate of return on investment c. Draw a cumulative (discounted) after-tax cash flow diagram. d. From Part (c), calculate the following discounted profitability criteria for the project: (i) Net present value and net present value ratio (ii) Discounted payback period (iii) Discounted cash flow rate of return (DCFROR)
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 21P
Related questions
Question
Please help me with this land project assignment

Transcribed Image Text:The projected costs for a new plant are given below (all numbers are in Millions):
Land Cost = $10
Fixed Capital Investment without land = $100 ($40 at end of year 1, $40 at end of year 2, and $20
at end of year 3)
Working Capital = $20 (at start-up)
Start-up at end of year 3
Revenue from sales are $80 for the entire project lifetime of 10 years.
Cost of manufacturing (without depreciation) = $25
Tax rate = 40%
Depreciation method = Current MACRS over 5 years
Internal rate of return = 10% p.a. (Interest rate)
(1). For this project, please do the following:
a. Draw a cumulative (non-discounted) after-tax cash flow diagram.
b. From Part (a), calculate the following non-discounted profitability criteria for the project:
(i) Cumulative cash position and cumulative cash ratio
(ii) Payback period
(iii) Rate of return on investment
c. Draw a cumulative (discounted) after-tax cash flow diagram.
d. From Part (c), calculate the following discounted profitability criteria for the project:
(i) Net present value and net present value ratio
(ii) Discounted payback period
(iii) Discounted cash flow rate of return (DCFROR)
Expert Solution

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 2 steps with 2 images

Recommended textbooks for you

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing

Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing

Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning

Management, Loose-Leaf Version
Management
ISBN:
9781305969308
Author:
Richard L. Daft
Publisher:
South-Western College Pub