As mentioned new product will be sold for 5 years, so we will calculate the Cash Flow for 5 Years. However there is R&D Exp and Working Capital change is applicable for 4 years only.
New Equipment Depreciation = 62.1 / 5 = 12.42
Opportunity Cost Calculation = Salvage Value - Tax Rate (Salvage Value - Book Value)
= 11 - .35(11-0) = 7.15 - As mentioned in questions this was in use for 1 year only.
Present Value Formula =P*((1-(1+r)^-n)/r)
Cash Flow Below table
1 | 2 | 3 | 4 | 5 | |||
Revenue | 444.7 | 444.7 | 444.7 | 444.7 | 444.7 | ||
- | COGS | 354.7 | 354.7 | 354.7 | 354.7 | 354.7 | |
Gross Profit | 90 | 90 | 90 | 90 | 90 | ||
- | Annual Charges | 4.6 | 4.6 | 4.6 | 4.6 | ||
- | Depreciation | 12.42 | 12.42 | 12.42 | 12.42 | 12.42 | |
EBIT | 72.98 | 72.98 | 72.98 | 72.98 | 77.58 | ||
- | Tax @ 35% | 25.543 | 25.543 | 25.543 | 25.543 | 27.153 | |
Incremental Earning | 47.437 | 47.437 | 47.437 | 47.437 | 50.427 | ||
+ | Depreciation | 12.42 | 12.42 | 12.42 | 12.42 | 12.42 | |
- | Incremental Working Capital | -21 | 21 | ||||
- | Capital Investment | -10.2 | |||||
- | Opportunity Cost | -7.15 | 7.15 | ||||
Incremental Cash Flow | -38.35 | 67.007 | 59.857 | 59.857 | 80.857 | 62.847 | |
Discount Rate @ 14.4% | |||||||
Present Value | -38.35 | 58.57255 | 45.7365 | 39.97946 | 47.20777 | 32.0741 | |
NPV | 185.2204 |
NPV Table at Y0
Y0 | |
Revenue | 1512.128 |
COGS | 1206.098 |
Gross Profit | 306.03 |
Annual Charges | 13.29391 |
Depreciation | 42.23213 |
EBIT | 250.5039 |
Tax @ 35% | 87.67637 |
Incremental Earning | 162.8275 |
Depreciation | 42.23213 |
Incremental Working Capital | -8.7393 |
Capital Investment | -10.2 |
Opportunity Cost | -0.9 |
Incremental Cash Flow | 185.2204 |
Hope this helps
You work for Apple. After toiling away on $10.2 million worth of prototypes, you have finally...
You work for Apple. After toiling away on $10.3 million worth of prototypes, you have finally produced your answer to Google Glasses: iGlasses (the name alone is genius). iGlasses will instantly transport the wearer into the world as Apple wants him to experience it: iTunes with the wink of an eye and apps that can be activated just by looking at them. You think that these will sell for five years until the next big thing comes along (or until...
You work for Apple. After toiling away on $ 9.9 million worth of prototypes, you have finally produced your answer to Google Glasses: iGlasses (the name alone is genius). iGlasses will instantly transport the wearer into the world as Apple wants him to experience it: iTunes with the wink of an eye and apps that can be activated just by looking at them. You think that these will sell for five years until the next big thing comes along (or...
Question 2 You work for Apple. After toiling away on $10.7 million worth of prototypes, you have finally produced your answer to Google Glasses: iGlasses (the name alone is genius). iGlasses will instantly transport the wearer into the world as Apple wants him to experience it: iTunes with the blink of an eye and apps that can be activated just by looking at them. You think that these will sell for five years until the next big thing comes along...
After spending a year and $53,000, you finally have the design of your new product ready. In order to start production, you will need $30,000 in raw materials and you will also need to use some existing equipment that you've fully depreciated, but which has a market value of $102,000. Your colleague notes that the new product could represent 10% of the company's overall sales and that 10% of overhead is $60,000. Your tax rate is 38%. As you start...
do for all years After spending $10,900 on client development, you have just been offered a big production contract by a new client. The contract will add $193,000 to your revenues for each of the next five years and it will cost you $97.000 per year to make the additional product. You will have to use some existing equipment and buy new equipment as well. The existing equipment is fully depreciated, but could be sold for $46,000 now. If you...
Question 11 of 25 1 Points After spending $10,000 on client-development, you have just been offered a big production contract by a new client. The contract will add $200,000 to your revenues for each of the next 3 years and it will cost you $100,000 per year to make the additional product. You will have to use some existing equipment and buy new equipment as well. The existing equipment is fully depreciated, but could be sold for $50,000. If you...
7 parts reminaing must do all the way until year 6 thank you an example of what its supposed to look like After spending $10.100 on client-development you have just been offered a big production contract by a new clent The contract will add $191,000 to your revenues for each of the next five years and it will cost you $95,000 per year to make the additional product. You will have to use some existing equipment and buy new equipment...
Your firm is considering building a $594 million plant to manufacture HDTV circuitry. You expect operating profits (EBITDA) of $140 million per year for the next ten years. The plant will be depreciated on a straight-line basis over ten years (assuming no salvage value for tax purposes). After ten years, the plant will have a salvage value of $291 million (which, since it will be fully depreciated, is then taxable). The project requires $50 million in working capital at the...
You are the CFO of Carla Vista, Inc., a retailer of the exercise machine Slimbody6 and related accessories. Your firm is considering opening up a new store in Los Angeles. The store will have a life of 20 years. It will generate annual sales of 4,400 exercise machines, and the price of each machine is $2,500. The annual sales of accessories will be $600,000, and the operating expenses of running the store, including labor and rent, will amount to 50...
Need some assistance with this tricky excel case! Here is an updated info screenshot! Mini-case study 3 Capital budgeting- using incremental cash flow Suppose you recently got an offer from Cisco. You work as a financial manager of the router division of Cisco Systems. On your first day, your boss talks about a project that Cisco is considering now: the development of a wireless home networking appliance, called HomeNet. He asks you to value this project, and then submit a...