what discount rates is it  profitable to create the French version of the software? 

PROBLEM 35

A software company is considering translating its program into French.  Each unit of the program sells for $50 and incurs a variable cost of $10  to produce. Currently, the size of the market for the product is  300,000 units per year, and the English version of the software has a  30% share of the market. The company estimates that the market size will  grow by 10% a year for the next five years, and at 5% per year after  that. It will cost the company $6 million to create a French version of  the program. The translation will increase its market share to 40%.  Given a 10-year planning horizon, for what discount rates is it  profitable to create the French version of the software?

PROBLEM 39

You are thinking of starting Peaco which will produce Peakbabies, a  product that competes with Ty’s Beanie Babies. In year 0 (right now),  you will incur costs of $4 million to build a plant. In year 1, you  expect to sell 80,000 Peakbabies for a unit price of $25. The price of  $25 will remain unchanged through years 1 to 5. Unit sales are expected  to grow by the same percentage (g) each year. During years 1 to 5, Peaco  incurs two types of costs: variable costs and SG&A (selling,  general, and administrative) costs. Each year, variable costs equal half  of revenue. During year 1, SG&A costs equal 40% of revenue. This  percentage is assumed to drop 2% per year, so during year 2, SG&A  costs will equal 38% of revenue, and so on. Peaco’s goal is to have  profits for years 0 to 5 sum to 0 (ignoring the time value of money).  This will ensure that the $4 million investment in year 0 is paid back  by the end of year 5. What annual percentage growth rate g does Peaco  require to pay back the plant cost by the end of year 5?

PROBLEM 43

The file P02_43.xlsx contains a template for a car loan. Specifically,  once values are entered in the blue cells, you need to enter formulas in  the gray cells to calculate the amount financed, the monthly payment  (assuming that monthly payments stay the same throughout the term of the  loan), the total interest paid, and an amortization schedule. For the  latter, fill in the entire gray area with formulas, but use IF functions  so that blanks appear past the term of the loan.

PROBLEM 45

A project does not necessarily have a unique IRR. (Refer to the previous  problem for more information on IRR.) Show that a project with the  following cash flows has two IRRs: year 1, $20; year 2, $82; year 3,  $60; year 4, $2. (Note: It can be shown that if the cash flow of a  project changes sign only once, the project is guaranteed to have a  unique IRR.)

  • attachment

    Sh02_35.xlsx
  • attachment

    Sh02_39.xlsx
  • attachment

    Sh02_43.xlsx
  • attachment

    Sh02_45.xlsx