Darnell Enterprises constructed an addition to its building at a cost of $73,000. Extra annual expenses are expected to be $1850, but extra income will be $19.000 per year. How long will it take for the company to recover its investment at an interest rate of 10% per year? The time taken for the company to recover its investment is determined to be Choose the spreadsheet function that determines p a. Spreadsheet function: NPER (10%, 17,150, -73,000) displays 6 years b. Spreadsheet function: NPER(10%, 18,815, -73,000) displays 4 years c. a. Spreadsheet function: NPER(10%, 17,150.-19.000) displays 4 years d. a. Spreadsheet function: NPER(10%, 18,815, -19,000) displays 6 years The correct spreadsheet function is in option a years.

Darnell Enterprises constructed an addition to its building at a cost of $73,000. Extra annual expenses are expected to be $1850, but extra income will be $19.000 per year. How long will it take for the company to recover its investment at an interest rate of 10% per year? The time taken for the company to recover its investment is determined to be Choose the spreadsheet function that determines p a. Spreadsheet function: NPER (10%, 17,150, -73,000) displays 6 years b. Spreadsheet function: NPER(10%, 18,815, -73,000) displays 4 years c. a. Spreadsheet function: NPER(10%, 17,150.-19.000) displays 4 years d. a. Spreadsheet function: NPER(10%, 18,815, -19,000) displays 6 years The correct spreadsheet function is in option a years.

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

A $10,000 loan amortized over 5 years at an interest rate of 10% per year requires payments of $2638 to completely remove the loan when interest is charged on the unrecovered balance of the principal. If interest is charged on the original principal instead of the unrecovered balance, what is the loan balance after 5 years, provided the same $2638 payments are made each year?
EncryptCo has two possible plans for accumulating money for capital projects. One plan is to save $100,000 per year, independent of growth. The second plan is to start with $80,000 per year and increase the annual contribution by 5% each year. The money will accumulate interest at 4% nominal annual, compounded quarterly. Which plan will have more money after 10 years?
Darnell Enterprises constructed an addition to its building at a cost of $70,000. Extra annual expenses are expected to be $1850, but extra income will be $14,000 per year. How long will it take for the company to recover its investment at an interest rate of 10% per year? Also, write the spreadsheet function that determines np.
An automaton asset with a high first cost of $10 million has required capital recovery (CR) of $1,985,000 per year. The correct interpretation of this CR value is that: (a) the owner must pay an additional $1,985,000 each year to retain the asset. (b) each year of its expected life, a net revenue of $1,985,000 must be realized to recover the $10 million first cost and the required rate of return on this investment. (c) each year of its expected life, a net revenue of $1,985,000 must be realized to recover the $10 million first cost. (d) the services provided by the asset will stop if less than $1,985,000 in net revenue is reported in any year.
A municipal bond with a face value of $10,000 was issued today with an interest rate of 6% per year payable semiannually. The bond matures 20 years from now. If an investor paid $9,000 for the bond and holds it to maturity, all of the following equations will yield the correct semiannual rate of return except: (a) 0 = −9000 + 300(P/A,i*,40) + 10,000(P/F,i*,40) (b) 0 = −9000(F/P,i*,40) + 300(F/A,i*,40) + 10,000 (c) 0 = −9000(A/P,i*,40) + 300 + 10,000(A/F,i*,40) (d) 0 = −9000 + 600(P/A,i*,40) + 10,000(P/F,i*,40)
Eastside Auto purchases a component used in the manufacturing of automobile generators directly from the supplier. Eastside’s generator production operation, which is operated at a constant rate, will require 1,000 components per month throughout the year (12,000 units annually). Assume that the ordering costs are $25 per order, the unit cost is $2.50 per component, and annual holding costs are 20% of the value of the inventory. Eastside has 250 working days per year and a lead time of 10 days. What is the EOQ for this component? What is the cycle time? What is the reorder point?
Ellis Equipment sold a used Massey Ferguson tractor for $55,000 to a South Kansas farmer 10 years ago. (a) What is the uniform net cash flow that the farmer had to receive each year to realize payback and a return of 5% per year on his investment over a period of 3 years? 5 years? 8 years? All 10 years? (b) If the net cash flow was actually $6000 per year, what is the amount the farmer should have paid for the tractor to realize payback plus the 5% per year return over these 10 years?
Faro laser trackers are portable contact measurement systems that use laser technology to measure large parts and machinery to accuracies of 0.0002inches across a wide range of industrial applications. A customer that manufactures and installs cell phone relay dishes and satellite receiving stations reported the cash flows (in $1000 units) for one of its product lines. (a) Determine the number of possible rate of return values. (b) Find all rate ofreturn values between 0 and 150%.
Self-tightening wedge grips are designed for tensile testing applications up to 1200 pounds. The cash flows associated with the product are available below. Determine the following from these values: net cash flow series, cumulative cash flow series, and i* displayed by the IRR spreadsheet function, if an option for “guess” is not entered. Year 1 2 3 4 Revenue 25,000 13,000 4,000 70,000 Costs −30,000 −7,000 −6,000 −12,000
The capitalized cost of $ 10,000 , every 5 years forever, starting now at an interest rate of 10% per year? ( thanks in advance)
Army Research Laboratory scientists developed a diffusion-enhanced adhesion process which is expected to significantly improve the performance of multifunction hybrid composites. NASA engineers estimate that composites made using the new process will result in savings in space exploration projects. The cash flows for one project are estimated. Determine the rate of return per year. Year, t Cost ($1000) Savings ($1000) 0 −210 — 1 −150 — 2–5 — 100 + 60(t − 2)
A municipal bond with a face value of $10,000 will mature 15 years from now. The bond interest rate is 6% per year, payable quarterly. At an interest rate of 16% per year compounded quarterly, what is the present worth of the bond?