ENGINEERING FUNDAMENTALS
6th Edition
ISBN: 9781337705011
Author: MOAVENI
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 20, Problem 45P
To determine
Find the value of X using Excel functions.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Solve Problem 20.25 using Excel.
Solve Problem 20.16 using Excel.
4. Use the cash flow diagranm below to calculate the amount of money in year
that is equivalent to all the cash flows shown, if the interest rate is 12%
5.
per year.
2 3
4
6 7 8 9 10 11 12 13 Year
$1000
$2000
Chapter 20 Solutions
ENGINEERING FUNDAMENTALS
Ch. 20.4 - Prob. 1BYGCh. 20.4 - Prob. 2BYGCh. 20.4 - Prob. 3BYGCh. 20.4 - Prob. 4BYGCh. 20.4 - Prob. 5BYGCh. 20.4 - Prob. BYGVCh. 20.5 - Prob. 1BYGCh. 20.5 - Prob. 2BYGCh. 20.5 - Prob. 3BYGCh. 20.5 - Prob. BYGV
Ch. 20.8 - Prob. 1BYGCh. 20.8 - Prob. 2BYGCh. 20.8 - Prob. 3BYGCh. 20 - Prob. 1PCh. 20 - Prob. 2PCh. 20 - Prob. 3PCh. 20 - Prob. 4PCh. 20 - Prob. 5PCh. 20 - Prob. 6PCh. 20 - Prob. 7PCh. 20 - Prob. 8PCh. 20 - Prob. 9PCh. 20 - Prob. 10PCh. 20 - Prob. 11PCh. 20 - Prob. 12PCh. 20 - Prob. 13PCh. 20 - Prob. 14PCh. 20 - Prob. 15PCh. 20 - Prob. 16PCh. 20 - Prob. 17PCh. 20 - Prob. 18PCh. 20 - Prob. 19PCh. 20 - Prob. 20PCh. 20 - Prob. 21PCh. 20 - Prob. 22PCh. 20 - Prob. 23PCh. 20 - Prob. 24PCh. 20 - Prob. 25PCh. 20 - Prob. 26PCh. 20 - Prob. 27PCh. 20 - Prob. 28PCh. 20 - Prob. 29PCh. 20 - Prob. 30PCh. 20 - Prob. 31PCh. 20 - Prob. 32PCh. 20 - Prob. 33PCh. 20 - Prob. 34PCh. 20 - Prob. 35PCh. 20 - Prob. 36PCh. 20 - Prob. 37PCh. 20 - Prob. 38PCh. 20 - Prob. 39PCh. 20 - Prob. 40PCh. 20 - Prob. 41PCh. 20 - Prob. 42PCh. 20 - Prob. 43PCh. 20 - Prob. 44PCh. 20 - Prob. 45PCh. 20 - Prob. 46PCh. 20 - Prob. 47PCh. 20 - Prob. 48PCh. 20 - Prob. 49PCh. 20 - Prob. 50PCh. 20 - Prob. 52PCh. 20 - Prob. 53PCh. 20 - Prob. 54P
Knowledge Booster
Similar questions
- 2. Attach a complete solution. Draw the cash flow diagram. Suppose that P 4500 is deposited each year into a bank account that pays 8% interest compounded quarterly. How much would be accumulated in his fund by the end of the 4th year? The first payment occurs at time zero (now).arrow_forwardA software engineer borrows money to pay her employees while they are working at her start-up company. The bank offers an interest rate on the loan of 7% and the loan will be repaid in equal annual installments over 7 years at $70,000.00 per year. How much is the engineer able to borrow with the terms offered by the bank?arrow_forwardProblem2. Josh created two cash flow diagrams shown at the bottom of this page. The cash flows for alternative B represent two life cycles of A. Calculate the annual worth value of each over the respective life cycles to demonstrate that they are the same. Use an interest rate of 10% per year. Alternative A Alternative B $1000 i = 10% per year $1000 1 3 2 3 4 5 6 Year Year $25 $25 $25 $25 $25 $25 $25 $25 $25 $4000 $5000 $5000 2.arrow_forward
- I need the solution in handwriting Q1/ If the first deposit was $5,000 and decreased by $150 during the five years. Calculate the equivalent P and then the equivalent A?i=5% 5 4 5000 3 2 1arrow_forwardWhat is the equivalent annual worth of the cash flow given in the accompanying figure? Assume i = 8% .arrow_forwardSolve for each problems. Show your solution legible and neatly. Write the question, the given(also what is the given?), what to find and a cash flow diagram. Answers should be in 2 decimal places, unless stated otherwise. Solution should be hand-written. Question can be hand-written or type-written. Answer should be in 2 decimal places. 21. If the nominal interest rate is 3% of P5,000, how much worth in 15 years continuously compounded account? 22. You deposited $15,000 in a savings account five years ago. The account has earned 5.25% interest compounded continuously since then. How much money is in the account today? 23. A young engineer wants to surprise her husband with a European vacation for their tenth anniversary, which is five years from now. She determine that the trip will cost $7,000. Assuming an interest rate of 5.5% compounded daily, approximately how much money does she need to deposit today for the trip? 24. Mr. Ayala borrows P1,000. In 4 years, the money become P2,500…arrow_forward
- Q3:How much money must you deposit in year 6 if you deposit $5000 now and you want to have $12,000 at the end of year 11? Assume your deposits earn interest at 6% per year. [40 marks]arrow_forwardPlease give answer fastarrow_forwardFOR THE CASH FLOW REVENUES SHOWN BELOW, FIND THE VALUE OF G THAT MAKES THE EQUIVALENT ANNUAL WORTH IN YEARS 1 THROUGH 7 EQUAL TO $500. THE INTEREST RATE IS 10% PER YEAR.arrow_forward
- For the cashflow diagram below, what is the equivalent annual worth? Consider i=8%. 0 1 2 3 4 5 6 Years ४. 300 400 500 600 700 800arrow_forwardUsing Excel or a spreadsheet of your choice, create interest–time factor tables, similar to Table 20.9 , for i = 8 5% and i = 9 5%.arrow_forwardCalculate the total present worth of the cash flow below using an interest rate of 2.8% and when Q is: i. $1950 ii. $1250 iii. $580 iv. $0 0 1 2 3 4 5 6 Which case from (i), (ii), (iii), and (iv) produces the highest total present worth? is it the best case to invest in? Why? $14700 + $335 $335 → $750 00sS → $950arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Engineering Fundamentals: An Introduction to Engi...Civil EngineeringISBN:9781305084766Author:Saeed MoaveniPublisher:Cengage Learning
Engineering Fundamentals: An Introduction to Engi...
Civil Engineering
ISBN:9781305084766
Author:Saeed Moaveni
Publisher:Cengage Learning