I need help with FIN-320 module 7 assignement. The scenario is listed below:
Financial Option 1: Purchase a $10 Million Building
Rationale for investment: The business is considering environmental, social, and corporate governance
(ESG) factors as part of its investment into a new building for its headquarters. The building itself will be
a Leadership in Energy and Environmental Design (LEED)-certified building, but the new site being
considered currently houses a large, inactive gas station that sold both gasoline and diesel fuel. The new
site also has a sizable repair facility left over that was used for deliveries and tractor-trailer trucks for
more than 50 years. While some restoration was performed on the site prior to the new building’s
construction, the previous owner ran out of funds before they were ever able to bring the site up to
LEED standards. Four large fuel tanks remain on the site, and they will also need to be addressed per
LEED standards.
Assumptions to consider:
$10 million cash purchase
Building generates additional net profits after tax of $1.25 million per year
20 year expected useful life of building
Salvage value: $1.5 million
Discount rate is 10%
Financial Option 2: Lease of $25 Million in Equipment
Rationale for investment: The business’s current equipment is efficient, but it uses a substantial amount
of electricity. Operating the production line also creates significant waste material, including waste
plastics. The business is looking into leasing newer, more environmentally friendly equipment that will
still allow it to be at least as efficient in production as it is now.
Assumptions to consider:
Annual cash flows generated with equipment: $4 million
Discount rate is 12%
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
- Attached is questions diagram, USE EXCEL AS ITS REQUIRED Question 10. Using the replacement chain method (machine B can be replaced with an identical machine at the end of year 3), determine which project should be adopted after tax. Pick the correct answer. Machine A Machine B Either machine Neither machinearrow_forwardUse the following information to answer questions 1 to 5. A development corporation purchased land that will be the site of a new luxury condominium complex. Management is considering a six month market research study designed to learn more about potential market acceptance of the condominium project. Management anticipates that, if conducted, the market research study will provide one of the following two results. 1. Favorable report (F): A significant number of the individuals contacted express interest in purchasing a condominium. 2. Unfavorable report (U): Very few of the individuals contacted express interest in purchasing a condo- minium. After deciding whether to conduct the market research study, they have the following two decision alternatives. d1 = a small complex with 30 condominiumsd2 = a medium complex with 60 condominiumsFollowing this, a chance event concerning the demand for the condominiums has two states of nature. s1 = strong demand for the condominiumss2 = weak…arrow_forwardRefer to Picture, Please answer Part A and Barrow_forward
- Your company is developing a new textbook for FIN 301 and you paid your current FIN 301 instructor $700,000 for his input about the feasibility of such a product. The project would involve initial capital investment of $1,200,000 and installation costs related to the capital expenditures of $600,000. The project would also necessitate an increase in net working capital of $200,000 at the beginning of the project. You can straight line depreciate any depreciable expenses to zero over the three-year life of the project, and you don't expect the capital investment to be sold at the end of the project. Each year, you estimate you will receive $3,000,000 in sales revenue from your awesome textbook. Variable product and selling costs associated with these sales are expected to be 40% of revenue in each of those years. The fixed costs in each of the three years of the project will be $500,000. The corporate tax rate is 40%. Calculate the total year 0 cash flows associated with the project. $…arrow_forwardThe investment committee of Granny’s Restaurants Inc. is evaluating two restaurant sites. The sites have different useful lives, but each requires an investment of $1,200,000. The estimated net cash flows from each site are as follows: Net Cash Flows Year Helena Butte 1 $375,000 $500,000 2 $375,000 $500,000 3 $375,000 $500,000 4 $375,000 $500,000 5 $375,000 6 $375,000 The committee has selected a rate of 20% for purposes of net present value analysis. It also estimates that the residual value at the end of each restaurant’s useful life is $0, but at the end of the fourth year, Helena’s residual value would be $500,000. Instructions: Using formulas/functions wherever available, complete the following on the Input tab… For each site, compute the net present value,…arrow_forwardPlease see image for question.arrow_forward
- Can some one please help me to answer each question correctly? please and thank you.arrow_forwardVishunuarrow_forwardAn electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some air pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would require an initial outlay of $240.20 million, and the expected cash inflows would be $80 million per year for 5 years. If the firm does Invest in mitigation, the annual inflows would be $84.06 million. Unemployment in the area where the plant would be built is high, and the plant would provide about 350 good jobs. The risk adjusted WACC is 19%. a. Calculate the NPV and IRR with mitigation. Enter your answer for NPV in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values, if any, should be indicated by a minus sign. Do not…arrow_forward
- Citco Company is considering investing up to $512,000 in a sustainability-enhancing project. Its managers have narrowed their choices to three potential projects. • Project A would redesign the production process to recycle raw materials waste back into the production cycle, saving on direct materials costs and reducing the amount of waste sent to the landfill. Project B would remodel an office building, utilizing solar panels and natural materials to create a more energy-efficient and healthy work environment. Project C would build a new training facility in an underserved community, providing jobs and economic security for the local community. Required: 1. Assuming the cost of capital is 12%, complete the table below by computing the payback period, NPV, profitability index, and internal rate of return. (Future Value of $1, Present Value of $1, Future Value Annuity of $1, Present Value Annuity of $1.) 2. Based strictly on the economic analysis, in which project should they invest?…arrow_forwardAn electric utility is considering a new power plant in northern Arizona. Power from the plant would be sold in the Phoenix area, where it is badly needed. Because the firm has received a permit, the plant would be legal; but it would cause some alr pollution. The company could spend an additional $40 million at Year 0 to mitigate the environmental problem, but it would not be required to do so. The plant without mitigation would require an initial outlay of $210.55 million, and the expected cash Inflows would be $70 million per year for 5 years. If the firm does Invest in mitigation, the annual inflows would be $75.20 million. Unemployment in the area where the plant would be built is high, and the plant would provide about 350 good jobs. The risk adjusted WACC is 19%. a. Calculate the NPV and IRR with mitigation. Enter your answer for NPV in millions. For example, an answer of $10,550,000 should be entered as 10.55. Negative values, if any, should be indicated by a minus sign. Do not…arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education