ENGINEERING FUNDAMENTALS
6th Edition
ISBN: 9781337705011
Author: MOAVENI
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 20, Problem 48P
To determine
Find the number of months required to pay off half of the loan using excel functions.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
$20,000.00 borrowed today for 2 years at 5% Compound Interest will result
in how much total interest (I) at the end of Year 2?
a) $2000.00
b) $2050.00 c) $20,000.00 d) $22,000.00
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.
#20,000.00 borrowed today for 2 years at 5% compound interest will result in how much total interest at the end of Year 2?
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_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_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
- I 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_forwardSolve Problem 20.16 using Excel.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
- Q2: 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_forward1.You deposit $50,000 into a fund that pays 5% per year compounded annually. You plan to make the following withdrawals. You withdraw $X one year from now, $2X three years from now, and $3X five years from now. If the last withdrawal depletes the fund, what is the value of X?arrow_forwardDetermine the equivalent amount pf money at the beginning of the second year if interest is 6% per year, compounded monthlyarrow_forward
- Compute the future value of a $3500 deposit made today, after eight years, in an account that pays an interest rate of 5% that compounds annually. How much interest will be paid to this account?arrow_forwardhat is the equivalent present value of the following series of payments if the interest rate is 10% compounded annually? P7,000 for 1styear, P6,500 for 2ndyear, P6000 for 3rdyear, P5,500 for 4thyear, and P5,000 5thyear. please also draw a cash flow diagram and dont use the table methodarrow_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_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