Check myRequired informationa. 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 value2,859,330c. The internal rate of return is between what two whole discount rates (e.g., between 10% and 11%, between 11% ond 12%, between 12%and 13%, between 13% and 14%, etc.)?The internal rate of returm is belweenandd. Reset the discount rate to 17%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in apositive net present value?Minimum salvage value required to generata a positivo present value Chapter 12: Applying Excel: Exercise (Part 2 of 2) (Algo)2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to matchthe following: Use Exhibit 128-1 and Exhibit 128-2. (Use appropriate factor(s) from the tables provided.)AB.Chapter 12: Applying Excel2Data4Example ECost of equipment needed430,00045,00035,00020,0006.Working capital neededOverhaul of equipment in four years8.Salvage value of the equipment in five years$49.Annual revenues and costs:435,00010Sales revenues11Cost of goods sold245,000Out-of-pocket operating costs%2450,0001213Discount rate17 %

NPV is capital budgeting technique used to evaluate performance of projects. It is arrived at by…

Check my Required information 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 $ 2,859,330 c. 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 retum is between and d. Reset the discount rate to 17%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value? Minumum salvage value required to generate a positive present value

Check my Required information 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 $ 2,859,330 c. 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 retum is between and d. Reset the discount rate to 17%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value? Minumum salvage value required to generate a positive present value

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter27: Time Value Of Money (compound)

Section: Chapter Questions

