Harley worked for many years to save enough money to start his own residential landscape design business. The net cash flows shown are those he recorded for the first 6 years as his own boss. Find the external rate of return using the modified rate of return approach with a reinvestment rate of 15% per year and a borrowing rate of 8%. Additionally, after using the procedure, use the MIRR function to confirm your answer.

Harley worked for many years to save enough money to start his own residential landscape design business. The net cash flows shown are those he recorded for the first 6 years as his own boss. Find the external rate of return using the modified rate of return approach with a reinvestment rate of 15% per year and a borrowing rate of 8%. Additionally, after using the procedure, use the MIRR function to confirm your answer.

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Similar questions

For the nonconventional net cash flow series shown, the external rate of return per year using the MIRR method, with a investment rate of 20% per year and a borrowing rate of 8% per year, is closest to: Year 0 1 2 3 4 NCF, $ -40,000 +19,076 -29,000 +25,000 +54,302
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 solid waste disposal company borrowed money at 10% per year interest to purchase new equipment needed. If the company got the loan 2 years ago and paid it off with a single payment of $4,600,000, a) Identify the engineering economy symbols and their values (PW, FW, i%, n) b) Draw the cash flow c) Calculate the principal amount P of the loan
A company developed a new product that is projected to have $575,000 in sales in year one. These sales projections grow by 6% a year through year 8. What is the future value of sales 8 years from now. The company uses a MARR of 6% per quarter. Interperiod cashflows earn prorated interest.
A small minority firm TheGlobalTrans invested $100,000 for an intersection signal innovation project. At an interest rate of 15% per year, compounded bimonthly, what is the bimonthly income required to recover the investment in 2 years.
At CAE, the engineers estimated that a total of $500,000 will be deposited at the end of next year into a saving account for the repair of an old bridges throughout Amman area. Further, they estimate that the deposits will increase by $100,000 per year for only 9 years thereafter, then cease. The present worth, if public funds earn at a rate of 5% per year is
The population of a small city is 87,000. Find the population in 17 years if the city grows at an annual rate of 2.5% per year.
Costa Rica Savings Bank issues 100,000 bonds as a response to the Costa Rica Central Bank's initiatives to increase domestic saving. The bonds have a face value of $40,000, a bond interest rate of 8% per year payable annually and a maturity date of 14 years. What is the current price one should pay for this bond, if the market interest rate is 9% per year, compounded annually? Requires to answer these questions using EXCEL spreadsheets. I am clueless went it comes to this subject and using EXCEL formulas so it would help if you provided which formula to use and how to enter it into EXCEL to get the correct answer. Don't just post values it will not help I need Excel formulas to enter in Excel. Thank you!
Trial and error is the only way to compute the internal rate of return (IRR) when interest is calculated over five or more periods Select one: True False
Two investments totaling $60,000 produce an annual income of $3410. One investment yields 5% per year, while the other yields 6% per year. How much is invested at each rate?