How to Proceed

Develop your investment proposal business case draft:

1. Prepare a summary narrative (i.e., a detailed description) of each proposal with detailed elements on the initial investment, as well as the costs/revenues over the life of each of the projects. Identify which revenues and costs are relevant to your analysis, and which costs are irrelevant. Identify the time horizon for each investment.
2. Calculate the after-tax cash flows during the life of each of the projects. Be sure to identify the total costs of ownership and deduct those costs from the benefits to arrive at the net cash inflow per year.

Pear Computer Horizons Case Study

Investment Proposals

Amanda Morrison, CEO of PCH, wants you to evaluate two investment proposals that the company is considering:

1. The acquisition of a Canadian camera company; and
2. The launch of a new product for government and business enterprises.

Ms. Morrison reminds you that only relevant costs and revenues should be considered. "Relevant costs have to be occurring in the future," explained Ms. Morrison. "And have to differ from the status quo. For example, if we choose to buy the Canadian camera company, it is only the incremental revenue and costs related to the purchase that should be considered. We also need to take into account the opportunity costs associated with the alternatives. For example, for the new product launch, we need to factor in the lost sales from some of our current products in catering to those customers."

More details on each investment proposal are included below. Ms. Morrison wants you to recommend if PCH should invest in one, both, or none of the investment proposals.

Required Return

Ms. Morrison wants you to use the weighted average bond yield for your required return. The total market value of debt PCH is expected to have going into this investment is $200M, which includes the current amount of bonds on the financial statements of $150M at a 6% interest rate and a planned new debt issuance of $50M at a higher 8% rate. All long-term debt is in the form of bonds. Ignore income tax effects when calculating the required return (i.e., do not take the after-tax cost of debt). Use current interest rates as a proxy for bond yield.

Acquisition of Canadian Camera Company

Ms. Morrison is considering acquiring a high-tech Canadian camera company for $50M in cash consideration. The camera phones that the target company is developing are only in the prototype stage, and would need an initial investment of $10M for development costs (to be expensed immediately) and $6M for production equipment. The camera company currently only has $1M of available tax shield left, excluding any tax shield related to the additional equipment to be purchased, for equipment that was originally purchased for $10M. Furthermore, PCH plans on spending an additional $2.025M in research and development (R&D) costs every year to continue to innovate with the camera phones and adopt new advancements in technology, as they are internally developed or externally acquired.

The manufacturing costs for the camera phones are expected to be 45% of sales, once the phone passes the prototype stage into the final product stage when the phones can start to be sold. Software support costs for upgrades and warranty & repair costs are expected to be 6% and 5% of sales, respectively. These costs, as a percentage of sales, are expected to remain consistent over the time horizon. It is anticipated that twenty employees from the camera company will be absorbed into PCH, with the average employee having a salary (including benefits) of $100,000. Other incremental manufacturing overhead costs (property taxes, maintenance, security, etc.), excluding depreciation, are estimated to be $1M annually. Wages are expected to increase with inflation (estimated at 2%) over the time period, while other fixed costs are expected to remain steady.

Due to the integration process of the camera company into PCH operations and the additional development required for the prototype camera phones, initial sales are only expected to reach a volume of 50,000 units in the first year. However, production is expected to double in Year 2, Year 3, and Year 4, before stabilizing at 400,000 units per year. Additional marketing costs of $3M per year will be spent to promote the product among the millennial segment through a social media campaign and promotional events.

The camera phone's retail price to consumers is $500, but that includes the 30% markup that retailers apply to the phone to make a profit. Thus, the sales price for PCH would be 70% of the retail price, and this price is expected to increase by inflation over the time horizon.

Ms. Morrison wants to see if the project will reach profitability after 5 years, so she wants you to evaluate the return on investment in that period using the investment criteria of payback period, discounted payback period, NPV, IRR, and profitability index. The following table will help in the calculations of the tax shield for the new equipment:

Class	CCA Rate	Description
43	30%	Machine and equipment to manufacture and process goods for sale

Tax Shield Formula:

Assume no salvage value when calculating the tax shield, and that the half-year rule applies for each class. The tax rate Ms. Morrison wants you to utilize is 20%. When calculating the tax shield, the present value should be in the same period as the initial investment (Year 0), which also means that deprecation (i.e., CCA) should not be taken from the cash flows in subsequent years, since their tax shelter effects are already accounted for in the tax shield.

New Product Launch

