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...
How much and in which ways did unbridled self-interest contribute to the subprime lending crisis?
What does the story of the BBCs failed Digital Media Initiative suggest to you about the importance of carefully managing not only the project, but the message of the project? That is, why is...
Mainland Supply Company recently changed its system of internal control over cash disbursements. The system includes the following features. Instead of being unnumbered and manually prepared, all...
Calculate the amount of revenue and gross profit (loss) to be recognized in each of the three years, assuming the following costs incurred and costs to complete information. Note: Do not round...
It is October 16, 2020, and you have just taken over the accounting work of China Moon Products, whose annual accounting period ends October 31. The company?s previous accountant journalized its...
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)...
If gamma radiation has a wavelength of 1.00 10 12 m, what is the energy of gamma radiation in joules?
Implement the nearest neighbor algorithm in the programming language of your choice. The algorithm should work with vectors of up to 10 integer values and allow up to 10 integer classifications. By...
Use the operators described in Section 16.2.4 and the STRIPS method to solve the block world planning problem shown in Figure 16.11. The first state shown is the start state and the second state is...
Implement a Bayesian belief network in the programming language of your choice to represent a subject in which you are interested (for example, you might use it to diagnose medical conditions from...
Researchers have measured the acceleration of racing greyhounds as a function of their speed; a simplified version of their results is shown in Figure P4.67. The acceleration at low speeds is...
If the rate at which energy is dissipated by resistor 1 in Figure P31.86 is $2.5 \mathrm{~W}$, and $R_{1}=10 \Omega, \mathscr{E}_{1}=12 \mathrm{~V}$, and $\mathscr{E}_{2}=6 \mathrm{~V},$ (a)...
In Problem 4.4 you showed that Apply the raising operator to find Y 2 2 (,). Use Equation 4.121 to get the normalization. Y(0,0)=/15/8 sin cos 9e.
In Exercises 516, find the focus and directrix of the parabola with the given equation. Then graph the parabola. y 2 = 4x
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....
Product Weight Sales Additional Processing Costs P 300,000 lbs. $ 245,000 $ 200,000 Q 100,000 lbs. 30,000 -0- R 100,000 lbs. 175,000 100,000 If joint costs are allocated based on relative weight of...
The projected benefit obligation was $380 million at the beginning of the year. Service cost for the year was $21 million. At the end of the year, pension benefits paid by the trustee were $17...
CVP Modeling project The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to determine the effects of changing business conditions on...

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