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

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 15M

See similar textbooks

Similar questions

Find the interest earned on $5,750 deposited into a savings account for 3 1/2 years at an annual interest rate of 4 1/2% a. What formula should be used? b. What are you trying to find and what variable does it represent in the formula? c. Solve the problem showing all of your work (must show all steps!!) d. Interpet your answer using a complete sentence You may use the box below to upoload a picture of your written explanation or type it out in the box. Use the "mountain" button to add pictures.
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?
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
Please indicate what you entered into your calculator to solve these problems. 1. You graduated with $28,000 in school loans. You will make annual payments of $4,000 at the beginning of each year for the next 10 years. What annual rate of interest are you being charged on your school loans? 2. You bought equipment for $23,000 and agreed to make monthly payments at the end of each quarter for 5 years. Assuming you are being charged 9% interest compounded QUARTERLY, how much will your QUARTERLY payments be? 3. You currently have $750,000 in your building fund. If you start depositing an additional $20,000 per year into this account at the beginning of each year, how much will be in the account after 6 years assuming 5.5% interest compounded annually? 4. You want to start saving for a new car and have decided to put S$90 per month at the beginning of each month into an account which earns 6% compounded monthly. You would like to be able to buy a car for $25,000. (a) How many deposits will…
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?
ENGINEERING ECONOMY UPVOTE WILL BE GIVEN. PLEASE WRITE THE COMPLETE SOLUTIONS LEGIBLE. FOLLOW THE INSTRUCTIONS CAREFULLY. Draw CASH FLOW DIAGRAMS for the GIVEN AND REQUIRED/FIND. Begins the solutions by writing the equations/formulas. Use 2 decimal places and Box the final answer. Five friends plan to establish a consulting firm after 5 years. The plan is for each to make semi-annual deposits of P15,000 in their respective bank accounts starting at the end of the first semester after the agreement up to the 5th year. All deposits are to be made every end of the periods. One of them is not capable of starting at the same time with everyone because of a present obligation but promised to start her deposits by the end of the first semester after the second year until the 5th year. How much should she deposit in equal amounts to save as much as each of her friends if money is worth 14% compounded semi-annually?
A civil engineer starts investing his money when he graduates from college. He is able to afford investing $10,000 a year from the time he graduates in four years until the end of eight years. He also plans to increase his investment an additional $2,500 per year increasing by $2,500 every year until year eight. Use the interest rate 10%. a. draw the cash flow diagrams for the above cash flows b. how much will the civil engineer have saved by the end of year eight c. what is its present worth on the year he started college
For TVM calculator: Write each known variable’s value as it appears in the calculator and use a question mark for the missing variable. Then, in the space provided write the missing variable’s value, as it appears in the calculator. Finally, write your final answer in context, with units, as a complete sentence. Herman is looking to invest $5,000 in an account that earns 3.7% annual interest compounded semi-annually. If Herman plans to regularly deposit semi-annual payments of $1,575 into the account, how much is the account worth after 30 years? N=60 I= 3.7 PV=5000 PMT= 1575 FV= ? P/Y=2 C/Y=2 Missing Variable Value __________________ Context Sentence:
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
Company investment says will pay out $64,000 at the end of 3 years. To invest, you'll need to deposit $9,900 to their bank account and keep the information private. What is the average annual return on this investment? Remember to use a TVM function. the answer is provided: 86.29% Please show how to get on EXCEL in one function
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.