When I adjust the cash flows in Excel to reflect the new payment in year 4, no IRRs appear. However, I’m not sure if that’s the correct answer. Could someone help? Your firm has been hired to develop new software for the university's class registration system. Under the contract, you will receive $500,000 asan upfront payment. You expect the development costs to be $447,000 per year for the next 3 years. Once the new system is in place, you willreceive a final payment of $881,000 from the university 4 years from now.a. What are the IRRs of this opportunity? (Hint: Build an Excel model which tests the NPV at 1% intervals from 1% to 40%. Then zero in on therates at which the NPV changes signs.)Suppose you are able to renegotiate the terms of the contract so that your final payment in year 4 will be $1.2 million.c. What is the IRR of the opportunity now? (Select the best choice below.)A. Now there are 3 IRRs.OB. The IRR rule works as before.C. Now there are no IRRS.OD. The IRR rule always gives the wrong answer. 0.010.020.030.040.050.060.070.080.090.10.110.120.130.140.150.160.170.180.190.20.210.220.23500,000-447,000-447,000-447,0001,200,000338,556.0319,518.7301,795.2285,299.3269,951.1255,676.1242,405.0230,073.5218,621.5207,993.3198,136.7189,003.1180,547.3172,726.8165,502.3158,836.7152,695.6147,046.7141,859.7137,106.5132,760.5128,797.0125 192 7#NUM!

IRR IRR is the internal rate of return at which the NPV is equal to zero. IRR is calculated using…

Your firm has been hired to develop new software for the university's class registration system. Under the contract, you will receive $500,000 an upfront payment. You expect the development costs to be $447,000 per year for the next 3 years. Once the new system is in place, you receive a final payment of $881,000 from the university 4 years from now. a. What are the IRRs of this opportunity? (Hint: Build an Excel model which tests the NPV at 1% intervals from 1% to 40%. Then zero in on rates at which the NPV changes signs.) MECHI Suppose you are able to renegotiate the terms of the contract so that your final payment in year 4 will be $1.2 million. c. What is the IRR of the opportunity now? (Select the best choice below.)

Your firm has been hired to develop new software for the university's class registration system. Under the contract, you will receive $500,000 an upfront payment. You expect the development costs to be $447,000 per year for the next 3 years. Once the new system is in place, you receive a final payment of $881,000 from the university 4 years from now. a. What are the IRRs of this opportunity? (Hint: Build an Excel model which tests the NPV at 1% intervals from 1% to 40%. Then zero in on rates at which the NPV changes signs.) MECHI Suppose you are able to renegotiate the terms of the contract so that your final payment in year 4 will be $1.2 million. c. What is the IRR of the opportunity now? (Select the best choice below.)

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 restaurant is considering the purchase of new tables and chairs for their dining room with an initial investment cost of $515,000, and the restaurant expects an annual net cash flow of $103,000 per year. What is the payback period?
If it cost $50,000 to attend a public university today, what would it cost to attend that same university 18 years from now assuming that the cost escalated at a rate of 6% per year (annual compounding)?
An engineering student borrows $4000 to pay tuition for his senior year. Payments are to be made in 36 equal monthly installments, to begin the first month after graduation. How much money must the student repay each month, if he is graduated 9 months after taking out the loan and if the interest rate is 10% per year, compounded quarterly? Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
. A student plans to enroll at the university and plans to continue there until earning a PhD degree (a total time of 9 years). If the tuition for the first 4 years will be $7,200 per year and it increases by 5% per year for the next 5 years, what is the present worth of the tuition cost at an interest rate of 8% per year?
a college can purchase a telephone system for $35000 or lease a system for 5 years for a front-end charge and regular payments of $1500 at the beginning of every quarter (including the first quarter). The system can be purchased at the end of the lease period for $3000 a) should the college lease or buy the system if it can borrow funds at 5% compounded quarterly? b) what is the current economic value of the saving with the lower cost option?
A bag manufacturer will rent a space in a mall for 24 months for an exhibit. The monthly rent is p25,000 and is paid at the beginning of each month. The manufacturer likes to pay a single lump sum at the beginning of the two-year period. He wants to have that lump sum when the exhibit begins, so he needs to invest this amount at 7.5% per annum. How much is that lump sum?
AD Construction, a property developer, is building a property complex consisting of 50 apartments. Apartments are similar in size and proportion - however, can be adapted to suit client needs. AD Construction enters into a contract with customer B. The client wants to buy an apartment and agrees to a total price of CU100,000 per apartment. The payment schedule is as follows: After signing the contract, clients pay a deposit of CU 10,000 each. Milestone: 1 year before the planned completion, AD Construction will send a progress report to the client and the client will have to pay CU 50,000 each. Completion: After construction is completed, the legal ownership of the apartment is transferred to the client and they pay the remaining amount of CU40,000 each. The assumed construction period is 2 years from the contract date. AD Construction has the right to withhold payment from any client in the event that that client fails to pay for the contract prior to its completion. The contract…
A land surveyor just starting in private practice needs a van to carry crew and equipment. He can lease a used van for $8000 per year, paid at the beginning of each year, in which case maintenance is provided. Alternatively, he can buy a used van for $16,000 and pay for maintenance himself. He expects to keep the van for 3 years, at which time he would sell it for an anticipated $3500. Given a MARR of 6%, what is the most the surveyor should pay for uniform annual maintenance to make it worthwhile to buy the van instead of leasing it?
AD Construction, a property developer, is building a property complex consisting of 50 apartments. Apartments are similar in size and proportion - however, can be adapted to suit client needs. AD Construction enters into a contract with customer A. The client wants to buy an apartment and agrees to a total price of CU100,000 per apartment. The payment schedule is as follows:- After signing the contract, clients pay a deposit of CU 10,000 each.- Milestone: 1 year before the planned completion, AD Construction will send a progress report to the client and the client will have to pay CU 50,000 each.- Completion: After construction is completed, the legal ownership of the apartment is transferred to the client and they pay the remaining amount of CU40,000 each. The assumed construction period is 2 years from the contract date. AD Construction has the right to withhold payment from any client in the event that that client fails to pay for the contract prior to its completion. There is no…
A Firm Considering The Installation Of An Automatic Data Processing Unit To Handle Some Of Its Accounting Operations. Machines For That Purpose May Be Purchased For P20, 000 Or Maybe Leased For P 8, 000 For The First Year And P 1, 000 Less Every Year Now And Then Until The End Of The 4th Year. If Money Is Worth 15%, Is It Advisable To Rent Or Buy The Machine?
New Tech Corporation is a rapidly growing biotech company that has a required rate of return of 10%. It plans to build a new facility in Santa Clara County. The building will take 2 years to complete. The building contractor offered New Tech a choice of three payment plans, as follows: More Info • Plan I: Payment of $225,000 at the time of signing the contract and $4,800,000 upon completion of the building. The end of the second year is the completion date. • Plan II: Payment of $1,800,000 at the time of signing the contract and $1,800,000 at the end of each of the 2 succeeding years. • Plan III: Payment of $250,000 at the time of signing the contract and $1,500,000 at the end of each of the 3 succeeding years. 1. Using the net present value method, calculate the comparative cost of each of the three payment plans being considered by New Tech. 2. Which payment plan should New Tech choose? Explain. 3. Discuss the financial factors,…
Because you study at AUIS when you graduate, we expect you to earn $150 more a month than another student who is graduated from another university in Iraq. If you invest and earn 10% interest annually compounding semi-annually on the extra $150 you have earned for your entire working life from age of (22 – 65). What extra value studying at AUIS has given to you? in another-word, what is the future value of the extra money you have earned?