Ms. Morrison also wants you to evaluate if PCH should go forward with a new product launch for business and government enterprises. Over the past several years, PCH has spent over

$50M on R&D on a new laptop and associated software. An additional investment of $20M is required before the product is ready to launch. There are 40 universities and 25 government ministries across Canada that are interested in entering ten-year contracts with PCH, which would lead to $75K in before-tax cash flow from each client. However, the interested parties are also existing clients of PCH, which means that the current contracts (with ten years remaining) that lead to $15K in before-tax cash flow per client would be nullified. Ms. Morrison wants you to evaluate the profitability of this investment after a ten-year period using the investment criteria of NPV and profitability index.

Q1	After-tax Cash Flows	Marks	Student
	Investment 1: Acquisition of Camera Company
	Initial Investment Including Equipment & development	3
	Old tax shield included	1
	Investment horizon utilized	2
	Reasonable inclusion of inflation	1
	Correct volume for phone sales	1
	Correct sales price for phones	1
	Warranty Costs Considered	1
	Manufacturing Costs Considered	2
	Software support costs considered	2
	Incremental Marketing costs included	2
	Salary of twenty employees considered	2
	Other overhead costs considered	2
	Incremental R&D costs included	2
	After-tax cash flows (ATCF) calculated	4
	Attempt at Tax Shield	2
	Investment 2: New Product Launch
	Initial Investment Calculation (ignore sunk costs)	2
	Correct amount of clients identified	1
	After-tax cash flows (ATCF) calculated	2
	Ten-year horizon utilized	1
	Opportunity cost of lost cash flow included	2
Q2	Investment Criteria Calculated	Marks	Student
	Investment 1: Acquisition of Camera Company
	Payback Period	2
	Discounted Payback Period	2
	Net Present Value	6
	Internal Rate of Return	2
	Profitability Index	2
	Investment 2: New Product Launch
	Net Present Value	4
	Profitability Index	2

