Determine the equivalent future worth of the savings

Assignment Help Accounting Basics
Reference no: EM132768136

Problem - Create an MS Excel file (and use its functions) to answer the following problem/s. Make sure to use cell referencing for the variables. Do not forget to highlight the final answer.

The Southwestern Electricity and Water Authority authorized construction projects totaling $1.08 million to improve desalination plant efficiency and salinity-reduction technology for reject chemicals. Three bids from potential vendors were received in the amounts of $1.05, $1.063 and 51.075 million. Assume the savings will be realized immediately for each bid, were it accepted. Use an expected life of 10 years and the interest rate is 6% per year to do the following for the savings anticipated from the bids:

a. Determine the equivalent future worth of the savings.

b. Determine the equivalent annual worth of the savings.

c. Prepare a chart to visualize parts (a) and (b).

Reference no: EM132768136

Questions Cloud

Differences between financial and managerial accounting : Illustrate how Alhekmais doing relative to its competitors - Describe the differences between merchandising and manufacturing companies with respect to income
Would the juvenile be dealt with as a delinquent : Complete the required reading and presentations in the Reading & Study folder of Module/Week 3. Then, answer the following discussion board question
Develop the outline of a quality plan for a project : Project Quality Management - What quality items were compromised because of time, resourcing or other constraints and Were measurable items specified?
What more could be done to prevent the crime you chose : Speak to the prevalence of Cybercrime. Research national statistics using the FBI database we learned about in Week 2. Detail those statistics.
Determine the equivalent future worth of the savings : Three bids from potential vendors were received in the amounts of $1.05, $1.063 and 51.075 million. Determine the equivalent future worth of the savings
What outcomes have been realized due to the new hr strategy : What outcomes have been realized due to the new HR strategy? What challenges do global organizations face when establishing HR policies?
How much is the adjusted cash receipts in July : Kriselda Co. has the following information for the months of June and July. How much is the adjusted cash receipts in July
Determine cost of goods manufactured : Determine the sales required in dollars to earn net income of $200,000 and Describe the differences between merchandising and manufacturing companies
How much is the amount of bonus to or LONZO : Under the Bonus Method, if the partner agreed to have a capital ratio of 40:60 for LONZO and BRANDON respectively, how much is the amount of bonus to or LONZO

Reviews

Write a Review

Accounting Basics Questions & Answers

  Compute beneficial''s 2012 regular income tax liability

Beneficial's QPAI for purposes of the domestic production activites deduction is 600,000. Compute Beneficial's 2012 regular income tax liability and its AMT.

  Describe an alternative income-statement format that would

alberta gauge company ltd. a small manufacturing company in calgary alberta manufactures three types of electrical

  What is the new divisor for the index

Suppose that Douglas McDonnell shareholders approve a 7-for-1 stock split on January 1, 2017. What is the new divisor for the index

  Record the sale of the equipment

Computer equipment (office equipment) purchased 6 1/2 years ago for $170,000, Record the sale of the equipment

  Produce evidence about certain assertions

As discussed in class the six general audit procedures will produce evidence about certain assertions

  Explain the reasons for adjusting entries

Explain the reasons for adjusting entries, closing and reversing entries. Discuss with illustrations and examples, the complete accounting cycle

  What is the cost per unit for product a

Shed Industries produces two products. The products' identified costs are as follows. What is the cost per unit for product A?

  What are self-directed teams

What are self-directed teams? What are the purposes of self-directed teams using in accounting? Briefly discuss three characteristics or elements of it

  What is its contribution margin

If the Sorin company sells 4,600 units, what is its contribution margin? Show the answer using the contribution margin ratio

  Describe a merchandiser cost of goods sold

Identify which items are subtracted from the list amount and not recorded when computing purchase price: (a) freight-in; (b) trade discount.

  Compute for the dividend per share

CACA Co. has the following shareholders' equity accounts: 8% Preference Share, P10 par P200,000 Ordinary share, P6 par P300,000, Accumulated Profit P100,000.

  Trowbridge company has just completed the processing

Trowbridge Company has just completed the processing of its year-end payroll and distributed all the weekly paychecks. The payroll department is now computing the amount of the annual bonus to be given each worker.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd