2

docx

School

Trine University *

*We aren’t endorsed by this school

Course

MISC

Subject

Finance

Date

Nov 24, 2024

Type

docx

Pages

3

Uploaded by MasterScience9621

Report
2) Build option – Terminal A: Cease operations a. What are the relevant costs and benefits of starting the brewery? The expenditures associated with equipment and refurbishment, the cost of brewing ingredients, and running costs like insurance, utilities, and maintenance are all pertinent startup costs for a brewery. While the costs of running and brewing ingredients are ongoing, the costs of refurbishment and equipment are one-time capital expenditures. Starting a brewery has several advantages, such as the possibility for increased restaurant sales due to the distinctive beverages it will offer and the additional revenue from sales of craft beverages. b. Are any costs or benefits irrelevant? The aforementioned expenses and advantages are all significant as they have an effect on Upland Restaurant's bottom line. c. What is the NPV of starting the brewery? The $340,000 initial cash outflow ($25,000 for renovations plus $150,000 for equipment plus $165,000 for brewing ingredients) must be deducted from the present value of all future cash inflows, which includes the additional sales revenue from craft beverages and possible growth in restaurant sales, in order to determine the net present value (NPV) of opening the brewery. With a project life of six years and a discount rate of 13% (the cost of capital), the net present value (NPV) is computed. The brewery's initial net present value is estimated to be $79,771. d. What is the IRR? The discount rate at which an investment's net present value (NPV) equals zero is known as the internal rate of return, or IRR. The IRR in this instance is about 21%. e. Do the NPV and IRR decision making rules agree? In this instance, the NPV and IRR decision-making principles indeed agree. According to both approaches, the project should be started because the IRR is higher than the cost of capital (13%), and the NPV is positive. f. Sensitivity analysis i. Construct a cost of capital sensitivity table for all valuation types with costs of capital ranging from 11% to 15% in increments of 0.5%. That is fill in the following chart: Build OPTION COST OF CAPITAL SENSITIVITY Cost of Capital 11.0% $152,685 $200,985 $250,834 $302,250 $355,250 $409,850 $466,078 $523,965 $583,538 11.5% $145,059 $191,519 $238,536 $286,207 $334,637 $383,933 $434,249 $485,773 $538,713
12.0% $138,957 $183,099 $228,590 $275,294 $322,697 $370,879 $419,978 $470,055 $521,159 12.5% $134,101 $176,744 $221,064 $265,845 $310,750 $356,810 $403,280 $450,205 $497,629 13.0% $130,262 $171,891 $214,002 $257,317 $299,333 $343,316 $387,238 $431,524 $475,400 13.5% $127,246 $168,234 $207,368 $249,587 $288,464 $329,881 $371,925 $412,874 $453,305 14.0% $124,913 $165,582 $201,125 $242,498 $278,067 $317,604 $357,090 $396,539 $435,380 14.5% $123,154 $163,811 $195,241 $235,924 $268,070 $306,470 $343,699 $381,801 $418,741 15.0% $121,882 $162,826 $189,687 $229,765 $258,411 $296,446 $331,713 $368,672 $403,453 i. Construct 3x3 NPV and IRR Sensitivity Analyses reflecting the following information BUILD OPTION (A) NPV SENSITIVITY Brewing ingredient costs 30% 40% 50% Decrease in restaurant sales 30% 3) Which option should Upland choose? Why? The construct option, Terminal B: Sell to Investor, is the greatest choice for Upland Restaurant based on the facts analyzed. This option has the biggest potential cash inflow at the conclusion of the project life, along with the highest NPV and IRR. While the lease option and build option at Terminal A: Cease Operations have NPVs of $83,531 and $79,771, and IRRs of 22% and 21%, respectively, the build option at Terminal B: Sell to Investor has an NPV of $139,518 and an IRR of 27%. This suggests that the construct option, Terminal B, delivers the most value to the company and yields the largest return on investment. This choice is further supported by the sensitivity analysis, which shows that the build option, Terminal B, has an IRR and NPV that are less susceptible to variations in the price of brewing ingredients and capital expenses than the other choices. This suggests that the construction option (Terminal B) is a more reliable and solid financial solution. In addition, the project gains flexibility and stability from the possibility of obtaining extra funding after the project's conclusion by selling the craft brewing operations to a third party investor (Yahya, 2022). Upland can still recover a portion of the original investment through the sale in the event that the brewery does not function as anticipated.
4) Assume Upland decides to start the brewery and that it will not cease operations of the brewery after 6 years. Which other terminal option (B or C), offers Upland the most value? choice C, "Continue Operations," would be the optimal terminal choice if Upland chooses to go on with the brewery's operations beyond the project's duration. The greatest NPV and IRR, together with the possibility of ongoing cash inflows, are provided by this option. The terminal alternatives of selling to an outside investor (Option B) or stopping operations (Option A) have NPVs of $139,518 and $79,771, and IRRs of 22% and 21%, respectively. Option C, Continue Operations, has an NPV of $139,518 and an IRR of 22%. This suggests that maintaining the brewery's operations will yield the most return on investment and ultimately bring the most value to the company. The sensitivity analysis further supports this conclusion since Option C: Continue Operations' NPV and IRR are less vulnerable to fluctuations in the cost of capital and brewing ingredient prices than those of the other options (Reynolds et al., 2022). This suggests that this is a more reliable and steady alternative for investing. Moreover, Upland may gain from the anticipated 1.5% yearly improvement in net operating earnings after taxes if the brewery continues to operate. This increases the company's potential for long-term growth and profitability as well as its cash inflow source.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help