Times New Roman - 14 ub Wrap Text General * Cut Copy Format Painter BE Paste BIU Merge & Center % Conditional Format as Cell Formatting Table Styles Insert Delete Clipboard Font Alignment Number Styles Cells G23 f D E E G H M 24 5 6 INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2018 7 PARTICULARS Pro Forma s (SYMILLIONS 288.95 8 RAVENUE 9 COMPUTER $875.62 - $586.67) 10 PHONES ($875.62.50%) 11 SOFTWARE & GAMING ($875.62 17%) 12 437.81 $148.86 Reveme have increased by 10% from 2017 Revenue(S796.02). Consist of 50% from phones $875.62 and 17% of the Revenue from software and gaming. The balance Revenue is from computers 13 TOTAL REVENUE LESS: COST OF GOODS SOLD: 14 30% OF REVENUE 262.69 Cost of good sold in 2017 was 30% of revenue. However, in 2018 the same would encounter an increase of 2% due to an increase in material cost, 1% due to depreciation in canadian dollars, 1% due to switching of material supplier and futher 1% to uncertainity surrounding NAFTA and trade tariffs, thereby resulting in an increase of 5% in COGS as compared to previous year hence the COGS is 35% of revenue 2% INCREASE IN COST OF GOODS SOLD DUE TO INCREASE IN MATERIAL COST 17.51 16 1% INCREASE IN COST OF GOODS SOLD DUE TO SWITCHING OF MATERIAL SUPPLIER 8.76 7 28 1% INCREASE IN COST OF GOODS SOLD DUE TO DEPRECIATING CANADIAN DOLLAR. 8.76 1% INCREASE IN COST OF GOODS SOLD DUE TO UNCERTAINTY AND TRADE TARIFFS COVER PAGE SWOT RATIO ANALYSIS INVESTMENT PROPOSAL FORECAST INCOME STATEMENT 2018 CCA Ready Type here to search O BI ? 22C Times New Roman 14 a Wiap Text General Paste Copy Es Format Painter EF Insert Dele BIU A EE Merge & Center S% % DO Conditional Format as Cell Formatting Table Styles Clipboard Font Alignment Number Styles Cell G23 : X fr B D E F G H K A LESS: COST OF GOODS SOLD: 14 262.69 30% OF REVENUE 15 2% INCREASE IN COST OF GOODS SOLD DUE TO INCREASE IN MATERIAL COST 16 1% INCREASE IN COST OF GOODS SOLD DUE TO SWITCHING OF MATERIAL SUPPLIER Cost of good sold in 2017 was 30% of revenue. However, in 2018 the same would encounter an increase of 2% due to an increase in material cost, 1% due to depreciation in canadian dollars, 1% due to switching of material supplier and futher 1% to uncertainity surrounding NAFTA and trade tariffs, thereby resulting in an increase of 5% in COGS as compared to previous year, hence, the COGS is 35% of revenue. 17.51 8.76 8.76 8.76 1% INCREASE IN COST OF GOODS SOLD DUE TO DEPRECIATING CANADIAN DOLLAR 18 1% INCREASE IN COST OF GOODS SOLD DUE TO UNCERTAINTY AND TRADE TARIFFS 19 20 GROSS PROFIT @65% OF REVENUE 21 LESS: OPERATING EXPENSES:- 22 ADVERTISING & MARKETING @10% OF REVENUE $306.48 $569.14 -S(10% X 87562) MILLIONS=$87.56 87.56 GENERAL & ADMINISTRATIVE @15% OF REVENUE **S(15% X 875.62) MILLIONS =$131 34 131 34 RESEARCH, IT & DEVELOPMENT 20% OF THE COMPUTER SALES **($288.95 MILLIONS X 20 = $57.79 MILLIONS) COVER PAGE SWOT RATIO ANALYSIS INVESTMENT PROPOSAL Ready 57.791 FORECAST INCOME STATEMENT 2018 CCA ... - HL Type here to search o 22C 05 VIEW VIEW Tell me what you want to do X cut Copy Times New Roman - 14 A A ab Wrap Text General Paste BIU 1 UV A d Merge & Center Format Painter 9% 000 Insert Delete Form Conditional Format as Cell Formatting Table Styles Clipboard 15 Font Alignment 5 Number 6 Styles Cells G23 x & fr D F G 57.79 RESEARCH, IT & DEVELOPMENT@ 20% OF THE COMPUTER SALES **($288.95 MILLIONS X 20% = $57.79 MILLIONS). 05 DEPRECIATION & AMORTIZATION @ SAME AS WAS IN 2017 ES TOTAL OPERATING EXPENSES -8 OPERATING INCOME 251 $301.69 $267.45 9 INTEREST EXPENSE @ SAME AS WAS IN 2017 10 LOSS FROM WRITE DOWN OF GOODWILL 11 INET GAUN FROM SALE OF EQUIPIVINT AND LICENSES ($20-$10) 2 100 10 PRE-TAX INCOME 168.45 INCOME TAX @20% OF PRE-TAX INCOME 4 NET INCOME (LOSS) 33.691 is taken average of 5 years of income ta $134.76 Calculation of income tax 2013 2014 2015 Income $46.00 $85.50 $125.79 $$ Income tax 59.20 $17.10 $25.16 % of income ta 20.00% 20.00% 20.00% 7 3 3 0 2016 $180.68 $36.14 20.00% 2017 $271.74 $34 35 20 00 1 Average 20.00% 3 4 5 6 COVER PAGE SWOT RATIO ANALYSIS INVESTMENT PROPOSAL FORECAST INCOME STATEMENT 2018 CCA + Type here to search O Et 22C Po C Times New Roman - 14 ub Wrap Text General * Cut Copy Format Painter BE Paste BIU Merge & Center % Conditional Format as Cell Formatting Table Styles Insert Delete Clipboard Font Alignment Number Styles Cells G23 f D E E G H M 24 5 6 INCOME STATEMENT FOR THE YEAR ENDED DECEMBER 31, 2018 7 PARTICULARS Pro Forma s (SYMILLIONS 288.95 8 RAVENUE 9 COMPUTER $875.62 - $586.67) 10 PHONES ($875.62.50%) 11 SOFTWARE & GAMING ($875.62 17%) 12 437.81 $148.86 Reveme have increased by 10% from 2017 Revenue(S796.02). Consist of 50% from phones $875.62 and 17% of the Revenue from software and gaming. The balance Revenue is from computers 13 TOTAL REVENUE LESS: COST OF GOODS SOLD: 14 30% OF REVENUE 262.69 Cost of good sold in 2017 was 30% of revenue. However, in 2018 the same would encounter an increase of 2% due to an increase in material cost, 1% due to depreciation in canadian dollars, 1% due to switching of material supplier and futher 1% to uncertainity surrounding NAFTA and trade tariffs, thereby resulting in an increase of 5% in COGS as compared to previous year hence the COGS is 35% of revenue 2% INCREASE IN COST OF GOODS SOLD DUE TO INCREASE IN MATERIAL COST 17.51 16 1% INCREASE IN COST OF GOODS SOLD DUE TO SWITCHING OF MATERIAL SUPPLIER 8.76 7 28 1% INCREASE IN COST OF GOODS SOLD DUE TO DEPRECIATING CANADIAN DOLLAR. 8.76 1% INCREASE IN COST OF GOODS SOLD DUE TO UNCERTAINTY AND TRADE TARIFFS COVER PAGE SWOT RATIO ANALYSIS INVESTMENT PROPOSAL FORECAST INCOME STATEMENT 2018 CCA Ready Type here to search O BI ? 22C Times New Roman 14 a Wiap Text General Paste Copy Es Format Painter EF Insert Dele BIU A EE Merge & Center S% % DO Conditional Format as Cell Formatting Table Styles Clipboard Font Alignment Number Styles Cell G23 : X fr B D E F G H K A LESS: COST OF GOODS SOLD: 14 262.69 30% OF REVENUE 15 2% INCREASE IN COST OF GOODS SOLD DUE TO INCREASE IN MATERIAL COST 16 1% INCREASE IN COST OF GOODS SOLD DUE TO SWITCHING OF MATERIAL SUPPLIER Cost of good sold in 2017 was 30% of revenue. However, in 2018 the same would encounter an increase of 2% due to an increase in material cost, 1% due to depreciation in canadian dollars, 1% due to switching of material supplier and futher 1% to uncertainity surrounding NAFTA and trade tariffs, thereby resulting in an increase of 5% in COGS as compared to previous year, hence, the COGS is 35% of revenue. 17.51 8.76 8.76 8.76 1% INCREASE IN COST OF GOODS SOLD DUE TO DEPRECIATING CANADIAN DOLLAR 18 1% INCREASE IN COST OF GOODS SOLD DUE TO UNCERTAINTY AND TRADE TARIFFS 19 20 GROSS PROFIT @65% OF REVENUE 21 LESS: OPERATING EXPENSES:- 22 ADVERTISING & MARKETING @10% OF REVENUE $306.48 $569.14 -S(10% X 87562) MILLIONS=$87.56 87.56 GENERAL & ADMINISTRATIVE @15% OF REVENUE **S(15% X 875.62) MILLIONS =$131 34 131 34 RESEARCH, IT & DEVELOPMENT 20% OF THE COMPUTER SALES **($288.95 MILLIONS X 20 = $57.79 MILLIONS) COVER PAGE SWOT RATIO ANALYSIS INVESTMENT PROPOSAL Ready 57.791 FORECAST INCOME STATEMENT 2018 CCA ... - HL Type here to search o 22C 05 VIEW VIEW Tell me what you want to do X cut Copy Times New Roman - 14 A A ab Wrap Text General Paste BIU 1 UV A d Merge & Center Format Painter 9% 000 Insert Delete Form Conditional Format as Cell Formatting Table Styles Clipboard 15 Font Alignment 5 Number 6 Styles Cells G23 x & fr D F G 57.79 RESEARCH, IT & DEVELOPMENT@ 20% OF THE COMPUTER SALES **($288.95 MILLIONS X 20% = $57.79 MILLIONS). 05 DEPRECIATION & AMORTIZATION @ SAME AS WAS IN 2017 ES TOTAL OPERATING EXPENSES -8 OPERATING INCOME 251 $301.69 $267.45 9 INTEREST EXPENSE @ SAME AS WAS IN 2017 10 LOSS FROM WRITE DOWN OF GOODWILL 11 INET GAUN FROM SALE OF EQUIPIVINT AND LICENSES ($20-$10) 2 100 10 PRE-TAX INCOME 168.45 INCOME TAX @20% OF PRE-TAX INCOME 4 NET INCOME (LOSS) 33.691 is taken average of 5 years of income ta $134.76 Calculation of income tax 2013 2014 2015 Income $46.00 $85.50 $125.79 $$ Income tax 59.20 $17.10 $25.16 % of income ta 20.00% 20.00% 20.00% 7 3 3 0 2016 $180.68 $36.14 20.00% 2017 $271.74 $34 35 20 00 1 Average 20.00% 3 4 5 6 COVER PAGE SWOT RATIO ANALYSIS INVESTMENT PROPOSAL FORECAST INCOME STATEMENT 2018 CCA + Type here to search O Et 22C Po C