Can someone please help me answer this question using Excel? Previous helper did not help question question is wrong even after I reworked it. Problem 9-2 Relevant Cash Flows [LO 1]Winnebagel Corporation currently sells 29,300 motor homes per year at$79,500 each and 8,300 luxury motor coaches per year at $121,500 each. Thecompany wants to introduce a new portable camper to fill out its product line; ithopes to sell 24,300 of these campers per year at $25,500 each. Anindependent consultant has determined that if the company introduces thenew campers, it should boost the sales of its existing motor homes by 3,900units per year and reduce the sales of its motor coaches by 980 units per year.What is the amount to use as the annual sales figure when evaluating thisproject?Note: Do not round intermediate calculations and round your answer to thenearest whole number, e.g., 32.Net sales$81,063,000 X

Sales revenue refers to the amount received by the company from selling goods and services to the…

What is the amount to use as the annual sales figure when evaluating this project? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. Net sales $ 81,063,000 X

What is the amount to use as the annual sales figure when evaluating this project? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. Net sales $ 81,063,000 X

Fundamentals of Financial Management (MindTap Course List)

14th Edition

ISBN:9781285867977

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter12: Cash Flow Estimation And Risk Analysis

Section: Chapter Questions

Problem 16P: REPLACEMENT CHAIN The Fernandez Company has an opportunity to invest in one of two mutually...

See similar textbooks

Similar questions

