Question

In: Finance

Hollow Truth Publishers is considering whether to launch a new e-magazine. The annual percentage rate of...

Hollow Truth Publishers is considering whether to launch a new e-magazine. The annual percentage rate of return (APR) on a similar risk project is 8%, the cash flows occur semi-annually (at the end of the 6th and 12th month for each year), and the publishing company requires a payback period of 2 years. The finance department has calculated that the required rate of return for all projects that it will consider is 14%.

The costs of the project are:

Advertising on various billboards and cable television stations $200,000

Hollow Truth’s headquarters accounting department charges $50,000

Production costs and employee bonuses $260,000

Last year’s purchase price for the e-magazine's offices $470,000

Potential rental income from the offices if rented to a 3rd party $200,000

a. What are the total relevant costs of the project? Explain why you consider each cost relevant or not for this project.
b. Assume the semi-annual cash inflows are $150,000 and $200,000 in year 1, and $250,000 and $200,000 in year 2. Calculate the payback, discounted payback, IRR and MIRR of the project. Based on each criterion, should you accept the project? Why?
c. If the project is analyzed using the NPV rule, should you accept the project? Why?
What would you do if you believed the semi-annual cash flows had a high degree of uncertainty and could be potentially 15% lower? (You don’t have to re-estimate the NPV, just describe what you would do and how you would assess this.)
d. If you were the CEO of the firm, would you accept or reject this project? Why?   

Solutions

Expert Solution

a) What are the total relevant costs of the project? Explain why you consider each cost relevant or not for this project.

Advertising = $200,000

Production costs = $260,000

Potential rents = $200,000

Total = $660,000

The accounting department charges are allocated overhead and last year's purchase price is a sunk cost so it will not be included.

b)  Assume the semi-annual cash inflows are $150,000 and $200,000 in year 1, and $250,000 and $200,000 in year 2. Calculate the payback, discounted payback, IRR, and MIRR of the project. Based on each criterion, should you accept the project? Why?

-The accumulated cash flows at the end of the third period are $600,000 and $800,000 at the end of the fourth period. Payback for the project will occur between the third and fourth cash flows (the first and last cash flow in year 2).

Total costs are $660,000

Payback = 1.5 yrs+[(660,000–600,000)/200,000]*0.5 yrs = 1.65years

Accept because it is paid back in the pre-specified period, 2 years.

The discounted accumulated cash flows at the end of the third period are $551,391 and $722,352 at the end of the fourth period. Discounted Payback for the project will occur between the third and fourth cash flows (the first and last cash flow in year 2).

Total costs are $660,000

Payback = 1.5 yrs+[(660,000–551,391)/170,961]*0.5 yrs = 1.82 years

Accept because it is paid back in the pre-specified period, 2 years.

IRR is that r which makes the NPV equal to 0. Remember IRR is solved by iteration. If you are doing IRR by hand, you need to use trial and error to find IRR. Alternatively, your financial calculator probably has an IRR function and Excel has an IRR function. Since these cash flows are semi-annual, the computed r is semi-annual. So the annual IRR is 16.06% ((1.0773^2)–1).

0 =-$660,000 + (150,000)/(1+IRR)^1+ (200,000)/(1+IRR)^2+ (250,000)/(1+IRR)^3+(200,000)/(1+IRR)^4

Solve for IRR, IRR=0.0773

Since the finance department requires a 14% return, you would accept this project (16.06%>14%)

Since the IRR is 16% while the appropriate r is only 8%, IRR overstates the expected return due to the reinvestment rate assumption. In other words, IRR assumes that all the intermediate cash flows are reinvested at 16%. MIRR solves that problem by assuming that the intermediate cash flows are reinvested at an r that is closer to the appropriate r which is 8%. The semi-annual MIRR is 6.37% while the annual rate is 13.15% ((1.0637^2)-1).

PV(outflows) =-660,000 (in period 0 dollars)

FV(inflows, period 4 dollars) = 150,000*(1.04^3) + 200,000*(1.04^2) + 250,000*(1.04^1) + 200,000*(1.04^0)

= 845,050

MIRR = {[FV/PV] ^ (1/T)}-1 = {[845,050/660,000] ^ (1/4)}–1 = 0.0637

Since the finance department requires a 14% return, you would reject this project (13.15%<14%)

c. If the project is analyzed using the NPV rule, should you accept the project? Why?
What would you do if you believed the semi-annual cash flows had a high degree of uncertainty and could be potentially 15% lower? (You don’t have to re-estimate the NPV, just describe what you would do and how you would assess this.)

semi-annual rate = .04

NPV = -$660,000 + (150,000)/(1.04)^1+ (200,000)/(1.04)^2+ (250,000)/(1.04)^3+(200,000)/(1.04)^4

NPV = $62,352

Therefore, accept the project because NPV > 0

If there is a high degree of uncertainty about the semi-annual cash flows the first question that needs to be addressed is did you pick the correct r. In this case, assume you have the correct r and instead the uncertainty comes from whether you have the correct estimated cash flows. In that case, we should do a scenario analysis that includes assigning probabilities to each cash flow outcome and re-estimate NPV.

