Reference no: EM131443938
Business Finance Assignment: Memo to Management
Widget Ltd has developed a new cloud-based service for network managers called ViewAll that continually monitors a network and displays the results in a handy mobile dashboard. Over the past year, the company has paid $5 million to research and develop the technology underlying the software and service model. With research and development now complete, Widget's directors must decide the way forward. Macrosoft has offered to buy the patent rights to ViewAll from Widget. This sale would result in an immediate net cash flow of $15 million after taxes. In the past, Widget has usually taken up such offers. However, this time the Board of Directors wants to explore the viability of Widget running the ViewAll service itself, rather than selling it.
Last month, Widget paid an external consultant $200,000 for a demand analysis of the ViewAll service. The consultant recommended a five year life for the service because competition and technological change will likely render the service obsolete after that time. Revenue for the service will come in the form of subscriptions to users. Subscriptions are estimated as follows:
|
Year
|
Estimated subscription volume
|
|
1
|
150,000
|
|
2
|
200,000
|
|
3
|
220,000
|
|
4
|
200,000
|
|
5
|
120,000
|
In the first year, the price of a subscription will be $200 per annum and increase to $250 in the second year. Predicted competition in the market for the final three years of the project will necessitate maintaining the subscription price at the year 2 level. Variable service costs are estimated to be $40 per subscription for the entire life of the project. Additional fixed costs (excluding depreciation and marketing) for the project are predicted to be $10 million per year and project marketing costs will be $15 million per year.
Equipment costing $12 million will have to be purchased. Widget will depreciate this equipment for tax purposes using a prime cost rate of 20% per annum (applied to the equipment cost) and at the end of the project expects to be able to sell the equipment for $2 million.
Investment in net working capital will also be required. It is estimated that accounts receivable will be 10% of annual sales, while accounts payable will be 5% of total annual variable and fixed costs (excluding depreciation). Inventory will be negligible for the ViewAll service. The investment in net working capital will be required from the beginning of the project because credit sales and purchases will begin building up immediately. All accounts receivable will be collected and suppliers paid by the end of the project, thus the investment in net working capital will be returned by the end of the project's final year.
Widget's cost of capital is 10% and the company is subject to a 30% tax rate. Assume that tax is paid at the end of the year in which the income is received. The company is not eligible for any research and development tax deductions. During the project analysis period(s), Widget is expected to have other sources of taxable income.
Your Task
Your boss, Widget's CFO Diane Jones, has asked you to analyse the project and draft a memo to the Board of Directors providing recommendations, along with supporting analysis.
Diane has outlined three areas that you must cover in your memo:
1. Estimation of the project's base case NPV, with associated supporting detail;
2. Recommendation on the project based on the base-case analysis;
3. Recommendations on further analyses and factors that should be considered prior to making a final decision on ViewAll (but you do not have to undertake further analyses).
She has also asked that you structure your memo to begin with a (maximum) one page summary of your method, key findings and recommendations, supported by no more than three additional pages showing input assumptions, estimated cash flows and supplementary analysis detail and discussion.
Table format for presenting numerical analyses is preferable. Ensure that readers will be able to easily follow what you have done. You may wish to use footnotes under tables that clarify calculations, details and/or assumptions where this is not clear from the table itself.
|
Customers wait on average before being processed
: Currently customers come in at the rate of 4 per hour and are processed at a similar rate. On average 8 cars are waiting to be processed, 4 needing routine repairs and 4 needing major repairs. People are served on a first come first serve basis. (..
|
|
Which condition has the highest frequency
: You analyzed a pre-intervention elementary school asthma database from the perspective of a public health informatician. This week, you will review the data set in more detail and discuss the tools informaticians use. For the asthma data summary, ..
|
|
Of the various sales and operations planning options
: Of the various sales and operations planning options, which do you think is the best approach? Why? Provide an example supporting your selection.
|
|
Conduct a non-intrusive breaching experiment
: Conduct a non-intrusive "breaching experiment", wherein you attempt to validate the existence of a particular norm. This may include singing on the bus, singing in an elevator, not talking to anyone for a day, or any other informally deviant activ..
|
|
Analyse the project and draft a memo
: ACC00152 Business Finance Assignment: Memo to Management. Your boss, Widget's CFO Diane Jones, has asked you to analyse the project and draft a memo to the Board of Directors providing recommendations, along with supporting analysis
|
|
What costume design tells the viewer about that character
: Like sets and lights, costume design not only helps to tell the story, but also gives us insight into the individual characters (without them ever having to speak). A character's costume may indicate gender, position and status, occupation, occas..
|
|
Pick one of the reimbursement arrangements
: Pick one of the reimbursement arrangements discussed in this week's reading and discuss ONE advantage and ONE disadvantage.
|
|
What was the function of the spanish inquisition
: What was the function of the Spanish Inquisition? What conflicts or flaws within its intent might you identify when examining it though a contemporary perspective?Compare and contrast the Baroque style found In the Netherlands in contrast to that f..
|
|
Generate a linear regression equation
: 1. Xun Co. sells umbrellas in three cities. Management wants to generate a linear regression equation to use sales to predict future investment in advertisement. Given the data below,
|