Differential Analysis Involving Opportunity Costs On July 1, Coastal Distribution Company is considering leasing a building and buying the necessary equipment to operate a public Alternatively, the company could use the funds to invest in $149,100 of 6% U.S. Treasury bonds that mature in 16 years. The bor at face value. The following data have been assembled: Cost of store equipment $149,100 Life of store equipment 16 years Estimated residual value of store equipment $18,600 Yearly costs to operate the warehouse, excluding depreciation of equipment $55,900 Yearly expected revenues-years 1-8 75,600 Yearly expected revenues-years 9-16 70,100 Required: 1. Prepare a differential analysis as of July 1 presenting the proposed operation of the warehouse for the 16 years (Alternative 1 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.

Differential Analysis Involving Opportunity Costs On July 1, Coastal Distribution Company is considering leasing a building and buying the necessary equipment to operate a public Alternatively, the company could use the funds to invest in $149,100 of 6% U.S. Treasury bonds that mature in 16 years. The bor at face value. The following data have been assembled: Cost of store equipment $149,100 Life of store equipment 16 years Estimated residual value of store equipment $18,600 Yearly costs to operate the warehouse, excluding depreciation of equipment $55,900 Yearly expected revenues-years 1-8 75,600 Yearly expected revenues-years 9-16 70,100 Required: 1. Prepare a differential analysis as of July 1 presenting the proposed operation of the warehouse for the 16 years (Alternative 1 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.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter26: Capital Budgeting (capbud)

Section: Chapter Questions

Problem 5R

See similar textbooks

Similar questions

Com/ilmn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator- der eBook < Average Rate of Return The following data are accumulated by Lone Peak Inc. in evaluating two competing capital investment proposals: 3D Printer Truck $32,000 9 years Amount of investment Useful life 3D Printer Estimated residual value Estimated total income over the useful life $8,640 Determine the expected average rate of return for each Truck Check My Work Show Me How % % $96,000 4 years 3 0 0 Print Item $10,080 proposal. If required, round your answers to one decimal place 0 M
A My Home * CengageNoWv2 | Online teachin X enow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator-&inpro.. *** Average Rate of Return, Cash Payback Period, Net Present Value Method for a Service Company Spanish Peaks Railroad Inc, is considering acquiring equipment at a cost of $215,000, The equipment has an estimated life of 10 years and no residual value. It is expected to provide yearly net cash flows of $43,000. The company's minimum desired rate of return for net present value analysis is 10%. Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1. 0.943 0.909 0.893 0.870 0.833 2 1.833 1.736 1.690 1.626 1.528 3 2.673 2.487 2.402 2.283 2.106 4 3.465 3.170 3.037 2.855 2.589 4.212 3.791 3.605 3.353 2.991 4.917 4.355 4.111 3.785 3.326 7. 5.582 4.868 4ర 4.160 3.605 6.210 5.335 4.968 4.487 3.837 6.802 5.759 5.328 4.772 4.031 6.145 5.650 5.019 4.192 10 7.360 Compute the following: a. The average rate of return, giving effect to…
MAIN PROJECT lums University is considering investing in an online book ordering and information service, which will be managed by 2 employees. The following estimates relate to the costs of starting the service and the subsequent revenues from it. The initial investment needed to start the service, including the installation of additional phone lines and computer equipment, will be $1,000,000. These investments are expected to have a life of 4 years with 0 salvage value.The investments will be depreciated straight line over the four-year life.The revenues in the first year are expected to be $1500,000, growing 20% in year 2, and 10% in the two years following.The salaries and other benefits for the employees are estimated to be $150,000 in year 1, and grow 10% a year for the following three years.The cost of the books is assumed to be “0.60” of the revenues in each of the four years.The non-cash working capital, which includes the inventory of books needed for the service and the…
Make a feasibility study for Virtual Reality In Education project by making the balance sheet, Project Cost and Financial Plan. The donor is a non-profit financial institution. The investment cost of the project is $500,000. land $100,000 Construction $100,000 Supplies and equipment $200,000 Stuff: 2 employees, 2 guards and 2 cleaners, working 8 hours, an annual salary of $100,000 The answer is only tables of the the balance sheet, Project Cost and Financial Plan.
A My Home X CengageNOWv2 |Online teachin X agenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inpro... to Dickerson Co. is evaluating a project requiring a capital expenditure of $810,000. The project has an estimated life of 4 years and no salvage value. The estimated net income and net cash flow from the project are as follows: Year Net Income Net Cash Flow 1. $75,000 $285,000 100,000 290,000 3 109,000 190,000 4 36,000 125,000 $320,000 $890,000 The company's minimum desired rate of return is 12%o. The present value of $1 at compound interest of 12% for 1, 2, 3, and 4 years is 0.893, 0.797, 0.712, and 0.636, respectively. Required: Determine the average rate of return on investment. Round your answer to one decimal place. Previous Next
MAIN PROJECT Iqra University is considering investing in an online book ordering and information service, which will be managed by 2 employees. The following estimates relate to the costs of starting the service and the subsequent revenues from it. The initial investment needed to start the service, including the installation of additional phone lines and computer equipment, will be $1,000,000. These investments are expected to have a life of 4 years with 0 salvage value. The investments will be depreciated straight line over the four-year life. The revenues in the first year are expected to be $1500,000, growing 20% in year 2, and 10% in the two years following. The salaries and other benefits for the employees are estimated to be $150,000 in year 1, and grow 10% a year for the following three years. The cost of the books is assumed to be “0.60” of the revenues in each of the four years. The non-cash working capital, which includes the inventory of books needed for the service and…
MAIN PROJECT Iqra University is considering investing in an online book ordering and information service, which will be managed by 2 employees. The following estimates relate to the costs of starting the service and the subsequent revenues from it. The initial investment needed to start the service, including the installation of additional phone lines and computer equipment, will be $1,000,000. These investments are expected to have a life of 4 years with 0 salvage value.The investments will be depreciated straight line over the four-year life.The revenues in the first year are expected to be $1500,000, growing 20% in year 2, and 10% in the two years following.The salaries and other benefits for the employees are estimated to be $150,000 in year 1, and grow 10% a year for the following three years.The cost of the books is assumed to be “0.60” of the revenues in each of the four years.The non-cash working capital, which includes the inventory of books needed for the service and the…
MAIN PROJECT Texas University is considering investing in an online book ordering and information service, which will be managed by 2 employees. The following estimates relate to the costs of starting the service and the subsequent revenues from it. The initial investment needed to start the service, including the installation of additional phone lines and computer equipment, will be $1,000,000. These investments are expected to have a life of 4 years with 0 salvage value.The investments will be depreciated straight line over the four-year life.The revenues in the first year are expected to be $1500,000, growing 20% in year 2, and 10% in the two years following.The salaries and other benefits for the employees are estimated to be $150,000 in year 1, and grow 10% a year for the following three years.The cost of the books is assumed to be “0.60” of the revenues in each of the four years.The non-cash working capital, which includes the inventory of books needed for the service and the…
Russell Trent was recently tasked with evaluating projects for Stan's No Touch Car Wash. The company recently decided to use NPV as its primary criterion for approving projects. To be selected, a project must have a positive NPV. Russell is currently evaluating a project with the following estimated investment requirements ($ millions) by year (starting in year 0): \ Investment Year Investment 0 16 1 10.1 2 12.5 The estimated revenues ($ millions) from the project, expected to begin at time 2, are given in the table below: Investment Year Investment 0 11.1 1 11.3 2 8.2 3 14.3 4 11.9 To account for the different risk characteristics throughout the project's life, Russell has determined that a hurdle rate of 23% should be used beginning at time 0, while 37% should be used beginning in period 4. Determine the NPV for the project. NPV=
Zenith Investment Company is considering the purchase of an office property. It has done an extensive market analysis and has estimated that based on current market supply or demand relationships, rents, and its estimate of operating expenses, annual NOI will be as follows: Year NOI 1 $ 1,030,000 2 1,030,000 3 1,030,000 4 1,210,000 5 1,260,000 6 1,310,000 7 1,349,000 8 1,389,170 A market that is currently oversupplied is expected to result in cash flows remaining flat for the next three years at $1,030,000. During years 4, 5, and 6, market rents are expected to be higher. It is further expected that beginning in year 7 and every year thereafter, NOI will tend to reflect a stable, balanced market and should grow at 3 percent per year indefinitely. Zenith believes that investors should earn a 12 percent return (r) on an investment of this kind.Required: a. Assuming that the investment is expected to produce NOI in years 1 to 8 and is expected to be owned for…
| MYUSF x My Home CengageNOWv2 | Online teachin X engagenow.com/ilm/takeAssignment/takeAssignmentMain.do?invoker%3D&takeAssignmentSessionLocator3D&inpro... to 全临 Dickerson Co. is evaluating a project requiring a capital expenditure of $810,000. The project has an estimated life of 4 years and no salvage value. The estimated net income and net cash flow from the project are as follows: Year Net Income Net Cash Flow $75,000 $285,000 2 100,000 290,000 3. 109,000 190,000 4 36,000 125,000 $320,000 $890,000 The company's minimum desired rate of return is 12%. The present value of $1 at compound interest of 12% for , 2, 3, and 4 years is 0.893, 0.797, 0.712, and 0.636, respectively. Required: Determine the average rate of return on investment. Round your answer to one decimal place. Previous Next 9:40 PM 5/8/2021 2.
A project engineer is assigned to provide computer networking and internet access to an office building. After research, various equipment suppliers' two alternatives are detailed for further economic analysis. Alternative A is a wireless network with lower capital investment costs but higher operational costs. Alternative B is a wired network with low operational costs but higher equipment and installation costs. The costs associated with each of the two (2) alternatives are outlined below. Alternative A Wireless Network Alternative B Wired Network $50,000 $100,000 Design Equipment $50,000 $100,000 Installation $25,000 $100,000 0 Upgrades $25,000 per year Maintenance & Operation P25,000 per year $5,000 per year Salvage $10,000 6 years $5,000 9 years Service Life Using the information provided above, determine which alternative to recommend using PW analysis. Conduct the analysis twice, once for the least common multiple of the service lives and once using a five-year study period.…