An engineer developed a fee proposal that requests the owner pay $20,000 after 6 months of work and $40,000 after 12 months. The engineer spent $8.000 developing the proposal and will spend $4,000 each month working on the project. The engineer can borrow funds at enn - 12% per year, invest at eny 6% per year. and desires an MARR of 9%. Using MIRR analysis, determine the attractiveness of this project. O Attractive O Not Attrative O No answer text provided. O No answer text provided.

An engineer developed a fee proposal that requests the owner pay $20,000 after 6 months of work and $40,000 after 12 months. The engineer spent $8.000 developing the proposal and will spend $4,000 each month working on the project. The engineer can borrow funds at enn - 12% per year, invest at eny 6% per year. and desires an MARR of 9%. Using MIRR analysis, determine the attractiveness of this project. O Attractive O Not Attrative O No answer text provided. O No answer text provided.

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

A construction firm is considering establishing an engineering computing center. The center will be equipped with three engineering workstations that cost $45,000 each, and each has a service life of five years. The expected salvage value of each workstation is $2,000. The annual operating and maintenance cost would be $25,000 for each workstation. At a MARR of 15%, determine the equivalent annual cost for operating the engineering center. Click the icon to view the interest factors for discrete compounding when MARR= 15% per year. C The equivalent annual cost is $thousand. (Round to the nearest whole number.) More Info Worth Single Payment Compound Present Amount Factor (F/P, i, N) 1.1500 Compound Amount Factor (F/A, i, N) Factor (P/F, i, N) 0.8896 1.0000 1.3225 0.7561 2.1500 1.5209 0.6575 3.4725 0.5718 4.9934 1.7490 2.0114 0.4972 6.7424 0.4323 8.7537 0.3759 11.0688 2.3131 2.6800 3.0590 3.5179 0.3269 13.7268 0.2843 16.7858 4.0456 0.2472 20.3037 SAWNIN 2 3 4 5 67899 10 Equal Payment…
An IT company receives two new project proposals. Project A will cost $250,000 to develop and is expected to have an annual net cash flow of $50,000. Project B will cost $350,000 to develop and is expected to have an annual net cash flow of $60,000. Analyzing the two projects from a cashflow perspective using the payback period, which project is better? Why? Write the answers in the “Payback" tab of the attached EXCEL template. You may use the Payback Period template if you wish to. Note: Enter the discounted costs and benefits for your project below. Add and delete rows as needed. Year Costs Benefits Cumulative Costs Cumulative Benefits 1 2 3 4
An IT company receives two new project proposals. Project A will cost $250,000 to develop and is expected to have an annual net cash flow of $50,000. Project B will cost $350,000 to develop and is expected to have an annual net cash flow of $60,000. Analyzing the two projects from a cashflow perspective using the payback period, which project is better? Why? Write the answers in the “Payback" tab of the attached EXCEL template. You may use the Payback Period template if you wish to. Note: Enter your criteria, weights, and scores in the template below Insert or clear rows and columns as needed. Double check formulas and results. Criteria Project 1 Project 2 Project 3 Project 4 Project 5 Sponsor Support Strategic Alliance Urgency Fills a market gap Sales Competition Weighted Project Scores 0.00 0 0 0 0 0
EncryptCo is considering a project with a $50,000 first cost that returns $12,000 per year. Assume that it will have a salvage value of $6500 at the end of its service life. The MARR is 12 percent. (a) Calculate the payback period for this project. (b) Calculate the discounted payback period for this project. Use Excel to do this and include the Excel output in your Assignment report.
ABC Service can purchase a new assembler for $15,052 that will provide an annual net cash flow of $6,000 per year for five years. Calculate the NP of the assembler if the required rate of return is 12%. Show calculation. Would you accept/reject a project based on NPV decision criteria? Why? Based on NPV calculated in part A, determine Profitability Index (PI). Show calculation. Would you accept/reject a project based on PI decision criteria? Why?
You are responsible to manage an IS project with a 4-year horizon. The annal cost of the project is estimated at $40,000 per year, and a one-time costs of $120,000. The annual monetary benefit of the project is estimated at $96,000 per year with a discount rate of 6 percent. a. Calculate the overall return on investment (ROI) of the project. b. Perform a break-even analysis (BEA). At what year does break-even occur?
Komfy Karz is evaluating a project (Project A) that costs $325,000 and is expected to generate $200,000 for the next two years. They are also evaluating a project (Project B) that costs $350,000 and is expected to generate $200,000 in the first year and $230,000 in the second year. Komfy's required rate of return for both projects is 13.3%. Upload a file with the following calculations: a) Calculate the NPV for both projects. b) Calculate the IRR for both projects. c) Calculate the payback period for both projects. d) Calculate the discounted payback period for both projects. e) Calculate the cross-over rate.
An engineer has designed 2 alternative systems to cater for customer's plant operation. System 1 will need initial investment of $150,000 and will have an annual operating cost of $20,000 with salvage price of $5,000 after 4 years. System 2 will need an investment of $180,000 and the annual operating cost will be $15,000. System can be salvaged for $8,000 after 6 years. At an interest rate of 10% per year, which system should be proposed by the engineer on the basis of a present worth analysis? Use equations to solve this problem.
As a financial analyst, you must evaluate a proposed project to produce printer cartridges. Theequipment would cost $55,000, plus $10,000 for installation. Annual sales would be 4,000 units at aprice of $50 per cartridge, and the project’s life would be 3 years. At time 0, current assets wouldincrease by $5,000 and payables by $3,000. At the end of 3 years, the equipment could be sold for$10,000, while the working capital will be recovered. Depreciation would be based on the MACRS 3-year class, so the applicable rates would be 33%, 45%, 15%, and 7%. Variable costs would be 70% ofsales revenues, fixed costs excluding depreciation would be $30,000 per year, the marginal tax rate is40%, and the corporate cost of capital is 11%. What are the annual depreciation charges?What are the project’s annual cash flows?
Billabong Tech uses the internal rate of return (IRR) to select projects. Calculate the IRR for each of the following projects and recommend the best project based on this measure. Project T-Shirt requires an initial investment of $ 15,333 and generates cash inflows of $ 7,000 per year for 4 years. Project Board Shorts requires an initial investment of $ 28,500 and produces cash inflows of $ 13,500 per year for 5 years.
The construction of a bypass road needs a capital investment of $200,000 and $10,000 would be required each year for maintenance. The annual benefits to the project have been estimated to be $60,000. The study period(estimated life) of the project is 10 years. The MARR is set at 12%. a. What is the discounted payback period(in years)? b. Determine whether this is a good investment using Modified Benefit-Cost Ratio method with Present Worth(PW). c. Using Conventional Benefit-Cost Ratio method with PW but the MARR is set at 12%, is this project acceptable?
A paper company invests $4m to clear a tract of land and plant some young pine trees. The trees will mature in 10 years, at which time the forest will have a market value of $12m. The required rate of return for long-term projects is 15%. Calculate the internal rate of return for the paper company's investment and decide if the project should be accepted or rejected.