d. If you were the CEO of the firm, would you accept or reject this project? Why?

All of the other methods have various advantages and disadvantages but in the end, you want to focus on NPV because it is the only method that always is consistent with maximizing shareholder wealth. Therefore you want to accept this project because the NPV>0. Note that IRR and MIRR should be consistent with NPV in this case because the cash flows are conventional and the project is independent. However, the finance department has established a hurdle rate (14%) that does not reflect the riskiness of the cash flows so these two methods may lead to sub-optimal decisions

If you have any doubts please let me know in the comments.

.


Related Solutions

A magazine is considering the launch of an online edition. The magazine plans to go ahead...
A magazine is considering the launch of an online edition. The magazine plans to go ahead only if it is convinced that more than 29.1% of current readers would subscribe. The magazine contacted a simple random sample of 464 current subscribers, and 141 of those surveyed expressed interest. Test the appropriate hypotheses using a significance level of 0.05 to determine if the magazine should launch an online edition.    H0: Select an answer p < ? > =       Ha: Select...
A magazine is considering the launch of an online edition. The magazine plans to go ahead...
A magazine is considering the launch of an online edition. The magazine plans to go ahead only if it is convinced that more than 25​% of current readers would subscribe. The magazine contacted a simple random sample of 500 current​ subscribers, and 134 of those surveyed expressed interest. What should the company​ do? Test appropriate hypotheses and state your conclusion Find the Z and P Value of the test statistic
A magazine is considering the launch of an online edition. The magazine plans to go ahead...
A magazine is considering the launch of an online edition. The magazine plans to go ahead only if it is convinced that more than 20​% of current readers would subscribe. The magazine contacted a simple random sample of 400 current​ subscribers, and 90 of those surveyed expressed interest. What should the company​ do? Test appropriate hypotheses and state your conclusion. Are the assumptions and the conditions to perform a​ one-proportion z-test​ met? Yes No State the null and alternative hypotheses....
A magazine is considering the launch of an online edition. The magazine plans to go ahead...
A magazine is considering the launch of an online edition. The magazine plans to go ahead only if it is convinced that more than 20​% of current readers would subscribe. The magazine contacted a simple random sample of 400 current​ subscribers, and 102 of those surveyed expressed interest. What should the company​ do? Test appropriate hypotheses and state your conclusion. Are the assumptions and the conditions to perform a​ one-proportion z-test​ met? Yes or No State the null and alternative...
A new magazine, Cycling n’ Running NZ is about to be published. The magazines’ publishers are...
A new magazine, Cycling n’ Running NZ is about to be published. The magazines’ publishers are unsure whether readers of this magazine would be more interested in articles on cycling or articles on running. Accordingly, a study was conducted to find out how interested readers of this magazine would be in articles on either of these topics. The variables to use in answering this question are Cycling and Running. Potential interest in both topics was measured on a five-point semantic...
Corporation A plans to launch a new project and the financial manager is considering whether this...
Corporation A plans to launch a new project and the financial manager is considering whether this is a valuable investment for the corporation. Consider: The initial cost of this project is $197.92, and it offers cash flows in the next 3 years, with an estimated cash flow of $ 50 in the first year, $100 in the second year and $150 in the third year. Questions: 1. What is the Internal Rate of Return (IRR) of this project? 2. If...
A magazine publisher wants to launch a new magazine geared to college students. The project's initial...
A magazine publisher wants to launch a new magazine geared to college students. The project's initial investment is $65. The project's cash flows that come in at the end of each year are $23 for 5 consecutive years beginning one year from today. What is the project's NPV if the required rate of return is 15%? $_____ Place your answer in dollars and cents without the use of a dollar sign or comma. If applicable, a negative answer should have...
1. A magazine publisher wants to launch a new magazine geared to college students. The project's...
1. A magazine publisher wants to launch a new magazine geared to college students. The project's initial investment is $69. The project's cash flows that come in at the end of each year are $26 for 5 consecutive years beginning one year from today. What is the project's NPV if the required rate of return is 11% Based upon the NPV decision rule, should the company accept or reject the project?
1. First Part: A magazine publisher wants to launch a new magazine geared to college students....
1. First Part: A magazine publisher wants to launch a new magazine geared to college students. The project's initial investment is $66. The project's cash flows that come in at the end of each year are $24 for 6 consecutive years beginning one year from today. What is the project's NPV if the required rate of return is 13%? Answer #1: $ Place your answer in dollars and cents without the use of a dollar sign or comma. If applicable,...
Brutech Corporation is considering whether or not to launch its new product, a kioskfor checking in...
Brutech Corporation is considering whether or not to launch its new product, a kioskfor checking in medical patients at doctor’s offices. Marketing research is confidentthe kioskwill sell 1,300units per year, but the finance department is also evaluating the risks that unit sales and other key forecast variables might pose if the initial data differs from reality. In the Base Case, the selling price on the 1,300 units will be $2,100 per kiosk. Variable costsper unitwill be $1,300, and fixed costs...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT