Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)
5th Edition
ISBN: 9781305084766
Author: Saeed Moaveni
Publisher: Cengage Learning
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
Solve Problem 20.25 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
Solve Problem 20.16 using Excel.
Chapter 20 Solutions
Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)
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
- A 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_forward2. 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_forwardWhat is the equivalent annual worth of the cash flow given in the accompanying figure? Assume i = 8% .arrow_forward
- 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%.arrow_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_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_forwardPlease give answer fastarrow_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_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_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_forwardECONOMICS An item worth P60,000 is payable in 60 days or P57,500 payable in 15 days. Find the equivalent annual rate of simple interest if paid in 60 days. Which of the following has the least effective annual interest rate?arrow_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