question archive On January 1, 20Y2, the controller of Omicron Inc
On January 1, 20Y2, the controller of Omicron Inc
Subject:AccountingPrice:3.86 Bought7
On January 1, 20Y2, the controller of Omicron Inc. is planning capital expenditures for the years 20Y2-20Y5. The following interviews helped the controller collect the necessary information for the capital expenditures budget:
Director of Facilities: A construction contract was signed in late 20Y1 for the construction of a new factory building at a contract cost of $10,000,000. The construction is scheduled to begin in 20Y2 and be completed in 20Y3.
Vice President of Manufacturing: Once the new factory building is finished, we plan to purchase $1.5 million in equipment in late 20Y3. I expect that an additional $200,000 will be needed early in the following year (20Y4) to test and install the equipment before we can begin production. If sales continue to grow, I expect we'll need to invest another $1,000,000 in equipment in 20Y5.
Chief Operating Officer: We have really been growing lately. I wouldn't be surprised if we need to expand the size of our new factory building in 20Y5 by at least 35%. Fortunately, we expect inflation to have minimal impact on construction costs over the next four years. In addition, I would expect the cost of the expansion to be proportional to the size of the expansion.
Director of Information Systems: We need to upgrade our information systems to wireless network technology. It doesn't make sense for this do be done until after the new factory building is completed and producing product. During 20Y4, once the factory is up and running, we should equip the whole facility with wireless technology. I think it would cost us $800,000 today to install the technology. However, prices have been dropping by 25% per year, so it should be less expensive at a later date.
Chief Financial Officer: I am excited about our long-term prospects. My only short-term concern is managing our cash flow while we expend the $4,000,000 of construction costs on the portion of the new factory building scheduled to be completed in 20Y2.
Use this interview information for creating a capital expenditures budget for Omicron Inc. for the years 20Y2-20Y5. Enter all amounts as positive numbers.
Omicron Inc.
Capital Expenditures Budget
For the Four Years Ending December 31,
Building 20Y2 $?, 20Y3 $?, 20Y5 $?
Equipement 20Y3 $?, 20Y4 $?, 20Y5 $?
Information systems 20Y4 $?
Purchase A New Answer
Custom new solution created by our subject matter experts
GET A QUOTE
Answer Preview
Capital expenditure budget:
This budget helps the organization estimates the cash outflows on investments.
The investment can include equipment, building and technology.
Preparation of capital expenditure budget:
Required to consider while preparing the capital expenditure budget
There is a plan of purchasing an equipment for $1.5 million in 20Y3, additional equipment will be purchased in 20Y4 of $200,000 and by the year 20Y5 it is expected to invest in $1 million in equipment.
In the year 20Y5, the building is evaluated calculating 35% of $1 million. In the year 20Y2 $4 million will be spend on the portion of the new factory building.
Installing an information technology will cost $800,000 today but its price will drop down by 25% each year and it will be installed in the year 20Y4.
The following "Table 1" shows the calculations used in excel while preparing the capital expenditure budget:
The outcomes of "Table 1" are shown in "Table 2"
Please see the attached file for the complete solution
