Differential analysis report involving opportunity costs
On March 1, Midway Distribution Company is considering leasing a building and buying the necessary equipment to operate a public warehouse. Alternatively, the company could use the funds to invest in $750,000of 7% U.S. Treasury bonds that mature in 14 years. The bonds could be purchased at face value. The following data have been assembled: Cost of equipment $750,000
Life of equipment 14 years
Estimated residual value of equipment $76,000 Yearly costs to operate the warehouse, excluding depreciation of equipment $195,000 Yearly expected revenues—years 1–7 $330,000
Yearly expected revenues—years 8–14 $280,000
Instructions:
1. Prepare a report as of March 1, 2010, presenting a differential analysis of the proposed operation of the warehouse for the 14 years as compared with present conditions.
2. Based on the results disclosed by the differential analysis, should the proposal be accepted?
3. If the proposal is accepted, what is the total estimated income from operations of the warehouse for the 14 years?
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 2 images
- Required information A potential investment has a cost of $380,000 and a useful life of 6 years. Annual cash sales from the investment are expected to be $267,382 and annual cash operating expenses are expected to be $105,332. The expected salvage value at the end of the investment's life is $40,000. The company has a before-tax discount rate of 15%. Required: Calculate the following. (Round dollar amounts to the nearest whole dollar and IRR to one decimal place (i.e. .055 = 5.5%). Enter negative amounts with a minus sign.) Annual PMT of the investment FV of the investment NPV of the investment IRR of the investment $ 162050 GA 69 40000arrow_forwardOn October 1, Midway Distribution Company is considering leasing a building and purchasing the necessary equipment to operate a retail store. Alternatively, the company could use the funds to invest in $150,400 of 5% U.S. Treasury bonds that mature in 16 years. The bonds could be purchased at face value. The following data have been assembled: Cost of store equipment $150,400 Life of store equipment 16 years Estimated residual value of store equipment $19,000 Yearly costs to operate the store, excluding depreciation of store equipment $56,900 Yearly expected revenues—years 1-8 $74,100 Yearly expected revenues—years 9-16 $70,800 Required: Question Content Area 1. Prepare a differential analysis as of October 1 to determine whether to Operate Retail Store (Alternative 1) or Invest in Bonds (Alternative 2). If an amount is zero, enter zero "0". For those boxes in which you must enter subtracted or negative numbers use a minus sign. Differential…arrow_forwardDifferential Analysis Involving Opportunity Costs On July 1, Matrix Stores Inc. is considering leasing a building and buying the necessary equipment to operate a public warehouse. Alternatively, the company could use the funds to invest in $149,800 of 6% U.S. Treasury bonds that mature in 16 years. The bonds could be purchased at face value. The following data have been assembled: Cost of store equipment $149,800 Life of store equipment 16 years Estimated residual value of store equipment $17,800 Yearly costs to operate the warehouse, excluding depreciation of equipment $55,600 Yearly expected revenues—years 1-8 74,600 Yearly expected revenues—years 9-16 70,200 Required: 1. Prepare a differential analysis as of July 1 presenting the proposed operation of the warehouse for the 16 years (Alternative 1) as compared with investing in U.S. Treasury bonds (Alternative 2). If an amount is zero, enter "0". If required, use a minus sign to indicate a loss.…arrow_forward
- Net Present Value Method for a Service Company Coast-to-Coast Inc. is considering the purchase of an additional delivery vehicle for $46,000 on January 1, 20Y1. The truck is expected to have a five-year life with an expected residual value of $7,000 at the end of five years. The expected additional revenues from the added delivery capacity are anticipated to be $61,000 per year for each of the next five years. A driver will cost $41,000 in 20Y1, with an expected annual salary increase of $3,000 for each year thereafter. The annual operating costs for the truck are estimated to be $2,000 per year. Present Value of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 0.890 0.826 0.797 0.756 0.694 3 0.840 0.751 0.712 0.658 0.579 4 0.792 0.683 0.636 0.572 0.482 0.747 0.621 0.567 0.497 0.402 6 0.705 0.564 0.507 0.432 0.335 0.665 0.513 0.452 0.376 0.279 8 0.627 0.467 0.404 0.327 0.233 0.592 0.424 0.361 0.284 0.194 10 0.558 0.386 0.322 0.247 0.162 a. Determine the…arrow_forwardA company is planning to purchase a machine that will cost $39,552, have a six-year life, and will have no salvage value. The company expects to sell the machine's output of 3,000 units evenly throughout each year. A projected income statement for each year of the asset's life appears below. What is the payback period for this machine? $ 144,000 Sales Costs: Manufacturing Depreciation on machine Selling and administrative expenses Income Multiple Choice 6.18 years. 12 36 veare $ 86,400 4,000 48,000 (138,400) $ 5,600arrow_forwardRequired information A potential investment has a cost of $395,000 and a useful life of 5 years. Annual cash sales from the investment are expected to be $255,338 and annual cash operating expenses are expected to be $100,588. The expected salvage value at the end of the investment's life is $50,000. The company has a before-tax discount rate of 17%. Required: Calculate the following. (Round dollar amounts to the nearest whole dollar and IRR to one decimal place (i.e. .055 = 5.5%). Enter negative amounts with a minus sign.) Annual PMT of the investment FV of the investment NPV of the investment IRR of the investment 0000 $arrow_forward
- Differential Analysis Involving Opportunity Costs On July 1, Midway Distribution Company is considering leasing a building and buying the necessary equipment to operate a public warehouse. Alternatively, the company could use the funds to invest in $150,400 of 6% U.S. Treasury bonds that mature in 16 years. The bonds could be purchased at face value. The following data have been assembled: Cost of store equipment $150,400 Life of store equipment 16 years Estimated residual value of store equipment $18,900 Yearly costs to operate the warehouse, excluding depreciation of equipment depreciation of store equipment $56,200 Yearly expected revenues—years 1-8 74,600 Yearly expected revenues—years 9-16 70,500 Required: 1. Prepare a differential analysis as of July 1 presenting the proposed operation of the warehouse for the 16 years (Alternative 1) as compared with investing in U.S. Treasury bonds (Alternative 2). If an amount is zero, enter "0". For those boxes…arrow_forwardplease answer in text form and in proper format answer with must explanation , calculation for each part and steps clearlyarrow_forwardGodoarrow_forward
- Required information [The following information applies to the questions displayed below.] Cardinal Company is considering a five-year project that would require a $2,800,000 investment in equipment with a useful life of five years and no salvage value. The company's discount rate is 14%. The project would provide net operating income in each of five years as follows: Sales Variable expenses Contribution margin $ 2,845,000 1,109,000 1,736,000 Fixed expenses: Advertising, salaries, and other fixed out-of-pocket costs $ 799,000 Depreciation 560,000 Total fixed expenses 1,359,000 $ 377,000 Net operating income Click here to view Exhibit 7B-1 and Exhibit 7B-2, to determine the appropriate discount factor(s) using table. 6. What is the project's internal rate of return? Project's internal rate of return %arrow_forwardA factory manager is considering the purchase of one of the following two production equipment. Cash flow estimates for equipment A are in year-zoro dollars while those of equipment B are in actual dollars Equipment A (year-zero S) Equipment B (actual $) $1,200 Initial investment $9,500 Net annual revenue $3.000 $4,000 $0 Market value at end of useful life Useful ife, years 11 11 The manager uses a market interest rate of 12% per year. If inflation rate is expected to average 5.66% per year over the next several years, determine the PW of each equipment. 1. The PW of Equipment A is OA. S14,161 OB. $14,578 OC. $12,500 OD. $0,313 2. The PW of Equipment B is O A. $20,347 OB. S15,200 OC. $20,903 OD. $12,651arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education