Problem 9-2 Relevant Cash Flows [LO 1] Winnebagel Corporation currently sells 29,900 motor homes per year at $82,500 each and 8,900 luxury motor coaches per year at $124,500 each. The company wants to introduce a new portable camper to fill out its product line; it hopes to sell 24,900 of these campers per year at $28,500 each. An independent consultant has determined that if the company introduces the new campers, it should boost the sales of its existing motor homes by 4,500 units per year and reduce the sales of its motor coaches by 1,040 units per year. What is the amount to use as the annual sales figure when evaluating this project?
Problem 10.24Blanda Incorporated management is considering investing in two alternative production systems. The systems are mutually exclusive, and the cost of the new equipment and the resulting cash flows are shown in the accompanying table. If the firm uses a 9 percent discount rate for their production systems,Year System 1 System 20 -$14,800 -$45,662 1 15,037 32,200 2 15,037 32,200 3 15,037 32,200 Compute the IRR for both production system 1 and production system 2. (Round answers to 2 decimal places, e.g. 15.25.)a). IRR of system 1 is __% and IRR of system 2 is ___% b).Which has the higher IRR, System 1 or System 2? c). Compute the NPV for both production system 1 and production system 2. (Round answers to 2 decimal places, e.g. 15.25 or 15.25%.)NPV of system 1 is $ ____ and NPV of system 2 is ____d). Which production system has the higher NPV? System 1 or System 2?
Problem 9-2 Relevant Cash Flows [LO 1] Winnebagel Corp. currently sells 29,200 motor homes per year at $79,000 each and 8,200 luxury motor coaches per year at $121,000 each. The company wants to introduce a new portable camper to fill out its product line; it hopes to sell 24,200 of these campers per year at $25,000 each. An independent consultant has determined that if the company introduces the new campers, it should boost the sales of its existing motor homes by 3,800 units per year and reduce the sales of its motor coaches by 970 units per year. What is the amount to use as the annual sales figure when evaluating this project? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) Net sales
Question 15 of 30 View Policies Current Attempt in Progress -/0.35 ⠀ Carla Vista Corporation is considering adding a new product line. The cost of the factory and equipment to produce this product is $1,856,000. Company management expects net cash flows from the sale of this product to be $400,000 in each of the next eight years. If Carla Vista uses a discount rate of 11 percent for projects like this, what is the net present value of this project? (Round intermediate calculations to 6 decimal places and answer to 2 decimal places, e.g. 52.50. Enter negative amounts using negative sign e.g. -45.25.) NPV $ What is the internal rate of return? (Round intermediate calculations to 6 decimal places and answer to 2 decimal places, e.g. 52.50.) Internal rate of return eTextbook and Media Save for Later Using multiple attempts will impact your score. 20% score reduction after attempt 2 Search % Attempts: 0 of 3 used Submit Answer
Homework, Chapter 26 Determine Cash Flows Natural Foods Inc. is planning to invest in new manufacturing equipment to make a new garden tool. The new garden tool is expected to generate additional annual sales of 5,600 units at $38 each. The new manufacturing equipment will cost $91,000 and is expected to have a 10-year life and a $7,000 residual value. Selling expenses related to the new product are expected to be 4% of sales revenue. The cost to manufacture the product includes the following on a per-unit basis: Direct labor $6.50 Direct materials 21.00 Fixed factory overhead-depreciation 1.50 Variable factory overhead 3.30 Total $32.30 Determine the net cash flows for the first year of the project, Years 2-9, and for the last year of the project. Use the minus sign to indicate cash outflows. Do not round your intermediate calculations but, if required, round your final answers to the nearest dollar. Natural Foods Inc. Net Cash Flows Year 1 Years 2-9 Last Year Initial investment…
c. What is the IRR, and what would be the decision based on the IRR? (Round answer to 2 decimal places, e.g. 15.25.) The IRR of the project is %, and using the IRR rule the project should be Click if you would like to Show Work for this question: Open Show Work rejected accepted
# 40 A firm is must choose to buy the GSU-3300 or the UGA- 3000. Both machines make the firm's production process more efficient which in turn increases incremental cash flows. The GSU-3300 produces incremental cash flows of $24,456.00 per year for 8 years and costs $100,996.00. The UGA-3000 produces incremental cash flows of $28,731.00 per year for 9 years and cost $125,838.00. The firm's WACC is 7.18%. What is the equivalent annual annuity of the GSU-3300? Assume that there are no taxes. Submit Answer format: Currency: Round to: 2 decimal places. unanswered not_submitted Attempts Remaining: Infinity
4 Book Consider two mutually exclusive new product launch projects that Nagano Golf is considering. Assume that the discount rate for Nagano Golf is 16 percent Project A Nagano NP-30. Professional clubs that will take an initial investment of $971,000 at time 0. Next five years (years 1-5) of sales will generate a consistent cash flow of $440,000 per year. Introduction of new product at year 6 will terminate further cash flows from this project Project B Nagano NX-20 High-end amateur clubs that will take an initial investment of $700,000 at time 0. Cash flow at year 1 is $290,000. In each subsequent year, cash flow will grow at 10 percent per year. Introduction of new product at year 6 will terminate further cash flows from this project. Year e 1 2 3 4 NP-30 -$971,000 440,000 440,000 440,000 440,000 440,000 NX-20 -$700,000 290,000 319,000 350,900 Net present value Internal rate of return 385,990 424,589 Complete the following table: (Do not round intermediate calculations. Round the…
[EXCEL] Investment cash flows: Six Twelve, Inc., is considering opening up a new convenience store in downtown New York City. The expected annual revenue at the new store is $800,000. To estimate the increase in working capital, analysts estimate the ratio of cash and cash-equivalents to revenue to be 0.03 and the ratios of receivables, inventories, and payables to revenue to be 0.05, 0.10, and 0.04, respectively, in the same industry. What is the expected incremental cash flow related to working capital when the store is opened? Please use excel
Question 27 PART 1 Miller and Sons is evaluating a project with the following cash flows: Year Cash Flows 0 -$150,000 1 20,000 2 45,000 3 100,000 4 30,000 5 -10,000 The company uses a 7 percent reinvestment rate and a 12 percent discount rate on all of its projects. What is the MIRR of the project using the reinvestment approach? Hint: This information will be used on three related MIRR problems. Group of answer choices 7.76 percent 9.05 percent 8.74 percent 7.05 percent 7.92 percent Question 27 PART 2 Miller and Sons is evaluating a project with the following cash flows: Year Cash Flows 0 -$150,000 1 20,000 2 45,000 3 100,000 4 30,000 5 -10,000 The company uses a 7 percent reinvestment rate and a 12 percent discount rate on all of its projects. What is the MIRR of the project using the combination approach? Hint: This information will be used on three related MIRR problems. Group of answer…
10.5 Net present value: Blanda Incorporated management is considering investing in two alternative production systems. The systems are mutually exclusive, and the cost of the new equipment and the resulting cash flows are shown in the accompanying table. If the firm uses a 9 percent discount rate for production system projects, in which system should the firm invest? Year System 1 System 2 -$15,000 -$45,000 1 15,000 32,000 2 15,000 32,000 15,000 32,000 10.6 Payback: Refer to Problem 10.5. What are the payback periods for production systems 1 and 2? If the systems are mutually exclusive and the firm always chooses projects with the lowest payback period, in which system should the firm invest? 10.7 Payback: Quebec, Inc., is purchasing machinery at a cost of $3,768,966. The company's management expects the machinery to produce cash flows of $979,225, $1,158,886, and $1,881,497 over the next three years, respectively. What is the payback period? 10.8 Payback: Northern Specialties just…
Problem 10.20 Nugent Communication Corp. is investing $9871,647 in new technologies. The company expects significant benefits in the first three years after installation (as can be seen by the following cash flows), and smaller constant benefits in each of the next four years. Year 1 3 4-7 Cash Flows $2,015,329 $5,179,619 $2,934,922 $1,372,250 What is the discounted payback period for the project assuming a discount rate of 10 percent? (Round answer to 2 decimal places, e.g. 15.25. If discounted payback period exceeds life of the project, enter 0 for the answer.) The discounted payback period for the project is years. Click if you would like to Show Work for this question: Open Show Work