a 20-year study7.24 You work for the New Mexico Department ofTransportation (NMDOT). Two proposals to im-prove street safety and lighting in a colonia in southcentral New Mexico have been proposed. (a) Use aB/C analysis and a discount rate of 8% per year toevaluate the proposals. (b) (Here is a thought ques-tion.) If you reevaluate proposal 1 benefits and findthem to be understated by $100,000 per year, ben-efits will increase from $530,000 to $630,000 peryear. Now, the evaluation (1 vs. DN) will have aB/C = 1.30. There are three questions: (1) Whatwill be the time basis of the incremental evalua-tion? (2) Using the comparison terminology "largerinitial cost" vs. "smaller initial cost," what will bethe order of incremental comparison between thetwo proposals: (1 vs. 2) or (2 vs. 1)? (3) Whichproposal will be selected now? Why?

Step 1:(a) Use a B/C analysis and a discount rate of 8% per year to evaluate the proposals.The…

Answered: a 20-year study 7.24 You work for the…

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter26: Capital Budgeting (capbud)

Section: Chapter Questions

Problem 5R

See similar textbooks

Similar questions

can you answer this question for me as Excel formula ?
Struggling to find the payback period and NPV. I believed pay period to be annual net income+depreciation, then divide that number into initial investment. Please if you can, show me what the right equation is? Thank you for the help in advance. Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows: (Future Value of $1, Present Value of $1. Future Value Annuity of $1. Present Value Annuity of $1.) Note: Use appropriate factor(s) from the tables provided. Initial investment (for two hot air balloons). Useful life Salvage value Annual net income generated BBS's cost of capital Assume straight line depreciation method is used. Required: Help BBS evaluate this project by calculating each of the following: 1. Accounting rate of return. Note: Round your answer to 2 decimal places. $ 536,000 Answer is not complete. 1. Accounting rate of return 2. Payback period…
Dark Skies Observatory is considering several options to purchase a new deep space telescope. Revenue would be generated from the telescope by selling “time and use” slots to various researchers around the world. Four possible telescopes have been identified in addition to the possibility of not buying a telescope if none are financially attractive. The table below details the characteristics of each telescope. An internal rate of return analysis is to be performed. Solve, a. Determine the preferred telescope if MARR is 25%/yr. b. Determine the preferred telescope if MARR is 42%/yr.
K Mc Graw Hill You are asked to evaluate the following two projects for the Norton corporation. Use a discount rate of 13 percent. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. Project X (Videotapes of the Weather Report) ($18,000 Investment) Year Cash Flow 1 $ 9,000 2 7,000 8,000 7,600 3 4 Profitability index Project Y (Slow-Motion Replays of Commercials) ($38,000 Investment) Cash Flow $ 19,000 12,000 13,000 15,000 a. Calculate the profitability index for project X. Note: Do not round intermediate calculations and round your answer to 2 decimal places. Year 1 2 3 4 Profitability index b. Calculate the profitability index for project Y. Note: Do not round intermediate calculations and round your answer to 2 decimal places. c. Which project would you select based on the profitability index? O Project X Project Y Project Y
A. Calculate the profitability index for project X. B. Calculate the profitability for project Y C. Using the NPV method combined with the PI aporoach, which project would you select? Use a discount rate of 13 percent
Q. 3. You have an opportunity to install solar panels on your home. The upfront cost of installing the system is $30,000 and the system is expected to save you $140 per month in electricity costs. The expected lifetime of the system is 25 years. a) Write down the formula for the internal rate of return on this project. b) Use Excel to graph the internal rate of return at different discount rates, ranging from 0% to 10%. Attach your graph. c) Over the last 20 years the rate of return on the U.S. stock market has been an average of 7% (using the annual rate of growth in the Wilshire 5000 index). Given that you could invest your $30,000 in the stock market, does the investment in solar panels make sense from an economic perspective? Why or why not? d) How high would the monthly electricity savings need to be to justify this investment if the internal rate of return needed to be at least 7%.
Help
Please help me. Thankyou.
1. Solve the following three independent scenarios: A. If a copy center is considering the purchase of a new copy machine with an initial investment cost of $150,000 and the center expects an annual net cash flow of $20,000 per year, what is the payback period? Payback period = ? years. Round your Payback Period (PB) answer to one decimal place (i.e. 12.3). B. If a garden center is considering the purchase of a new tractor with an initial investment cost of $120,000, and the center expects a return of $30,000 in year one, $20,000 in years two and three, $15,000 in years four and five, and $10,000 in year six and beyond, what is the payback period? Payback period = ? years. Round your Payback Period (PB) answer to one decimal place (i.e. 12.3). C. A mini-mart needs a new freezer and the initial investment will cost $300,000. Incremental revenues, including cost savings, are $200,000, and incremental expenses, including depreciation, are $125,000. There is no salvage value. What is…
Give me answer
Austins cell phone manufacturer wants to upgrade their product mix to encompass an exciting new feature on their cell phone. This would require a new high-tech machine. You are excited about his new project and are recommending the purchase to your board of directors. Here is the information you have compiled in order to complete this recommendation: According to the information, the project will last 10 years and require an initial investment of $800,000, depreciated with straight-line over the life of the project until the final value is zero. The firms tax rate is 30% and the required rate of return is 12%. You believe that the variable cost and sales volume may be as much as 10% higher or lower than the initial estimate. Your boss understands the risks but asks you to explain the alternatives in a brief memo to the board, Write a memo to the Board of Directors objectively weighing out the pros and cons of this project and make your recommendation(s).
As soon as possible . Thank you

SEE MORE QUESTIONS

Recommended textbooks for you

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Excel Applications for Accounting Principles

Accounting

ISBN:

9781111581565

Author:

Gaylord N. Smith

Publisher:

Cengage Learning

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS