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. Year NCF, $ -9,000 1 4,100 4 5 12,000 700 2 -3,400 -7,000 750 The external rate of return is % per year. The spreadsheet function is =RATE(6,,-17472,25672) ♥

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. Year NCF, $ -9,000 1 4,100 4 5 12,000 700 2 -3,400 -7,000 750 The external rate of return is % per year. The spreadsheet function is =RATE(6,,-17472,25672) ♥

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 18EB: Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the...

See similar textbooks

Similar questions

Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?
Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the following cash flows over the next five years: $99,000, $88,000, $92,000. $87,000, and $72,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel. see Appendix C.
The business plan for KnowIt, LLC, a start-up company that manufactures portable multi-gas detectors, showed equivalent annual cash flows of $400,000 for the first 5 years. If the cash flow in year 1 was $320,000 and the constant increase thereafter was $50,000 per year, what interest rate was used in the calculation? (Solve using factors or a spreadsheet as requested by your instructor.)
In the provided scenario, you address the time value of money also known as discounted cash flow analysis. This type of analysis is crucial to being able to viably analyze financial statements. The start - up firm you founded is trying to save $10, 000 in order to buy a parcel of land for a proposed small warehouse expansion. In order to do so, your finance manager is authorized to make deposits of S 1250 per year into the company account that is paying 12% annual interest. The last deposit will be less than $1250 if less is needed to reach $10,000. How many years will it take to reach the $10,000 goal and how large will the last deposit be? Show your work
You have just been employed as an investment analyst in an investment bank. You took over fromsomeone who left with a number of issues that need answers. The issues are itemized below:a) A client just deposited ¢7,000,000 in one of your investment funds which is currently earning10% return. The bank has advised the client to deposit an additional ¢4,000,000 at the end ofeach of the next three years. The client would like to know how much the total amount in thisinvestment will be in three years’ time.b) A client has been offered an investment product which requires that he pays ¢200,000 in oneyear, ¢400,000 the next year, ¢600,000 the year after, and ¢800,000 at the end of the followingyear. The client could have earned 12% on similar investments being offered on the marketbut has decided to take your firm’s offer. How much is this investment worth today assumingthe client proceeds to invest?c) Kassim has just been offered a job at ¢600,000 a year. He anticipates his salary will…
The business plan for KnowIt, LLC, a start-up company that manufactures portable multigas detectors, showed equivalent annual cash flows of $400,000 for the first 5 years. If the cash flow in year 1 was $313,000 and the constant increase thereafter was $50,000 per year, what interest rate was used in the calculation? what is the interest rate used in the calculation?
You have just been employed as an investment analyst in an investment bank. You took over from someone who left with a number of issues that need answers. The issues are itemized below: a) A client just deposited ¢7,000,000 in one of your investment funds which is currently earning 10% return. The bank has advised the client to deposit an additional ¢4,000,000 at the end of each of the next three years. The client would like to know how much the total amount in this investment will be in three years’ time. b) A client has been offered an investment product which requires that he pays ¢200,000 in one year, ¢400,000 the next year, ¢600,000 the year after, and ¢800,000 at the end of the following year. The client could have earned 12% on similar investments being offered on the market but has decided to take your firm’s offer. How much is this investment worth today assuming the client proceeds to invest? c) Kassim has just been offered a job at ¢600,000 a year. He anticipates his salary…
You have just been employed as an investment analyst in an investment bank. You took over from someone who left with a number of issues that need answers. The issues are itemized below: a) A client just deposited ¢7,000,000 in one of your investment funds which is currently earning 10% return. The bank has advised the client to deposit an additional ¢4,000,000 at the end of each of the next three years. The client would like to know how much the total amount in this investment will be in three years’ time. b) A client has been offered an investment product which requires that he pays ¢200,000 in one year, ¢400,000 the next year, ¢600,000 the year after, and ¢800,000 at the end of the following year. The client could have earned 12% on similar investments being offered on the market but has decided to take your firm’s offer. How much is this investment worth today assuming the client proceeds to invest? c) Kassim has just been offered a job at ¢600,000 a year. He anticipates his salary…
Mr.Andi is a manager at an automation company. As part of his future planning, Mr.Andi plan to manage an investment IDR 100 thousand in the first year and increase this amount is 10% annually. To solve this problem, you have to create a spreadsheet from the data provided to complete your calculations along with the cash flow. Based on the data given: (a) How long will Mr.Andi's account have value in the future of IDR 3,000,000 at a rate of return of 6% per annum? (b) If Mr.Andi counts up to the next 30 years, find the nominal amount in the next 10, 20, and 30 years that Mr. Andi will achieve. The calculation spreadsheet can describe the amount deposited annually.
Solve the following question with complete solution and include cash flow diagram in handwritten form: A recent government study reported that a college degree is worth an extra Php 37754 per quarter income compare to high school graduate. If the interest is 6 % per year compounded quarterly and you work for 30 years, what is the future compound amount of this extra income? (Round off the interest rate to 5 decimal places)
The store owner hires 2 sellers with a total payment fund of 150 thousand rubles per year. Pays a monthly rent of 60 thousand rubles. He invested his own capital of 300 thousand rubles in the business, donating 30 thousand rubles per annum, which he would have had with another placement of capital. He estimates his entrepreneurial talent at 100 thousand rubles a year. A large trading company offers him a place with a salary of 200 thousand rubles a year. Calculate the amount of accounting and economic costs and draw conclusions.
Jefferson Bank lent a newly graduated engineer $1000 at i = 10% per year for 4 years to buy home office equipment. From the bank’s perspective (the lender), the investment in this young engineer (the borrower) is expected to produce an equivalent net cash flow of $315.47 for each of 4 years. A = $1000(A/P,10%,4) = $315.47 This represents a 10% per year rate of return on the bank’s unrecoveredbalance. Compute the amount of the unrecovered investment for each of the 4 years using (a) the rate of return on the unrecovered balance (the correct basis) and (b) the return on the initial $1000 investment (the incorrect basis).