Question

Metalfab Pump and Filter Inc. estimates that the cost of steel bodies for pressure valves will...

Metalfab Pump and Filter Inc. estimates that the cost of steel bodies for pressure valves will increase by $2 every 3 months. If the cost for the first quarter is expected to be $80, what is the present worth of the costs for a 4-year time period at an interest rate of 1.18% per quarter? The present worth is $____?

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Present worth $1,370.53

WORKINGS

Quarter Costs
1 80.00
2 82.00
3 84.00
4 86.00
5 88.00
6 90.00
7 92.00
8 94.00
9 96.00
10 98.00
11 100.00
12 102.00
13 104.00
14 106.00
15 108.00
16 110.00

Sign in - Book1 Excel (Product Activation Failed) & Share Tell me what you want to do Home InsertDrawPage Layout FormulasData Review View File 10A A 쿤므 wrap Text General 田EE ▼ Calibri . Sort & Find & Editing Merge & Center-5 . % , 4,04% Conditional Format as Cell Insert Delete Format Paste ta Filter-Select- Formatting Table Styles Styles Cells Number Font Alignment Clipboard反 A2 xfQuarter Costs 80 -B3+2 -B4+2 -B5+2 -B6+2 -B7+2 -B8+2 -B9+2 B10+2 -811+2 -B12+2 2 Quarter Present worth -NPV(1.18%,B3:B18) 10 8 11 9 12 10 13 11 14 12 15 13 16 14 17 15 18 16 19 B13+2 -B14+2 -B15+2 B16+2 :817+2 Sheet1 + 100 Ready cENG 8:53 AM

Add a comment
Know the answer?
Add Answer to:
Metalfab Pump and Filter Inc. estimates that the cost of steel bodies for pressure valves will...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Metalfab Pump and Filter Inc. estimates that the cost of steel bodies for pressure valves will...

    Metalfab Pump and Filter Inc. estimates that the cost of steel bodies for pressure valves will increase by $2 every 3 months. If the cost for the first quarter is expected to be $80, what is the present worth of the costs for a 4-year time period at an interest rate of 1.18% per quarter? The present worth is

  • The pumping cost for delivering water from the Ohio River to Wheeling Steel for cooling hot...

    The pumping cost for delivering water from the Ohio River to Wheeling Steel for cooling hot rolled steel was $1.8 million for the first 4 years. An effective energy conservation program resulted in a reduced cost of $1.77 million in year 5, and $1.74 million in year 6, and amounts decreasing by $30,000 each year through year 10. What is the present worth of the pumping costs in year 0 at an interest rate of 6% per year? What is...

  • A high-pressure pump at a methane gas (biofuel) plant in Memphis costs $30,000 for installation and...

    A high-pressure pump at a methane gas (biofuel) plant in Memphis costs $30,000 for installation and has an estimated life of 12 years. By the addition of a specialized piece of auxiliary equipment, an annual savings of $400 in operating expense for the pump can be realized, and the estimated life of the pump can be doubled to 24 years. The salvage (market) value of either alternative is negligible at any time. If the MARR is 7% per year, what...

  • The cost to manufacture a firing system component used in a rapid deployment missile defense system...

    The cost to manufacture a firing system component used in a rapid deployment missile defense system was $38,000 the first year however, the company expects the cost to increase by 2% each year. Calculate the present worth of this cost over a 5-year period at an interest rate of 10% per year compounded monthly The present worth of the cost is $

  • A​ high-quality filter for tap water and a reusable drinking container cost $75 and typically will...

    A​ high-quality filter for tap water and a reusable drinking container cost $75 and typically will last for three years. If a family drinks an average of eight cups of water per day​ (one cup is 8 fluid​ ounces), the consumption of water is 547.5 gallons over a​ three-year period. Tap water costs $0.02 per gallon ​Alternatively, bottled water may be purchased in​ 16-ounce bottles for $1.29 each. Compare the present worth of tap filtered water versus bottled water if...

  • (6) A municipal water authority is considering the installation of a new water system. Two options...

    (6) A municipal water authority is considering the installation of a new water system. Two options are being considered. The first option is a steel pipeline with an installation cost of $225 million. Annual maintenance and pumping costs begin at $15 million and increase by $1.0 million per year. The second option is a gravity fed concrete canal with an installation cost of $400 million. Annual maintenance costs begin at $0.5 million and increase by $0.4 million per year. If...

  • Question 20 of 23 Question 20 5 points Weirton Steel signed a 5-year contract to purchase...

    Question 20 of 23 Question 20 5 points Weirton Steel signed a 5-year contract to purchase water treatment chemicals from a local distributor for 55000 per year. When the contract and the cost of the chemicals expected to increase by 550 per year for the next 5 years. If an initial investment in storage tanks is $15.000, and a maintenance cost is $150 per year in the A overall cost over the 10 years. Interest rate 10m. (closest answer) l...

  • 5. A number of intersections on an arterial in the City of Norcross in Metro Atlanta...

    5. A number of intersections on an arterial in the City of Norcross in Metro Atlanta currently have a traffic count of 100,000 cars daily, expected to increase by 1,000 cars/day every year. A consultant for Georgia Department of Transportation has estimated that a new set of traffic signal systems for the intersections will cost $700,000 and save each car passing through an average of $0.005 in fuel, wear and tear, and time. It will cost $45,000/year to operate the...

  • Chris Inc. has accumulated the following information for its second-quarter income statement for 20X2: Sales Cost...

    Chris Inc. has accumulated the following information for its second-quarter income statement for 20X2: Sales Cost of goods sold Operating expenses $ 860,000 430,000 240,000 Additional Information 1. First-quarter income before taxes was $110,000, and the estimated effective annual tax rate was 40 percent. At the end of the second quarter, expected annual income is $600,000, and a dividend exclusion of $30,000 and a business tax credit of $15,000 are anticipated. The combined state and federal tax rate is 50...

  • AN ENGINEERING PROFESSOR OWNS AN 8-YEAR OLD SENTRA OVER THE NEXT FOUR YEARS, HE EXPECTS TO...

    AN ENGINEERING PROFESSOR OWNS AN 8-YEAR OLD SENTRA OVER THE NEXT FOUR YEARS, HE EXPECTS TO MAKE REPAIRS EVERY SIX MONTHS HE GUESSES THAT THE COST OF THE REPAIRS WILL INCREASE BY $50 EACH SEE TIME,STARTING AT $500 THE FIRST TIME,SIX MONTHS FROM NOW WHAT IS THE PRESENT WORTH OF THE REPAIR BILLS OVER THE NEXT FOUR YEARS IF THE INTEREST RATE IS 12% COMPOUNDED SEMI-ANNUALLY (EVERY 6MONTHS)* E.G. FROM ANOTHER INVESTMENT THAT THE MONEY COULD HAVE BEEN USED FOR...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT