ENGINEERING FUNDAMENTALS
6th Edition
ISBN: 9781337705011
Author: MOAVENI
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 20, Problem 47P
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
Your future company has purchased a machine and has entered into a contract that requires the company to pay $2000 each year for the upgrade of machine components at the end of years 6, 7, and 8. In anticipation of the upgrade cost, your company has decided to deposit equal amounts ( X ) at the end of each year for five years in a row in an account that pays i = 6% . The first deposit is made at the end of the first year. What is the value of X?
Deposits 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.
Suppose that the parents of a young child decide to make annual deposits into a savings
account with the first deposit being made on the child's 5th birthday and the last deposit being
made on the 15th birthday. Then starting on the child's 18th birthday, the withdrawals shown
below will be made. If the effective annual interest rate is 8% during this period of time, what
are the annual deposits in year 5 to 15?
3200
2800
2400
2000
5 bday
15th bdav
18
19
20
21
A = ?
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
- An amount of $ 500 was borrowed for the period from January 10 to October 28, 1996 at 16% interest. a) Calculate the exact simple interest. b) What is the total amount to be paid at the end of the period?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_forwardA man will deposit 200 with a savings bank at the beginning of each 3 months for 9 years. If the bank pays interest at the rate of 5.5% quarterly, find the sum to his credit just after the last deposit. *written solution pleasearrow_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_forwardQ3: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_forwardQ2: Being a senior citizen you decide to invest $200,000 say for period 24 months, then describe what is the value you would expect to receive? Deposit rate (recurring deposit) available for various periods is given below.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_forwardCompute the future value of a $1500 deposit, after eight years, in an account that pays a simple interest rate of 7%. How much interest will be paid to this account?arrow_forward3. On january 1, 2016, Diana opened an account with a P 50,000 deposit. On january 1, 2017, she withdraws P 25,000 and on january 1, 2019 she deposits P 75,000. If the account earns 7.5% interest, compounded yearly, and no further deposits or withdraws are made, what was the balance on january 1, 2021?arrow_forward
- A machine was purchased for $ 8,000, with an estimated useful life of 10 years, and it has a scrap value of $ 1,000 and rate of interest = %1O. Calculate the following: The book value at the end of the ninth year using Sum of the Years- Digits method. * The book value at the end of the fourth year using constant percentage method. * The depreciation installment for the sixth year using straight line method. *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_forwardGiven: Amount A, = Ph 50,000 %3D Number of conversion periods n =98 The present value P is Ph 50,000 P= (1+0.04) 96 P= Ph 1,158.16 50.000 if invested at 4% interest compounded monthly. II. Exercises A. Exercise Direction: Find the present value of the following: Show your solution and write your answer in a sheet of paper. 1. Ph 40,000 due in two years at 3% compounded monthly 2. Ph 60,000 due in 3 years at 4% compounded monthly 3. Ph 75,000 due in 5 years at 5% compounded montnly 8. Compound I = 4% = 0.04arrow_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