Answered step by step
Verified Expert Solution
Question
1 Approved Answer
NPV Profile Discount Rate ( % ) BRIGHT RAY Limited is an automation firm that invests much in research and development ( R&D ) before
NPV Profile
Discount Rate
BRIGHT RAY Limited is an automation firm that invests much in research and development R&D before releasing a new equipment, which is typically designed to save employees time. BRIGHT RAY Limited serves the manufacturing industry as a supplier. BRIGHT RAY recently spent $ developing BR an autonomous food preparation system. However, a few random test runs revealed that BR is not yet marketready because it has difficulty distinguishing residue from fine output. Such uncommon failures need a long restart time. During the reset phase, companies that purchase and install BR may lose a significant amount of output. Nonetheless, given the level of rivalry, BRIGHT RAY officials want to release the BR machine before any new competitors do
A local importer will sell BRIGHT RAY the equipment required to construct the plant that will manufacture machine BR for $ BRIGHT RAY Limited must pay an additional $ in installation fees. The plant's useful life would be five years, and it would be depreciated at a straightline rate of each year.
According to the marketing director at BRIGHT RAY Limited, units of the BR machine can be sold in the first year, with sales dropping by units each year for the remainder of the project. The projected price per unit is $ As long as at least units are produced each year, the variable cost of production is predicted to equal of sales revenue. The fixed costs of operating this factory would be $ per year.
BR will most likely require an initial inventory of $ Also, as sales increase, $ will be locked up in debtors accounts, but this will be substantially offset by a $ increase in accounts payable. The project management intends to maintain the same level of net working capital NWC throughout the project's duration. This indicates that there will be no fresh investments in NWC during the
project's lifetime. After four years, NWC will be recovered. The new plant will be located in a manufacturing space that is currently utilised for storage. This yields a net income of $ a month, however it will be discontinued due to the new plant. Additionally, when BRIGHT RAY sells machine BR its annual income from automation consulting fees will decrease by $ At the conclusion of this project, the plant would be transferred sold to another project for a price of $
If a firm purchases BRIGHT RAY's BR machine, it will eventually replace many of its unskilled and semiskilled employees with a few skilled ones in order to increase production efficiency. An Association
of Labour Unions is opposed to firms installing BR because it will result in many people losing their employment since they will be unable to do their duties. In response to the Association's worries,
BRIGHT RAY's management has identified another project that would manufacture semiautomatic machines BR and will require both semiskilled and skilled people. The initial total investment for this
BR project would exceed the cost of BR project by and the predicted future cash flows after all adjustments for this fiveyear project would be as follows:
Year: $; Year: $; Year: $; Year: $; Year: $
The company's weighted average cost of capital WACC which has fluctuated between and in recent years, is utilised to determine the required rate of return. Management has chosen to utilise both rates in evaluating this project. Companies are subject to a tax rate of Based on projections, the estimated payback period for BRIGHT RAY is years.
Prior to reaching a final decision during the upcoming meeting, the Managing Director MD of BRIGHT RAY Limited is seeking a comprehensive explanation of the key components of the BR project. The MD is requesting a formal report that includes a thorough analysis of cash flows and clear explanations of the results, utilising appropriate capital budgeting procedures commonly employed for project evaluation.
In addition, the MD is interested in examining the specific details of the comparison between the BR and BR projects. This analysis will involve evaluating the results of appropriate capital budgeting methods, considering both a and required rate, determining the crossover rate, and taking into account all relevant factors that can contribute to making a final decision. These findings will be presented in a separate section of the report.
Follow the picture of the template given to complete the cash flow tabel and write out all the formula for the calculation in excel. Thank you very much.
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