please do it in excel way and give me the excel formula, picture attached in excel A1
Fantastic news! We've Found the answer you've been seeking!
Question:
please do it in excel way and give me the excel formula, picture attached in excel
Transcribed Image Text:
A1 X Net Present Value Method A B C D E Nel Present Value Method 2 3 The following data are accumulated by Waiola Company in evaluating the purchase of equipment, having a four-year useful life: 4 5 DATA 6 Net Income Net Cash Flow 7 Year 1 $45,500 $83,000 8 Year 2 24,000 61,500 9 Year 3 20,000 57,500 10 Year 4 4,000 41,500 11 12 Cost of equipment 13 Desired rate of return 14 15 REQUIRED: $150,000 10% 16 Determine the net present value for the proposal Using formulas and cell references from the problem data, perform the required 17 analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWV2 for grading. 18 19 20 Net present value 21 22 23 24 25 26 " Amount Formula 000 H A1 X Net Present Value Method A B C D E Nel Present Value Method 2 3 The following data are accumulated by Waiola Company in evaluating the purchase of equipment, having a four-year useful life: 4 5 DATA 6 Net Income Net Cash Flow 7 Year 1 $45,500 $83,000 8 Year 2 24,000 61,500 9 Year 3 20,000 57,500 10 Year 4 4,000 41,500 11 12 Cost of equipment 13 Desired rate of return 14 15 REQUIRED: $150,000 10% 16 Determine the net present value for the proposal Using formulas and cell references from the problem data, perform the required 17 analysis. Formulas entered in the green cells show in the orange cells. Transfer amounts to CNOWV2 for grading. 18 19 20 Net present value 21 22 23 24 25 26 " Amount Formula 000 H
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
On average, which group of borrowers would have to pay a higher effective rate for its short-term loans, those who are required to put up collateral or those who are not? Explain.
-
The following table summarizes the rules of debit and credit. For each of the items (a) through (l), indicate whether the proper answer is a debit or acredit. Normal Balance Increase Decrease Balance...
-
What is the fundamental matrix, and how is it used in determining equilibrium conditions?
-
Suppose we have a volume of nitrogen plus a small amount of water vapor at \(1.0 \mathrm{~atm}\). The walls of the container are at \(25^{\circ} \mathrm{C}\), and there is a hot pipe at \(105^{\circ}...
-
a. For the OA fraud questions, identify the 16 variables that have the strongest correlation (in absolute value) with whether or not a company was involved in fraudulent activities (use Excels...
-
Simms Corp. is considering a project that has the following cash flow data. The WACC of Simms is 14.64%. Using the IRR method, will Simms accept this project? Year 0 1 2 3 -$1,000 $425 $425 $425 Cash...
-
Use the given data set to complete parts (a) through (c) below. (Use = 0.05.) X y 10 9.15 8 8.15 13 8.73 Click here to view a table of critical values for the correlation coefficient. 9 11 8.76 9.27...
-
You have recently been appointed sales manager of a company selling abrasives to the motor trade. Sales are declining and you believe that a major factor causing this decline is a lack of motivation...
-
Savage, CPA, has been requested by an audit client to perform a nonrecurring engagement involving the implementation of a computer information and control system. The client requests that in setting...
-
In each of the following cases, indicate whether there is a violation of the rule on independence of the AICPA Code of Professional Conduct. Support your answer. a. A CPA is a director of a...
-
Give two examples of each of the following, with appropriate justification of products or services that tend to utilise: (a) a straight commission remuneration system; (b) a straight salary...
-
The four geographical regions of the United States recognized by the U.S. Census Bureau are listed. Northeast South Midwest West
-
Calculate the goodwill of firm on the basis of years purchase of the weighted average profit of the last four year. The appropriate weight to be used and profits are: Year 2014-15 2015-16 2016-17...
-
1. Below is depicted a graph G constructed by joining two opposite vertices of C12. Some authors call this a "theta graph" because it resembles the Greek letter 0. a. What is the total degree of this...
-
Milton Company planned to produce 21,000 units of its only product during the year. Milton established the following standard cost data for this product prior to the beginning of the year: Assume...
-
In building factories to manufacture 50 -inch TV screens, how might companies build risk factors into their financial analyses?
-
Jacobs Company manufactures a single product and uses a standard costing system. The nature of its product dictates that it be sold in the period it is produced. Thus, no ending work in process or...
Study smarter with the SolutionInn App