2. cesa. What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present valuefactor to 3 decimals and round all other intermediate calculations to nearest whole dollar.)Net present valuec. The internal rate of return is between what two whole discount rates (e.g., between 10% and 11%, between 11% and 12 %, between 12%and 13%, between 13% and 14%, etc.)?The internal rate of return is betweenandMinimum salvage value required to generate a positive present value%d. Reset the discount rate to 12%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in apositive net present value? es2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to matchthe following: Use Exhibit 78-1 and Exhibit 78-2. (Use appropriate factor(s) from the tables provided.)A1 Chapter 7: Applying Excel234DataExample ECost of equipment neededWorking capital neededOverhaul of equipment in four years8 Salvage value of the equipment in five years.9Annual revenues and costs:567Sales revenuesCost of goods soldOut-of-pocket operating costs10111213 Discount rate$$$$$$$B210,00025,00015,00035,000360,000225,00080,000C12 %a. What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present valuefactor to 3 decimals and round all other intermediate calculations to nearest whole dollar)

We are going to build an excel sheet to determine the cash flow for each year. Then we are going to…

Net present value c. The internal rate of return is between what two whole discount rates (e.g., between 10 % and 11%, between 11% and 125 and 13%, between 13% and 14%, etc.)? The internal rate of return is between and %

Net present value c. The internal rate of return is between what two whole discount rates (e.g., between 10 % and 11%, between 11% and 125 and 13%, between 13% and 14%, etc.)? The internal rate of return is between and %

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter9: Depreciation (deprec)

Section: Chapter Questions

Problem 6R: Dunedin Drilling Company recently acquired a new machine at a cost of 350,000. The machine has an...

See similar textbooks

Similar questions

