How would I go about charting this in Excel. I'm having trouble on which data I need to select out of the first table in order to make the chart in the picture look the same as in the other picture. Discount rate8%Assume the project is completed in Year 0Year13 TotalCosts140,000 40,000| 40,000| 40,000|Discount factor0.930.860.79Discounted costs140,000 37,200| 34,400| 31,600 243,200|O 200,000 200,000 200,000|0.790 186,000 172,000 158,000 516,000BenefitsDiscount factor0.930.86Discounted benefitsDiscounted benefits - costs (140,000) 148,800 137,600 126,400 272,800 NPVCumulative benefits - costs (140,000) 8,800 146,400 272,800ROI112%Payback in Year 1 Payback600,000-500,000-400,000-Payback$ 300,000 -200,000 -100,000-12Year- Cumulative costs Cumulative benefits

Answered: Image /qna-images/answer/da89f1bd-c651-4c7e-bbd6-4498d3d78e73.jpg

Discount rate 8% Assume the project is completed in Year 0 Year 1 2 3 Total Costs Discount factor Discounted costs 140,000 40,000 40,000 40,000 0.79 1 0.93 0.86 140,000 37,200 34,400 31,600 243,200 Benefits 0 200,000 200,000 200,000 Discount factor 1 0.93 0.86 0.79 Discounted benefits 0 186,000 172,000 158,000 516,000 Discounted benefits - costs (140,000) 148,800 137,600 126,400 272,800 NP Cumulative benefits - costs (140,000) 8,800 146,400 272,800 ROI 112% Payback in Year 1

Discount rate 8% Assume the project is completed in Year 0 Year 1 2 3 Total Costs Discount factor Discounted costs 140,000 40,000 40,000 40,000 0.79 1 0.93 0.86 140,000 37,200 34,400 31,600 243,200 Benefits 0 200,000 200,000 200,000 Discount factor 1 0.93 0.86 0.79 Discounted benefits 0 186,000 172,000 158,000 516,000 Discounted benefits - costs (140,000) 148,800 137,600 126,400 272,800 NP Cumulative benefits - costs (140,000) 8,800 146,400 272,800 ROI 112% Payback in Year 1

Algebra & Trigonometry with Analytic Geometry

13th Edition

ISBN:9781133382119

Author:Swokowski

Publisher:Swokowski

Chapter10: Sequences, Series, And Probability

Section10.3: Geometric Sequences

Problem 82E

See similar textbooks

Similar questions

Continued This is a continuation of Exercise 13. As we saw earlier, the stock turnover rate of an item is the number of times that the average inventory of the item needs to be replaced as a result of sales in a given time period. Suppose that a hardware store sells 80 shovels each year. a. Suppose that the hardware store maintains an average inventory of 5 shovels. What is the annual stock turnover rate for the shovels? How is this related to the yearly number of orders to the wholesaler needed to restock inventory? b. What would he the annual stock turnover rate if the store maintained an average inventory of 20 shovels? c. Write a formula expressing the annual stock turnover rate as a function of the average inventory of shovels, identify the function and the variable, and state the units.
Comparing Three Depreciation Methods Waylander Coatings Company purchased waterproofing equipment on January 6 for $561,600. The equipment was expected to have a useful life of four years, or 9,200 operating hours, and a residual value of $46,400. The equipment was used for 3,500 hours during Year 1, 2,900 hours in Year 2, 1,700 hours in Year 3, and 1,100 hours in Year 4. Required: 1. Determine the amount of depreciation expense for the years ended December 31, Year 1, Year 2, Year 3, and Year 4, by (a) the straight-line method, (b) the units-of-activity method, and (c) the double-declining-balance method. Also determine the total depreciation expense for the four years by each method.Note: Round the answer for each year to the nearest whole dollar. see chart
Taxable income Rate $0 — $9,525 10.0% $9,526 — $38,700 12.0% $38,701 — $82,500 22.0% $82,501 — $157,500 24.0% $157,501 — $200,000 32.0% $200,001 — $500,000 35.0% $500,001 or more 37% Using the previous tax table, compute the tax liability for the individual in the scenario presented, rounding the liability to the nearest dollar. In addition, use the dropdown lists to identify the marginal tax rate and average tax rate for the individual in the scenario. Ginny’s Tax Scenario Ginny is a professional with taxable income of $24,525. What is Ginny’s total tax liability? (Note: Round your answer to the nearest cent, if necessary.) What is Ginny’s top marginal tax rate? What is Ginny's average tax rate?
Special promotion—effects of a 1-cent sale The management of Rocko’sPizzeria is considering a special promotion for the last two weeks of May, which is normally a relatively low-demand period. The special promotion would involve selling two medium pizzas for the price of one, plus 1 cent. The medium pizza normally sells for $9.99 and has variable expenses of $3. Expected sales volume without the special promotion is 400 medium pizzas per week. Required:a. Calculate the total contribution margin generated by the normal volume of medium pizzas in a week.b. Calculate the total number of medium pizzas that would have to be sold during the 1-cent sale to generate the same amount of contribution margin that results from the normal volume.c. What other factors should management consider in evaluating the pros and cons of the special promotion?
The diversifiable risk of a portfolio:a. Is correlated with systematic risk.b. Can be made sufficiently small.c. Is zero in the real world.d. Is the risk that investors lose because of transaction costs.