Problem 1R

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. 148-1 and Exhibit 14B-2. (Use appropriate factor(s) from the tables provided.) Required information The Chapter 14 Form worksheet is to be used to create your own worksheet version of Example E and Exhibit 14-8 in the text. 1 2 3 Data 4 Example E 10 11 A Chapter 14: Applying Excel 5 Cost of equipment needed 6 Working capital needed 7 Overhaul of equipment in four years 8 Salvage value of the equipment in five years 9 Annual revenues and costs: 12 13 Sales revenues Cost of goods sold Out-of-pocket operating costs Discount rate $ $ $ $ $ $ $ B 110,000 45,000 15,000 20,000 385,000 270,000 80,000 с 14 %
ework i 370253A%252+%252Flms.mheducation.com%252Fmghmiddleware%252Fmheproducts%252 Saved Check my work mode: This shows what is correct or incorrect for the work you have completed so far. It does not Required information [The following information applies to the questions displayed below.] Wardell Company purchased a minicomputer on January 1, 2022, at a cost of $56,000 The computer was depreciated using the straight-line method over an estimated five-year life with an estimated residual value of $8,000. On January 1, 2024, the estimate of useful life was changed to a total of 10 years, and the estimate of residual value was changed to $2,000. 2. Prepare the year-end journal entry for depreciation on December 31, 2024. Assume that the company uses the double-declining- balance method instead of the straight-line method. Note: If no entry is required for a transaction/event, select "No journal entry required" in the first account field. Do not round intermediate calculations. Round…
Question 3: Note: below list is a snap shot of table of content of the book. Planning website design and redesign projects 362 Require: You Are require to Read the topic and summarize it in your own words. ( 200-250 words) Book: th DavE ChaffEy , fiona ElliS-ChadwiCk, Digital Marketing 6 Edition
- Main View | Course X * CengageNOWV2| Online teachin X University of Sioux Falls, South D x - genow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator%3D&inpro... eBook Average Rate of Return-Cost Savings Maui Fabricators Inc. is considering an investment in equipment that will replace direct labor. The equipment has a cost of $90,000 with a $8,000 residual value and a ten-year life. The equipment will replace one employee who has an average wage of $15,980 per year. In addition, the equipment will have operating and energy costs of $4,350 per year. Determine the average rate of return on the equipment, giving effect to straight-line depreciation on the investment. If required, round to the nearest whole percent. IC
A 12 Compute the ROI 13 Margin 14 Turnover 15 ROI 16 1 Chapter 10: Applying Excel 2 3 Data 4 Sales 5 6 Average operating assets 7 Minimum required rate of return 8 9 Enter a formula into each of the cells marked with a ? below 10 Review Problem: Return on Investment (ROI) and Residual Income 11 Net operating income 17 Compute the residual income 18 Average operating assets 22 23 24 25 26 27 28 29 30 31 32 33 34 19 Net operating income 20 Minimum required return 21 Residual income Chapter 10 Form B + $25,000,000 $3,000,000 $10,000,000 25% ? ? ? C ? ? ? ? D E F G H | J K L
pject: Company Accour X DEL. Project Guidelines and Rubric x DEL 7-1 Problem Set: Module Sev X CengageNOWv2 |Online tea x com/ilm/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator3D&inprogress=false eBook 4Show Me How Return on Total Assets A company reports the following income statement and balance sheet information for the current year: Net income $224,540 Interest expense 39,620 000'080 Determine the return on total assets. If required, round the answer to one decimal place. Average total assets Feedback Check My Work Divide the sum of net income and interest expense by average total assets. Check My Work ( Previous *AD dy
engageNOWV2 | Assignme CengageNOWv2 |Unlın X now.com/ilrm/takeAssignment/takeAssignmentMain.do?invoker%3D8takeAssignmentSessionLocator3&inprogress%3false Calculator Equipment with a cost of $220,000 has an estimated residual value of $30,000 and an estimated life of 10 years or 19,000 hours. It is to be depreciated by the straight-line method. What is the anount of depreciation for the first full year, during which the equipment was used for 2,100 hours? Oa. $21,000 Ob. $22,000 Oc. $19,000 Od. $30,000 Previous Next 8:21 AM 5/4/2020
t: Modi X * CengageNOWv2 | On x * Cengage Learning m/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=. CD B Milestone Two Guideli x G module 5 problem set x A eBook Show Me How Impaired Goodwill and Amortization of Patent On April 1, a patent with an estimated useful economic life of 12 years was acquired for $43,200. In addition, on December 31, it was estimated that goodwill of $41,000 was impaired. a. Record the acquisition of patent. If an amount box does not require an entry, leave it blank. April 1 b. Journalize the adjusting entry on December 31 for the amortization of the patent rights. Do not round intermediate calculations. If an amount box does not require an entry, leave it blank. Dec. 31 C. Journalize the adjusting entry on December 31 for the impaired goodwill. If an amount box does not require an entry, leave it blank. Dec. 31 Next Previous 3:24 PM Check My Work 11/28/2021 56°F Mostly cloudy a O E - A 0 home delete prt sc %23
plem Set: Mod x * CengageNOW2| On x * Cengage Learning B Milestone Two Guidel x G module 5 problem se x+ ow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogres.. еBook Show Me How Determining Cost of Land On-Time Delivery Company acquired an adjacent lot to construct a new warehouse, paying $44,000 in cash and giving a short-term note for $272,000. Legal fees paid were $1,780, delinquent taxes assumed were $14,700, and fees paid to remove an old building from the land were $21,700. Materials salvaged from the demolition of the building were sold for $4,700. A contractor was paid $960,600 to construct a new warehouse. Determine the cost of the land to be reported on the balance sheet. Next Previous 3:20 PM Check My Work 11/28/2021 56 F
DA. 7-2 Project: Company Accour x D2L 7-1 Problem Set: Module Sev X CengageNOWv2 |Online tea X Cengage Learning + x ngagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker3D&takeAssignmentSessionLocator=&inprogress%3Dfalse 电手 eBook Show Me How Long-Term Solvency Analysis The following information was taken from Celebrate Company's balance sheet: Fixed assets (net) 006'86$ 000 1,471,050 Long-term liabilities Total liabilities Total stockholders' equity 1,634,500 Determine the company's (a) ratio of fixed assets to long-term liabilities and (b) ratio of liabilities to stockholders' equity. If required, round your answers to one decimal place. a. Ratio of fixed assets to long-term liabilities b. Ratio of liabilities to stockholders equity (Previous Check My Work 330 PM hp 144 114
7-2 Project: Company Accour x 121. Project Guidelines and Rubric x 121. 7-1 Problem Set: Module Sev X CengageNOWv2 | Online tea now.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker3&takeAssignmentSessionLocator3D&inprogress3false eBook Show Me How Return on Total Assets A company reports the following income statement and balance sheet information for the current year: Net income $224,540 Interest expense 39,620 Average total assets Determine the return on total assets. If required, round the answer to one decimal place. 1.8 Check My Work Divide the sum of net income and interest expense by average total assets. Previa Check My Work ADE dy
mpt=17649928cmid=8751838page=D9 wio a https//alternativet A SQUCOFFEE - Goog A BCOM2911-Busines O Sultan Caboos Univ. G Trading Platform C. Accounting Club DEMIC) E-LEARNING SERVICES- SQU LIBRARIES - SQU PORTAL ATTENDANCE Time left 1:46:33 An allocation base: O a can be units of output if the company has a single product O b. All the given answers are NOT correct. Oc is determined at the end of the period. O d. isameasure used to assign conversion costs to products and services O e isameasure used to assign prime costs to products and services ר A Company uses job order costing and has chosen direct labor hours to allocate its manufacturing overhead. The company estimates that total direct labor hours to be operated next year are 250,000 hours. The estimated variable overhead is $15 per hour and the estimated fixed overhead costs are $750,000. The predetermined overhead rate is: O a $6 O b. None of the answers given Oc $45 Od. $3 Oe $18 NEXT PAGE OUS PAGE ACCT2121 general-chat Origin…