The following data are accumulated by Geddes Company in evaluating the purchase of $120,000 of equipment, having a four-year useful fe Net Income Net Cash Flow Year 1 $49,500 $79,500 Year 2 29,000 59,000 Year 3 16,500 46,500 Year 4 6,500 36,500 This information has been collected in the Microsot Excel Online fle. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. K) open spreadsheet a. Auming that the desired rate of return is 15%, determine the net present value for the proposal. f required, round to the nearest dollac Net present value b. Would management be lky to look with favor on the proposal? the net present value indicates that the return on the proposal is than the minimum desired rate of returm of 15%

The following data are accumulated by Geddes Company in evaluating the purchase of $120,000 of equipment, having a four-year useful fe Net Income Net Cash Flow Year 1 $49,500 $79,500 Year 2 29,000 59,000 Year 3 16,500 46,500 Year 4 6,500 36,500 This information has been collected in the Microsot Excel Online fle. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. K) open spreadsheet a. Auming that the desired rate of return is 15%, determine the net present value for the proposal. f required, round to the nearest dollac Net present value b. Would management be lky to look with favor on the proposal? the net present value indicates that the return on the proposal is than the minimum desired rate of returm of 15%

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter9: Depreciation (deprec)

Section: Chapter Questions

Problem 5R: A truck was recently purchased for 75,000 with a salvage value of 5,000 and an estimated useful life...

See similar textbooks

Similar questions

The following data are accumulated by Geddes Company in evaluating the purchase of $130,000 of equipment, having a four-year useful life: Net Income Net Cash Flow Year 1 $49,000 $81,500 Year 2 24,500 57,000 Year 3 13,000 45,500 Year 4 7,000 39,500 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet Assuming that the desired rate of return is 15%, determine the net present value for the proposal. If required, round to the nearest dollar. Net present value $ Would management be likely to look with favor on the proposal? , the net present value indicates that the return on the proposal is than the minimum desired rate of return of 15%.
The following data are accumulated by Waiola Company in evaluating the purchase of $120,000 of equipment, having a 4-year useful life: Year Net Income Net Cash Flow Year 1 $45,000 $75,000 Year 2 28,000 58,000 Year 3 19,500 49,500 Year 4 (7,000) 37,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Assuming that the desired rate of return is 6%, determine the net present value for the proposal. If required, round to the nearest dollar.Net present value fill in the blank 1 of 1$
Consider the following accounting information for a computer system: Cost basis of the asset, I = $10,000, Useful life, N = 5 years, Estimated salvage value, S = $0. Use the double-declining-depreciation method to compute the annual depreciation allowances and the resulting book values.
Brill Company made the following expenditures during the current year: Costs to develop computer software for internal use in Brill’s general management information system: 1 000 000 Cost of market research activities 750 000 How much Brill Company's expense?
Calculate the total cost, total depreciation, and annual depreciation (in $) for the following assets by using the straight-line method. (Round your answers to the nearest cent.) Cost ShippingCharges SetupCharges TotalCost SalvageValue EstimatedUseful Life(years) TotalDepreciation AnnualDepreciation $76,300 $1,500 $650 $ $4,500 11 $ $
Equipment acquired at a cost of $96,000 has an estimated residual value of $6,000 and an estimated useful life of 10 years. It was placed in service on May 1 of the current fiscal year, which ends on December 31. This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a. Determine the depreciation for the current fiscal year and for the following fiscal year by the straight-line method. Round your answers to the nearest dollar. Depreciation Year 1 S Year 2 $ b. Determine the depreciation for the current fiscal year and for the following fiscal year by the double-declining-balance method. Do not round the double-declining balance rate. Round your answers to the nearest dollar. Depreciation Year 1 S Year 2 S
Brill Company made the following expenditures during the current year: Costs to develop computer software for internal use in Brill’s general management information system: 1 000 000 Cost of market research activities 750 000 Brill Company’s total Expense?
A company owner has asked his accountant to research the photocopier equipment available from vendors, and to recommend the two best equipment alternatives. The company owner will decide on one piece of equipment topurchase. The fee charged for the accountant’s research was $500. The accountant’s report produced the following information: Photocopier (A) Photocopier (B) Initial cost, including installation $6,500 $ 6,000 Economic life 5 years 5 years Scrap value at end of economic life -0- -0- Initial training cost $ 500 $ 700 Annual maintenance $ 400 $ 300 Annual wage cost $12,500 $12,500 REQUIRED 1. Which photocopier should the company owner choose? Why? 2. The company owner requested your help in preparing the coming year company budget. Please, guide him to the best method and appropriate type from your perspective.
Consider the following accounting information for a computer system:Cost basis of the asset (I) = $10,000;Useful life (N) = 5 years;Estimated salvage value (S) = $2,000. Compute the annual depreciation allowances and the resulting book values using the double-declining-balance depreciation method.
A company bought a machine for BD300,000 which has a useful life of 7 years and can be sold for BD30,000 at the end of its useful life. Determine the Depreciation schedules, dn Accumulated depreciation, Dn Book value, Cn using straight line method and double declining balance method. Generate the plots using Microsoft excel. Repeat problem #1 if there is an installation cost of BD20,000. Repeat problem #1 if there is a dismantling cost of BD5,000. The coupon interest rate issued by Jordan Company on a 10-year bond is 10%, with a par value of BD1,000 and pays interest semi-annually. The required annual return expected by the company is 12%. Determine the bond’s value?
Calculate the total cost, total depreciation, and annual depreciation (in $) for the following assets by using the straight-line method. (Round your answers to the nearest cent.) Estimated Shipping Charges Setup Charges Total Salvage Value Total Annual Useful Life (years) Cost Cost Depreciation Depreciation $88,700 $625 $2,500 $7,000
Calculate the Annual Depreciation for each listed asset. Assume the assets were purchased on January 1st and used for 12 months. The first asset has been completed. Utilize the straight-line depreciation method: (Original cost - Estimated Salvage Value) / Estimated Useful Life = Annual Depreciation Plant Asset Cash register Computer Vehicle Machinery Desk Asset Original Cost 500.00 4,500.00 15,500.00 8,000.00 2,500.00 Calculate the amount to be depreciated: Annual Depreciation Cash register Computer Vehicle Machinery Desk Estimated Salvage Value 25.00 800.00 3,000.00 1,200.00 200.00 67.86 Estimated Useful Life 7 years 5 years 10 years 5 years 15 years Questions? Contact your instructor!