2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following: Use Exhibit 14B-1 and Exhibit 14B-2. (Use appropriate factor(s) from the tables provided.) A 1 Chapter 14: Applying Excel 2 3 Data 4 Example E 5 6 Working capital needed 7 Overhaul of equipment in four years 8 009 10 11 12 13 Cost of equipment needed Salvage value of the equipment in five years Annual revenues and costs: Sales revenues Cost of goods sold Out-of-pocket operating costs Discount rate Net present value S The internal rate of ratum is between $ $ and $ $ $ $ $ B 310,000 50,000 25,000 30,000 a. What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present value factor to 3 decimals and round all other intermediate calculations to nearest whole dollar.) (1.734) c. The internal rate of return is between what two whole discount rates (e.g., between 10% and 11%, between 11% and 12…
2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match the following: Use Exhibit 148-1 and Exhibit 148-2. (Use appropriate factor(s) from the tables provided.) A Chapter 14: Applying Excel 3. Data 4. Example E 5. Cost of equipment needed 310,000 6. Working capital needed 20,000 7. Overhaul of equipment in four years 2$ 30,000 8. Salvage value of the equipment in five years 35,000 9. Annual revenues and costs: 415.000 10 Sales revenues 270,000 11 Cost of goods sold %24 55,000 12 Out-of-pocket operating costs 16 % 13 Discount rate a. What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present value factor to 3 decimals and round all other intermediate calculations to nearest whole dollar.) Net present value
I need the solution in handwriting The following are the cost of a system and the useful life is five years. The salvage value for depreciation purpose is equal to 25% of the hardware cost Item Cost Hardware $170,000 Training Installation $18,000 $18,000 a) What is the book value of the system at the end of year three if Straight line method is used? b) Suppose that after depreciation of the system for two years with straight line, the company decides to switch to the decline method for the reminder of the system life (depreciation rate 30%). What is the system Book Value at the end of four years? (
Required information Use the following information for the Exercises below. (Algo) [The following information applies to the questions displayed below.] NewTech purchases computer equipment for $261,000 to use in operating activities for the next four years. It estimates the equipment's salvage value at $30,000. Exercise 8-7 (Algo) Straight-line depreciation LO P1 Prepare a table showing depreciation and book value for each of the four years assuming straight-line depreciation. Choose Numerator: Year Year 1 Year 2 Year 3 Year 4 Total Straight-Line Depreciation Choose Denominator: Annual Depreciation = = Annual Depreciation Expense Depreciation expense Year-End Book Value
Dunedin Drilling Company recently acquired a new machine at a cost of 350,000. The machine has an estimated useful life of four years or 100,000 hours, and a salvage value of 30,000. This machine will be used 30,000 hours during Year 1, 20,000 hours in Year 2, 40,000 hours in Year 3, and 10,000 hours in Year 4. With DEPREC5 still on the screen, click the Chart sheet tab. This chart shows the accumulated depreciation under all three depreciation methods. Identify below the depreciation method that each represents. Series 1 _____________________ Series 2 _____________________ Series 3 _____________________ When the assignment is complete, close the file without saving it again. Worksheet. The problem thus far has assumed that assets are depreciated a full year in the year acquired. Normally, depreciation begins in the month acquired. For example, an asset acquired at the beginning of April is depreciated for only nine months in the year of acquisition. Modify the DEPREC2 worksheet to include the month of acquisition as an additional item of input. To demonstrate proper handling of this factor on the depreciation schedule, modify the formulas for the first two years. Some of the formulas may not actually need to be revised. Do not modify the formulas for Years 3 through 8 and ignore the numbers shown in those years. Some will be incorrect as will be some of the totals. Preview the printout to make sure that the worksheet will print neatly on one page, and then print the worksheet. Save the completed file as DEPRECT. Hint: Insert the month in row 6 of the Data Section specifying the month by a number (e.g., April is the fourth month of the year). Redo the formulas for Years 1 and 2. For the units of production method, assume no change in the estimated hours for both years. Chart. Using the DEPREC5 file, prepare a line chart or XY chart that plots annual depreciation expense under all three depreciation methods. No Chart Data Table is needed; use the range B29 to E36 on the worksheet as a basis for preparing the chart if you prepare an XY chart. Use C29 to E36 if you prepare a line chart. Enter your name somewhere on the chart. Save the file again as DEPREC5. Print the chart.
Quary Company is considering an investment in machinery with the following information. Initial investment Useful life Salvage value Expected sales per year (a) Compute the investment's annual income and annual net cash flow. (b) Compute the investment's payback period. Required A Required B Complete this question by entering your answers in the tabs below. $ 335,000 9 years $ 20,000 16,750 units Annual Amounts Materials, labor, and overhead (except depreciation) Depreciation-Machinery Selling, general, and administrative expenses Selling price per unit Compute the investment's annual income and annual net cash flow. Expenses Income Net cash flow $ 75,375 35,000 8,375 $ 10
1. Use the information below for the next two questions. Leaky Pipe Inc. is considering a new machine for its largest product line. The cash flows Lastalled Purchase Price S40, 000 Roduced Cost of Materials S 6,000 per year Labor Savings S9, 000 per year locrease in Working Capital $5, 000 (for Year 0 and I only) Depreciable Life (zero salvage value) 4 years Economic Life 8 years Required Return 12% Tax Rate 40% a . What is the NPV of this machine if it does not replace any other?. b. Suppose the machine replaces another machine with the following characteristics: Book Value of Old Machine $6.000 Market Value of Old Machine $4,000 Remaining Depreciable Life of Old Machine 6years Assume the old machine was not expected to have any salvage value and compute the NPV of the New Machine.
Linda's Luxury Travel (LLT) is considering the purchase of two Hummer limousines. Various information about the proposed investment follows: Initial investment (2 limos) Useful life. Salvage value Annual net income generated. LLT's cost of capital $1,800,000 $ 140,000 180,000 $ 15% 1. Accounting rate of return. 2. Payback period. 10 years Assume straight line depreciation method is used. Required: Help LLT evaluate this project by calculating each of the following: 3. Net present value 4. Without making any calculations, determine whether the IRR is more or less than 15% Complete this question by entering your answers in the tabs below. Required 4 Required 1 Required 2 Required 3 Calculate accounting rate of return. (Round your answer to 1 decimal place.) Accounting Rate of Return
Modified Accelerated Cost Recovery System (MACRS) (LO 8.2) Calculate the following: Click here to access the various depreciation tables. If required, round your final answers to the nearest dollar. If your answer is zero, enter "0". The first year of depreciation on a office building that cost $250,000 purchased June 2, 2022. 4,168 X b. The second year (2023) of depreciation on a computer that cost $5,000 purchased in May 2022, using the half-year convention and accelerated depreciation considering any bonus depreciation taken Ov a. The first year of depreciation on a computer costing $2,800 purchased in May 2022, using the half-year convention and straight-line depreciation with no bonus depreciation 280 b. The third year of depreciation on business furniture costing $10,000 purchased in March 2020, using the half-year convention and accelerated depreciation but no bonus depreciation. 1,748 x
E. Sum of the Year's Digit Method Problem: A structure costs P120,000. It is estimated to have a life of 5 years, with a salvage value at the end of its life of P1,000. Determine the book value at the end of each year of life. Use the sum- of-the-years-digit method. (Make a table in Microsoft Excel)
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…
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…