EBK BASICS OF ENGINEERING ECONOMY
2nd Edition
ISBN: 8220100255052
Author: Blank
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 1, Problem 63P
To determine
Identify the engineering economy symbol for the spread sheet function.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
A $10,000 loan amortized over 5 years at an interest rate of 10% per year requires payments of $2638 to completely remove the loan when interest is charged on the unrecovered balance of the principal. If interest is charged on the original principal instead of the unrecovered balance, what is the loan balance after 5 years, provided the same $2638 payments are made each year?
State the purpose for each of the following built-in spreadsheet functions:a. FV(i%,n,A,P)b. IRR(first_cell:last_cell)c. PMT(i%,n,P,F)d. PV(i%,n,A,F)
What are the values of the engineering economy symbols P, F, A, i, and n in the following spreadsheet or TVM calculator functions? Use a “?” for the symbol that is to be determined.a. FV(8%,10,2000,-10000)b. PMT(12%,30,16000)c. PV(9%,15,1000,700)d. n(8.5,5000,-50000,20000)
Chapter 1 Solutions
EBK BASICS OF ENGINEERING ECONOMY
Ch. 1 - Prob. 1PCh. 1 - Which of the following would be considered...Ch. 1 - Prob. 3PCh. 1 - Prob. 4PCh. 1 - Prob. 5PCh. 1 - Prob. 6PCh. 1 - Prob. 7PCh. 1 - Prob. 8PCh. 1 - Prob. 9PCh. 1 - What is meant by the term time value of money?
Ch. 1 - Prob. 11PCh. 1 - Of the fundamental dimensions length, mass, time,...Ch. 1 - Prob. 13PCh. 1 - When an interest rate statement does not include a...Ch. 1 - Prob. 15PCh. 1 - Prob. 16PCh. 1 - Prob. 17PCh. 1 - Prob. 18PCh. 1 - Prob. 19PCh. 1 - Prob. 20PCh. 1 - Prob. 21PCh. 1 - Prob. 22PCh. 1 - Prob. 23PCh. 1 - Prob. 24PCh. 1 - Prob. 25PCh. 1 - Prob. 26PCh. 1 - Prob. 27PCh. 1 - Prob. 28PCh. 1 - How many years does it take for an investment of...Ch. 1 - Prob. 30PCh. 1 - Prob. 31PCh. 1 - Prob. 32PCh. 1 - Prob. 33PCh. 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 - Prob. 44PCh. 1 - At 9% per year simple interest, 1000 is equivalent...Ch. 1 - Prob. 46PCh. 1 - Prob. 47PCh. 1 - Prob. 48PCh. 1 - Prob. 49PCh. 1 - Prob. 50PCh. 1 - Prob. 51PCh. 1 - Prob. 52PCh. 1 - Prob. 53PCh. 1 - Prob. 54PCh. 1 - Prob. 55PCh. 1 - Prob. 56PCh. 1 - Prob. 57PCh. 1 - Prob. 58PCh. 1 - Prob. 59PCh. 1 - Prob. 60PCh. 1 - Prob. 61PCh. 1 - Prob. 62PCh. 1 - Prob. 63PCh. 1 - Prob. 64PCh. 1 - Prob. 65PCh. 1 - Prob. 66PCh. 1 - Prob. 67PCh. 1 - Prob. 69APQCh. 1 - Prob. 70APQCh. 1 - Prob. 71APQCh. 1 - Prob. 72APQCh. 1 - An investment of 8,000 nine years ago has...Ch. 1 - Prob. 74APQCh. 1 - Prob. 75APQCh. 1 - Prob. 76APQCh. 1 - Prob. 77APQ
Knowledge Booster
Similar questions
- How much will Kingston Technologies have to pay each year in eight equal payments, starting 2 years from now, to repay a $900,000 loan? The interest rate is 8% per yeararrow_forwardFor the factor (F∕P,10%,43), find the percent difference between the interpolated and formula-calculated values, assuming the formula-calculated value is the correct one.arrow_forwardA small minority firm TheGlobalTrans invested $100,000 for an intersection signal innovation project. At an interest rate of 15% per year, compounded bimonthly, what is the bimonthly income required to recover the investment in 2 years.arrow_forward
- A Texas chemical company had to file for bankruptcy because of a nationwide phaseout of methyl tertiary butyl ether (MTBE). The company is in the planning phase of reorganizing and expects to invest $50 million in a new ethanol production facility. Determine the revenue necessary each month to recover its investment in 3 years, plus interest at a rate of 2% per month, compounded continuously. Solve by (a) formula, and (b) spreadsheet functionarrow_forwardDetermine the exact simple interest on Php 1,000,000invested for the period from October 24, 1987 to January 7,1990, if the rate of interest is 17%. Provide a summary for the answer thanks!arrow_forwardDetermine the exact simple interest on $5000 invested for the period from January 15,1996 to October 12,1996, if the rate of interest is 18 %,arrow_forward
- Find the value of APC if the C is 1123 billion and Y is 211 billionarrow_forwardSince your first birthday, your grandparents have been depositing $110 into a savings account every month. The account pays 12% interest annually. Immediately after your grandparents make the deposit on your 18th birthday, the amount of money in your savings account will be closest to ________.arrow_forwardA company that manufactures general-purpose transducers invested $2 million 4 years ago in high-yield junk bonds. If the bonds are now worth $2.8 million, what rate of return per year did the company make on the basis of (a) simple interest, and (b) compound interest? (c) What is the spreadsheet function to find the answer for compound interest?arrow_forward
- Are all the cash flows estimated in actual dollars?arrow_forwardAn engineer has just borrowed P800,000 from a local bank, at the rate of 1% per month on the unpaid balance. His contract states that he must repay the loan in 36 equal monthly installments. How much money must he repay each month?arrow_forwardA company wants to start a recapitalization pool for replacement of network servers. If the company invests $5000 at the end of year 1 and increases the amount invested by 5% each year, how much will be in the account 5 years from now? Interest is earned at a rate of 8% per year. Northrop Grumman will purchase a new automated 3D printer for a component it manufactures. The printer vendor requires no payment upon delivery of the printer, but requires annual payments of $5,000 that will start three years from now (in year 3) and continue through year 6. Northrop Grumman would like to set aside today an amount of money to cover the future annual payments. How much should they set aside now if the interest rate is 10%? Aerojet Rocketdyne is providing an annual maintenance contract to one of its customers. The contract will begin five years from now after the warranty period is over. The customer will pay $5,000 in year 5, with that amount increasing by 3% per year in years 6-10 (a…arrow_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