Allegience Insurance Company’s management is considering an advertising program that would require an initial expenditure of $178,740 and bring in additional sales over the next five years. The projected additional sales revenue in year 1 is $83,000, with associated expenses of $29,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 40 percent. (Hint: The $178,740 advertising cost is an expense.)
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.
Calculation of incremental cash flow for next five years is shown below | ||||||||
Year | 1 | 2 | 3 | 4 | 5 | |||
Sales revenue | $83,000 | $91,300 | $100,430 | $110,473 | $121,520 | |||
Less: Expenses | $29,000 | $31,900 | $35,090 | $38,599 | $42,459 | |||
Income before taxes | $54,000 | $59,400 | $65,340 | $71,874 | $79,061 | |||
Taxes | -$21,600 | -$23,760 | -$26,136 | -$28,750 | -$31,625 | |||
Net income | $32,400 | $35,640 | $39,204 | $43,124 | $47,437 | |||
Calculation of payback period | ||||||||
Year | Cash flow | Accumulated cash flow | ||||||
0 | -$178,740 | -$178,740 | ||||||
1 | $32,400 | -$146,340 | ||||||
2 | $35,640 | -$110,700 | ||||||
3 | $39,204 | -$71,496 | ||||||
4 | $43,124 | -$28,372 | ||||||
5 | $47,437 | $19,065 | ||||||
Payback period | 4 + 28372/47437 | |||||||
Payback period | 4 + 0.59809 | |||||||
Payback period | 4.00 | |||||||
Thus, payback period period is 4.60 | ||||||||
Calculation of net present value is shown below | ||||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | ||
Sales revenue | $83,000.00 | $91,300.00 | $100,430.00 | $110,473.00 | $121,520.30 | |||
Less: Expenses | $29,000.00 | $31,900.00 | $35,090.00 | $38,599.00 | $42,458.90 | |||
Income before taxes | $54,000.00 | $59,400.00 | $65,340.00 | $71,874.00 | $79,061.40 | |||
Taxes | -$21,600.00 | -$23,760.00 | -$26,136.00 | -$28,749.60 | -$31,624.56 | |||
Net income | $32,400.00 | $35,640.00 | $39,204.00 | $43,124.40 | $47,436.84 | |||
Initial expenditure | -$178,740.00 | |||||||
Free cash flow | -$178,740.00 | $32,400.00 | $35,640.00 | $39,204.00 | $43,124.40 | $47,436.84 | ||
Discount factor @ 10% | $1.00000 | $0.90909 | $0.82645 | $0.75131 | $0.68301 | $0.62092 | ||
Present value | -$178,740.00 | $29,454.55 | $29,454.55 | $29,454.55 | $29,454.55 | $29,454.55 | ||
Net present value | -$31,467.27 | |||||||
Thus, net present value of advertising program is -$31,467.27 | ||||||||
Allegience Insurance Company’s management is considering an advertising program that would require an initial expenditure of...
Allegience Insurance Company's management is considering an advertising program that would require an initial expenditure of $177,085 and bring in additional sales over the next five years. The projected additional sales revenue in year 1 is $82,000, with associated expenses of $28,500. The additional sales revenue and expenses from the advertising program are projected to increase by 10 percent each year. Allegience's tax rate is 40 percent. (Hint: The $177,085 advertising cost is an expense.) Use Appendix A for your...
To Tutor
In this question above I want to know that when
I calculate net cash outflow, Should
I less taxes from advertising expense?
Thank you
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...
The management of L Corporation is considering a project that would require an investment of $228,000 and would last for 6 years. The annual net operating income from the project would be $108,000, which includes depreciation of $29,000. The cash inflows occur evenly throughout the year. The payback period of the project is closest to (Ignore income taxes.):
Cardinal Company is considering a project that would require a $2,985,000 investment in equipment with a useful life of five years. At the end of five years, the project would terminate and the equipment would be sold for its salvage value of $400,000. The company’s discount rate is 16%. The project would provide net operating income each year as follows: Sales $ 2,737,000 Variable expenses 1,001,000 Contribution margin 1,736,000 Fixed expenses: Advertising, salaries, and other fixed out-of-pocket costs $...
CARDINAL COMPANY IS CONSIDERING A FIVE-YEAR PROJECT THAT WOULD REQUIRE A $2,975,000 INVESTMENT IN EQUIPMENT WITH A USEFUL LIFE OF YEARS AND NO SALVAGE VALUE. THE COMPANY'S DISCOUNT RATE IS 14%. THE PROJECT WOULD PROVIDE NET OPERATING INCOME EACH OF THE 5 YEARS AS FOLLOWS: SALES $2,735,000 VARIABLE EXPENSES 1,000,000 CONTRIBUTION MARGIN $1,735,000 FIXED EXPENSES: ADVERTISING, SALARIES, AND OTHER FIXED OUT OF POCKET COSTS $735,000 DEPRECIATION $ 95,000 TOTAL FIXED EXPENSES $1,330,000 NET OPERATING EXPENSES ...
13.
The management of Lanzilotta Corporation is considering a project that would require an investment of $228,000 and would last for 6 years. The annual net operating income from the project would be $108,000, which includes depreciation of $29,000. The scrap value of the project's assets at the end of the project would be $15,000. The cash inflows occur evenly throughout the year. The payback period of the project is closest to (Ignore income taxes.): (Round your answer to 1...
You are considering a project that will require an initial outlay of $200,000. This project has an expected life of four years and will generate after-tax cash flows to the company as a whole of $60,000 at the end of each year over its five-year life. Thus, the free cash flows associated with this project look like this: Year Free Cash Flow 0 -150,000 1 60,000 2 60,000 3 60,000 4 60,000 Given a required rate of return of 10%...
You are considering a project that will require an initial outlay of $400,000. This project has an expected life of four years and will generate after-tax cash flows to the company as a whole of $120,000 at the end of each year over its five-year life. Thus, the free cash flows associated with this project look like this: Year Free Cash Flow 0 -150,000 1 120,000 2 120,000 3 120,000 4 120,000 Given a required rate of return of 20%...
Quintiles Corporation is considering a project that would require an investment of $343,000 and would last for 8 years. The incremental annual revenues and expenses generated by the project during those 8 years would be as follows (Assume a tax rate of 25% and that all sales are cash sales and all expenses are paid as incurred): Sales.................................$227,000 Variable expenses......... 52,000 Contribution margin....... 175,000 Fixed expenses: Salaries.........................27,000 Rents..............................41,000 Depreciation................ 42,875 Total fixed expenses.....110,875 Net operating income...$ 64,125 The payback period of the...
Washington County's Board of Representatives is considering the construction of a longer runway at the county airport. Currently, the airport can handle only private aircraft and small commuter jets. A. new, long runway would enable the airport to handle the midsize jets used on many domestic flights. Data pertinent to the board's decision appear below. Cost of acquiring additional land for runway Cost of runway construction Cost of extending perimeter fence Cost of runway lights Annual cost of maintaining new...