Question

The most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost: Fixed cost: Expected s

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a:

NPV 332494.78
Year Sales Variable cost Fixed cost Depreciation Profit before tax Tax OCF Cost of new
machine
Net cash flow
0 -1200000 -1200000
1 3200000 2400000 460000 120000 220000 46200 293800 293800
2 3200000 2400000 460000 120000 220000 46200 293800 293800
3 3200000 2400000 460000 120000 220000 46200 293800 293800
4 3200000 2400000 460000 120000 220000 46200 293800 293800
5 3200000 2400000 460000 120000 220000 46200 293800 293800
6 3200000 2400000 460000 120000 220000 46200 293800 293800
7 3200000 2400000 460000 120000 220000 46200 293800 293800
8 3200000 2400000 460000 120000 220000 46200 293800 293800
9 3200000 2400000 460000 120000 220000 46200 293800 293800
10 3200000 2400000 460000 120000 220000 46200 293800 293800
NPV 332494.78

AutoSave © of HO- Book1 - Excel Sign in - o X File Home Insert Draw Page Layout Formulas Data Review View Help O Tell me what

b:

NPV -1023225.84

In the worst case, selling price and sales are 5% less, and variable and fixed costs are 5% higher. Assuming tax rate is the same at 21%

Year Sales Variable cost Fixed cost Depreciation Profit before tax Tax OCF Cost of new
machine
Net cash flow
0 -1200000 -1200000
1 2888000 2394000 483000 120000 -109000 -22890 33890 33890
2 2888000 2394000 483000 120000 -109000 -22890 33890 33890
3 2888000 2394000 483000 120000 -109000 -22890 33890 33890
4 2888000 2394000 483000 120000 -109000 -22890 33890 33890
5 2888000 2394000 483000 120000 -109000 -22890 33890 33890
6 2888000 2394000 483000 120000 -109000 -22890 33890 33890
7 2888000 2394000 483000 120000 -109000 -22890 33890 33890
8 2888000 2394000 483000 120000 -109000 -22890 33890 33890
9 2888000 2394000 483000 120000 -109000 -22890 33890 33890
10 2888000 2394000 483000 120000 -109000 -22890 33890 33890

AutoSave © of HO- Book1 - Excel Sign in - o X File Home Insert Draw Page Layout Formulas Data Review View Help O Tell me what

Add a comment
Know the answer?
Add Answer to:
The most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost:...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost:...

    The most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost: Fixed cost: Expected sales: $ 60 $ 40 $420,000 47,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $2.1 million, which will be depreciated straight-line...

  • The most likely outcomes for a particular project are estimated as follows: points Unit price: Variable...

    The most likely outcomes for a particular project are estimated as follows: points Unit price: Variable cost: Fixed cost: Expected sales: $ 50 $ 30 $420,000 41,000 units per year ebook Print However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.2 million, which will...

  • URGENTTT The most likely outcomes for a particular project are estimated as follows: Unit price: Variable...

    URGENTTT The most likely outcomes for a particular project are estimated as follows: Unit price: Variable cost: Fixed cost: Expected sales: 80 68 $280,eee 30,eee units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 5% higher or 5% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.0 million, which will be depreciated straight-line over...

  • The most likely outcomes for a particular project are estimated as follows: Unit price: $ 60...

    The most likely outcomes for a particular project are estimated as follows: Unit price: $ 60 Variable cost: $ 40 Fixed cost: $ 250,000 Expected sales: 30,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.2 million, which will be depreciated...

  • The most likely outcomes for a particular project are estimated as follows: Unit price: $50 Variable...

    The most likely outcomes for a particular project are estimated as follows: Unit price: $50 Variable cost: $30 Fixed cost: $300,000 Expected sales: 30,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1 million, which will be depreciated straight-line over the...

  • The most likely outcomes for a particular project are estimated as follows: Unit price: $ 80...

    The most likely outcomes for a particular project are estimated as follows: Unit price: $ 80 Variable cost: $ 60 Fixed cost: $ 380,000 Expected sales: 37,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 5% higher or 5% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.7 million, which will be depreciated...

  • The most likely outcomes for a particular project are estimated as follows: Unit price: $50 Variable...

    The most likely outcomes for a particular project are estimated as follows: Unit price: $50 Variable cost: $30 Fixed cost: $300,000 Expected sales: 30,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1 million, which will be depreciated straight-line over the...

  • Problem 10-9 Scenarlo Analysls (LO3) The most likely outcomes for a particular project are estimated as...

    Problem 10-9 Scenarlo Analysls (LO3) The most likely outcomes for a particular project are estimated as follows: Unit price Variable cost: Fixed cost Expected sales: 58 30 $328,eee 31,808 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.5 million, which will...

  • Variable cost: 20 Fixed cost: 350,000 Unit Price:40 Expected sales: 34,000 units per year However, you...

    Variable cost: 20 Fixed cost: 350,000 Unit Price:40 Expected sales: 34,000 units per year However, you recognize that some of these estimates are subject to error. Suppose that each variable may turn out to be either 10% higher or 10% lower than the initial estimate. The project will last for 10 years and requires an initial investment of $1.2 million, which will be depreciated straight-line over the project life to a final value of zero. The firm’s tax rate is...

  • You are considering a proposal to produce and market a new sluffing machine. The most likely...

    You are considering a proposal to produce and market a new sluffing machine. The most likely outcomes for the project are as follows: Expected sales: 115,000 units per year Unit price: $220 Variable cost: $132 Fixed cost: $4,890,000 The project will last for 10 years and requires an initial investment of $16.70 million, which will be depreciated straight-line over the project life to a final value of zero. The firm’s tax rate is 30%, and the required rate of return...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT