Using a spreadsheet, (a) Work Problem 12.19 as stated, (b) Expand the bundles to allow up to

Question:

Using a spreadsheet,

(a) Work Problem 12.19 as stated,

(b) Expand the bundles to allow up to three projects and no more than $25,000 invested.

Data from problem 12.19

4 Project Investment, $ -5000 -7000 -9000 -10,000 |Life, years 2 3 4 3 3 5 4

Project 2 3 4 Year NCF Estimates, $ per Year 1000 500 5000 1700 500 5000 3 2400 500 2000 4 3000 500 17,000 5 3800 10,500

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Engineering Economy

ISBN: 978-0073523439

8th edition

Authors: Leland T. Blank, Anthony Tarquin

See More Books

Question Posted: Dec 26, 2018 05:55 AM

See More Questions

Work Problem using a spreadsheet. Use the PW method to evaluate four independent projects. Select as many as three of the four projects. The MARR is 12% per year, and up to $16,000 in capital...
General Journal Transactions Dec. 01 Paid cash for months rent, $1,200.00; Check No. 3829. 01 Paid cash for monthly telephone bill, $237.73; Check No. 3830. 02 Paid cash for delivery charges, $42.00;...
General Journal Transactions Dec. 01 Paid cash for months rent, $1,200.00; Check No. 3829. 01 Paid cash for monthly telephone bill, $237.73; Check No. 3830. 02 Paid cash for delivery charges, $42.00;...
If Y = $200 billion, c = 0.75, autonomous consumption = $10 billion, and T = $20 billion, induced consumption expenditure is Question 5 options: a) $135 billion. b) $200 billion. c) $180 billion. d)...
Effective April 27, 2017, Dorr Corporation's shareholders approved a two-for-one split of the company's common stock and an increase in authorized common shares from 100,000 shares (par value of $20...
The following are audit procedures from different transaction cycles: 1. Examine sales invoices for evidence of internal verification of prices, quantities, and extensions. 2. Select items from the...
Two large, parallel, current-carrying plates are oriented horizontally and the vertical distance between them is $5.0 \mathrm{~mm}$. The current per unit width in each plate is \(100 \mathrm{~A} /...
It certainly is nice to see that small variance on the income statement after all the trouble weve had lately in controlling manufacturing costs, said Linda White, vice president of Molina Company....
1. The above image shows a thin lens of focal length 5m. (i) What is the kind of lens shown in the above figure? (ii) If a real inverted image is to be formed by this lens at a distance of 7m from...
A 3 m 3 insulated tank contains steam at 1 bar, 150 C. The tank is connected to a steam line that is maintained at 10 bar, 300 C until the pressure in the tank is 5 bar. How much steam (kg) was...
In drawing 2 screws from a lot of right-handed and left-handed screws, let A, B, C, D mean at a least 1 right-handed, at least 1 left-handed, 2 right-handed, 2 left-handed, respectively. Are A and B...
(a) Find the points of inflection of the curve of (1). (b) Considering Î¦ 2 () and introducing polar coordinates in the double integral (a standard trick worth remembering), prove (c)...
What might be the components of a data center audit program?
Jeremy ( unmarried ) earned $ 1 0 7 , 5 0 0 in salary and $ 6 , 4 0 0 in interest income during the year. Jeremy's employer withheld $ 1 0 , 0 0 0 of federal income taxes from Jeremy's paychecks...
Show whether or not the following formulae are dimensionally consistent? (a) h = 9(gt - 2vt) 8(v-gt) gt gt 2v 2va (b) t = (c) t = y V v sin 0+ sin2 0+2gy 9 (d) K = (kAr-mgAr sin a) cos a where k has...
[5 points] (d) A modem has a baud rate of 2400 symbols/sec. What would be the bit rate for this modem if its phase-amplitude constellation is as follows: [2 points] (e) A voice grade modem has a...
Z Incorporation acquired significant influence over Y Company by purchasing 1 0 0 percent of the common stock of the Y Incorporation for $ 1 0 0 , 0 0 0 ; Y earns income of $ 5 0 , 0 0 0 and pays...
Suppose the following balance sheet for Winbnb after second round of venture financing. Second Stage Market Value Balance Sheet ($mil) Assets Cash from new Equity Fixed Assets Liabilities and Equity...
In May 1996, Fred Parramore executed four deeds, each conveying a life estate in his land to him and his wife and a remainder interest in one-fourth of his land to each of his four children: Alney,...
In Problems 1522, find the principal needed now to get each amount; that is, find the present value. To get $750 after 2 years at 2.5% compounded quarterly.
What is the depreciation deduction, using each of the following methods, for the second year for an asset that costs $35,000 and has an estimated MV of $7,000 at the end of its seven-year useful...
A piece of construction equipment (asset class 15.0) was purchased by the Jones Construction Company. The cost basis was $300,000. a. Determine the GDS and ADS depreciation deductions for this...
A manufacturer of aerospace products purchased three flexible assembly cells for $500,000 each. Delivery and insurance charges were $35,000, and installation of the cells cost another $50,000. a....
Christopher has collected data about women's heights and their shoe sizes. He noticed that taller women tend to have larger shoe sizes and shorter women tend to have smaller shoe sizes. Christopher...
Discuss the implications of collateral scarcity and collateral velocity for market liquidity and financial stability. How do changes in market conditions, such as regulatory reforms, market...
Critically assess the role of collateral in secured lending and the mitigation of credit risk for lenders. How do banks evaluate the quality, liquidity, and marketability of collateral assets to...

Using a spreadsheet, (a) Work Problem 12.19 as stated, (b) Expand the bundles to allow up to

Question:

4 Project Investment, $ -5000 -7000 -9000 -10,000 |Life, years 2 3 4 3 3 5 4 Project 2 3 4 Year NCF Estimates, $ per Year 1000 500 5000 1700 500 5000 3 2400 500 2000 4 3000 500 17,000 5 3800 10,500

Step by Step Answer:

a Spreadsheet Projects 1 and 3 are selected with PW 3893 with ...View the full answer

Engineering Economy

Students also viewed these Business questions