ENGINEERING FUNDAMENTALS
6th Edition
ISBN: 9781337705011
Author: MOAVENI
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 20, Problem 49P
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
Using 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%.
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
Solve Problem 20.16 using Excel.
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_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_forwardI 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_forward
- Using Excel, create a table that can be used to look up monthly paymentson a car loan for a period of five years. The monthly payments are calculated fromarrow_forwardDeposits of 35 000.00, 48 000.00, and 25 000.00 were made in a savings account eight years, five years, and two years respectively. Determine the accumulate amount in the account today if a withdrawal of 55 000.00 was made four years ago. The applied interest rate is 12% compounded continuously.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
- Solve 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_forwardUse tabulated factors and a spreadsheet to determine the interest rate per period for the following rate of return equation: 0 = -40,000 + 8000(P/A,i*,5) + 8000(P/F,i*,8).arrow_forwardWithout using excel. (A) Determine the number of possible rate of return value. (B) Find all i* values between 0 and 100%arrow_forward
arrow_back_ios
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