Concept explainers
a.
Interpretation: Initial capital outlay, cash flows after tax and terminal cash flow of this project needs to be computed.
Concept introduction:Capital Budgeting technique is the most useful tool for
b.
Interpretation:
Concept introduction: Capital Budgeting technique is the most useful tool for financial management which helps to understand the investment in project is financially viable or not.
Payback period 0.84
Discounted Payback period 0.9299
NPV $1,883,164
PI 3.8044
IRR 119%
MIRR 52%
Payback period: It is the period in which cash flow of investment covers the initial investment. It can be computed shown below:
Discounted payback period: It is the period in which discounted cash flow of investment covers the initial investment. It can be computed shown below:
Net present value: NPV is the sum of present value of the cash flows and initial investment when discounted at 11%. It can be computed as:
Profitability Index: It is used to analyze the profitability of an investment wherein its cash flow is divided by the initial investment It can be computed as:
IRR& MIRR:
The formula used to compute IRR and MIRR is as follows:
c.
Interpretation: A scenario analysis is required.
Concept introduction: Capital Budgeting technique is the most useful tool for financial management which helps to understand the investment in project is financially viable or not.
1. Click on “Data” menu and select “scenario Manager” under “what if Analysis” option, then click on “add” option.Then rename the scenario name and select changing cells which need to replace.
2. Enter values which need to be resulted in that scenario, accordingly.
3. Then click on “summary” option to get the various scenario analysis.
4. Scenario Analysis will represent the final output in given scenario.
c.
Interpretation: A scenario analysis is required.
Concept introduction: Capital Budgeting technique is the most useful tool for financial management which helps to understand the investment in project is financially viable or not.
Want to see the full answer?
Check out a sample textbook solutionChapter 12 Solutions
EBK 3N3-EBK: FINANCIAL ANALYSIS WITH MI
- Shelby Industries has a capacity to produce 45.000 oak shelves per year and is currently selling 40,000 shelves for $32 each. Martin Hardwoods has approached Shelby about buying 1,200 shelves for a new project and is willing to pay $26 each. The shelves can be packaged in bulk; this saves Shelby $1.50 per shelf compared to the normal packaging cost. Shelves have a unit variable cost of $27 with fixed costs of $350,000. Because the shelves dont require packaging, the unit variable costs for the special order will drop from $27 per shelf to $25.50 per shelf. Shelby has enough idle capacity to accept the contract. What is the minimum price per shelf that Shelby should accept for this special order?arrow_forwardHudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing, or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? What is the expected annual cost associated with that recommendation? Construct a risk profile for the optimal decision in part (a). What is the probability of the cost exceeding $700,000?arrow_forwardScrooge McDuck Safe Limited is considering buying the hinges it uses in the manufacture of vaults from an outside vendor. Currently, Scrooge McDuck Safe Limited makes the hinges in its own manufacturing facility. Scrooge McDuck Safe Limited can buy the hinges for $1.50 each. The company uses 900,000 hinges each year. Fixed cost for Scrooge McDuck Safe Limited would not change if the company stopped making the hinges. Information about Scrooge McDuck Safe Limited's cost to manufacture the 900,000 casters follows: Per Unit $.50 .10 Total Direct material $450,000 90,000 360,000 225.000 $1,125,000 Direct labor Variable overhead Fixed overhead Total .40 25 $1.25 Required: A. Prepare a relevant cost schedule that indicates whether Scrooge McDuck Safe Limited should buy the hinges or continue to make them. B. If Scrooge purchased the hinges, management has approached you that a dial producer wishes to rent the vacant space for $150,000 to produce their dials. Does this change your decision??…arrow_forward
- Midtown Soup Kitchen would like to provide meals in a new location. The initial study shows that the fixed costs, including the rent, equipment, and personnel costs, are $50,000 per month. The facility can serve 1,000 meals per day 30 days a month, and there is more demand than the kitchen can supply. The variable cost is the food cost, which is approximately $2.00 per meal, and the city is willing to support the project. You are preparing a budget application to the city. How much support will you need from the city to make this project break even for your nonprofit financially?arrow_forwardVijayarrow_forwardA large food-processing corporation is considering using laser technology to speed up and eliminate waste in the potato-peeling process. To implement the system, the company anticipates needing $3.5 million to purchase the industrial-strength lasers. The system will save $1,550,000 per year in labor and materials. However, it will require an additional operating and maintenance cost of $350,000. Annual income taxes will also increase by $150,000. The system is expected to have a 10-year service life and will have a salvage value of about $200,000. If the company's MARR is 18%, use the NPW method to justify the project. Click the icon to view the interest factors for discrete compounding when MARR = 18% per year. The NPW of the project is $ thousand. (Round to the nearest whole number.) X More Info Single Payment Compound Amount Equal Payment Series Sinking Fund Factor Compound Amount Factor (F/A, i, N) Present Worth Factor Factor (F/P, i, N) (A/F, i, N) (P/A, i, N) 1.1800 1.0000 1.0000…arrow_forward
- A large food-processing corporation is considering using laser technology to speed up and eliminate waste in the potato-peeling process. To implement the system, the company anticipates needing $3.5 million to purchase the industrial-strength lasers. The system will save $1,550,000 per year in labor and materials. However, it will require an additional operating and maintenance cost of $350,000. Annual income taxes will also increase by $150,000. The system is expected to have a 10-year service life and will have a salvage value of about $200,000. If the company's MARR is 18%, use the NPW method to justify the project. Equal Payment Series Sinking Present Compound Amount Factor Fund Single Payment Compound Present Amount Worth Factor (F/P, i, N) 1.1800 Worth Capital Recovery Factor Factor Factor Factor N (P/F, i, N) (F/A, i, N) (A/F, i, N) (P/A, i, N) (A/P, i, N) 1 0.8475 1.0000 1.0000 0.8475 1.1800 2 1.3924 0.7182 2.1800 0.4587 1.5656 0.6387 3 1.6430 0.6086 3.5724 0.2799 2.1743 0.4599…arrow_forwardTwo alternative locations are under consideration for a new plant: Jackson, Mississippi, and Dayton, Ohio. The Jackson location is superior in terms of costs. However, management believes that sales volume would decline if this location were chosen because it is farther from the market, and the firm's customers prefer local suppliers. The selling price of the product is $350 per unit in either case. Use the following information to determine which location yields the higher total profit per year: Location Jackson Dayton The annual profit from Jackson is $ Annual Fixed Cost $2,100,000 $3,000,000 Variable Cost per Unit 45 $95 Forecasted Demand per Year 35,000 units 39,000 units (Enter your response as an integer.) ..arrow_forwardShue Music Company is considering the sale of a new sound board used in recording studios. The new board would sell for $24,700, and the company expects to sell 1,640 per year. The company currently sells 1,990 units of its existing model per year. If the new model is introduced, sales of the existing model will fall to 1,660 units per year. The old board retails for $23,100. Variable costs are 53 percent of sales, depreciation on the equipment to produce the new board will be $1,035,000 per year, and fixed costs are $3,250,000 per year. If the tax rate is 24 percent, what is the annual OCF for the project? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. OCFarrow_forward
- Rolston Music Company is considering the sale of a new sound board used in recording studios. The new board would sell for $27,300, and the company expects to sell 1,580 per year. The company currently sells 2,080 units of its existing model per year. If the new model is introduced, sales of the existing model will fall to 1,900 units per year. The old board retails for $23,200. Variable costs for both boards are 54 percent of sales, depreciation on the equipment to produce the new board will be $1,530,000 per year, and fixed costs are $1,430,000 per year. If the tax rate is 34 percent, what is the annual OCF for the project? (Do not round intermediate calculations and round your answer to the nearest whole dollar amount, e.g., 32.)arrow_forwardBaghibenarrow_forwardMesa Cheese Company has developed a new cheese slicer called Slim Slicer. The company plans to sell this slicer through its catalog, which it issues monthly. Given market research, Mesa believes that it can charge $30 for the Slim Slicer. Prototypes of the Slim Slicer, however, are costing $31. By using cheaper materials and gaining efficiencies in mass production, Mesa believes it can reduce Slim Slicer's cost substantially. Mesa wishes to earn a return of 40% of the selling price. (a) Compute the target cost for the Slim Slicer. Target cost $arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning