Engineering Economy
8th Edition
ISBN: 9780073523439
Author: Leland T Blank Professor Emeritus, Anthony Tarquin
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 51ES
To determine
Show the formula to calculate simple and compound interest by using spreadsheet.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
E.Z. Money, who owns a chain of nightclubs, needs to borrow $20,000 to remodel the local dive. Ima Shark offers to loan the $20,000 to Money for 24 months. Money must make monthly payments of $1118. Determine the loan’s (a) monthly interest rate and (b) effective annual interest rate. Use interpolation method.
Jasmine invested the profit of his
business in an investment fund that
was earning 3.50% compounded
monthly. He began withdrawing
$3,500 from this fund every 6 months,
with the first withdrawal in 4 years. If
the money in the fund lasted for the
next 6 years, how much money did he
initially invest in the fund?
A credit union charges 4% interest per month on the unpaid balance for purchases made on the credit card. Calculate the effective annual interest rate. use a cash flow diagram and manual solution.
Chapter 1 Solutions
Engineering Economy
Ch. 1 - Prob. 1PCh. 1 - Prob. 2PCh. 1 - Prob. 3PCh. 1 - Prob. 4PCh. 1 - Prob. 5PCh. 1 - Prob. 6PCh. 1 - Prob. 7PCh. 1 - Prob. 8PCh. 1 - Prob. 9PCh. 1 - Prob. 10P
Ch. 1 - Prob. 11PCh. 1 - Prob. 12PCh. 1 - Prob. 13PCh. 1 - Prob. 14PCh. 1 - Prob. 15PCh. 1 - Prob. 16PCh. 1 - Determine the amount of money FrostBank might loan...Ch. 1 - Prob. 18PCh. 1 - Prob. 19PCh. 1 - Prob. 20PCh. 1 - Prob. 21PCh. 1 - Prob. 22PCh. 1 - Prob. 23PCh. 1 - Prob. 24PCh. 1 - To attract new customers, EP Employees Credit...Ch. 1 - Prob. 26PCh. 1 - Prob. 27PCh. 1 - Prob. 28PCh. 1 - Prob. 29PCh. 1 - Prob. 30PCh. 1 - Prob. 31PCh. 1 - Prob. 32PCh. 1 - State University tuition and fees can be paid...Ch. 1 - Prob. 34PCh. 1 - Prob. 35PCh. 1 - Prob. 36PCh. 1 - Prob. 37PCh. 1 - Prob. 38PCh. 1 - Prob. 39PCh. 1 - Prob. 40PCh. 1 - Prob. 41PCh. 1 - Prob. 42PCh. 1 - Prob. 43PCh. 1 - What is the weighted average cost of capital for a...Ch. 1 - Prob. 45PCh. 1 - Prob. 46PCh. 1 - Prob. 47PCh. 1 - Prob. 48ESCh. 1 - Prob. 49ESCh. 1 - Prob. 50ESCh. 1 - Prob. 51ESCh. 1 - Prob. 52APQCh. 1 - Prob. 53APQCh. 1 - Prob. 54APQCh. 1 - Prob. 55APQCh. 1 - Prob. 56APQCh. 1 - Prob. 57APQCh. 1 - Prob. 58APQCh. 1 - Prob. 59APQCh. 1 - Prob. 60APQCh. 1 - Prob. 61APQCh. 1 - Prob. 1CSCh. 1 - Prob. 2CSCh. 1 - You developed an interest in the LCOE relation and...
Knowledge Booster
Similar questions
- A rich man put up a trust fund in the bank to give his son the earnings of P 400, 000 at the end of every four years and to continue until the 20th year. What is the amount of money placed in the trust fund if guaranteed interest is 16% per year? Use a Cash flow diagram. Discuss the concept of Trust Fund.arrow_forwardDarien invests $10,000 in an account that pays 3.2% interest per year, compounded semi-annually. What is the amount of money that he will have after 3 years?arrow_forwardjust all three subparts please. i,ii and iii. spreadsheet attached tooarrow_forward
- Pls provide cash flow diagram if neededarrow_forwardPls provide Cash flow diagram if need. thank youarrow_forwardENGINEERING ECONOMICS For a company that uses a year as its interest period,determine the net cash fl ow that will be recorded at the end of the year from the cash flows shown.arrow_forward
- A loan of P200,000 was to be paid monthly for 1 year at an interest rate of 18 % compounded continuously, the first payment to be made at the end of 4th month and decreasing this amount by 5% every month thereafter. What is the amount of each payment? Construct the amortization schedule. Draw the cash flow diagram. What type of cash flow was described in the problem? Subject : Mechanical Engineering Economicsarrow_forwardIf $100 is invested at 6% interest per year, compounded annually, then the future value of this investment after 4 years isarrow_forwardRose invested P20,000 in a savings bank account that earned 3% simple interest. Find the interest earned if the amount was kept in the bank for 3 years and 6 months.arrow_forward
- don't use excel only formula used. For an interest rate of 8% per year compounded quarterly, determine the number of times interest would be compounded (a) per 2 years, (b) per half year, and (c) per quarter.arrow_forwardThe only time you change the original cash flow diagram in problems involving uniform series cash flows is when the: (a) payment period is longer than the compounding period (b) payment period is equal to the compounding period (c) payment period is shorter than the compounding period (d) stated interest rate is a nominal interest ratearrow_forwardPlease solve by Excel Spreadsheet formulas and give the equations. Thank youarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Economics (12th Edition)EconomicsISBN:9780134078779Author:Karl E. Case, Ray C. Fair, Sharon E. OsterPublisher:PEARSONEngineering Economy (17th Edition)EconomicsISBN:9780134870069Author:William G. Sullivan, Elin M. Wicks, C. Patrick KoellingPublisher:PEARSON
- Principles of Economics (MindTap Course List)EconomicsISBN:9781305585126Author:N. Gregory MankiwPublisher:Cengage LearningManagerial Economics: A Problem Solving ApproachEconomicsISBN:9781337106665Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike ShorPublisher:Cengage LearningManagerial Economics & Business Strategy (Mcgraw-...EconomicsISBN:9781259290619Author:Michael Baye, Jeff PrincePublisher:McGraw-Hill Education
Principles of Economics (12th Edition)
Economics
ISBN:9780134078779
Author:Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:PEARSON
Engineering Economy (17th Edition)
Economics
ISBN:9780134870069
Author:William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:PEARSON
Principles of Economics (MindTap Course List)
Economics
ISBN:9781305585126
Author:N. Gregory Mankiw
Publisher:Cengage Learning
Managerial Economics: A Problem Solving Approach
Economics
ISBN:9781337106665
Author:Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-...
Economics
ISBN:9781259290619
Author:Michael Baye, Jeff Prince
Publisher:McGraw-Hill Education