Question

Allegience Insurance Company’s management is considering an advertising program that would require an initial expenditure of $165,500 and bring in additional sales over the next five years. The projected additional sales revenue in year 1 is $75,000, with associated expenses of $25,000. The additional sales revenue and expenses from the advertising program are projected to increase by 10 percent each year. Allegience’s tax rate is 30 percent. (Hint: The $165,500 advertising cost is an expense.)
Required:

Compute the payback period for the advertising program.

Calculate the advertising program’s net present value, assuming an after-tax hurdle rate of 10 percent.

Answer 1

Answer:

a. Pay back period is 4 years and 18 days

b. Net present value is - $5,909. Since the NPV is negative, the project should be rejected.

Explanation:

Note: See the attached for the calculation tables of a and b.

a. Pay back period = 4 years and [($2,565/$51,244)*365 days] = 4 years and 18 days approximately.

Download xlsx