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) ♥

International Financial Management

14th Edition

ISBN:9780357130698

Author:Madura

Publisher:Madura

Chapter14: Multinational Capital Budgeting

Section: Chapter Questions

Problem 1IEE

See similar textbooks

Similar questions

There is an investor stating they will pay out $84,000 at the end of 4 years. In order to invest into the opportunity, you'll need to make a deposit of $10,000 to thier indicated bank account. What is the average annaul return rate. Use excel functions to indicate your steps.
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 1 NCF, $ -9,000 4,100 2 -4,000 The external rate of return is 3 -7,000 % per year. The spreadsheet function is =RATE(6,-17986,,25972) 4 5 12,000 700 6 1,050
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 10 NCF, $ -9,000 4,100 The external rate of return is 2 -4,300 % per year. 5 -7,000 12,000 700 Saved The spreadsheet function is (Click to select) (Click to select) =RATE(6, 26122,-18243) =RATE(6,26122,,-18243) =RATE(6,-18243,26122) =RATE(6,-18243, 26122) 6 1,200
What is the excel function and formula for this question? Off-The-Books Investment Firm, LLC, has offered you an investment it says will return to you $20,000 in 2 years. To get in, you'll need to make a $10,000 deposit to their receivables account and promise not to tell anyone about it. What is the annual return on this investment?
PLEASE, PERFORM THE EXERCISE IN EXCEL AND SHOW THE FORMULAS2.- Mr. Rafael Robles goes to his financial advisor and asks him to calculate the interest to be earned on a deposit for the amount of 730,000.00; when the current interest rate is 9.75%, capitalized quarterly, and it was invested for 5 years, 9 months and 27 days. The Finance Company reinvests at simple interest when there are not complete capitalization periods. Note:In the image, this is the original exercise, it is in Spanish, but it is easy to understand. Very important Note:It is necessary that you make a solution approach and then the result. Above all, to check the procedure and/or the formulas used, especially when you use excel. TO CONSIDER THE YEAR AS 360 DAYS (WHICH IS COMMERCIAL) (only if required)
You invest $ 500 today and receive $ 750 at the end of 5 years. a. DETERMINE the internal rate of return, using hand interpolation. Write answer to 2 decimal places. b. SUBMIT the procedures via the spreadsheet icon. Show all your computations. -
Melannie Bayless has purchased a business building for $331,000. She expects to receive the following cash flows over a 10-year period: Year 1: $43,000 Year 2: $58,500 Year 3-10: $89,000 What is the payback period for Melannie? Round your answer to one decimal place.fill in the blank What is the accounting rate of return? Enter your answer as a whole percentage value (for example, 16% should be entered as "16" in the answer box).fill in the blank
One year ago, JK Mfg. deposited $12,000 in an investment account for the purpose of buying new equipment four years from today. Today, it is adding another $15,000 to this account. The company plans on making a final deposit of $10,000 to the account one year from today. How much will be available when it is ready to buy the equipment, assuming the account pays 5.5 interest? solve using financial calculator please
Assume that you are nearing graduation and have applied for a job with a local bank. As part of the bank's evaluation process, you have been asked to take an examination that covers several financial analysis techniques. The first section of the test addresses time value of money analysis. See how you would do by answering the following questions. Draw time lines for: (a) a $2000 lump sum cash flow at the end of year 4, (b) an ordinary annuity of $1000 per year for 5 years, and (c) an uneven cash flow stream of -$450, $1000, $650, $850 and $500 at the end of years 0 through 4.
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?
For the following economic calculations, write the factors (multipliers) that should be used,in (i) using the parameter values, and in (ii) calculate the result by showing your computations. Write the results you find in the spaces left. (Use factors for your calculations.)EXAMPLE: If you deposit $ 100 to a bank account that earns 8% annual interest, how much money will you have in this account after five years?(i)(F/P, 8%, 5) (ii)146.93100 * (F/P, 8%, 5) = 100 * 1.4693 = 146.93 TLa. You plan to take a credit with $1500 installment size per year with an annual interest rate of 8% over six years from a bank. What is the amount of your current credit?(i) (ii)b. A bank is required to deposit money for four years with an interest rate 10%. The money deposited at the end of the first year is 6000 TL and the amount of money deposited in the next three years will be reduced by 500 TL every year. How much money will be in the bank at the end of the fourth year?(i) (ii)
Suppose you are a relationship manager at an international bank. A customer who recently got admission at a prestigious Business School approached you for an education loan of Rs. 36,00,000. Your bank offers the education loan at 9.6 percent to be repaid in 10 years in EMIs. You are assigned the task of preparing the amortization schedule for the customer and answer the following. Prepare the amortization schedule for the first 5 EMIs. What will be interest paid for 93th EMI? What will be the loan balance after 93th EMI? What is the total interest paid for the loan?