Question

In: Economics

Please show work, don't just put it in excel: A firm will choose one of two...

Please show work, don't just put it in excel: A firm will choose one of two projects. Both projects have useful lives of 10 years. Project A has an initial cost of $10,000, annual fuel cost of $500 per year, maintenance cost of $100 at the end of year 1 that increases by $25 per year thereafter, a salvage value of $1,000, and annual benefits of $2,300. Project B has an initial cost of $13,000, annual fuel cost of $400 per year, maintenance cost of $100 at the end of year 1 that increases by 10% per year thereafter, a salvage value of $2,000, and annual benefits of $2,500. Evaluate the present worth using an interest rate of 8 percent, compounded annually.

1.What is the present worth of project A ($)?

2.What is the present worth of the annual benefits for Project B ($)?

3.What is the present worth of Project B ($)?

4.Suppose that Project A has a present worth of $1,294 and that project B has a present worth of $1,105 (these are not the correct answers to prior parts of the problem), which project is preferred?

5.Suppose that the interest rate is 6.7 percent. At this interest rate, what is: 1. the net present value of Project A ($)? 2. the net present value of Project B ($)? 3. from an engineering perspective, is there any significant difference in the present value of these two projects (y/n)?

Solutions

Expert Solution


Related Solutions

please don't do it by excel, do it manually and show work! 1. A manufacturing company...
please don't do it by excel, do it manually and show work! 1. A manufacturing company decides to buy solar cells in anticipation of rising electricity costs. The company is modeling its purchase to save it $20,000 for the first year, and this saving increases 5% each year for the next 20 years as the solar cells generate enough electricity to compensate for the rising power bills. If the expected rate of return for the company equals 8%, what is...
Please do it in Excel and show detailed work I'm really confused about how to put...
Please do it in Excel and show detailed work I'm really confused about how to put the Z- value on Excel. I will rate you! The crab spider, Thomisus spectabilis, sits on flowers and preys upon visiting honeybees. Do honeybees distinguish between flowers that have crab spiders and flowers that do not? To test this, Heiling et al. (2003) gave 33 bees a choice between 2 flowers: one with, and one without a crab spider. In 23 of the 33...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
PLEASE SHOW WORK IN EXCEL WITH FORMULA You are constructing a two stock portfolio based on...
PLEASE SHOW WORK IN EXCEL WITH FORMULA You are constructing a two stock portfolio based on the information provided below. What dollar amount will you invest in each stock to achieve the desired return goal? Stock X Stock Y Expected Return 14.0% 9.0% Goal Return of Portfolio: 10.00% Dollar Amount to Invest: $20,000
Please show work and formulas used for excel The SK Industries, Inc. manufactures and sells two...
Please show work and formulas used for excel The SK Industries, Inc. manufactures and sells two products, Accel Active and Accel Regular. In September 2018, SK Industries Budget Department gathered the following data in order to prepare budgets for 2019: 2019 Projected Sales Product Units Price Accel Active 45,000 $225 Accel Regular 75,000 $155 Expected Target Inventories Product January 1, 2019 December 31, 2019 Accel Active 9,000 12,000 Accel Regular 17,000 25,000 The following direct materials are expected to be...
Please show work A firm with a 14% WACC is evaluating two projects for this year's...
Please show work A firm with a 14% WACC is evaluating two projects for this year's capital budget. After-tax cash flows, including depreciation, are as follows: 0 1 2 3 4 5 Project M -$15,000 $5,000 $5,000 $5,000 $5,000 $5,000 Project N -$45,000 $14,000 $14,000 $14,000 $14,000 $14,000 Calculate NPV for each project. Round your answers to the nearest cent. Do not round your intermediate calculations. Project M    $ Project N    $ Calculate IRR for each project. Round your answers to two...
In EXCEL Please: you must show your work in Excel, which includes providing the formulas in...
In EXCEL Please: you must show your work in Excel, which includes providing the formulas in the cells, not just the summary value. You may not earn full points if you do not show your work in detail. JLR Enterprises provides consulting services throughout California and uses a job-order costing system to accumulate the cost of client projects. Traceable costs are charged directly to individual clients; in contrast, other costs incurred by JLR, but not identifiable with specific clients, are...
Please show all work A firm produces two types of products, A and B. The total...
Please show all work A firm produces two types of products, A and B. The total profit, P(x, y), in thousands of dollars, for selling x thousand units of A and y thousand units of B is P(x, y) = –5x2 – 2y2 – 2xy + 24x + 12y – 20. Find the amounts of x and y that maximize P(x, y).      x = ___,     y = ___.
Please use excel and show all work and formulas. (I will give your work a like...
Please use excel and show all work and formulas. (I will give your work a like if you do this) Size (1000s sq. ft) Selling Price ($1000s) 1.26 117.5 3.02 299.9 1.99 139.0 0.91 45.6 1.87 129.9 2.63 274.9 2.60 259.9 2.27 177.0 2.30 175.0 2.08 189.9 1.12 95.0 1.38 82.1 1.80 169.0 1.57 96.5 1.45 114.9 What are the p-values of the t test (for the slope estimate) and F test? What is the coefficient of determination? What is...
Note: You need to show your work. If you choose to use Excel for your calculations,...
Note: You need to show your work. If you choose to use Excel for your calculations, be sure to upload your well-documented Excel and to make note in this file how you arrived at your answers. If you choose to do the work by hand, Microsoft Word has an equation editor. Go to “Insert” and “Equation” on newer versions of Word. On older versions, go to “Insert” and “Object” and “Microsoft Equation.” Chapter 8 Reflection: The National Center for Education...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT