Question
I need to the worksheet on (Excel) for all of them.
5.2 NRG Energy plans to construct a giant solar plant in Santa Teresa, NM to supply electricity to 30,000 southern NM and western TX homes. The plant will have 390,000 heliostats to concentrate sunlight onto 32 water towers to generate steam NRG will spend $560 million in constructing the plant and $430,000 per year in operating it. If a salvage value of 20% of the initial cost is assumed, how much will the company have to make each year for 15 years in order to recover its investment at a MARR of 18% per year?
5.22 Calculate the infinite-life equivalent annual cost of $5,000,000 in year 0, $2,000,000 in year 10, and $100,000 in years 11 through infinity. The interest rate is 10% per year.
media%2F643%2F643b4b29-0e34-4ea1-a282-c9
5.19 Estimates have been presented to Holly Farms, which is considering two environmental chambers for a project that will detail laboratory confirma- tions of on-line bacteria tests in chicken meat for of E coli 0157:H7 and Listeriamono- cytogenes. (a) If the project will last for 6 years and 1-10% per year, perform an AW evaluation to determine which chamber is more economical (b) Chamber D103 can be purchased with differ- ent options and, therefore, at different installed costs. They range from $300,000 to $500,000. Will the selection change if one of these other models is installed? (c) Use single-cell spread- sheet functions to solve part (b). the presence Chamber D103 Chamber 490G Installed cost, S -400,000 -250,000 Annual operating cost $ per year Salvage value at 10% of P, $ -4000 -3000 40,000 25,000 Life, years
5.9 A small commercial building contractor pur- chased a used crane 2 years ago for $60,000. Its operating cost was $2500 in month one, $2550 in month two, and amounts increasing by $50 per month through the end of year two (now). If the crane was sold for $48,000 now, what was its equivalent monthly cost at an interest rate of 1% per month?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

As per HOMEWORKLIB RULES first question is answered

Kindly ask rest of the questions in a separate post

Add a comment
Know the answer?
Add Answer to:
I need to the worksheet on (Excel) for all of them. 5.2 NRG Energy plans to...
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
  • I wanna have a spreadsheet in excel (b & c). 5.19 Estimates have been presented to...

    I wanna have a spreadsheet in excel (b & c). 5.19 Estimates have been presented to Holly Farms, which is considering two environmental chambers for a project that will detail laboratory confirma- tions of on-line bacteria tests in chicken meat for of E coli 0157:H7 and Listeriamono- cytogenes. (a) If the project will last for 6 years and 1-10% per year, perform an AW evaluation to determine which chamber is more economical (b) Chamber D103 can be purchased with differ-...

  • NRG Energy plans to construct a giant solar plant in Santa Teresa, NM to supply electricity...

    NRG Energy plans to construct a giant solar plant in Santa Teresa, NM to supply electricity to 30,000 southern NM and west TX homes. The plant will have 390,000 heliostats to concentrate sunlight onto 32 water towers to generate steam. NRG will spend $560 million in constructing the plant and $430,000 per year in operating it. If a salvage value of 20% of the initial cost is assumed, how much will the company have to make each year (i.e., AW)...

  • Hi there, I have problem-solving this question, would definitely need help to explain if we need ...

    Hi there, I have problem-solving this question, would definitely need help to explain if we need to look for the taxable income portion: Question: Topless:- A sporty convertible with a cost of $100,000 and a useful life of 5 years. It will produce rental income of $60,000 per year and operating costs of $10,000 per year. A major service is required after 3 years costing $15,000. A salvage value of $25,000 is expected after 5 Years. The required return is...

  • Please don’t use Excel and answer all the parts of the questions. Make sure to show your work!! Problem 3 Machine...

    Please don’t use Excel and answer all the parts of the questions. Make sure to show your work!! Problem 3 Machine Useful Life 20 yrs II 25 yrs Initial Cost Salvage Value Annual Operating Cost $80,000 $20,000 $18.000 $100,000 $25,000 $15,000 first 10 years 20,000 thereafter A company is considering buying a new piece of machinery. A 10 percent interest rate will be used in the computations. Two models of the machine are available. a. Determine which machine should be...

  • Edit: Please do not use Excel as I need to learn to solve without it. thank...

    Edit: Please do not use Excel as I need to learn to solve without it. thank you. Problem 4 After paying $3 million for a feasibility study, Stanley wrote a proposal with the following cash flow estimates for a 25-year capital project. Equipment cost: $34 million, Shipping costs: $1 million, Installation: S19 million, Salvage: $4, Working capital investment: $2 million, Revenues are expected to increase by $20 million per year and cash operating expenses by $9 million per year. The...

  • please use excel to answer the questions and show all outputs E3) The Erley Equipment Company...

    please use excel to answer the questions and show all outputs E3) The Erley Equipment Company purchased a machine 5 years ago at a cost of $100,000. The machine had an expected life of 10 years at the time of purchase, and an expected salvage value of $10,000 at the end of the 10 years. It is being depreciated by the straight line method toward a salvage value of $10,000, or by $9,000 per year. A new machine can be...

  • I need help finding the numbers for the empty boxes. Can someone help me out? Thank...

    I need help finding the numbers for the empty boxes. Can someone help me out? Thank you. Crane Processing Company performs word-processing services for business clients and students in a university community. The work for business clients is fairly steady throughout the year. The work for students peaks significantly in December and May as a result of term papers, research project reports, and dissertations. Two years ago, the company attempted to meet the peak demand by hiring part-time help. This...

  • The answer is shown in the picture, i want to know how they got it, please show all your work and if you are using excel please show your formulas, Thank You and good luck. Toll lanes on a section of...

    The answer is shown in the picture, i want to know how they got it, please show all your work and if you are using excel please show your formulas, Thank You and good luck. Toll lanes on a section of the 1-40 freeway are being considered in order to reduce traffic congestion and travel times Since this is a government project, the B-C ratio method must be applied in the evaluation. Construction costs of the project are estimated to...

  • I need you to work this assignment out using excel. It will be a huge help to me. Thanks.

    I need you to work this assignment out using excel. It will be a huge help to me. Thanks. The ABC Project 1 3 The ABC Company currently markets its chocalate and other related products. 4While seeking expansion ideas, management of the company decided to look into the possibility of a line of the new product. 5 Entry into this business would require the purchase of an existing 50-acre land in Atalanta GA at a cost of $250,000 for the...

  • Please, I need the answer and the approaches step by step( all the information about how...

    Please, I need the answer and the approaches step by step( all the information about how to get the data) in an easy way for my understanding Thanks! Question.3 As the accountant for Gamble Limited you have the responsibility for eveluating capi proposals. For th of both proposals are as follows al. Details e coming year the following two proposals have been presented for your approv Proposal X This project will require an initial investment of є500 000 n plant...

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