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 0 NCF, $ -9,000 1 4,100 The external rate of return is The spreadsheet function is 2 4,300 % per year. 3 -7,000 (Click to select) (Click to select) =RATE(6, 26122,-18243) =RATE(6,26122,,-18243) =RATE(6,-18243,26122) =RATE(6,-18243, 26122) V 4 5 12,000 700 6 1,200

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 0 NCF, $ -9,000 1 4,100 The external rate of return is The spreadsheet function is 2 4,300 % per year. 3 -7,000 (Click to select) (Click to select) =RATE(6, 26122,-18243) =RATE(6,26122,,-18243) =RATE(6,-18243,26122) =RATE(6,-18243, 26122) V 4 5 12,000 700 6 1,200

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.
Each of the following scenarios is independent. All cash flows are after-tax cash flows. Required: 1. Patz Corporation is considering the purchase of a computer-aided manufacturing system. The cash benefits will be 800,000 per year. The system costs 4,000,000 and will last eight years. Compute the NPV assuming a discount rate of 10 percent. Should the company buy the new system? 2. Sterling Wetzel has just invested 270,000 in a restaurant specializing in German food. He expects to receive 43,470 per year for the next eight years. His cost of capital is 5.5 percent. Compute the internal rate of return. Did Sterling make a good decision?
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.)
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.
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
A third-year college friend of yours opened Mike’s Bike Repair Shop when he was a freshmen working on a sociology degree. He shared his NCF figures for the 3 years, including the $17,000 amount that it took to get started in business. (a) Determine the number of possible rate of return values. (b) Find all i* values between −50% and 110% by plotting PW versus i* for your friend. (Use 20% increments.) Year Net Cash Flow, $ 0 −17,000 1 20,000 2 −5,000 3 8000
Think about the cash flows associated with putting in the bank for five years, assuming you draw out the interest each year and then close the account. Now think about a set of hypothetical cash flows associated with putting the same money in a business, operating for five years, and then selling out. Write an explanation of why the IRR on the business project is like the bank’s interest rate. How are the investments different?
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?
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)
Inco purchased a computer for $200,000, and this machine is expected to generate annual cash flows of $48,271 over the next 5 years. What is the expected rate of return on this investment? a. 8.84% b. 26.58% c. 6.61% d. None of these are correct