Question
Jenny Hewes, a newly appointed assistant to the financial manager of the Smart Devises division of Freedom Communication, was asked to prepare a capital budgeting
Jenny Hewes, a newly appointed assistant to the financial manager of the Smart Devises division of Freedom Communication, was asked to prepare a capital budgeting report to introduce a new line of smartphones with flexible screens. The new plants and equipment constructed today is $30 million and has a five years life. The company used straight-line depreciation and the market value of the plant and equipment are estimated to be $15 million. The division planned to sell the plants and equipment when the project is ended. According to the previous projects, the companys working capital is usually 20% of its sales and could be fully recovered. There is another old production line which annual sales is 40 million. Freedom Communication is not the only innovator among smart phone manufacturer. The market has more new entrants and Freedom must adjust its strategy to survive in the competitive environment.
From Jennys report, the new line costs $46 million and promises a 37% internal rate of return. She has recommended to accept the project.
Jenny was confident with the report but when she presented to the manager, it was attacked from all sides. Jenny was surprised and she needed to revise the report in one day. Can you help Jenny to correct her work and give her some advices on how to improve a capital budgeting report? (Note the question is an open ending question, you may not have specific data in some analytical parts, give comments and examples)
Below is Jennys capital budgeting report:
| Year | |||||
| 0 | 1 | 2 | 3 | 4 | 5 |
Plant and equipment | $(30) |
|
|
|
| $15 |
Increased working capital | (14) |
|
|
|
|
|
Preliminary engineering | (2) |
|
|
|
|
|
Excess capacity | 0 |
|
|
|
|
|
Total investment | $(46) |
|
|
|
|
|
Total salvage value |
|
|
|
|
| $15 |
Sales |
| $60 | $82 | $140 | $157 | $120 |
Cost of sales |
| 26 | 35 | 60 | 68 | 52 |
Gross profit |
| 34 | 47 | 80 | 89 | 68 |
Interest expense |
| 5 | 4 | 4 | 3 | 3 |
Allocated expenses |
| 0 | 0 | 0 | 0 | 0 |
Selling and administrative expenses |
| 10 | 13 | 22 | 25 | 19 |
Total operating expenses |
| 14 | 17 | 26 | 28 | 22 |
Operating income |
| 20 | 29 | 54 | 61 | 46 |
Depreciation |
| 3 | 3 | 3 | 3 | 3 |
Income before tax |
| 17 | 26 | 51 | 58 | 43 |
Tax at 40% |
| 7 | 11 | 20 | 23 | 17 |
Income after Tax |
| $10 | $16 | $30 | $35 | $26 |
Operating Cash Flows | $(46) | $10 | $16 | $30 | $35 | $26 |
Net Present Value @15% | $35 |
|
|
|
|
|
Profit Index | 1.76 |
|
|
|
|
|
Internal Rate of Return | 37% |
|
|
|
|
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started