Lock Limited is an Australian listed company (hypothetical) that designs door and window hardware and sells its designs to othercompanies. The company's Board of Directorsis under mountingpressure from shareholders to improve performance outcomes. Share pricesand dividends are shown in Table 1, while Table 2 provides market index data. In each table, the year end is December. Other capital marketinformation at the present time is presented in Table 3.

Table 1: Lock Limitedshare price and dividend history

Year	Closing shareprice ($)	Dividend per share($)
2017	8.21	n.a.
2018	6.83	0.10
2019	8.55	0.12
2020	9.20	0.12
2021	10.38	0.12
2022	9.64	0.12

Table 2: Marketindex history (All Ordinaries index)

Year	Closing price index (points)	Closing accumulated index (points)
2017	6167.29	60007.77
2018	5709.44	57887.91
2019	6802.40	71813.87
2020	6850.61	74424.55
2021	7779.21	87626.08
2022	7221.69	85033.52

Source: S&P Global

Table 3: Currentcapital market information

YTM on 10-year Australian government bonds:	4.00%
Long-term average marketrisk premium	6.00%
Beta:
Lock Limited1	1.25
Industry	1.10

¹ Based on a more complete data set than shown in Tables 1 and 2.

Lock uses no debt and so estimates its cost of capital with the expectedreturn on its shares calculated using CAPM. Company policy specifies use of the cost of capital for project evaluation.

Lock's latest windowlock design

Lock has spent $500,000 over the past six months developing a new window lock design, which the company has now patented. Last week, Lock received an offer from Global Corporation Limited to license the design patent for five years. Global would pay a $1 million licensing fee per year, payable at the end of each year. If Lock was to accept this offer, it would need to spend $200,000 immediately on legal and administrative costs it would not otherwiseincur.

In the past, Lock has not manufactured and sold products itself, instead selling or licensing its design patents to other companies, like Global Corporation. Nevertheless, for this design, Lock has beeninvestigating if they should manufacture and sell the lock themselves. So far, this investigation has involved hiringan external consulting firm to provideLock with a production and sales plan. Lock paid

$250,000 upon receiving the plan two weeks ago.

Based on expected competitive conditions, the consultant's plan recommends only a five-year period for manufacturing and selling the window lock. The plan forecasts annualsales volume of 50,000 unitsin the first year of the project and this is expected to grow by 10% in year two, and fall by 20% per year in each remaining year. The consultants recommend a selling price of $195 per unit.

In terms of operatingcost estimates, the product's cost of goods sold will be 50% of sales revenue and selling, general and administrative expenses (excluding depreciation) will be $1.5 million in the first year and increase by 4% per year thereafter. Lock's Operations Manager has considered various locations where product manufacturing might take place. Her recommendation is the use of factory space Lock owns but currently rents for $300,000 per year to another business.

Equipment will have to be purchased before manufacturing of the product can commence. Quotes indicate this will cost $3 million. The equipment will be depreciated at a prime cost rate of 15% per annum for tax purposes and be sold at the end of the last year of the project for an expected $2 million. Lock will also need to invest in net working capital. The balance of net working capital will need to be 25% of each upcoming year's sales and reduced to zero at the end of the project.

Lock pays income tax at a rate of 30%. For project analysis purposes, assume all taxes are paid (credited) at the end of the year to which they relate and Lock is not eligible for any research and development tax deductions.

Your tasks: (1) Evaluate the firm's risk and return measures compared to the market, and (2) Evaluate projects and make recommendations. All project decision criteria metrics taught in this unit should be calculated. You will also provide a spreadsheet to back up the numbers in the document.