Reference no: EM131213355
You invest $2,564.35 in a business, and in return you receive five uniform payments of $655.00 at the end of years 1 through 5. Solve for internal rate of return (IRR). Follow instructions in sequence requested below.
Do not solve this problem with Excel IRR function. Solve by hand calculation method and interest factor table values as shown on chapter 7 lectures slides example 7-15 (last slide in PowerPoint presentation)
Step 1. Create a cash flow table in Excel and the cash flow diagram graph representing this investment scenario.
Step 2. Write the theoretical equation you will use to set up and calculate the IRR of this investment scenario.
Step 3. Using the theoretical equation, write the interest factor notion version of the equation you will use to solve the problem.
Step 4. Solve for the IRR using the available interest factor tables. Guess interest rates that will bracket the actual IRR. (hint: start with 8%) You must show all algebraic steps for two solution attempts using interest rates that you guess that bracket the IRR.
Step 5. Show results in a 2 column by 3 row size table with interest rate guesses in column 1 and their matching calculated value / interest factor table value in column2 , with first guess in row 1 and second guess in row 3, and the IRR value in row 2 , showing that the two solution attempts bracket the unknown IRR.
Step 6. Then use linear interpolation to calculate the actual IRR and show all calculations.
Step 7. Now create a cash flow table in excel worksheet and solve problem with IRR function as a double check.
|
Write six to eight page essay on the cause of the civil war
: Write a 6-8 page essay on the cause of the civil war.
|
|
Annual income statement
: On January 1, a company issued 4%, 10-year bonds with a face amount of $75 million for $63,842,205 to yield 6%. Interest is paid semiannually. What was the straight-line interest expense on the December 31 annual income statement? (Enter your answer ..
|
|
Advantages and disadvantages of compilers and interpreters
: Discuss the advantages and disadvantages of compilers and interpreters. When would you use each? Pick a problematic that you think a Java can solve or make easier.
|
|
How will claim demonstrate the medical necessity for exams
: How would you select the ICD-9 and CPT codes for the procedural claim (encounter) for the ED visit? What diagnosis and procedure codes will result in dull reimbursement for the procedures rendered? How will the claim demonstrate the medical necessity..
|
|
Solve for internal rate of return
: You invest $2,564.35 in a business, and in return you receive five uniform payments of $655.00 at the end of years 1 through 5. Solve for internal rate of return (IRR). Create a cash flow table in Excel and the cash flow diagram graph representing th..
|
|
What was the most enjoyable aspect of the visit
: What was the most enjoyable aspect of the visit? What art did you see today that you were surprised to discover? When you have time to return to LACMA, which other exhibits are you interested in?
|
|
What is the total resistance for each of the three groupings
: Five 470 Ω, ten 1000 Ω, and two100 Ω resistors are all connected in parallel. What is the total resistance for each of the three groupings?
|
|
Bottom up analysis of companies current financial situation
: HA1022 - Principals of Financial Markets Group Assignment - Conduct a Top Down analysis of the overall economic environment and consider how forecast changes in economic fundamentals will impact on the performances of companies in the industry your..
|
|
How do coding and modulation work
: How do coding and modulation work with spread-spectrum and ODFM? This project will be helpful in analysing the differences and synthesizing the similaries.
|