Engineering Fundamentals: An Introduction to Engineering
6th Edition
ISBN: 9780357112311
Author: Saeed Moaveni
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Question
Chapter 20, Problem 50P
To determine
Find the value of X using Excel functions.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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
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%.
Solve Problem 20.16 using Excel.
Chapter 20 Solutions
Engineering Fundamentals: An Introduction to Engineering
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_forwardUsing 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_forwardWithout using excel. (A) Determine the number of possible rate of return value. (B) Find all i* values between 0 and 100%arrow_forward
- Problem2. 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_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
- Use 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_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_forwardI need to solve all questions and in handwriting Q3/ Find the effective interest rate per quarter at nominal interest rate og 8% compounded a)quarterly, b) monthly, c) weekly, and d) daily Q4/ Suppose you make $500 deposit monthly at interest rate of 10% compounded monthly. What is the amount (F) will be at the end of 10 years?arrow_forward
- Calculate 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_forwardQuestion 2 (1 point) Listen Rachel can earn 3% interest in her savings account. Her daughter Dani is 11 years old today. Suppose Rachel deposits $4000 today, and one year from today she deposits another $500. Each year she increases her deposit by $500 until she makes her last deposit on Dani's18th birthday. how much is on deposit after the 18th birthday? $20,635.62 $18,236.68 $23,623.00 $26,369.36 Previous Page Next Pagearrow_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