Suppose you are a senior financial analyst at PADICO and you are analysing the following project, where all of the dollar figures are in thousands of dollars. In year 0, the project requires an $11,350 investment in plant and equipment, which is depreciated using the straight-line method over seven years, and has a salvage value of $1,400 in year 7. The project is forecast to generate sales of 2,000 units in year 1, growing at 1.5% a year until year 5, then the growth rate declines to 0% in years 6 and 7. The cost of capital is forecast to be 11.0% in years 1-6, rising to 12.2% in years 6 and 7. The tax rate is forecast to be a constant 35.0%. Sales revenue per unit is forecast to be $9.70 in year 1 and then grow at 1% per annum. Variable cost per unit for Direct Labor, Materials, Selling Expenses, and Other Variable Costs are forecast to be $3.50, $2.00, $1.20, and $0.70, respectively, in year 1 and then grow at 1% per annum. Cash fixed costs for Lease Payment, Property Taxes, Administration, Advertising, and other cash fixed costs are forecast to be $2,800, $580, $450, $930, and $520, respectively, in year 1 and then grow at 1% per annum. The project will require working capital in the amount of $0.87 in year 0 for every unit of next year's forecasted sales and this amount will grow 1% per annum thereafter. You are required to build your detailed model in Excel to calculate the project's NPV.
Suppose you are a senior financial analyst at PADICO and you are analysing the following project, where all of the dollar figures are in thousands of dollars. In year 0, the project requires an $11,350 investment in plant and equipment, which is depreciated using the straight-line method over seven years, and has a salvage value of $1,400 in year 7. The project is forecast to generate sales of 2,000 units in year 1, growing at 1.5% a year until year 5, then the growth rate declines to 0% in years 6 and 7. The cost of capital is forecast to be 11.0% in years 1-6, rising to 12.2% in years 6 and 7. The tax rate is forecast to be a constant 35.0%. Sales revenue per unit is forecast to be $9.70 in year 1 and then grow at 1% per annum. Variable cost per unit for Direct Labor, Materials, Selling Expenses, and Other Variable Costs are forecast to be $3.50, $2.00, $1.20, and $0.70, respectively, in year 1 and then grow at 1% per annum. Cash fixed costs for Lease Payment, Property Taxes, Administration, Advertising, and other cash fixed costs are forecast to be $2,800, $580, $450, $930, and $520, respectively, in year 1 and then grow at 1% per annum. The project will require working capital in the amount of $0.87 in year 0 for every unit of next year's forecasted sales and this amount will grow 1% per annum thereafter. You are required to build your detailed model in Excel to calculate the project's NPV.
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
Related questions
Question
Transcribed Image Text:Suppose you are a senior financial analyst at PADICO and you are analysing the following
project, where all of the dollar figures are in thousands of dollars. In year 0, the project requires
an $11,350 investment in plant and equipment, which is depreciated using the straight-line
method over seven years, and has a salvage value of $1,400 in year 7. The project is forecast to
generate sales of 2,000 units in year 1, growing at 1.5% a year until year 5, then the growth rate
declines to 0% in years 6 and 7. The cost of capital is forecast to be 11.0% in years 1-6, rising to
12.2% in years 6 and 7. The tax rate is forecast to be a constant 35.0%. Sales revenue per unit is
forecast to be $9.70 in year 1 and then grow at 1% per annum. Variable cost per unit for Direct
Labor, Materials, Selling Expenses, and Other Variable Costs are forecast to be $3.50, $2.00,
$1.20, and $0.70, respectively, in year 1 and then grow at 1% per annum. Cash fixed costs for
Lease Payment, Property Taxes, Administration, Advertising, and other cash fixed costs are
forecast to be $2,800, $580, $450, $930, and $520, respectively, in year 1 and then grow at 1%
per annum. The project will require working capital in the amount of $0.87 in year 0 for every
unit of next year's forecasted sales and this amount will grow 1% per annum thereafter.
You are required to build your detailed model in Excel to calculate the project's NPV.
Assume that the product life-cycle of seven years is viewed as a safe bet, but that the scale of
demand for the product is highly uncertain. Analyze the sensitivity of the project NPV to the unit
sales scale factor and to the cost of capital. (Hint: Use two way datatable) (this is a bonus part).
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 5 steps with 4 images
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
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…
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